on ‎2018 Jan 19 5:54 PM
Hi - Am currently working on to get Target Values from Multiple dimensions , similar to COPYINPUT command .
However, the DM Package failed with message ''More than one dimension in selection condition'
Here is my advanced Script.
PROMPT(SELECT,%SELECTION%,,"Selection 1,2,3","%CATEGORY_DIM%,%TIME_DIM%,SHOW")
PROMPT(SELECTINPUT,%T_CAT%,%T_TIME%,%T_SHOW%,"%CATEGORY_DIM%,%TIME_DIM%,SHOW,")
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%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,SELECTION,%SELECTION%)
*TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,T_CAT%EQU%%T_CAT%%TAB%T_TIME%EQU%%T_TIME%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,T_CAT%EQU%%T_CAT%%TAB%T_TIME%EQU%%T_TIME%%TAB%T_SHOW%EQU%%T_SHOW%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,ZZTEST.LGF)
Please let me know, how to fix this and any other alternative solution.
Request clarification before answering.
Thanks Vadim . It works
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you are talking about badi (strange idea to copy using badi...) then you can use:
PROMPT(COPYMOVEINPUT, %SOURCE%, %TARGET%, [label], [dimensions], [default members])
You can pass SOURCE and TARGET "as is" using REPLACEPARAM and then you can parse variables inside badi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Vadim. Will try and let you know.
Regards
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For sure this syntax is not supported:
PROMPT(SELECTINPUT,%T_CAT%,%T_TIME%,%T_SHOW%,"%CATEGORY_DIM%,%TIME_DIM%,SHOW,")
You need 3 prompts - one prompt for each variable!
Please read help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 17 | |
| 8 | |
| 7 | |
| 6 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.