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.

[Former Member]

Nilanjan,

That worked, thanks..

Now i'd like to do more, lets say that when the user click on the button to chose the members he wants, i wanna it to be filtered by category for example.

Instead of showing all the members, it would only show the ones i filtered!

Thanks

Leandro

[Former Member]

Hi Leandro,

I dont think you can display the filtered members automatically. However, once the dimension list is popped up, you can definitely filter at that time.

Hope you got my point.

[Former Member]

Hi,

As far as I know, these variables are just names assigned to various dimensions. So, intead of using these variables, you can even use the dimension names directly. For the user defined variables, there are no variables available. So, you can use the dimension name directly.

Hope you got my point.

[sorin_radulescu]

For Dimensions type E, C, T, R, A you can use:

%ENTITY_DIM%

%CATEGORY_DIM%

%TIME_DIM%

%CURRENCY_DIM%

%ACCOUNT_DIM%

For user defined dimensions you don't have something similar.

You can use input field like text but for sure is not the same like having a selection windows.

Regards

Sorin Radulescu