ORDINAL
This documentation is for Kyvos 2026.8.x. To view documentation for other Kyvos versions, click here. |
|---|
Description:
This function is used to return the zero-based ordinal value associated with a level.
Syntax:
Level_Expression.Ordinal
Return type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Level_Expression | It is a valid MDX expression that returns a level. |
Example:
WITH SET [RankedProducts] AS
Order([Product].[Product].[Product].Members, [Measures].[Internet Sales Amount], DESC)
MEMBER [Measures].[Sales Rank] AS
[RankedProducts].CurrentOrdinal
MEMBER [Measures].[Top Tier] AS
IIF([RankedProducts].CurrentOrdinal <= 5, 'Tier 1 (Top 5)',
IIF([RankedProducts].CurrentOrdinal <= 20, 'Tier 2 (Top 20)',
IIF([RankedProducts].CurrentOrdinal <= 50, 'Tier 3 (Top 50)', 'Tier 4')))
MEMBER [Measures].[Rank Percentile] AS
1 - ([RankedProducts].CurrentOrdinal - 1) / Count([Product].[Product].[Product].Members),
FORMAT_STRING = 'Percent'
SELECT {[Measures].[Internet Sales Amount], [Measures].[Sales Rank],
[Measures].[Top Tier], [Measures].[Rank Percentile]} ON COLUMNS,
[RankedProducts] ON ROWS
FROM [AdventureWorksMF_ValueBased]