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.

This function only applies to aggregate storage databases.

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