Data Manager Prompt Multiple SELECT in one window with assigning multiple variables

[Former Member]

Hello, colleagues!
We have a data package with 3 SELECT prompts as we need to pass 3 selected values via variables to script logic. As a result we have 3 seperated Selection window. The last DM window where u should check selection, select when to run a package and press "Finish" only displays selected member from the last selection window.
Users wants us to display here all 3 selected members of dimensions. Is it possible anyhow? Maybe any workaround?

I've been thinking about several ideas:
Use prompt MESSAGE and fill it with variables with values of choosen dimension members, but variables in MESSAGE doesn't work as i tried.

Edit last window displayed members - can't find anywhere information about possibility of that.
Use 1 prompt SELECT with multiple select of 3 dimension members, but each one selection should go to it's own variable - can't find right syntax how to assigh several variables to several selections in one prompt SELECT.
Thanks in advance for any help!

[former_member186338 · Accepted solution]

You are doing something strange...

The correct scripts are:

PROMPT(SELECT,%SELECTION%,,"Selection 1,2,3","%ENTITY_DIM%,%TIME_DIM%,%CATEGORY_DIM%")
PROMPT(KEYDATE,%KEYDATE%,"Key date",0)
INFO(%EQU%,=)
INFO(%TAB%,;)
INFO(%DO_CALC%,ON)
INFO(%COMP1%,2)
TASK(ZBRP_ALLOCATION_LOGIC_21,TAB,%TAB%)
TASK(ZBRP_ALLOCATION_LOGIC_21,EQU,%EQU%)
TASK(ZBRP_ALLOCATION_LOGIC_21,SUSER,%USER%)
TASK(ZBRP_ALLOCATION_LOGIC_21,SAPPSET,%APPSET%)
TASK(ZBRP_ALLOCATION_LOGIC_21,SAPP,%APP%)
TASK(ZBRP_ALLOCATION_LOGIC_21,SELECTION,%SELECTION%)
TASK(ZBRP_ALLOCATION_LOGIC_21,REPLACEPARAM,DO_CALC%EQU%%DO_CALC%%TAB%COMP%EQU%%COMP1%)
TASK(ZBRP_ALLOCATION_LOGIC_21,LOGICFILENAME,LOGIC.LGF)


*SELECT(%V1%, YEAR, TIME, ID = %TIME_SET%)
*SELECT(%V2%, ID, TIME, YEAR = %V1% AND CALC = N)
*SELECT(%V3%, ORG_LINK, CFR, ID = %CFR_SET%)
*XDIM_MEMBERSET TIME = %V2%
*XDIM_MEMBERSET ORGSTR = BAS(%V3%)
*XDIM_MEMBERSET CAT = %CAT_SET%
*START_BADI ZBRP_CALC
DO_CALC = $DO_CALC$ //why do you fix it in advanced script?
COMP = $COMP$ //why do you fix it in advanced script?

ORG = %4% /??? What do you mean by %4%?
QUERY = OFF
WRITE = ON
*END_BADI

[former_member186338 · Accepted solution]

P.S. Why do you use custom chain ZBRP_ALLOCATION_LOGIC_21?

Standard chain /CPMB/DEFAULT_FORMULAS will do the same...

Or /CPMB/ALLOCATION

[former_member186338 · Accepted solution]

Is it clear? Have you tested it?