OrdinalPosition (Level Interface)
[!附註]
下一版的 Microsoft SQL Server 將不再提供此功能。請勿在新的開發工作中使用此功能，並且儘速修改使用此功能的應用程式。
The OrdinalPosition property of the Level interface contains the ordinal position of the level in the Levels collection.
Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel
Data Type
Integer
Access
Read-only
備註
The OrdinalPosition property for a level determines the relative position of the level in the dimension hierarchy: A value of 1 defines the most aggregated level, and the maximum value defines the most detailed level. Decision Support Objects (DSO) sets the value of this property when you add the level to a dimension.
The following table shows an example of relative ordinal positions.
Level |
Ordinal position |
|---|---|
All |
1 |
Yearly |
2 |
Quarterly |
3 |
Weekly |
4 |
Daily |
5 |
範例
Use the following code to return the ordinal position of a level object:
' 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