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 the dimension members of cells.

You can audit Scenario and Account members by setting the EnableDataAudit metadata attribute to Y for the scenarios and accounts to audit. To turn off auditing of Scenario and Account members, change the EnableDataAudit attribute to N.

Note:

Only users assigned to the Administrator role can perform a data audit.

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:

Username
Activity performed
Time modified
Server name
Point of view
New value for point of view
Note:
The Data Audit feature is available only in the Financial Management Web user interface.

The data audit log information is stored in a table (APPNAME_DATA_AUDIT). You can back up or extract the information in the table. You should monitor the log size and clear it on a regular basis.

To perform a data audit:

Select Administration, then Data Audit.
You must have an application open for the Data Audit link to be available.

Optional: Set filter options:

Enter a start date and an end date to filter by date range.
Tip:
Click to select dates from a pop-up calendar.
From the Server Selection list, select the server to audit, or select All to audit all servers.
From the User Selection list, select the user to audit, or select All to audit all users.

Enter member names in the text boxes for the applicable dimensions to filter by dimension members.

Note:

The system filters only by the dimensions for which you specify members. For example, if you specify a member in the Period text box and leave the other text boxes blank, the system filters only by the Period dimension.

Click View.
The data changes that meet the filtering criteria are displayed.
Optional: In the Point of View column, click a link to view the history for the corresponding cell.
Optional: Click Export to export the audit information to a CSV file.
Optional: Click Clear Log to delete all entries from the log.
Note:
When you clear the log, a record of the clear remains in the task audit log and cannot be erased.