Dynamic script - User defined dimension

[Former Member]

Hi

I have the following problem.

When i create a task in the data manager, and i want the user to select some menbers of the dimensions to be used in the script logic, for example, if i want him to select the time all i do is a PROMPT tag with the %TIME_DIM% variable.

What if i want a user defined dimention, lets say product for instance.

If i use the variable %DIMS% i get the product dimension and all others, but i want only the PRODUCT dimension.

Any ideas?

Thanks

[Former Member · Accepted solution]

I tried using the name of the dimension.

That ddin't work, and the idea of using a text field and letting the user input anything he wants, scares the living hell out of anyone.

Thanks

Leandro Brasil

[Former Member · Accepted solution]

Hi Leandro,

You can try something like below:

PROMPT(SELECTINPUT,%SELECTION%,,"Select the members to CLEAR",%DIMS%)
You can replace the above statement by
PROMPT(SELECTINPUT,%SELECTION%,,"Select the members to CLEAR",CATEGORY)

In the above statement, CATEGORY is just the name of the dimension. You can try similarly with other dimensions too.

Hope this helps.