OrdinalPosition (Level Interface)
[!NOTA]
Esta característica se quitará en la versión siguiente de Microsoft SQL Server. No utilice esta característica en nuevos trabajos de desarrollo y modifique lo antes posible las aplicaciones que actualmente la utilizan.
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
Notas
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 |
Ejemplo
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