OrdinalPosition

The OrdinalPosition property of the Level interface contains the ordinal position of the level. This is the relative position of this level in the dimension hierarchy, with 1 defining the most aggregated level and the maximum ordinal position being the most detailed level.

The following table shows an example of relative ordinal positions.

Level Ordinal Position
All 1
Yearly 2
Quarterly 3
Weekly 4
Daily 5

Applies To
clsAggregationLevel clsDatabaseLevel
clsCubeLevel clsPartitionLevel

Data Type

Integer

Access

Read-only

Example

Use the following code to return a level object ordinal position:

' Assume an object (dsoLev) of ClassType clsLevel exists

If dsoLev.OrdinalPosition = 1 Then

  'Code to handle top level

Else

  'Code to handle remaining levels

End If

See Also
About Decision Support Objects Using Decision Support Objects
Properties Cross-Reference  

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.