magritton
12/28/2014 - 10:09 PM

This is an MDX query that uses a bottom count command to get the last ten entries in a cube

This is an MDX query that uses a bottom count command to get the last ten entries in a cube

MDX Last 10
content_copyfile_download
SELECT
{ [Automated Process Tracker].[Process].[Process].ALLMEMBERS } * { [Measures].[Sum of SuccessCnt], [Measures].[Sum of FailCnt] as Failed }
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