Let me explain the purpose of the blog post via a diagram:
The current year selected was 2014 and since it’s 30 MAR 2014 today, it’s not showing data for April and onwards. But for 2013, it’s showing all months. How to hide null values for months in current fiscal year and at the same time show only applicable months for Previous Year? Here’s the pseudo code to get you started:
[code language=”sql” gator=”false”]
WITH MEMBER [Measures].[Prior Year Sales Amount] AS
([Measures].[Sales Amount],[Fiscal Year].CurrentMember.PrevMember)
SELECT
{[Measures].[Sales Amount],[Measures].[Prior Year Sales Amount]} on columns,
NONEMPTY ([Month].[Month],
[Measures].[Sales Amount]) on rows
FROM [CUBENAME]
WHERE
[Fiscal Year].&[2014]
[/code]
Note:
1) Do you see the use of NONEMPTY function? It hides the null values in the [measures].[sales amount].
Resource: Non Empty vs NONEMPTY function.
2) do not forget the { } around the measures that you’re putting on column axis. Otherwise you may see an error like “Parser: The statement dialect could not be resolved due to ambiguity.”
I hope this gives you a good starting point.