MDX Code:
WITH
MEMBER [Measures].[ParameterCaption] AS [Date].[Date Hierarchy].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue] AS [Date].[Date Hierarchy].CURRENTMEMBER.UNIQUENAME
MEMBER [Measures].[ParameterLevel] AS [Date].[Date Hierarchy].CURRENTMEMBER.LEVEL.ORDINAL
SELECTNONEMPTY
{ [Measures].[ParameterCaption]
, [Measures].[ParameterValue]
, [Measures].[ParameterLevel]
} ONCOLUMNS
, NONEMPTY
{ ORDER([Date].[Date Hierarchy].[Month]
,[Measures].[ParameterValue]
,BDESC)
} ONROWS
FROM [CubeName]
Result:
Parameter Label
Nov 2010
Oct 2010
Sep 2010
Aug 2010
Jul 2010
Jun 2010
May 2010
Parameter Value
[Date].[Date Hierarchy].[Month].&[20101100]
[Date].[Date Hierarchy].[Month].&[20101000]
[Date].[Date Hierarchy].[Month].&[20100900]
[Date].[Date Hierarchy].[Month].&[20100800]
[Date].[Date Hierarchy].[Month].&[20100700]
[Date].[Date Hierarchy].[Month].&[20100600]
[Date].[Date Hierarchy].[Month].&[20100500]
WITH
MEMBER [Measures].[ParameterCaption] AS [Date].[Date Hierarchy].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue] AS [Date].[Date Hierarchy].CURRENTMEMBER.UNIQUENAME
MEMBER [Measures].[ParameterLevel] AS [Date].[Date Hierarchy].CURRENTMEMBER.LEVEL.ORDINAL
SELECTNONEMPTY
{ [Measures].[ParameterCaption]
, [Measures].[ParameterValue]
, [Measures].[ParameterLevel]
} ONCOLUMNS
, NONEMPTY
{ ORDER([Date].[Date Hierarchy].[Month]
,[Measures].[ParameterValue]
,BDESC)
} ONROWS
FROM [CubeName]
Result:
Parameter Label
Nov 2010
Oct 2010
Sep 2010
Aug 2010
Jul 2010
Jun 2010
May 2010
Parameter Value
[Date].[Date Hierarchy].[Month].&[20101100]
[Date].[Date Hierarchy].[Month].&[20101000]
[Date].[Date Hierarchy].[Month].&[20100900]
[Date].[Date Hierarchy].[Month].&[20100800]
[Date].[Date Hierarchy].[Month].&[20100700]
[Date].[Date Hierarchy].[Month].&[20100600]
[Date].[Date Hierarchy].[Month].&[20100500]