How to enable auditing in Planning ADSO BW 7.5

[former_member399597]

We are designing a BPC 10.1 solution with ADSOs and would like to do auditing when users are inputting forecast data. When planning on InfoCubes, you could tick a check box called 'Auditable' which would automatically add new InfoObjects to the InfoCube with audit data. How is this built in in ADSOs or is it? Where can I put the audit on in HANA studio? (We plan not to use the BPC web client, so that is not an option).

[stefan_voltz1]

Hi Seija,

did you solve your problem? If yes, how?:)

I am about to have the same issue.

Regards,

Stefan

[former_member399597]

Hi, thanks for the answer but it does not help us. We are not using BPC model at all, we are just creating ADSO->Composite provider -> Aggregation level->query-> input form. I have not found a way to record the audit details this way.

[former_member182709]

Hello Seija,

I had the same question as you, but i finally figured it out that there is no need to enable the audit feature for aDSO manually. aDSO has the audit feature by default. The test i did is as follows.

1. Create an aDSO in HANA studio.

2. Create an aggregation level via t-code RSPLAN.

3. Create a input ready query using query designer.

4. Use t-code rsrt to execute query and send some data. (You can also create a AO report with the query and send the data)

5. Add this adso in the bpc model, you will see the auditable feature on automatically.

6. In the BPC system reports, you will see the data changes you did on step 4.

I have succeed in showing the data changes in the audit report.

Best regards,

Charlie

[SharadLTI]

Hi Charlie,

With these steps were you able to also see the Time stamp of when the data was changed and User who changed the data?

Thanks,

Sharad

[Former Member]

Hello Charlie and Sharad,

Effectivelly aDSO planning like Cube automatically enables this feature and we can see it turned on in BPC Embedded but this not happens with aDSO planning direct update type, do you know how to achieve this behaviour for this type of object?

Best Regards,

Juan Garces.

[former_member182709]

Hello Juan,

See blog

https://blogs.sap.com/2018/03/06/bpc-embedded-model-auditing-feature-in-adso-and-infocube/#

By far, Direct Update DSO and Direct Update aDSO don’t support auditing. Good new is there is a BAdi named BADI_RSPLS_LOGGING_ON_SAVE which can be used to used.

Best regards,

Charlie Lin