Skip to Content
avatar image
Former Member

Cumulative over rolling time period

Hi,

There has been a requirement from our client where we have to calculate a cumulative value on a given KF. How can it be made possible via back-end configuration?

For example, Say we have 1 KF: KF1@PL and another KF: CUMKF1@PL (This will be holding the Cumulative result of KF1). Now Let

KF1 have the following value over a 4 week period: 100     140     80     90

So CUMKF1 should contain:                                     100     240     320   410

Need help in this,

Regards,

Indaarjit  

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 03, 2015 at 11:47 AM

    Hi Indaarjit

    do you know how you build key figures with time period offset? You find that in the model reference guide

    http://help.sap.com/download/ibp/ibp40_model_ref_en.pdf

    You can find configuration description and examples for that in chapter 18.5 "Exaple: Attribute Transformations" --> Time Period Offset.

    So what you can do is create a key figure KF1Shift that moves the content of KF1 by one month according to the documentation, and than in CumKF1 you just sum up KF1 + KF1Shift

    Yours, Irmi

    Add comment
    10|10000 characters needed characters exceeded