This message was posted by a user wishing to remain anonymous

Dear Community members,
I kindly ask if someone has a good advice related to Top N, Other, Total lines calculations in Crosstab.
Namely, our Client has report created based on dynamic cube (aggregates used in report are in memory).
Report shows Top N products and is filtered via master-detail relationship (filter is based on list of values that are on higher level of that product hierarchy). When calculated members  "Other" and "Total" are added to report, report performance degrades (Top N member set itself doesn't represent such a problem).
Calculated members are calculated as
Total = aggregate (currentMeasure within set [Cube XX].[Hierarchy].[Level].[Product]) 
and
Other = aggregate (currentMeasure within set except ( [Cube XX].[Hierarchy].[Level].[Product], [TOP 10 Product]))

Thanks and regards!

#CognosAnalyticswithWatson