Skip to Content
0
Former Member
Jun 13, 2011 at 01:30 PM

DM variables to custom logic

17 Views

Hello Experts,

I developed a custom process chain with the following code:

PROMPT(SELECTINPUT,,,,"%ACCOUNT_DIM%,%ENTITY_DIM%,%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")
PROMPT(TEXT,%SCRIPT_FILE%,"Choose Script Logic File",)
PROMPT(TEXT,%PERCT%,"Input Percentage",)
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(ZBPC_RUN_LOGIC,TAB,%TAB%)
TASK(ZBPC_RUN_LOGIC,EQU,%EQU%)
TASK(ZBPC_RUN_LOGIC,SUSER,%USER%)
TASK(ZBPC_RUN_LOGIC,SAPPSET,%APPSET%)
TASK(ZBPC_RUN_LOGIC,SAPP,%APP%)
TASK(ZBPC_RUN_LOGIC,SELECTION,%SELECTION%)
TASK(ZBPC_RUN_LOGIC,LOGICFILENAME,%SCRIPT_FILE%)
TASK(ZBPC_RUN_LOGIC,REPLACEPARAM,PERCT%EQU%%PERCT%)

After this, I tried to execute a script logic with 2 accounts - UPSIDE_FACTOR & MY_ACCOUNT - with the following script logic code:

*WHEN ACCOUNT
*IS UPSIDE_FACTOR
*REC(FACTOR=$PERCT$, ACCOUNT = MY_ACCOUNT)
*ENDWHEN
*COMMIT

I am working with the following sample data:

ACCOUNT,CATEGORY,ENTITY,TIME,DATASRC,INTCO,RPTCURRENCY,AMOUNT

UPSIDE_FACTOR,PLAN,STORE1,2008.JAN,INPUT,NON_INTERCO,LC,2000.00

UPSIDE_FACTOR,PLAN,STORE1,2008.FEB,INPUT,NON_INTERCO,LC,2500.00

UPSIDE_FACTOR,PLAN,STORE1,2008.MAR,INPUT,NON_INTERCO,LC,1000.00

During the package execution, i specified the factor PERCT (DM variable) as 2.0 (to double the values). I got an error saying that the package was executed successfully, but the formula log gives the values to be written back as 0.0.

Any idea why this is happening? All your help is greatly appreciated.