I think Top N filter functionality should be implemented based on tuple as currently if more than 1 dimension is present on the column and user apply top N filter then it doesn't return top 10 Members
Current Implementation MDX:
Select non empty TopCount(HIERARCHIZE(DISTINCT({{
[Customers].[Name].Members}})),10,[Measures].[Store Sales]) on rows,
non empty Crossjoin(HIERARCHIZE(DISTINCT({Crossjoin({
[Gender].[All Gender].[M]},
{[Time].[1997].[Q1]}
)})),{
[Measures].[Store Sales]}) on columns
From [Sales]
Recommended solution MDX:
SELECT { CrossJoin({[Gender].[Gender].[M]}, CrossJoin({[Time].[Year].[1997].[Q1]}
,{Measures.[Store Sales]}))} ON COLUMNS,
NON EMPTY {Filter ({TopCount({[Customers].[Name].members}
,10.0,
([Measures].[Store Sales] , [Gender].[Gender].[M], [Time].[Year].[1997].[Q1])
)}, ( 1 = 1 ))} ON ROWS
FROM [Sales]
* I need other users feedback on this as i think this is a very important functionality to be implemented. |
Report Portal
Top N Filter tuple based
Posted - 12/01/2009 : 04:26:18
