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:

  1. Select Navigate, then Administer, and then Consolidation Administration.
  2. Select Administration, then Audit, and then Data.
  3. Optional: From the Point of View, click a dimension to select dimension members.
  4. Optional: From the Filters panel, select filter criteria:
    • Application

    • Server

    • Date Range

      • To view all dates, select Include All.

      • To specify a date range, select Range, and then specify Minutes, Hours, Days, or Months.

      • To specify specific dates, select Custom, and then enter a Start and End date, or click the calendar icon to select dates.

    • Users

  5. Optional: To export the audit information to a CSV file, click Export, or select Actions, and then Export and follow the download instructions.
  6. Optional: To delete entries based on the current filter settings, click Delete based on the current filter settings, or select Actions, and then Delete Filtered.
  7. Optional: To delete all entries from the log, click Delete All, or select Actions, and then Delete All.

    Note:

    When you clear the log, a record of the clear process remains in the task audit log and cannot be erased.