Skip to Content
avatar image
Former Member

Average value of next 3 periods

Hi All,

My scenarios it to get the average of next 3 periods of KF1 into KF2.

I tried to simulate the settings of ActualsPriorYear key figure from SAP2 mode in my KF2 , but it did not solve the problem. I might be missing something. I followed the below steps.

1. Created 3 different planning levels - Perprodcust1 , perprodcust2 and Perprodcust3

2. Created a key figure as an attribute - PeriodID2 with 3 calculations ( screenshot below)

3. Created 3 new key figures to hold data of N+1, N+2 and N+3 periods of KF1

4. In the calculations of above 3 key figures, I have assigned the 3 new planning levels. (screenshot below)

Provided below is the key figure as an attribute created for the same. Any thoughts on how to meet this specific scenario using IBP

periodid.JPG (40.3 kB)
calculation.JPG (30.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 18, 2015 at 04:59 AM

    Hi Vijay,

    Here is the configuration to come up with  average of 3 months starting from current month

    Steps:

    Assume PERPRODCUST is the base planning level and monthly time granularity

    1. KF1@ PERPRODCUST = IF ((PERIODID - $$PERIODIDCU$$ <= 2) and (PERIODID -        $$PERIODIDCU$$ >=0) , CONSDEMANDQTY,null)

      

         Extract the values for Current Month, M+1 and M+2

    2. Add additional calculation. This will sum up all the values for Current Month, M+1 and M+2

        KF1@PRODCUST = SUM(KF1@ PERPRODCUST)

    3.

        a. Create a helper key figure HKF1@PRODCUST to calculate average

            HKF1@ PRODCUST  = (KF1@PRODCUST / 3)

        b. Create helper key figure and pass input key figure with time dimensions for e.g. KF    

            DMDPLANQTY

           This will put the average value in Current period.

           HKF1@PERPRODCUST = IF ((PERIOIDID=$$PERIODIDCU$$), HKF1@ PRODCUST, null))

        c. KF2@PERPRODCUST = HKF1@PERPRODCUST

    Hope this helps.

    Thanks,

    Pramod

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Alecsandra Dimofte

      Hi Alecsandra,

      I need to create a KF calculation where,

      Past month value (Suppose July) of KF1 is current  month value (Suppose August) for KF2.

      How can we achieve this?

      Thanks,

      Samiksha

  • avatar image
    Former Member
    Aug 17, 2015 at 04:07 PM

    Hi Vijay,

    Will you be upgrading to new service patch 4.0 SP2 that is released this month, If yes then you can use the copy operator with and time shift parameter that will do a copy with +1 +2 and +3 time shift for you then you can average it within current time bucket based on newly created KF.

    If not then you may need to do an snapshot of period offset KF that you had created to do an average. I don't think so you can do an period transformation and calculation on top of it.

    Regards,

    Parag,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 03, 2016 at 09:21 AM

    Hi All,

    I created as following Key figure definition and calculations to copy past 3 periods value from "ZMDYOSOKU" to "ZSALECOEF".

    However occurs error in Activating situation as below.

    Log:

    ---------------------------------------------

    E - Ensure that calculation 276 | ZSALECOEF@REQUEST is included in the generated calculation definition graph

    E - Ensure that calculation 150993738 | ZSALECOEF@WKPRODLOC is included in the generated calculation definition graph

    E - Validation check failed

    ---------------------------------------------


    Please could you provide me a solution?


    regards,

    Sheng Lu




    a.png (50.8 kB)
    b.png (31.7 kB)
    c.png (31.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sheng,

      Hope you are doing well!

      Can you see the difference of key figures on RHS between REQUEST level and WKPRODCUST level? I can see ""@WKPRODCUST missing.

      Regards,

      Aditya G