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
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,
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
Add comment