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 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 only a single 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.

Use the following code to create an object of ClassType clsDatabaseDimension:

' Assume an object (dsoDB) of ClassType clsDatabase exists
Dim dsoDim As DSO.Dimension
Set dsoDim = dsoDB.Dimensions.AddNew("MyDim")

Community Additions