MDX Query Attribtue Dimension
I am creating an MDX data export from an Essbase 11.1.2.2 BSO cube to replace a slow-running report script. Using the Execute MDX in Smart View to test it. For the rows, I need the first member to be from the cost center dimension. The second cell will have the corresponding text from an attribute dimension. I am having trouble getting the attribute text out. Can someone help me with the syntax? What I have so far:
WITH MEMBER [Period].[YTD_CLSExpMonth] AS 'SUM(PeriodsToDate([Period].Generations(1), [Period].[&ClsExpMonth]))'SELECT{ ([Actual], [JDE], [&ClsExpYr], [&ClsExpMonth]),([Actual], [Final], [&ClsExpYr], [&ClsExpMonth]),([Actual], [Final], [&ClsExpYrMinus1], [&ClsExpMonth]),
0