Calculated Member MDX

• rk07

  SSC Enthusiast

  Points: 156

  More actions

  September 2, 2010 at 6:52 pm

  #141950

  Hi Everyone... i am new to mdx and need some approach or direction in writing an mdx query. i have a dimmension called brand and a measure called spend and i need to calculate the spend for the top 7 competitors .

  Any help would be appreciated..

  Thanks

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  September 2, 2010 at 8:36 pm

  #1216012

  Basically you can make use of the TOPCOUNT function. Either google for it or use the links below.

  The very dry, Books OnLine explanation of TOPCOUNT.

  A little longer article by Bill Pearson with possibly more worked examples.

  HTH,

  Steve.

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  September 6, 2010 at 5:17 am

  #1216868

  SELECT [Measure] ON COLUMNS,

  TOPCOUNT

  (

  {[Dimension]},7,[Measure]

  ) ON ROWS

  FROM [CUBE_NAME]

  Raunak J