ORDINAL

ORDINAL

This documentation is for Kyvos 2026.3.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.3.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

Parameter

Description

Level_Expression

It is a valid MDX expression that returns a level.

Example:

WITH MEMBER [Measures].x AS [Date].[Calendar].[Calendar Quarter].Ordinal SELECT [Measures].x on 0 FROM [AdventureWorksMF]

Copyright Kyvos, Inc. 2026. All rights reserved.