RUN_LOGIC:Dimension set:"TIME" not assigned in Data Manager

[former_member245036]

Dear Expert,

Please explain for me and show how to solve this issue.

thanks so much

hungth

[former_member186338 · Accepted solution]

Please provide the DM advanced script and script logic text you want to execute.

Vadim

[former_member245036 · Accepted solution]

here is my advanced:

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%")

PROMPT(TEXT,%SCRIPT_FILE%,"Choose Script Logic File",)

PROMPT(SELECTINPUT,%TFROM%,,"FROM MONTH","%TIME_DIM%")

PROMPT(SELECTINPUT,%TTO%,,"TO","%TIME_DIM%")

PROMPT(TEXT,%PERCT%,"Percentage Actual Data Last year",)

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,%SCRIPT_FILE%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,TFROM%EQU%%TFROM%%TAB%TTO%EQU%%TTO%)TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,PERCNT%EQU%%PERCT%)

and here is my script

//scope of data for processing

*XDIM_MEMBERSET CATEGORY= Actual

// loop record

*SELECT(%T%,"[ID]",TIME,"[CALC]=N AND [ID]>=$TFROM$ AND [ID]<=$TTO$")

*FOR %T% = %TIME_SET%

*XDIM_MEMBERSET TIME=%T%

*WHEN TIME

*IS %T%

*REC(EXPRESSION =%VALUE%*$PERCNT$,TIME=TMVL(12,%T%),CATEGORY=Plan)

*ENDWHEN

*NEXT

// save into database

*COMMIT

please check and help us

[former_member186338 · Accepted solution]

Your %TIME_SET% variable is not getting any value in advanced DM scrip. You have to change script line:

*SELECT(%T%,"[ID]",TIME,"[CALC]=N AND [ID]>=$TFROM$ AND [ID]<=$TTO$")

*FOR %T% = %TIME_SET%

To:

*SELECT(%TT%,"[ID]",TIME,"[CALC]=N AND [ID]>=$TFROM$ AND [ID]<=$TTO$")

*FOR %T% = %TT%

No %TIME_SET%!

And remove COMMIT!

Vadim

P.S. strange that %CATEGORY_SET% is not used in the script code...

[former_member200327]

Hi hungth,

I'd have to assume that you ran a DM Package for script logic. I'm also assuming that your script logic has %TIME_SET% variable, but no member was assigned to that Dimension in your Dynamic Script.

If those assumptions are not correct, please provide more info.

Regards,

Gersh