Filter Data Manager Variable for user Selection

[former_member597393]

Hi Experts,

I am selecting the time from Data Manager, in advanced script I have this statement :

PROMPT(SELECT,%TIMEID%,,"Selection 1","%TIME_DIM%")

My variable passed to the badi and script logic with the following value :

TIMEID =/.../..FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:TIME|2021.01,2021.02

I want to pass to the script logic only this value 2021.01,2021.02 because I am using it in further calculation in script logic.

How I can filter or trim this variable string in script logic ? or any other alternative in the advanced script of DM ?

Regards

Mohamed

[former_member186338]

Sorry, but you have to explain the required scenario in details!

Why do you need to have separate select for TIME?

[former_member186338 · Accepted solution]

In DM advanced script you can use %SELECTION% or some user defined variable like %TIMEID%

%SELECTION% is passed as %XXX_SET% to script logic.

To pass %TIMEID% you can't use REPLACEPARAM, you have to use MEMBERSELECTION in TASK with the same syntax.

Result of MEMBERSELECTION is $xxx$ variable in script logic.

[former_member597393 · Accepted solution]

Thanks Vadim,

using standard chain and MEMBERSELECTION , I am able to pass user selection to variable.