Percentile

The MDX Percentile() function for Essbase orders the set according to the numeric value expression, and then returns the value of the tuple that is at the given percentile. The returned value is such that n percent of the of the set members are smaller than it.

Syntax

Percentile ( set, numeric_value_expr, percentile )

Parameters

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 only applies to aggregate storage (ASO) cubes.

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.Basic