CURRENTORDINAL
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
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:
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]