Search code examples
ssasmdxbusiness-intelligence

Null values for calculated members in case statement (MDX)

i am a beginner in MDX. I want to show the number of a month January --> 1.

CREATE MEMBER CURRENTCUBE.[Measures].[Mnr]
 AS CASE [Measures].[Time].[Calendar].[Month].Currentmember.Name
   WHEN 'January' THEN '1'
   WHEN 'February' THEN '2'
ELSE 'Unknown'
END

I get only null values and can not find my mistake.

Solution

  • Probably you need to replace [Measures].[Time].[Calendar].[Month].Currentmember.Name with [Time].[Calendar].CurrentMember.Name

    The CurrentMember function operates on a hierarchy not a level. And Measures is wrong as the Time dimension isn’t a child of Measures.