BPC Saved Data change in Embedded BPC

[Former Member]

Hi Experts,

I got a typical requirement as discussed below and request your help for solution.

I built a simple Planning Query with Amount as planning Key figure. We have a filter on Audit Trail infoobject with Value "TOTAL" in the Query, so that the amount will be displayed for TOTAL Value only.

When an user does adjustment in this planning Query and save data, generally, the changed/Delta values will be posted to TOTAL only, but our requirement is the changed/Delta value Values should be posted to another value of Audit Trail = 'ADJUST' and not TOTAL.

TOTAL should be same and unchanged all the time. Changes should be recorded in ADJUST.

Please advise how this can be achieved. This requirement is on S4HANA 1709.

Thanks for your help in advance,

Raghavendra

[gregor_dieckmann · Accepted solution]

Hi,

there are two options:

1. Inverse formulas

You have two restricted key figures T := Amount restricted by Audit Trail = TOTAL, A := Amount restricted by Audit Trail = ADJUST and an input-ready formula RT (real total) := T + A; you make T not input-ready and A input ready; you define the inverse formula: A := RT - T.

2. Delta disaggregation

You have three restricted key figures T := Amount restricted by Audit Trail = TOTAL, A := Amount restricted by Audit Trail = ADJUST and

RT := Amount restricted by Audit Trail = ADJUST, TOTAL; T is not input-ready, A and RT are input-ready; for RT you used delta disaggregation with respect to A. Using this approach you have to ensure that disaggregation does not fail because no data records for Audit Trail = ADJUST exist; you might use create combinations based on master data or characteristic relationships).

The third option is a variant of 1 where you don't use input-ready formula and make only A input-ready, so the user has to maintain the adjustment only.

Regards,

Gregor

[Former Member]

Thanks Gregor for your timely help... Much appreciated as always..

One last question, we are on S4HANA 1709. We are using BW MT to create BEX Queries and i don't see the option to create Inverse formula in the Planning tab of RKF in BW MT... 😞

Any help 🙂

[Former Member]

Hi Gregor,

Thanks for your inputs. Will check all these options. Could you please advise me on the below?

1. Have not tried myself, my counter part says Inverse formula degrades the performance of query? Is it correct?

2. Heard there is a BADI we can implement which can be called after the user hits the save button. And in this BADI, we can change the data as per requirement. In this case, change TOTAL to ADJUSTMENTS for changed data. Do we have anything as such?

Thanks for your help in advance.

[gregor_dieckmann]

Hi,

here are the answers:

1 I have never seen such an example; inverse formulas are calculated on the level where data is changed, the basic key figure might be disaggregated.

2 Why to implement something (it is not a BADI but a planning function on save) when you get the feature out of the box? I also thinks the 'on save' is to late, I would expect that the user wants to see the total and the adjustment in the query.

Remark:

Just recently I have seen a customer using the third approach.

Regards,

Gregor