MDX Query doubt

• narendra.babu57

  Old Hand

  Points: 386

  More actions

  August 6, 2014 at 2:09 am

  #294026

  Hi All,

  I required each geography wise which product is highest sales . will you please help me any one idea in mdx how to write this query.

• happycat59

  One Orange Chip

  Points: 29387

  More actions

  August 6, 2014 at 10:37 pm

  #1735835

  You don't give much information so you can't really expect any detailed replies

  Have a look at the MAX aggregation function

• narendra.babu57

  Old Hand

  Points: 386

  More actions

  August 8, 2014 at 4:13 am

  #1736356

  Hi ,

  Thanks for the reply. Any how i got the solution

  WITH SET Top10Cust AS

  [DimGeographyBuyer].[State].[State]

  set topP as

  Generate( {Top10Cust}, CrossJoin( {[DimGeographyBuyer].[State].CurrentMember},

  TopCount([DimProduct].[MaterialId].[MaterialId].Members, 1, ([Measures].[DistributorSalesSum]))))

  SELECT

  {([Measures].[DistributorSalesSum]) } ON COLUMNS ,

  non empty {topP}

  ON ROWS

  FROM (SELECT ( { [MarketYear].[MarketYearHierarchy].[MARKETYEAR].&[2014] } ) ON COLUMNS

  FROM

  [Mycube])