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.

/wp-content/uploads/2015/04/audit1_689012.png

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.

AUDIT2.jpg

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

/wp-content/uploads/2015/04/bpcaudirrep_686808.jpg

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.

/wp-content/uploads/2015/04/audit3_686809.jpg

Thanks,

Dinesh.

To report this post you need to login first.

15 Comments

You must be Logged on to comment or reply to a post.

  1. 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

    (0) 
    1. Dinesh Veluru Post author

      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

      (0) 
      1. 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

        (0) 
  2. 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

    (0) 
    1. Dinesh Veluru Post author

      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

      (0) 
  3. Rahul Kumar

    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

    (0) 
  4. Ravindra Kumar

    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 ?

    (0) 
    1. 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

      (0) 
      1. Ravindra Kumar

        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

        (0) 
    2. Marijn Bax

      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?

       

      (0) 

Leave a Reply