cancel
Showing results for 
Search instead for 
Did you mean: 

12 weeks average history calculation

0 Kudos

integration.png

Hi,

We want to get the average 12 weeks of sales history. In weeks 13, average of 12 weeks history data should be there.

In the source side I have all 12 weeks sales history data. How can I send this directly to IBP using CPI-DS?

Accepted Solutions (1)

Accepted Solutions (1)

mkorndoerfer
Contributor
0 Kudos

Hello Anil,

You may create a new Calculated Key Figure that will calculate "on the fly" the average of last 12 periods. This configuration can be found in SAP Note 2240170 - SAP IBP Sample Model Configuration: Rolling Sum of the Last Three Periods, the only difference is that you'll use an Aggregation Mode = AVG and consider last 12 periods.

Best regards,
Matheus

Answers (0)