April 15, 2009 at 9:23 am
I need to do that my query order a result, but I don't understood how to do...
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 COLUMNS,
[Data].ALLMEMBERS ON ROWS
FROM [DMOB700]
Can someone help me?
April 15, 2009 at 11:16 am
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply