How to archive the data change audit and clearing/deleting the archived data change audit in SAP BPC 10.0 NW

[dinesh_veluru]

Hi All,

This document is intended for beginners on housekeeping of Data change Audit.

Why Data Audit feature has to be turned ON for models.

Benefits:

1. Keeps track of the data changes that have happened through various tasks (i.e input schedule, Data manager packages, script logic execution…etc )
2. Easy to identify the data loss issue (keeps track of data changes made by users based on their user ids)

Now,why we should archive the data change audit –In Production system when data auditing feature is enabled there will be large volumes of data change audit captured in the Audit tables and it will have significant impact on the performance when we do a report on audit “Data Changes” in the administration.

So, it is recommended to archive the Data Audit frequently.

Assuming Data Audit feature is already turned ON for Models.

Steps to be followed for Archiving the Data change Audit

Logon to BPC Administration>>Features>>Audit

In the “Data Audit Configuration by Model “section click on Edit and do the audit configuration category wise for the models

In the screenshot below set audited tasks and the Frequency of Data Audit Purge for the categories in scope.

Please note that setting the data Audit frequency(days) will not archive the data audit automatically.

Standard data manager package have to be run which will move the data audit from current audit table to Archive data audit table

Process chain: /CPMB/ARCHIVE_DATA    ---Archive Data Change Audit

To find out the Audit tables related to model specific then go to SE38 run the program UJ0_GET_GEN_TABNAME

Search for the keyword AUDDATA  &  AUDDATA_A(archive)

Below is the sample screenshot, table names will vary with respect to Models.

How to build BPC audit reports on Archived audit data

Execute the transaction code SPRO

SAP IMG references>>Planning and Consolidation>> Set Global parameters

“ENABLE_REPORT_ARCHIVED_AUDIT” = “X”

Logon to SAP BPC web>>Home>>Audit>>Data Changes

A new section appears after the global parameter is set

Report on: Archived, Current & Current and Archived.

Note: 1695526 has to be applied if the BPC system is lower than SP07

Steps to be followed for deleting /clearing the archived data audit.

Go to SE38 and run the program UJU_DELETE_AUDIT_DATA

Test Run “X” displays no records to be deleted

Test Run “ “ –  delete the audit data records.

If the BPC System is lower than CPMBPC 800 SP10 or CPMBPC 801 SP03 then Note: 1827262 have to be implemented to use the delete feature.

Thanks,

Dinesh.