Copying KF values across all future periods in SAP IBP

[former_member693860]

Hi all,

Is there a straight-forward way to copy a value sitting in current period into future periods (same KF) ?

Advanced Copy Operator / Copy and Disagg don't seem to handle this requirement.

Also Attribute as Key Figure may not be an option per business requirement.

Thanks,

[piyush_parekh · Accepted solution]

Hi,

Explore IBP_CAGGR function to extend a key figure value to future periods and then using copy operator/profile, you can copy extended values back to source key figure.

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/2011/en-US/c7f3218d10584e74bb71b76580a1...

Sample illustration :

Hope this helps!

Regards,

Piyush

[former_member693860 · Accepted solution]

Thanks Piyush, will try your solution and come back.

[former_member310060 · Accepted solution]

2021-02-19-13-01-53-clipboard.png

Hi piyush.parekh,

I'm currently trying to do something similar, populating the value from current week into my full horizon. I'm trying to use IBP_CAGGR Function, but for some reason I'm not able to succeed. I need to populate the 175 into all weeks of third key figure. Can you help me out with the right parameters?

[piyush_parekh · Accepted solution]

Please try following - Parameter 1 : Input KF, Parameter 2 : ''SUM'', Parameter 3 : "FORWARD", Parameter 4 : "CURRENTFUTURE". For parameters 2,3,4, use two single inverted commas.

[Irmi_Kuntze]

Hi Bastian

if you need it for disaggregation of another key figure, it needs to be on the same planning level and stored.

In that case, if you calculate with e.g. IBP_RAGGR you will need this calculated KF plus a copy operator with which you store it into the disaggregation key figure, so another configuration.

In that case, a FC operator could calculate the disaggregation KF directly, and if your needs change you can simply adjust the horizon of the input KF. You would not need the additional calculated KF with IBP_RAGGR.

If you need input as rolling average of next 4 weeks, you can work with the offset to have those 4 weeks as input, and choose simple average as FC operator

Yours, Irmi

[Irmi_Kuntze]

If you need the value as calculated, the suggested solution is smart. Downside: You get a filter block regarding the periods, which depending on what you plan to do with this KF might have negative performance impact.

If you need the value stored because e.g. you just want to have a prefill and you want to manually overwrite later, then you could create a statistical FC operator and use a constant model with history = only current period, and future = all desired horizon. Downside is you need to execute a job in order to see changes, it takes additional space on the data base, and you get a lot of superfluous business logs

Best solution depends on business requirement behind the technical question 🙂

[former_member310060]

Hi Irmhild,

thanks for your explanation. My requirement is to calculate the avg of one key figure using only the next 4 weeks. I'm currently doing this with IBP_RAGGR function. Then I need to use that value as disaggregation factor for another key figure for the full horizon. The avg is getting recalucalted every week. I already thought about using a forecast operator. Do you think that approach fits more to my requirement?

best regards

Bastian