Use the
TopCount()[
^] function. Remember, the set must already be ordered using the
Order (MDX)[
^] function.
select
{
[Measures].[Measure1], [Measures].[Measure1]
, [Measures].[Measure1]
}
on columns,
topcount(
crossjoin(
[Dimension].[Dimension].[Dimension].&[123]
, [Dimension2].[Dimension2].[Dimension2]
)
,10
)
on rows
from [Cube name]