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