clsCubeDimension
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
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.
Remarks
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.
Example
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")