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.

[manohar_pappireddy]

Hi Dinesh,

Thanks a lot for a detailed and useful document.

Once after archiving in which tables arhived data resides?

From which tables UJU_DELETE_AUDIT_DATA deletes the data?

Thanks,

Manohar

[dinesh_veluru]

Hi Manohar,

After running the program UJ0_GET_GEN_TABNAME and input the environment and model name

Search for the keyword AUDDATA & AUDDATA_A for the table names.

AUDDATA(current) :  /1CPMB/*****AD

After archiving the change data audit will move from above current audit table  to Archive audit table /1CPMB/*****AD_A

when u run the UJU_DELETE_AUDIT_DATA it will permanently delete the audit data from archived audit table /1CPMB/*****AD_A

Thanks,

Dinesh.V

[manohar_pappireddy]

Hi Dinesh,

"After archiving the change data audit will move from above current audit table  to Archive audit table /1CPMB/*****AD_A" is the answer I am looking for.

I have given my rating to the document already.Thanks a lot for the help.

Thanks,

Manohar

[dolly_katyal]

Hello Dinesh,

Could you please share any space considerations which should be taken care? How much extra storage is required to store audit data and can it impact system performance?

Thanks,

Dolly Katyal

[dinesh_veluru]

Hi Dolly,

"Could you please share any space considerations which should be taken care?"-- no special considerations usually the database size will be in terms of Terabytes.

Once we have archived the Audit data it is recommended to delete the Archived audit data also frequently.

when we do reports on archived audit data ,since we have large volume of data audit  it has to scan the entire audit table and it might consume more system resources which will have significant impact on performance.

Thanks,

Dinesh.V

[dolly_katyal]

Thanks Dinesh.

[manohar_pappireddy]

Hi Dinesh,

Do you have any such document on "/CPMB/ARCHIVE_ACTIVITY" DMP or "Administration Activity" Audit?

Thanks,

Manohar

[dinesh_veluru]

Hi Manohar,

sorry I don't have the document,activity audit avaliable in below highlighted tables

[Former Member]

Hi Dinesh,

Thank you for this useful document.

We are facing performance issues due to huge data in Audit table.Can this table be partitioned?If yes, what are the pros and cons?If not what can be done to improve performance?
The audit table data is cleared every 6months.However recently after deletion of data within one month we are facing the issue.Please suggest.

Thanks a lot again,
Aditya

[Former Member]

How to delete entries in Activity Audit tables? Is process same as deleting Audit data changes?

[manohar_pappireddy]

At this point of time,I am deleting entries from

UJU_AUDACTDET_A,UJU_AUDACTHDR_A tables with SE14 functionality.

[try4it]

I created a DMP with process chain /CPMB/ARCHIVE_DATA and kept parameters are category and time. Although the DMP is running successfully the audit data is not moving to archive table of my model. I am on EPM 10 with BW SP19. Any idea what could be missing ?

[manohar_pappireddy]

Hi,

Have you done “ENABLE_REPORT_ARCHIVED_AUDIT” = “X”?

And have you configured "Data audit Purge Frequency"? like 10 days/20days?

Best Regards,

Manohar

[try4it]

Hi Manohar,

yes, these parameters are already configured. We are using data audit for a long time now, it is just we are trying to clear the historical logs which is consuming a lot of space.

Thanks,

Ravi

[marijnbax2]

I'm having the same issue. The package runs for a bit more then a minute but it's not actually moving any data to the archive. Did you find a solution?

 

[Former Member]

Hello,

 

We are facing the similar issue as the job run for 1 sec and does nothing. please assist

 

[former_member285870]

We are facing similar kind of issue..Nothing has been archived for big BPC audit table which is of 350GB of data after running BPC arcive pkg.As our management doesn't want any audit data,can we directly delete or truncate table from backend..

Thanks,

Mehul

[former_member186338]

It's better to ask a question, not to post a comment in the blog. In the question please provide your configuration details.