Skip to Content
0
Former Member
Feb 22, 2009 at 07:44 PM

Some basic SQL script questions

30 Views

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