DECILE

This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here.

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:

WITH MEMBER [Measures].[Sales Decile] AS
    Decile([Measures].[Internet Sales Amount])
SELECT 
    {[Measures].[Internet Sales Amount], [Measures].[Sales Decile]} ON COLUMNS,
    [Product].[Product].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]