Re: calculation the median

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I'd like to add an example to my question:

I added this as a new Measure in the Calculation window of the Cube:

Median ([Surgery].[KT DURATION].Members)


as a result I get #value! (infinite recursion detected. The loop of
dependencies is Median KT Duration --> Median KT Duration.)

My second approach was to this in the calculation windows: Median
([Measures].[KT DURATION]) and define a new Measure in the Cube window
using NONE as the aggregate function. Unfortunately now when using the
calculated Median the field is empty.


------------

[Surgery].[KT DURATION] --- is a column in the Surgery Dimension which
is a double.

--------------

Any ideas?

florian schrieb:

hi,

I'd like to calculate the Median within a cube in SQL Server 2005.

I have a duration and the number of occurances --> so it was not
difficult to calculate the average but now I got stuck because I'd like
to calculate the median too.

I just found the following formula - Median(Set_Expression [
,Numeric_Expression ] ) but I don't know how to use it.

Thanks for your help!

.

Relevant Pages

  • RE: median as a derived measure
    ... it will get the median of the current member's children. ... > levels may not even make business sense. ... >> nature of the reports they supplied in prototype as Excel spreadsheets. ... You could then join these cubes in a virtual cube. ...
    (microsoft.public.sqlserver.olap)
  • RE: median as a derived measure
    ... "SQL McOLAP" wrote: ... Is MEDIAN necessary? ... > always be very fast in the cube, and you won't have to worry about different ... Their prototype reports are strictly static snapshots of measures calculated ...
    (microsoft.public.sqlserver.olap)
  • Re: AS2K Median function
    ... One issue with computing Median in a cube is whether the cube has the ... QUARTILE functions to operate at the granularity of the fact table. ... but more than likely you won't include a transaction dimension. ...
    (microsoft.public.sqlserver.olap)
  • RE: median as a derived measure
    ... A question to ask the business. ... Is MEDIAN necessary? ... always be very fast in the cube, and you won't have to worry about different ... create summary SQL tables for that level. ...
    (microsoft.public.sqlserver.olap)
  • Re: berechnungen analysis services
    ... Median KT Duration --> Median KT Duration.) ... Versuch war es ein neues Measure anzulegen. ...
    (microsoft.public.de.sqlserver)