CURRENTORDINAL

Description:

This function is used to return the current iteration number within a set during iteration.

Syntax:

Set_Expression.CurrentOrdinal

Return Type:
SCALAR

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.

Example:

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