Поделиться через


OrdinalPosition (Dimension Interface)

ms133924.note(ru-ru,SQL.90).gifПримечание.
  В следующей версии Microsoft SQL Server эта возможность будет удалена. Не используйте ее при работе над новыми приложениями и как можно быстрее измените приложения, в которых она в настоящее время используется.

The OrdinalPosition property of the Dimension interface contains the ordinal position of the dimension object within the Dimensions collection of its parent object.

ms133924.note(ru-ru,SQL.90).gifПримечание.
  The ordinal position is 1 for all dimension objects in the collection of dimensions for a database. The position of a dimension within the collection is significant only when it is used in a cube, partition, or aggregation.

The OrdinalPosition property for dimensions is different from the OrdinalPosition property for levels. Dimensions are ordered by the time sequence in which you add them to their parent object. The ordinal position of levels determines the hierarchy of the dimension.

Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension

Data Type

Integer

Access

Read-only

Пример

Use the following code to identify the first dimension in the Dimensions collection:

'Assume an object (dsoDim) of ClassType clsCubeDimension exists.
If dsoDim.OrdinalPosition = 1 Then
    'Insert code to handle the first dimension in the cube.
Else
    'Insert code to handle other dimensions.
End If

См. также

Справочник

Dimension Interface

Справка и поддержка

Получение помощи по SQL Server 2005