IIF syntax for dimensions

• Bunx

  SSC-Addicted

  Points: 473

  More actions

  May 6, 2010 at 5:59 am

  #218557

  Hi.

  I was just wondering what the proper syntax was when using the (MDX) immediate if when working with dimensions.

  I want to calculate a value depending on a certain dimension attribute value as such;

  IIF(Dimension.Attribute = "MyValue", 100, 0)

  However the above syntax doesn't seem to be working for me. Can you actually have a calculated measure evaluating a dimension attribute like this?

  Thanks.

• Bunx

  SSC-Addicted

  Points: 473

  More actions

  May 6, 2010 at 10:28 am

  #1163429

  I worked it out for anyone that needs to know...

  IIF(Dimension.Attribute.CurrentMember.Name = "MyValue", 100, 0)