1

I recently started encountering strange problem as shown in image below. While browsing a SSAS cube, the Dimension Names appear blank.

Dimension: I have [Date].[Calendar Month].[Month] Measure: [Services in 3 days]

enter image description here

After I run a query like 

Select [Date].[Calendar Month].[Month] on 0 From [Service Cube]

then the Dimension Member Names show up in cube browser with different value for measure.

Any clues?

enter image description here

JotaBe
  • 38,030
  • 8
  • 98
  • 117
Merin Nakarmi
  • 3,148
  • 3
  • 35
  • 42

1 Answers1

2

That's because you have blank members in [Date].[Calendar Month] hierarchy. To check 'em out, run the below MDX query:

WITH SET BlankMonth AS
FILTER([Date].[Calendar Month].CHILDREN, [Date].[Calendar Month].currentmember.MEMBERVALUE = '')

SELECT [Measures].[Services in 3 days] ON 0,
BlankMonth ON 1
FROM [Service Cube]
SouravA
  • 5,147
  • 2
  • 24
  • 49