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

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]