clsCubeDimension

[!附註]

  下一版的 Microsoft SQL Server 將不再提供此功能。請勿在新的開發工作中使用此功能,並且儘速修改使用此功能的應用程式。

An object of ClassType clsCubeDimension provides an implementation of the Decision Support Objects (DSO) Dimension interface that is specific to dimensions within a cube. This object provides collections and properties through the Dimension interface. There are no methods associated with an object of ClassType clsCubeDimension.

備註

The primary difference between a database dimension and a cube dimension is that in a cube dimension, certain properties that are inherited from the database dimension can be overridden by changing their values. For example, the IsVisible property can be overridden on a cube dimension, but the StorageType property cannot.

To define a cube dimension, you add a reference to a dimension that exists within a database to the Dimensions collection of the cube. A shared database dimension can be associated with multiple cube dimensions; a private database dimension can be associated with only one cube dimension. In both cases, the database dimension is automatically associated with the cube's partitions and aggregations, if there are any.

範例

Use the following code to create a clsCubeDimension object:

'Assume an object (dsoServer) of ClassType clsServer exists
'with an existing database and cube
Dim dsoDB As MDStore
Dim dsoCube As MDStore
Dim dsoCubeDim As DSO.Dimension
Set dsoDB = dsoServer.MDStores("FoodMart")
Set dsoCube = dsoDB.MDStores("Sales")
'"Employees" is an existing database dimension
Set dsoCubeDim = dsoCube.Dimensions.AddNew("Employees")