Hi Experts,
For performing the entity allocation in our project, we have a to consider the last 13 periods average of the Entity actual data. To do so, we have created a custom measure named R13, which holds the average data for last 13 actual periods. Using this measure, we have designed the script logic to read the R13(custom) measure data and on top of which we are calculating the allocation(%) values which will be used for allocating the forecast data.
The issue we are experiencing is that the data is not being read from the R13(custom) measure and it is by default taking the Periodic measure and also posting to the Periodic measure. Also, while trying to using this custom measure in input schedule, it is working fine and reads the value from it.
We are using BPC 10.1 NW Standarad, SP 13.
Please find the script logic below .Any leads on the above scenario would be of great help. Thank you!
*XDIM_MEMBERSET P_CATEGORY = %P_CATEGORY_SET%
*XDIM_MEMBERSET P_CUSTOMER = %P_CUSTOMER_SET%
*XDIM_MEMBERSET P_TIME = %P_TIME_SET%,2020.INP
*XDIM_MEMBERSET P_PACKAGE = %P_PACKAGE_SET%
*XDIM_ADDMEMBERSET MEASURES = R13, PERIODIC
*XDIM_ADDMEMBERSET P_ENTITY = BAS(PB)
*WHEN P_TIME
*IS %P_TIME_SET%
*WHEN P_PACKAGE
*IS %P_PACKAGE_SET%
*WHEN P_CATEGORY
*IS ACTUAL
*WHEN P_CUSTOMER
*IS %P_CUSTOMER_SET%
*WHEN P_DATASRC
*IS CONSUMPTION
*WHEN P_ACCOUNT
*IS 1000
*WHEN P_ENTITY
*IS BAS(PB)
*WHEN MEASURES
*IS R13
*REC(EXPRESSION=(%VALUE%)/([P_CATEGORY].[ACTUAL],[P_PROMO].[NO_PROMO],[P_DATASRC].[CONSUMPTION],[P_INSTANCE].[NO_IN],[P_CUSTOMER].[TOT_DSD],[P_PACKAGE].[TOT_PKG],[P_ENTITY].[PB]),P_DATASRC=USER_INPUT,P_TIME=2019.INP,P_ACCOUNT=WKPCT)
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.