Returning attribute value for MDX statement
Posted: Mon Nov 21, 2022 3:36 am
Hello. I am trying to return my Time dimension's "Month Status" attribute value in the results of this MDX statement:
SELECT non empty {[Scenario].[Scenario].[Budget]} on 0,
non empty
{TM1FILTERBYLEVEL(TM1SUBSETALL([Supplements].[Supplements]) , 0)}
* {TM1FILTERBYLEVEL(TM1SUBSETALL([Time].[Time]) , 0)}
DIMENSION PROPERTIES [Time].[Time].[Month Status]
on 1
from [Programs] where ([Currency].[Currency].[USD], [Programs Measure].[Programs Measure].[Total Revenue])
However I only get 3 columns returning data for Supplements, Time and Scenario...I was expecting a 4th column for the Time dimension's Month Status string attribute. Is something wrong with my syntax?
SELECT non empty {[Scenario].[Scenario].[Budget]} on 0,
non empty
{TM1FILTERBYLEVEL(TM1SUBSETALL([Supplements].[Supplements]) , 0)}
* {TM1FILTERBYLEVEL(TM1SUBSETALL([Time].[Time]) , 0)}
DIMENSION PROPERTIES [Time].[Time].[Month Status]
on 1
from [Programs] where ([Currency].[Currency].[USD], [Programs Measure].[Programs Measure].[Total Revenue])
However I only get 3 columns returning data for Supplements, Time and Scenario...I was expecting a 4th column for the Time dimension's Month Status string attribute. Is something wrong with my syntax?