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)
In this Blog we will look on enabling Audit feature in BW/4HANA & BPC 11.
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 ].
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.