how to run logic script with variable Tim From .... To not choose multiple value.

[former_member245036]

Dear Expert,

I don't know to create varialbe in logic script when running data package user can cho Time from month to month not choose multiple value.

please tell me how to do this?

thanks so much

[former_member186338 · Accepted solution]

Unfortunately there are no dedicated PROMPT(...) for this type of input.

You can use 2 PROMPT(SELECTINPUT...):

PROMPT(SELECTINPUT,%FROM%,,"Enter TIME From:","%TIME_DIM%")

PROMPT(SELECTINPUT,%TO%,,"Enter TIME To:","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,FROM%EQU%%FROM%%TAB%TO%EQU%%TO%)

Then in the script - something like:

*SELECT(%F%,"[TIMEID]",TIME,"[ID]=$FROM$")

*SELECT(%T%,"[TIMEID]",TIME,"[ID]=$TO$")

*SELECT(%MNTHS%,"[ID]",TIME,"[TIMEID]>=%F% AND [TIMEID]<=%T%")

*XDIM_MEMBERSET TIME=%MNTHS%

...

Vadim

P.S. Ups, correction! Can be used something like:

PROMPT(COPYMOVEINPUT,%FROM%,%TO%,"Enter TIME From/To",”%TIME_DIM%”,)

with the same result!

Unfortunately in both cases the user will be able to select multiple members in From/To...