Median Expression not working properly

#1

Hi,

I'm trying to get a median cycle time in my cube. I have used the following
expression in MDX as a start and so far it only works on the lowest level of
my employee dimension.

Median (
{ Descendants (
[CodingTime].CurrentMember,
[CodingTime].[Week]
) },
[Measures].[CycleTime]

I only have a time dimension and an employee dimension. I would like to
have the median roll up into the highest level possible (All Time & All
Employees) I have tried everything I can think of at this point. Can
someone please help me?

Thanks.

#2

Assuming that you consider each populated leaf-level combination of your
[Employee] and [CodingTime] dimensions as a [CycleTime] sample:

Quote:

Median(NonEmptyCrossJoin(

Descendants([CodingTime].CurrentMember,,LEAVES),
Descendants([Employee].CurrentMember,,LEAVES)),
[Measures].[CycleTime])

Quote:

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

#3

Thanks Deepak!

Deepak Puri wrote:

Quote:

Assuming that you consider each populated leaf-level combination of
your
[Employee] and [CodingTime] dimensions as a [CycleTime] sample:

Median(NonEmptyCrossJoin(
Descendants([CodingTime].CurrentMember,,LEAVES),
Descendants([Employee].CurrentMember,,LEAVES)),
[Measures].[CycleTime])

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Median Expression not working properly

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Median Expression not working properly - 01-05-2005 , 01:37 PM

Re: Median Expression not working properly - 01-06-2005 , 12:09 PM

Re: Median Expression not working properly - 01-10-2005 , 04:14 PM