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 |
clsAggregationLevel | clsDatabaseLevel |
clsCubeLevel | clsPartitionLevel |
Integer
Read-only
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
About Decision Support Objects | Using Decision Support Objects |
Properties Cross-Reference |