on 07-09-2014 11:53 AM
Dear Expert,
Please explain for me and show how to solve this issue.
thanks so much
hungth
Please provide the DM advanced script and script logic text you want to execute.
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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...
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.