Skip to Content
0
Former Member
Dec 07, 2011 at 02:31 PM

*FOR Variable

27 Views

Hi,

Is it possible to use the *FOR Variable in a subsequent MDX or SELECT statement? E.g.

*MEMBERSET(%Acc1%,"Descendants(Account.[A_1000],,LEAVES)")

*FOR %CurrAcc%=%Acc1%

*SELECT(%CurrAcc1%,"ID","Account","ID=%CurrAcc%")

*NEXT

The above sample does not validate. Is there a way to use %CurrAcc% within the *FOR?

Thanks.