MDX Code
WITH
MEMBER [MEASURES].[ParameterCaption] AS
[Date].[Retail Week].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [MEASURES].[ParameterValue] AS
[Date].[Retail Week].CURRENTMEMBER.UNIQUENAME
MEMBER [MEASURES].[ParameterLevel] AS
[Date].[Retail Week].CURRENTMEMBER.LEVEL.ORDINAL
MEMBER [Measures].[Sorter] AS VBAMDX!CINT(VBAMDX!MID([MEASURES].[ParameterValue],24,LEN([MEASURES].[ParameterValue])-24))
SELECT
{
[MEASURES].[ParameterCaption],
[MEASURES].[ParameterValue],
[MEASURES].[ParameterLevel],
[MEASURES].[Sorter]
} ON COLUMNS,
ORDER(
{
[Date].[Retail Week].[Retail Week].MEMBERS - [Date].[Retail Week].[All].UNKNOWNMEMBER
}
,[Sorter]
,BDESC)
ON ROWS
FROM [Cube Name]
RESULT
ParameterCaption Label
2008 W10
2008 W9
2008 W8
2008 W7
2008 W6
2008 W5
2008 W4
2008 W2
2008 W2
2008 W1
ParameterCaption Value
[Date].[Retail Week].&[60]
[Date].[Retail Week].&[59]
[Date].[Retail Week].&[58]
[Date].[Retail Week].&[57]
[Date].[Retail Week].&[56]
[Date].[Retail Week].&[55]
[Date].[Retail Week].&[54]
[Date].[Retail Week].&[53]
[Date].[Retail Week].&[52]
[Date].[Retail Week].&[51]
[Date].[Retail Week].&[50]
[Date].[Retail Week].&[49]
[Date].[Retail Week].&[48]
[Date].[Retail Week].&[47]
WITH
MEMBER [MEASURES].[ParameterCaption] AS
[Date].[Retail Week].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [MEASURES].[ParameterValue] AS
[Date].[Retail Week].CURRENTMEMBER.UNIQUENAME
MEMBER [MEASURES].[ParameterLevel] AS
[Date].[Retail Week].CURRENTMEMBER.LEVEL.ORDINAL
MEMBER [Measures].[Sorter] AS VBAMDX!CINT(VBAMDX!MID([MEASURES].[ParameterValue],24,LEN([MEASURES].[ParameterValue])-24))
SELECT
{
[MEASURES].[ParameterCaption],
[MEASURES].[ParameterValue],
[MEASURES].[ParameterLevel],
[MEASURES].[Sorter]
} ON COLUMNS,
ORDER(
{
[Date].[Retail Week].[Retail Week].MEMBERS - [Date].[Retail Week].[All].UNKNOWNMEMBER
}
,[Sorter]
,BDESC)
ON ROWS
FROM [Cube Name]
RESULT
ParameterCaption Label
2008 W10
2008 W9
2008 W8
2008 W7
2008 W6
2008 W5
2008 W4
2008 W2
2008 W2
2008 W1
ParameterCaption Value
[Date].[Retail Week].&[60]
[Date].[Retail Week].&[59]
[Date].[Retail Week].&[58]
[Date].[Retail Week].&[57]
[Date].[Retail Week].&[56]
[Date].[Retail Week].&[55]
[Date].[Retail Week].&[54]
[Date].[Retail Week].&[53]
[Date].[Retail Week].&[52]
[Date].[Retail Week].&[51]
[Date].[Retail Week].&[50]
[Date].[Retail Week].&[49]
[Date].[Retail Week].&[48]
[Date].[Retail Week].&[47]