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)
10|10000 characters needed characters exceeded

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

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

• 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,

10|10000 characters needed characters exceeded
• 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)