Little trick :)
WITH
MEMBER [Date].[Calendar Year].[Value] AS [Date].[Calendar Year].[CY 2005].Parent
SELECT
[Date].[Calendar Year].[Value] ON COLUMNS,
Measures.AllMembers ON ROWS
FROM [Adventure Works]
Little trick :)
WITH
MEMBER [Date].[Calendar Year].[Value] AS [Date].[Calendar Year].[CY 2005].Parent
SELECT
[Date].[Calendar Year].[Value] ON COLUMNS,
Measures.AllMembers ON ROWS
FROM [Adventure Works]