OrdinalPosition (Level Interface)

ms135586.note(zh-cn,SQL.90).gif注意:
  下一版本的 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

帮助和信息

获取 SQL Server 2005 帮助