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 |