NTile

The MDX NTile function returns a division number of a tuple in a set. This function only applies to Essbase aggregate storage databases.

Syntax

NTile ( member_or_tuple, set, number_of_divisions, numeric_value_expr )

Parameters

member_or_tuple

A member or a tuple.

set

The set to order.

number_of_divisions

The number of divisions to use in ordering the set.

numeric_value_expr

A numeric value or an expression that returns a numeric value.

Notes

• This function is applicable only to aggregate storage databases.

• This function orders the set by a numeric value, divides it into n equal divisions, and returns the division number that the given tuple is in.

Example

WITH
MEMBER [Measures].[7tile] AS
  'Ntile 
     ([Measures].[Price Paid],
    { [Products].Levels(0).Members },
      7,
    [Measures].[Price Paid]
  )'
SELECT
{ [Measures].[Price Paid], [Measures].[7tile] } on columns,
{ [Products].Levels(0).Members } on rows
FROM ASOSamp.Basic