SSAS Articles MDX SSAS: Median cube measures Aggregation
SSAS: Median cube measures Aggregation
User Rating: / 2
PoorBest 
Written by Clement Lefaure   
Tuesday, 05 January 2010 23:01

From a recent mission at a customer we have confronted the need of aggregate measures of cube in the form of median.

Interest to aggregate a median measure

In practice, this need is to return the median value of a measure for the dimensions that are in progress, rather than classically the sum or average.  On a basic example for a turnover, measure around an axis analysis region, the client need is to return the median value of the Board of each of the regions:

Read more... (split screen original post in French and translation to English)

Read more... (original post in French)
 

Tags: article, mdx

Quick Poll - Please vote

What is the most important feature for you in the BIDS Helper utility?