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


Dimension (Decision Support Objects)

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

The Dimension object in Decision Support Objects (DSO) provides access to shared dimensions, virtual dimensions, and private dimensions in Microsoft® SQL Server™ 2005 Analysis Services for several objects, including databases, cubes, partitions, and aggregations. Shared dimensions and virtual dimensions are accessed using the Dimensions collection of the DSO Database object, while private dimensions are accessed using the Dimensions collection of the DSO Cube object. Partitions and aggregations, associated with a source cube, also support access to the dimensions related to them. Partition and aggregation dimensions are also accessed by the Dimensions collection of the Partition and Aggregation DSO objects, respectively.

All four types of dimensions are supported with DSO objects. Each dimension object detailed in the following table uses the Dimension interface, with the ClassType property set to the appropriate value for the dimension type as shown.

Dimension type Dimension object Dimension class type

Database dimensions

DbDimension

clsDatabaseDimension

Cube dimensions

CubeDimension

clsCubeDimension

Partition dimension

PartitionDimension

clsPartitionDimension

Aggregation dimension

AggregationDimension

clsAggregationDimension

The Dimension object is used to:

  • Provide access to shared dimensions, virtual dimensions, and private dimensions in Analysis Services.
  • Create and edit levels for a shared dimension or private dimension.
  • Determine the various states of a shared dimension, virtual dimension, or private dimension, such as the temporary status and validity.
  • Process a shared dimension, virtual dimension, or private dimension.

См. также

Справочник

Aggregation (Decision Support Objects)
clsDatabaseDimension
clsCubeDimension
clsPartitionDimension
clsAggregationDimension
Cube (Decision Support Objects)
Database (Decision Support Objects)
Dimension Interface
Partition (Decision Support Objects)

Основные понятия

Working with Dimensions and Levels

Другие ресурсы

Dimensions (многомерные выражения)

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

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