An object of ClassType clsCubeDimension provides a specific implementation of the Decision Support Objects (DSO) Dimension interface. This object provides collections and properties through the Dimension interface. There are no methods associated with an object of ClassType clsCubeDimension.
To define a cube dimension, you add a reference to an existing dimension within a database to the cube’s Dimensions collection. 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. For more information, see Dimension Interface and About Decision Support Objects.
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(1)
Set dsoCube = dsoDB.MDStores(1)
'"Dim 1" is an existing database dimension
Set dsoCubeDim = dsoCube.Dimensions.AddNew("Dim 1")
About Decision Support Objects | Dimension Interface |
Using Decision Support Objects |