RANK

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]