Rolling Aggregation does not roll for all combinations - SAP IBP

[mzahmed]

Greetings Experts

We hope you are all well.

We have a requirement where the key figure values for the past 3 months should be added and into the current week only of a new key figure. We have achieved this using the rolling aggregation functionality. This solution works well but it fails to execute for some combinations.

We have not been able to find out exactly why this is happening.

Do you perhaps have an idea as to why this is occurring?

Please see below info on config and a screenshot of how the planning view looks.

Step 1 - RollingAggKF@REQUEST = SUM("RollingAggKF@DAYPRODLOCCUST")

Step 2- RollingAggKF@DAYPRODLOCCUST = IBP_RAGGR("KFtoRoll@DAYPRODLOCCUST", ''SUM'', -90 , 91 , ''CURRENT'' )

As can be seen below, we have created a "Total" column in the "Time Settings" under "Edit Planning View" for the same duration as we wanted to display on the planning view. Customer 1 and Customer 3 behave well whereas the other two customers do note roll and add up. This is rather unusual as there are no setting we are aware of that manipulate this.

Please advise.

Regards,

Mohammad

[suppadhyay]

Hello Mohammad,

Were you able to resolve this? We are facing similar issue in which Rolling aggregation is not working for all combinations. Any help will be appreciated.

Thanks,

Samiksha

[revanchatraban · Accepted solution]

Hi,

Please check your Horizon.

As mentioned by you, your horizon for rolling aggregation is only for the "CURRENT" bucket. I assume KFtoRoll is not having time frame for rolling but RollingAggKF is having bound by time frame. Please check

Please check the link below also:

https://answers.sap.com/questions/13156800/ibp-average-demand-calculated-at-different-time-pe.html

Regards,

Revan

[riyazahmed_ca2]

Hello Mohammed,

I suspect this is something with Initialization. Please check whether the Planning Objects for the problematic cases were initialized properly in the past, current and future.

Also check whether any of the involved KFs are Stored and Calculated, but your calculations catch up only the stored value, but not the calculated ones or vice versa. Better to have a snapshot of your KF config to see more 🙂

Best Regards,

Riyaz