on 04-28-2016 8:51 AM
Hi all,
How can selection entries of a data manager package be used in a script logic programme?
For example:
How can I use the version PLAN in a script logic and change the version dynamically to another version?
Can anybody please provide me with some example code?
Thanks in advance and best regards
Gerd
Hi Gerd,
There are 3 ways to pass DM package prompt values to script togic:
1. %SELECTION% with multiple dimensions and members - result: the script initial scope will be set according to %SELECTION%. In the script the initial scope can be referenced as %DIMNAME_SET% variables (%CURRENCY_SET%, %TIME_SET%, etc)
PROMPT(SELECTINPUT,%SELECTION%,,"Select CATEGORY, CURRENCY and TIME","%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")
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,TEST.LGF)
in TEST.LGF: use %CURRENCY_SET%, %TIME_SET%
2. Single dimension SELECTINPUT prompt with result stored in %SOMEVARIABLE%. Then you can use MEMBERSELECTION TASK to pass %SOMEVARIABLE% to $SOMEVARIABLE$ in script logic.
PROMPT(SELECTINPUT,%SOMEVARIABLE%,,"Select CATEGORY","%CATEGORY_DIM%")
INFO(%EQU%,=)
INFO(%TAB%,;)
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,EQU,%EQU%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,SOMEVARIABLE%EQU%%SOMEVARIABLE%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,TEST.LGF)
in TEST.LGF: use $SOMEVARIABLE$
3. TEXT or COMBOBOX Prompts resulting in text value stored in some variable %SOMETEXTVARIABLE%. Can be passed to script logic using REPLACEPARAM TASK to $SOMETEXTVARIABLE$
PROMPT(COMBOBOX,%SOMETEXTVARIABLE%,"Prompt text for user",0,TEXT1,{TEXT1,TEXT2,TEXT3,TEXT4,TEXT5})
INFO(%EQU%,=)
INFO(%TAB%,;)
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,EQU,%EQU%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,SOMETEXTVARIABLE%EQU%%SOMETEXTVARIABLE%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,TEST.LGF)
in TEST.LGF: use $SOMETEXTVARIABLE$
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
16 | |
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.