Partilhar via

  • Artigo

clsCubeDimension

ObservaçãoObservação

  Esse recurso será removido na próxima versão do Microsoft SQL Server. Não utilize esse recurso em desenvolvimentos novos e modifique, assim que possível, os aplicativos que atualmente o utilizam.

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.

Comentários

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.

Exemplo

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")