Problem in Select statement in script logic

[abhishekit332]

How to change dimension on the basis of property selection in Script logic?

[former_member186338]

Sorry, but unable to understand what do you want to achieve!

If you want an answer - please spend some time and provide a clear explanation with some sample.

[raghuramulumodi]

Do you mean, How to use a property of dimension in script logic select statement?

If yes, below is an example, We have YEAR property in TIME dimension and that can be used like below in select statement.

*SELECT(%YR%,"[YEAR]",TIME,"[ID] = '%TIME_SET%'")

Thanks

Raghu