Report Portal

SSAS: Median cube measures Aggregation

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: mdx

 

2007-2015 VidasSoft Systems Inc.