In SQL Query we can easily get the Top N records for a result set. But we cannot use the same syntax in MDX.
Below query will show the Top 10 records of the result set.
Below query will show the Top 10 records of the result set.
1: SELECT {[Measures].[Unit Price] } ON COLUMNS,NON EMPTY
2: Head(NONEMPTY(CrossJoin([Item].[Item].[All] ,[Company].[Company].[All].Children) ),10) ON ROWS
3: FROM [Cube]
No comments:
Post a Comment