As pointed out: the problem appears in SSAS Cube Browser, but no problem when browsing the cube in Excel Pivot Table

nb

It seems that the issue (at least for me) appears when it is trying to display a result which is invalid or undefined:

I can browse my calculated measure Moving Quarter to Date (lastperiods(3) at Month level, lastperiod(1) at quarter level, N/A or NULL at Year level

If I only display the quarters, it is fine

If I start browsing the cube at the top of the hierarchy, the years make no sense and the error appears

I have a piece of code which excludes the All dimension member

SCOPE ([DimTime].[Year - Quarter - Month].[All]);

[Date Calculations].[Date Calculation].[YTD] = NULL;

[Date Calculations].[Date Calculation].[PY YTD]=NULL;

END SCOPE;

But I am not sure how to write a similar fragment to exclude all members at the Year level .

But it is fine in Excel anyway, and users do not use the SSAS cube browser.

Mark Lockett