Help needed on resolving a string into MDX expression
Posted
by
excel_newbie
on Stack Overflow
See other posts from Stack Overflow
or by excel_newbie
Published on 2010-12-21T23:39:48Z
Indexed on
2011/01/12
4:53 UTC
Read the original article
Hit count: 207
The string is stored in a parameter.
Say, @FiscalPeriod = "[Date].[Fiscal Dates].[Fiscal Quarter]"
Now,
I need to use the parameter as
SELECT Measures.[Revenue] ON 0,
CLOSINGPERIOD("Parameter Here") ON 1
FROM [Sales]
STRTOMEBER function gives error because it is looking for a member at the leaf left such as
[Date].[Fiscal Dates].[Fiscal Quarter].&[Q1 - 2009]
How can I resolve the string into the mdx expression to use it with closing period??
© Stack Overflow or respective owner