How can I use entries from the selection screen of a data manager package in script logic programmes?

[Former Member]

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

[former_member186338 · Accepted solution]

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