Analysis Services - Median Calculation

#1

A really simple question,,,, I need to calculate the median of a

Quote:

measure. I'm having a tough time to figure out which dimension to use.
If If I have 4 dimensions, Date, region, site, and process code and I
want to get the median for the measure number of days, what do I use to
define the set?

median ([Process].AllMembers,measures.[No Of Days]) this is not working,
but at least the syntax was clean

standard median prompt
Median (Â«SetÂ»[, Â«Numeric ExpressionÂ»])

As I select different subsets of region, site and process code I
obviously want the median of No of days to be dynamic.

Stuck here and waiting anxiously for some bright person to shed the
light!!!

thanks,,,

#2

I'm not sure that I understand what you want rightly, but I guess you need
StrToSet(). For example,

Median(StrToSet("Axis(1)").Item(0).Item(0).Dimensi on.AllMembers, [No Of
Days])

Ohjoo Kwon

"Peter" <Peter (AT) discussions (DOT) microsoft.com> wrote

Quote:

A really simple question,,,, I need to calculate the median of a
measure. I'm having a tough time to figure out which dimension to use.
If If I have 4 dimensions, Date, region, site, and process code and I
want to get the median for the measure number of days, what do I use to
define the set?

median ([Process].AllMembers,measures.[No Of Days]) this is not working,
but at least the syntax was clean

standard median prompt
Median (¡ìSet¡í[, ¡ìNumeric Expression¡í])

As I select different subsets of region, site and process code I
obviously want the median of No of days to be dynamic.

Stuck here and waiting anxiously for some bright person to shed the
light!!!

thanks,,,

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

Analysis Services - Median Calculation

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

Analysis Services - Median Calculation - 03-03-2005 , 09:47 PM

Re: Analysis Services - Median Calculation - 03-03-2005 , 10:06 PM