Ordinal

Analysis Services

Analysis Services

Ordinal

Returns the zero-based ordinal value associated with a level.

Syntax

«Level».Ordinal

Example

For a dimension named Products with three levels, named [All Products], [Product Category], and [Product Name], the following example returns 2:

Products.[Product Name].Ordinal