An object of ClassType clsDatabaseDimension provides a specific implementation of the Decision Support Objects (DSO) Dimension interface. This object provides collections, methods, and properties through the Dimension interface.
Database dimensions can be shared or private. A shared database dimension can be associated with any number of cubes, but a private database dimension can be associated with one only cube. When a database dimension is associated with a cube, it is automatically associated with the cube’s partitions and aggregations, if there are any.
All dimensions, shared and private, are created in a database object and stored in the database object’s Dimensions collection. Private dimensions are identified by incorporating the names of the cubes to which they are private into the names of the dimensions. For example, a dimension named “Cube1^PrivateDimension” is private to Cube1 because its name begins with “Cube1” followed by the caret (^) character.
For more information, see Dimension Interface and About Decision Support Objects.
Use the following code to create a DatabaseDimension object:
' Assume an object (dsoDB) of ClassType clsDatabase exists
Dim dsoDim As DSO.Dimension
Set dsoDim = dsoDB.Dimensions.AddNew("MyDim")
About Decision Support Objects | Dimension Interface |
Using Decision Support Objects |