DM variables to custom logic

[Former Member]

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.

[Former Member · Accepted solution]

Hi,

Everything looks fine to me.

What are you selecting for the different dimensions at the prompt while running the DM package?

Can you please share your log?

[Former Member · Accepted solution]

Hi Nilanjan,

Thanks for your response.

I added the Data Source dimension to the selection criteria, and the data manager variable was passed on to the custom logic properly. The results appear to be just fine.

Once again, thanks...