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 MySet AS [Customer].[Geography].[Country].MEMBERS
MEMBER [Measures].[Average RateM] AS MySet.CURRENTORDINAL
SELECT [Measures].[Average RateM] ON 0
FROM [AdventureWorksMF]

Kyvos 2025.2

CURRENTORDINAL

Analytics

Related content