Skip to Content
0
Former Member
May 13, 2011 at 04:40 PM

Data Manager Package - SELECTINPUT multiple instance of the same dimension

36 Views

Hello Experts

In the data manager package, I would like to have multiple instances of Category dimension selection option.

I have the following code snippet.

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%TIME_DIM%,%CATEGORY_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,STORE_FLAG.LGF)

This displays two drop downs of Category. This is what I want.

In the LGF script, I did notice that %CATEGORY_SET% maps to the value selected in the first category drop down.

Question is - how to get the value/members selected in the second Category selection ?

I also tried the following code snippet. However I get an error message when I execute the package.

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%TIME_DIM%")

PROMPT(SELECTINPUT,%FVAR%,,,"%CATEGORY_DIM%")

INFO(%EQU%,=)

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,STORE_FLAG.LGF)

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

Thanks in advance for your time.

Nikil