Data transfer from DM package and script logic

[Former Member]

Hello experts.

I am using a U type dimension in a prompt in a datamanager package

I solved my first issue with this thread :

My second question is the following :

how do I access the input the user made in the prompt ?

(With a standard dimension like ENTITY, the mapping is automatic we should use %ENTITY_SET%, but for a user defined dimension ... ?)

My DM package code is :

PROMPT(SELECTINPUT,%FAMILLE%,,"Sélectionner une famille (GEN,SPE,LIB,MAR,MEU,POR) :",PRODUCT)

TASK(Execute alloc formulas,USER,%USER%)

TASK(Execute alloc formulas,APPSET,%APPSET%)

TASK(Execute alloc formulas,APP,%APP%)

TASK(Execute alloc formulas,SELECTION,%SELECTIONFILE%)

TASK(Execute alloc formulas,LOGICFILE,%APPPATH%..AdminApp%APP%BUDGET_AllocationsEntites.lgf)

TASK(Execute alloc formulas,RUNMODE,1)

TASK(Execute alloc formulas,LOGICMODE,1)

Thanks in advance for the help

[Former Member · Accepted solution]

Hi,

If your dimension name is ABC, then try using %ABC_SET%.

Hope this helps.

[Former Member · Accepted solution]

I've tested with a leave, and it works fine. (logic do the expected actions on expected records)

Here the dimension is Product, and the prompt is supposed to catch an aggregated member.

The logic should work only on leaves under the selected node in the prompt.

Parent1

--- leave1.1

--- leave1.2

--- leave1.3

Parent2

--- leave2.1

--- leave2.2

(parent1 in the prompt --> leave1.1, leave1.2, leave1.3 in the logic)

I try to use the following memberset :

*MEMBERSET(%PRODUCT_LIST%,Descendants([PRODUCT].[%PRODUCT_SET%],,leaves))

(PRODUCT and %PRODUCT_SET% are links here because of the forum formating, they are between brackets [])

but i get a parsing error message :

The hierarchy '[%PRODUCT_SET%]' was not found in the cube when the string, [PRODUCT].[%PRODUCT_SET%], was parsed.

(once again links are due to forum formatting, it is [])

it seems that the %PRODUCT_SET% is not replaced with its value.

Thanks for your time.

[Former Member · Accepted solution]

Hi,

If you are selecting the parent node in the prompt, then keep

*XDIM_MEMBERSET PRODUCT = BAS(%PRODUCT_SET%)

in the script.

Hope this helps.

[Former Member · Accepted solution]

It doesn't work with

*XDIM_MEMBERSET PRODUCT = BAS(%PRODUCT_SET%)

but it's OK with

*XDIM_MEMBERSET PRODUCT = Descendants([product].[%PRODUCT_SET%],,LEAVES)

Logic work is correct in spite of an error status, I'm checking why (and already found threads concerning that on SDN)

Error is "An error occurred while querying for the Webfolders path.".

Thanks for your time once again.