OrdinalPosition (Level Interface)
.gif "ms135586.note(de-de,SQL.90).gif") Hinweis: |
|---|
| Dieses Feature wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature nicht zum Entwickeln neuer Anwendungen, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird, zum frühstmöglichen Zeitpunkt ein. |
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
Hinweise
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 |
Beispiel
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