15 Track Changes to Data

Use an audit trail to track changes to cube data, including changes to Linked Reporting Objects (LROs), adding notes, attaching files, and referencing URLs. Export your log to an Excel spreadsheet, and perform ad hoc queries.

To view data audit trail records, you must be a Service Administrator or Power User who has one of these roles on the Application: Application Manager, Database manager, or Database Update role. You can only view those records where your user name matches the user name registered in the audit records. To delete data audit trail records, you must be a Power User who has Application Manager role on the application.

Limitations of Audit Trail

  • Supported only on block storage cubes

  • Not supported on scenario-enabled cubes

  • Not supported with text measures

  • Not supported in ad hoc analysis