RANK

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

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

Description:

This function is used to return the one-based rank of a specified tuple in a specified set.

Syntax:

Rank(Tuple_Expression, Set_Expression [ ,Numeric Expression ] )

Return type:

SCALAR

Parameters:

Parameter	Description

Parameter	Description
Tuple_Expression	It is a valid MDX expression that returns a member.
Set_Expression	It is a valid MDX expression that returns a set.
Numeric_Expression	It is a valid numeric expression, typically an MDX expression of cell coordinates that returns a number.

Example:

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