magritton
12/29/2014 - 12:12 AM

MDX query with changes to the names of multiple columns and use of the bottomcount function to get the last x number of items in the cube

MDX query with changes to the names of multiple columns and use of the bottomcount function to get the last x number of items in the cube

with member [Measures].[Success] as [Measures].[Sum of SuccessCnt]

member [Measures].[Fail] as [Measures].[Sum of FailCnt]

SELECT
{ [Automated Process Tracker].[Process].[Process].ALLMEMBERS } * { [Measures].[Success], [Measures].[Fail]}
ON COLUMNS,

{ bottomcount([Automated Process Tracker].[Process Date].[Process Date].ALLMEMBERS,10) }
ON ROWS

FROM [APT Tabular]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, FONT_FLAGS, FORE_COLOR, BACK_COLOR