TOPCount mdx query at different dimension hierarchy levels

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  analysis services   » TOPCount mdx query at different dimension hierarchy levels

TOPCount mdx query at different dimension hierarchy levels

Topic RSS Feed

Posts under the topic: TOPCount mdx query at different dimension hierarchy levels

Posted: 1/17/2012

Jedi Youngling 30  points  Jedi Youngling
  • Joined on: 7/19/2011
  • Posts: 10



I have a dimension called location having a hierarchy Country, State, City.......

I written an mdx query which will return top 3 customers having high sales amount.

Find the mdx query below: Created the below mdx as named set in cube.

TOPCOUNT([Customer].[Customer Name].[Customer Name],3,[Measures].[Sales Amount])

SELECT

NON EMPTY TOPCOUNT([Customer].[Customer Name].[Customer Name],3,[Measures].[Sales Amount])

ON COLUMNS,

NON EMPTY { [Measures].[Sales Amount] } ON ROWS

FROM [Cube]

I created a chart in PPS (performance point server) for Top 3 customers by Sales Amount,

having Sales Amount on series, Named set on bottom axis.

It works fine when i slice it through country level but if i drill down to state and city

level it is not working fine.

The same top 3 customers whose has high sales at country level is divided and given at

state and city level when i do a drill down. But if i do a query in database the list of top

3 customers at state level is slight different from the result i get from drill down from

country to state.

Please help me on this..... Thanks in Advance.


Page 1 of 1 (1 items)