Viewing post 1 (of 2 total)
I did this is way...
But can to order per month...
WITH
MEMBER [Measures].[ParameterCaption] AS '[Data].CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue] AS '[Data].CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[ParameterLevel] AS '[Data].CURRENTMEMBER.LEVEL.ORDINAL'
SELECT {
[Measures].[ParameterCaption],
[Measures].[ParameterValue],
[Measures].[ParameterLevel]
} ON 0,
ORDER(
(
[Data].ALLMEMBERS
),
[Measures].[ParameterCaption],
DESC
)
ON 1
FROM [DMOB700]
Sample...
DD/MM/YYYY
24/02/2009
23/02/2009
22/02/2009
21/02/2009
20/02/2009
19/02/2009
18/02/2009
24/03/2009
23/03/2009
22/03/2009
21/03/2009
20/03/2009
19/03/2009
18/03/2009
April 15, 2009 at 11:16 am
Viewing post 1 (of 2 total)