Auditing Data
You can use the Data Audit feature to view data changes performed by users. You can filter the data changes by date range, application server, user, and dimension members.
You can use the EnableDataAudit metadata attribute for the accounts and scenarios for which you want to audit data changes. The audit settings for the scenario override the audit settings for the account. If the EnableDataAudit attribute is set to Yes for a scenario, all accounts in the scenario are audited, even accounts for which EnableDataAudit is set to False. If EnableDataAudit is set to Override for a scenario, all accounts for which EnableDataAudit is set to True are audited. To disable auditing of Scenario and Account members, change the EnableDataAudit attribute to No.
If you are assigned the Application Administrator role, you can view, export, and delete data audit information. If you are not an administrator, but have the View Data Audit role, you can view and export data audit information.
These user activities are logged in the data audit:
-
Data Entry
-
Data Clear
-
Data Copy
-
Data Load
-
Journal Entry
The data audit log includes this information:
-
User name
-
Activity performed
-
Time modified
-
Server name
-
Point of view
-
Value entered for the point of view
The data audit log information is stored in the APPNAME_DATA_AUDIT table. You can back up or extract the information in the table. You should monitor the size of the log and clear it on a regular basis.
To perform a data audit: