View the Audit Trail of Measure Updates Table

You can view the audit trail for measure data using the Audit Trail of Measure Updates table in your demand, demand and supply, replenishment, sales and operations, or supply plan.

Points to Note

Note these points about viewing the audit trail for measure data in the table:

  • You can view the audit trail for only editable measures that are in the measure catalog for the plan from which you open the table.
  • You can view the audit trail for updates that were made before and after your software was upgraded to 23D. For information about the measures and update types for which the audit trail can be displayed, see the topic titled Overview of Viewing the Audit Trail for Measure Data.

    For 23D and later, you can also view the audit trail from a cell in a pivot table through the Audit Trail for Measure Updates dialog box. For more information, see the topic titled View the Audit Trail for Measure Data from a Cell in a Pivot Table.

  • Updates made through the collections process and the file-based data import (FBDI) templates aren’t displayed in the table.
  • If you’re viewing the audit trail for an editable, shared measure in a day-level plan, the update could have been made to the measure in another day-level plan. Otherwise, the audit trail pertains to updates made to the measure through pivot tables in the plan from which the Audit Trail of Measure Updates table is opened.

Information Displayed in the Table and Its Dialog Box

This table describes the information displayed in the Audit Trail of Measure Updates table and the Audit Trail Details dialog box that’s opened from the table:

Name Table or Dialog Box Description
Measure Name Table, dialog box Name of the editable measure for which the audit trail is displayed
Last Updated Date Table Date on which the update was made
Updated By Table User who made the update
Previous Value Table, dialog box Value for the measure before the update
New Value Table, dialog box Value for the measure after the update
Levels Dialog box Displayed levels for the cell in the pivot table where the update was made

The displayed levels and members represent the combination that was updated.

Members Dialog box Displayed members for the cell in the pivot table where the update was made

The displayed levels and members represent the combination that was updated.

Filtered Levels Dialog box Selected levels on the Members tab in the Selector Tool for the pivot table for the cell where the update was made

If there are no filtered levels, the following text is displayed: "No data to display."

Filtered Members Dialog box Selected members on the Members tab in the Selector Tool for the pivot table for the cell where the update was made

If there are no filtered members, the following text is displayed: "No data to display."

  1. In your plan, click the Open drop-down button, and select the pane in which you want to open the table.
    The Open Table, Graph, or Tile Set dialog box opens.
  2. Search for and select the Audit Trail of Measure Updates table, and click OK.
    The Audit Trail of Measure Updates table opens in the selected pane for your plan.
  3. Click Search to display the audit trail for all the editable measures in the measure catalog for your plan.
    You can also use the search fields to narrow the displayed results.
  4. View the audit trail for the editable measures.
    • Sort the displayed rows using the Measure Name, Last Updated Date, Updated By, Previous Value, and New Value columns.
    • For a row, click the Details icon to open the Audit Trail Details dialog box in which you can view the displayed levels and members and filtered (selected) levels and members for the update.
    • If the update was made by another user, the new value and previous value are masked. In this case, you can open the dialog box to view the update if you've the permission to view the information. Otherwise, an error message is displayed. For more information, see How Security Is Applied to the Audit Trail.