Audit tracking for BI planning solutions and scenarios

  • Article

 

Applies to: SharePoint Server 2010 Enterprise

Audit tracking

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.

See Also

Concepts

Basic planning scenarios in BI planning solutions and scenarios
Planning the data mart for BI planning solutions and scenarios
Planning modeling concepts in BI planning solutions and scenarios
Cube modeling for Write-back in BI planning solutions and scenarios
Performance considerations and approaches in BI planning solutions and scenarios
Cube modeling with Excel PowerPivot in BI planning solutions and scenarios
Create reports and forms for BI planning solutions and scenarios
Submit plan data for BI planning solutions and scenarios
Workflow actions, workflow diagram, and SharePoint workflow setup for BI planning solutions and scenarios
Audit tracking for BI planning solutions and scenarios
Administration for BI planning solutions and scenarios
Calculations for BI planning solutions and scenarios
Additional planning functions for BI planning solutions and scenarios
Migration for BI planning solutions and scenarios
Maintenance for BI planning solutions and scenarios
Corporate to subsidiary management for BI planning solutions and scenarios
Planning modeling and reporting guide for BI planning solutions and scenarios
Building planning functionalities guide for BI planning solutions and scenarios
Planning and budgeting calculation examples for BI planning solutions and scenarios