Pass range in script logic

[former_member269454]

Hi folks ,

I have a query , how to pass the range in the script logic . I am reading two dimension member values and basically I need to pass two value as range in the script logic .Is there any way to do that ?

Thanks in advance.

[former_member186338 · Accepted solution]

For example:

In %T1% you have start month and in %T2% - end month (selected from some property)

Then:

*SELECT(%TID1%,[TIMEID],TIME,ID=%T1%)
*SELECT(%TID2%,[TIMEID],TIME,ID=%T2%)
*SELECT(%T%,[ID],TIME,TIMEID>%TID1% AND TIMEID<%TID2%) // or ">=" and "<=" to include %T1% and %T2%
*XDIM_MEMBERSET TIME=%T%

[former_member269454 · Accepted solution]

Thank you so much.

[former_member186338]

Sorry, but not clear what do you mean! Please explain scenario with full details!

[former_member269454]

Hi Vadim ,

I am reading two different properties values from category dimension and those are two different months , I need to pass the range between those two months to the time dimension in the time script logic scoping for the time dimension.