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 |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Example:
| Code Block | ||
|---|---|---|
| ||
WITH SET MySet AS [Customer].[Geography].[Country].MEMBERS
MEMBER [Measures].[Average RateM] AS MySet.CURRENTORDINAL
SELECT [Measures].[Average RateM] ON 0
FROM [AdventureWorksMF] |