Query for calculated measure by member name?

• MWise

  SSCarpal Tunnel

  Points: 4074

  More actions

  September 14, 2011 at 2:47 pm

  #244881

  I'm simplyfing my issue by using a date hierarchy as the example since it's the same concept. How would I write an MDX query to get the sum of sales by month names (January, February, etc) across all the years?

  Thanks,

  Marcy

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  September 14, 2011 at 9:41 pm

  #1381707

  Something like the following is what you will need

  SELECT

  {[Measures].[Sales Amount] } * { [Calendar].[Month].members }

  ON COLUMNS,

  { [Calendar].[Year].members }

  ON ROWS

  FROM [Sales Cube]

  You will need to substitute the appropiate cube and dimension names