DECILE

Description:

This function is used to return a scalar value signifying decile of the given set.

Syntax:

Decile(Set_Expression, Measure, Numeric Value, Inclusive/Exclusive flag)

Return Type:

SCALAR

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.
Measure	It is a valid measure.
Numeric Value	It is a valid numeric value in the range of (0,10]
Inclusive / Exclusive flag	It is a flag specifying Inclusive or Exclusive implementation of percentile. The valid values are Inclusive / Exclusive. Inclusive: Specifies the value at or below which the given percentage of values may be found in distribution. Exclusive: Specifies the value below which the given percentage of values may be found in distribution.

Example:

Decile([Geo].[H_Geo].[Country], [Measures].[Sum Sales], 4, Inclusive)