Dear all,
I following the how to run a top down allocation with BPC NW。
I finish all step. But I got the script logic error.
************************************************************************************************
The code as following
*XDIM_MEMBERSET TIME=2008.JAN,2009.JAN
*XDIM_MEMBERSET P_ACCT=RENT
*XDIM_MEMBERSET CATEGORY=PLAN,ACTUAL
*XDIM_MEMBERSET ENTITY=$SOURCE$,$TARGET$
*WHEN ENTITY
*IS "ASA"
*REC (EXPRESSION=$ASARENT$,TIME=2009.JAN,CATEGORY=PLAN)
*ENDWHEN
*COMMIT
*RUNALLOCATION
*FACTOR=USING/TOTAL
*DIM P_ACCT WHAT=RENT; WHERE=<<<; USING=<<<; TOTAL=<<<
*DIM ENTITY WHAT=$SOURCE$; WHERE=BAS($TARGET$); USING=<<<; TOTAL=<<<
*DIM TIME WHAT=>>>; WHERE=2009.JAN; USING=2008.JAN; TOTAL=<<<
*DIM CATEGORY WHAT=>>>; WHERE=PLAN; USING=ACTUAL; TOTAL=<<<
*ENDALLOCATION
*WHEN ENTITY
*IS "ASA"
*REC (EXPRESSION=0,TIME=2009.JAN,CATEGORY=PLAN)
*ENDWHEN
****************************************************************************************************************************
The error message is that:
u201C/CPMB/MODIFY : Completed in 0 seconds
/CPMB/ALLOCATION_LOGIC : Completed in 2 seconds
/CPMB/CLEAR : Completed in 0 seconds
Selection
-
ASARENT=50000
SOURCE=ASA
TARGET=RASA
(Member Selection)
CATEGORY: ACTUAL,PLAN
RPTCURRENCY: LC
TIME: 2008.JAN,2009.JAN
Messages
-
RUN_LOGIC:Missing [] on property name: WHAT=RENT.
Failed
Application : PLANNING. Package status: ERROR"
**************************************************************************************************
So, would you please kindly give me the solution?
Thank you
Lei Wang