Dimension (Decision Support Objects)

ms135487.note(zh-cn,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 (MDX)

帮助和信息

获取 SQL Server 2005 帮助