Reporting on Data Changes

Business Planning and Consolidation records audit information on who changed transactional data in the model. Since a data audit can be captured only for a model, this report is applicable only at the model-level.

Features

The report shows who changed the data, what time they made the change, how they made the change (for example, through SAP EPM solutions, add-in for Microsoft Office), and the details of the record that was changed.

You can choose from the criteria listed below to fine tune your report. In the report, the columns correspond to these parameters.

Option

Description

Model

Select a model, for example, PLANNING or RATE.

Dimension Members

Select the dimension and dimension members the audit information is stored against.

Date and Time

You can choose start and end dates for the report or display the full history of the selected data audit information (Anytime).

Additional Criteria

Select from the following options:

  • Data Modified by Task

    • All

    • The EPM add-in for Microsoft Office

    • Data Manager Import

    • Data Manager Clear

    • Logic Script Execution

    • Web Report Input

    • Journals Input

    • Business Rule Execution

    • Ownership

    • FIM Import

  • User

  • IP Address

  • Group Rows by

    • Activity

    • AddInfo1

    • AddInfo2

    • Machine Name

    • IP Address

    • Dimensions relevant to the model

    • User

  • Show Rows by

    • ID (Member ID)

    • Description (Member description)

  • Machine Name
  • Current, which includes audit records of data changes that have not yet been archived
  • Archived, which includes audit records of data changes that have already been archived
  • Current and archived, which is the combination of both options

Value

The Value field shows you the value to which the original value was changed. That is, it shows you the new value, not the original nor the delta value posted to the database.

Activities

To view a data changes report, go to System Reports, and from the list of reports, choose Data Changes. Set the appropriate reporting options and display the report.

More Information