Audit tracking for BI planning solutions and scenarios


Applies to: SharePoint Server 2010 Enterprise

Topic Last Modified: 2011-01-25

Audit tracking is automatically done by Microsoft SQL Server 2008 Analysis Services (SSAS) when you are using the cube writeback feature. All updates that are made to the underlying cube, such as from Microsoft Excel 2010 PivotTables are fully audited with the authenticated user and time stamp for each row of fact data that is written to the writeback table.

Audit tracking is useful when it is recorded on the fact table as administrators of the solution can quickly build audit reports to see who has updated what and when. These reports can then be used for the following purposes:

  • Track planning progress by the number of unique users who have submitted data.

  • Track back who has changed what particular line item in the fact table when unraveling the change history of the plan.

  • Gather key statistics on usage patterns for the solution that is based on time stamps and user load.