Orders the set according to the numeric value expression, and then returns the value of the tuple that is at the given percentile.
This function only applies to aggregate storage databases.
Syntax
Percentile ( set, numeric_value_expr, percentile )
Parameter | Description |
---|---|
set | The set from which to get a tuple value. |
numeric_value_expr | A numeric value or an expression that returns a numeric value. |
percentile | A percentile. Must be between 0 and 100. |
Notes
This function is applicable only to aggregate storage databases.
The returned value is such that n percent of the of the set members are smaller than it.
Example
WITH MEMBER [Measures].[Perc] AS 'Percentile(Products.Levels(0).Members, [Measures].[Price Paid], 10)' SELECT {[Measures].[Price Paid], [Measures].[Perc] } ON COLUMNS, { Products.Levels(0).Members } ON ROWS FROM AsoSamp.Sample