Hi,
two small questions:
1) in SQL logic, how to select the value of a property of a certain member? For example 'select the value of property "PRIORYEAR" from member Q2009.TOTAL' ...
2) I'd like to use the value passed to the logic by the user for the time dimension in a *SELECT statement, as illustrated below. However apperantly *SELECT statement does not accept this. With the statement below, the variable target is not filled. If I replace %TIME_SET% with a certain member value, it works fine ...
*SELECT(%TARGET%,"[ID]","TIME","TD='%TIME_SET%'")
regards
D