Hi all,
I have written a script logic using for allocation [allocation.lgf] . in Finance model . I have to prompt the value from DM using allocation process chain.
I HAVE TO PASS value to "eurplan" ex:50000 then it distribute to bas members of " target" i.e asian region . I have to prompt source and targe using DM
ex:
HOW MUCH DO YOU WANT TO ALLOCATE = 50000,
source = base member i.e coneuroplan member in source,
Target = Parent value i.e" asian region"
Script logic:
*XDIM_MEMBERSET RPTCURRENCY=USD
*XDIM_MEMBERSET CATEGORY=ACTUAL,PLAN
*XDIM_MEMBERSET TIME=2008.JAN,2009.JAN
*XDIM_MEMBERSET ACCOUNT=RENT
*XDIM_MEMBERSET DATSRC=INPUT
*XDIM_MEMBERSET ENTITY=$SOURCE$,$TARGET$
*WHEN ENTITY
*IS "CONEUROPEPLAN"
*REC(EXPRESSION=$EURPLAN$, TIME="2009.JAN", CATEGORY="PLAN")
*ENDWHEN
*RUNALLOCATION
*FACTOR=USING/TOTAL
*DIM ACCOUNT WHAT=RENT,WHERE=<<<,USING=<<<,TOTAL=<<<
*DIM ENTITY WHAT=$SOURCE$,WHERE=BAS($TARGET$),USING=<<<,TOTAL=<<<
*DIM CATEGORY WHAT=>>>,WHERE=PLAN,USING=ACTUAL,TOTAL=<<<
*DIM TIME WHAT=>>>,WHERE=2009.JAN,USING=2008.JAN,TOTAL=<<<
*ENDALLOCATION
*WHEN ENTITY
*IS "CONEUROPEPLAN"
*REC(EXPRESSION=0, TIME="2009.JAN", CATEGORY="PLAN")
*ENDWHEN
DM allocation package:
PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")
PROMPT(TEXT,%EURPLAN%,"HOW MUCH DO YOU WANT TO ALLOCATE")
PROMPT(TEXT,%SOURCE%,''ENTITY SOURCE")
PROMPT(TEXT,%TARGET%,"ENTITY_TARGET")
INFO(%TAB%,;)
INFO(%EQU%,=)
TASK(/CPMB/ALLOCATION_LOGIC,%TAB%)
TASK(/CPMB/ALLOCATION_LOGIC,%EQU%)
TASK(/CPMB/ALLOCATION_LOGIC,SUSER,%SUSER%)
TASK(/CPMB/ALLOCATION_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/ALLOCATION_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/ALLOCATION_LOGIC,SAPP,%APP%)
TASK(/CPMB/ALLOCATION_LOGIC,LOGICFILENAME,ALLOCATION.LGF)
TASK(/CPMB/ALLOCATION_LOGIC,REPLACEPARAM,SOURCE%EQU%%SOURCE%%TAB%%TARGET%)
TASK(/CPMB/ALLOCATION_LOGIC,REPLACEPARAM,EURPLAN%EQU%%EURPLAN%)
Error: EQU DOES NOT EXIT
Anyone clarify above issue where it is wrong in my script .
Regards,
prasad