Error in Calculated Measures in SSAS 2008

• nalina_lingam

  Grasshopper

  Points: 13

  More actions

  November 4, 2011 at 4:46 am

  #262323

  I have been getting error for the below calculated measure.

  CREATE MEMBER CREATECUBE.[Measures].WOP

  AS

  CASE

  WHEN ([Month].[Year].members >= "2011")

  then [Measures].[M1]

  else [Measure].[M2]

  end,

  Visible=1;

  Scenario - When the year is <=2011, measure1 should get displayed else measure2.

  when I hardcode the year ([Month].[Year].&[2011]), it works

  Could anyone please help me on this or provide better solution?

  Thanks in advance!!

• mark 38539

  SSC Eights!

  Points: 848

  More actions

  November 11, 2011 at 8:33 pm

  #1406633

  This is not going to work... "2011" can not just be compared to members like that. Maybe lookup the filter function or the instr function.