ORDINAL
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 MEMBER [Measures].x AS [Date].[Calendar].[Calendar Quarter].Ordinal
SELECT [Measures].x on 0
FROM [AdventureWorksMF]