cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Copying KF values across all future periods in SAP IBP

0 Kudos
3,569

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,

View Entire Topic
Irmi_Kuntze
Product and Topic Expert
Product and Topic Expert
0 Kudos

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
Participant
0 Kudos

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