Help With MDX

• Jonathan Mallia

  SSCertifiable

  Points: 5192

  More actions

  October 22, 2012 at 8:47 am

  #283354

  Hi everyone,

  I need help with building a Cube Calculation.

  I have this MDX below that works OK. It shows the vehicles that are sold an and the profit made after the vehicles are sold.

  SELECT

  {[Measures].[Sales Amount], [Measures].[Profit on Vehicle Sale]} on 0,

  EXISTS( [Vehicle].[Vehicle ID].members, , "Vehicle Sales" ) on 1

  FROM [VehicleSales]

  Now I need to translate this to Cube Calculation but am struggling.

  When the user drags the vehicles dimension and [Measures].[Profit on Vehicle Sale] measure, I want to user to see only those vehicles that are sold.

  Thanks for the help,

  Jon

• a4apple

  SSCrazy

  Points: 2620

  More actions

  October 22, 2012 at 1:07 pm

  #1551603

  Jonathan Mallia (10/22/2012)

  ---

  Hi everyone,

  I need help with building a Cube Calculation.

  I have this MDX below that works OK. It shows the vehicles that are sold an and the profit made after the vehicles are sold.

  SELECT

  {[Measures].[Sales Amount], [Measures].[Profit on Vehicle Sale]} on 0,

  EXISTS( [Vehicle].[Vehicle ID].members, , "Vehicle Sales" ) on 1

  FROM [VehicleSales]

  Now I need to translate this to Cube Calculation but am struggling.

  When the user drags the vehicles dimension and [Measures].[Profit on Vehicle Sale] measure, I want to user to see only those vehicles that are sold.

  Thanks for the help

  Jon

  I am new to mdx too, but as far as I have been reading through there is a inbuilt function called NON EMPTY. I think that would suffice your needs. Please post once you find an answer. Good Luck..

  Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.