Data Manager ComboBox Issue

[former_member182305]

Hello Experts,

I have a combo box to limit the user selection category in the data Manager Prompt. The only filter I need is VERSION, since everything is in the Logic Script based on properties. So I have the next code:

'PROMPT(SELECT,%SELECTION%,,,"%TIME_DIM%") <----commented
PROMPT(COMBOBOX,%VER2%,"Select Destination Version:",0,V1{V1,V2,V3})

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%DIMENSION:VERSION|%VER2%|)
'TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%) <----------commented
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,COPY_ACTUAL_TO_VX.LGF)

I have been doing some testing and It seem like It is mandatory to have a SELECT or SELECTINPUT. Because if I have just the Comobox as in the code above, it doesn't work.

But when I include a dimension with a SELECT or SELECTINPUT, the same code works.

Any Idea if I am doing anything wrong? Is it possible to have just the comboBox??

Thanks in advance.

Best Regards.

[former_member186338 · Accepted solution]

Don't use %SELECTION% at all!

Read: https://blogs.sap.com/2014/09/19/dm-promptcombobox-behavior-in-bpc-nw-10-and-75/

and use replaceparam

[former_member182305 · Accepted solution]

Hi Vadim,

I changed the code as you suggested:

PROMPT(COMBOBOX,%VER2%,"Select Destination Version:",0,V1,{V1,V2,V3})
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,VARIABLE%EQU%%VER2%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,COPY_LIVE_TO_LKDN.LGF)

In the Logic Script I wrote the variable instead %CATEGORY_SET% I had $VER2$.

But I get the error:

/CPMB/MODIFY completed in 0 seconds /CPMB/DEFAULT_FORMULAS_LOGIC completed in 0 seconds /CPMB/CLEAR completed in 0 seconds [Selection] -------------------------------------------------------------- VER2 = V1 [Message] -------------------------------------------------------------- RUN_LOGIC:Members invalid On Dimension(VERSION) model: PBV. Package status: ERROR

As I mentioned it runs successfully when I have a Selection: It could be any dimension:\

The next log is when I tested with a selection:

/CPMB/MODIFY completed in 0 seconds /CPMB/DEFAULT_FORMULAS_LOGIC completed in 1 seconds /CPMB/CLEAR completed in 0 seconds [Selection] -------------------------------------------------------------- SELECTION = /,ENVIRONMENT>/<MODEL>/PRIVATEPUBLICATIONS/<USER>/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:TIME_QTR|ALL_TIME_QTR VER2 = LKDN [Message] -------------------------------------------------------------- model: <MODEL>. Package status: SUCCESS

[former_member182305]

Thank you very much Vadim, you correction made the package run Successfully,

Regards.

[former_member186338]

Incorrect syntax in the line:

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,VARIABLE%EQU%%VER2%)

Has to be:

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,VER2%EQU%%VER2%)

Then in the script you can use $VER2$