MDX CALCULED MEASURES FOR ALL LEVEL OF A HIERARCHY

• Lidou123

  Hall of Fame

  Points: 3186

  More actions

  July 2, 2014 at 4:33 am

  #309619

  Hi,

  Could someone help me to write a MDX script to calculate a measure for all level of a hierachy?

  I explain you:

  I have a hierarchy "Product" with these levels

  1- Category

  2- Subcategory

  3- Product

  I want to have in the same request to have the [measures].[Value] for all level for my hierarchy.

  I have this:

  SELECT {[MEASURES]. [VALUE]} ON COLUMNS

  , {[PRODUCT].[PRODUCT].[ID_PRODUCT]} ON ROWS

  FROM MYCUBE

  WHERE [DIM_TIME]&.[201406]

  Could someone help me ?

• PB_BI

  SSCoach

  Points: 17463

  More actions

  July 2, 2014 at 6:02 am

  #1726449

  Assuming you have a hierarchy in your product dimension called Product then the following will give you the "All" member along with everything else:

  [Product].[Product].Members

  If you want to display just your all member then you need to state it in the co-ordinates like:

  [Product].[Product].[i]whatever you call your all member[/i]

  Have a look here for more information on the All member: http://www.bp-msbi.com/2010/02/all-member-properties-name-key-and/

  I hope that helps 🙂

  ---

  I'm on LinkedIn

• Lidou123

  Hall of Fame

  Points: 3186

  More actions

  July 3, 2014 at 1:50 am

  #1726697

  Thanks !!! 🙂