how to create calculated measure

• quasar_phoenicis

  SSCommitted

  Points: 1625

  More actions

  November 3, 2010 at 4:23 pm

  #226036

  Hi,

  I wanted to create a new calculated measure using SSAS 2005.

  First, I want to check if the value of column1 in dimension_table_a is = 5.

  if True then calculated measure will return the value 1; if not then 0.

  how shall i do this in MDX or in SSAS 2005?

  Please help. Thanks!

• amit_gupta01

  SSChasing Mays

  Points: 605

  More actions

  November 3, 2010 at 11:17 pm

  #1246385

  Use IF ELSE statement

  Thanks,
  Amit G
  http://www.msbiconcepts.com

• quasar_phoenicis

  SSCommitted

  Points: 1625

  More actions

  November 4, 2010 at 10:47 am

  #1246683

  was able to figure it out through this http://www.databasejournal.com/features/mssql/article.php/3616526/MDX-Operators-The-IS-Operator.htm. thanks!