Skip to Content
Technical Articles
Author's profile photo Dinesh Mukundu Mohan

How to enable Audit feature with composite provider for ADSO in BW/4 HANA & BPC 11

BW/4 HANA & BPC 11 – ADSO Audit Feature

How to enable Audit feature for Infoproviders (BW/4 HANA)

Goal

In this Blog we will look on enabling Audit feature in BW/4HANA & BPC 11.

Overview

Data audit is used to monitor who made the changes to an InfoProvider’s transaction data either through input-ready queries or fox planning functions or Warehouse Management (DTP loads).

ADSO Data Audit

Data audit can be enabled with DataStore object (advanced) with the modeling property All Characteristics are Key.

Create Composite Provider with the ADSO and enable the option “Show Audit characteristics in Query”. Ticking the option will provide audit characteristics when the query is built.

 

 

Add the required ADSO in union providers

Enable Show Audit Characteristics option in the composite provider and drag the fields to the output section and activate the composite provider.

 

Create a query on top of the Composite provider, add the keyfigures and characteristics, you will have option to include the audit characteristics to the query.

Execute the query in either RSRT or open the query in Analysis for Office to see the changes made to the transaction data [ audit characteristics – Source of Data & user ].

 

Conclusion:

Now you just learnt how to enable Audit feature in BW/4HANA & BPC 11. You can find the benefits of this as mentioned below.

  • monitor who made the changes to an InfoProvider’s transaction data
  • feature can be used for new or existing ADSO.

Looking forward for reading your comments. I hope you will find this blog useful.

 

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mosigan Soundarajan
      Mosigan Soundarajan

      Nice blog

      Author's profile photo Karthikeyan Mohan
      Karthikeyan Mohan

      Good information. Thanks

      Author's profile photo Maksim Alyapyshev
      Maksim Alyapyshev

      Hi, Thank you for your blog!

      As I understood, now in aDSO there are not audit characteristics as it was previously in BW Cubes Audit Dimension. Am I right?

      Could you clear where are audit data saved technically in BW/4?

       

      BR, Maksim

      Author's profile photo Yilmaz Alpdogan
      Yilmaz Alpdogan

      Hi Maksim,

      Audit data is saved in the infoobject 0REQTSN and in its attributes.

      Regards,

      Author's profile photo Ragunathan R
      Ragunathan R

      Useful blog.

      Thanks.

      Author's profile photo Iago Conde
      Iago Conde

      Great blog dinesh, any ideas on how to apply a similar solution for master data audit?

      Author's profile photo CRISTINA UNGUREANU
      CRISTINA UNGUREANU

      Hello Dinesh,

      Do you know how can be enabled the audit in BPC 11.1? The option All Characteristics are Key is missing when creating an ADSO.

      Best Regards,

      Cristina