Skip to Content
0
Former Member
Nov 22, 2012 at 04:41 AM

Problem on execution of script logic and promp the values from DM using allocation package

49 Views

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