How to provide rank
Hi All,
I have created report for rank .for this i have used below query WITH
SET [OrderedSet] AS
ORDER
(
NonEmpty
(
(
[Employee].[EMPLOYEE NAME].[EMPLOYEE NAME].members,[Client].[PROGRAM NICK].[PROGRAM NICK].members,
[Employee].[SUP NAME].&[SUSAN FOOTE]) ,
{ [Measures].[SCHEDULEDTIME] } )
,
[Measures].[SCHEDULEDTIME], DESC
)
MEMBER [Measures].[Rnk] AS
Rank
(
(
[Employee].[EMPLOYEE NAME].CurrentMember,[Client].[PROGRAM NICK].[PROGRAM NICK].members,,
[Employee].[SUP NAME].&[SUSAN FOOTE]
),
[OrderedSet]
,[Measures].[SCHEDULEDTIME]
)
SELECT
{[Measures].[SCHEDULEDTIME], [Measures].[Rnk]} on 0,
[OrderedSet] on 1
FROM
(
SELECT FILTER([Date].[Date].MEMBERS,[Date].[Date].MEMBERVALUE>=CDate("7/1/2010")
AND [Date].[Date].MEMBERVALUE<=CDate("28/10/2010"))
ON 0 FROM
[Team Lead]
)
but get the result like this
employee programnick measure rank
A 30
35 Error
B 30
25 Error
C 30
15 Error
A 25
56 Error
B 25
25 Error
C 25
12 Error
and so on
but i want result like this
employee programnick measure rank
A 30
35 1
B 30
25 2
C 30
15 3
A 25
56 1
B 25
25 2
C 25
12 3
please help
amit
October 29th, 2010 12:38pm