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

请参阅

参考

Level Interface