IBP - How to Store a KF with a request level calculation

[former_member591592]

Hello,

I have done one KF1 calculation at Request level, since i wanted to have correct calculation at both aggregated and lowest level. with request level calculation i am getting correct values. but i want to use this KF1 in some other calculation. for ex in defaulting to another KF ,or adding value of KF1 with other KFs. but i am unable to do so since at request level the values does not gets stored at it base planning level.

is there a way by which i can achieve above?

Thanks for input

[Irmi_Kuntze · Accepted solution]

Hi

Data can only be stored at Base planning level of the key figure, never at request level.

So why do you want to store the value anyhow and not just let it be calculated on the fly?

One of the very few reasons to have it as stored key figure is either that you need it as stored key figure as input for some operator, or you need it in the disaggregation expression.

If you just want to have it defaulted but don't need the disaggregation expression, you don't need it stored.

So, if the disaggregation expression is your business case, than you need to use either COPY or DISAGG operator to copy the value from the calculated to the stored key figure.

Hope that helps

Irmi

[former_member591592 · Accepted solution]

Hi Irmhild,

Thanks for your response. the reason for doing above is. i have a calculation like this- KF1@request= KF2@request * KF3@request. all these KFs have same base planning level. request level calculation is done because as per requirement i want to maintain value for KF2 at higher level(say monthly) and KF3 already have some values. now when you maintain values of KF2 at higher (month) level it should get multiplied by KF3 to give result. now if i see at a disaggregated level(week) it should have values of both KF2 & KF3 disaggregated propotionally and KF3 should be equal to KF2*KF3 at lower (Week) level. but this is not happening normally. hence when i write this calculation at request level, i am getting correct value at each level.

now the problem is, i have to use KF3 in other calculations. for ex KF5@BPL= KF3@BPL + KF4@BPL. this calculation doesnt gives me correct result as it doesnt consider values of KF3(calculated at request level)

So my requirement is whether we have any option to store /copy value of KF3@request to some other KF (by copy or disagg) and use that in calculation OR is there a way i can achieve the above calculation at different level without using request level calculation.

Thanks a lot for response.