• Artigo

clsAggregationDimension

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 clsAggregationDimension allows you to specify the level of granularity an aggregation will have. This object provides collections and properties through a specific implementation of the Decision Support Objects (DSO) Dimension interface. There are no methods associated with an object of ClassType clsAggregationDimension.

Comentários

By default, an aggregation for a partition precalculates values based on the top-most levels within the partition. To specify a different granularity, that is, the degree to which an aggregation is precalculated, add additional levels to the aggregation's dimensions. For example, in a default scenario a cube (and consequently its partition) may contain a Time dimension that has the levels (All) (default), Year, Quarter, and Month. An aggregation for this partition inherits all of the dimensions of the partition, but only the top-most level or the default (All) level is precalculated. To precalculate a greater detail of data over the Time dimension, add one or more of the levels Year, Quarter, and Month.

Exemplo

The following example causes the aggregation for the Time dimension to include data for the Year, Quarter, and Month levels, in addition to the default level (All):

'Assume an object (dsoAgg) of ClassType clsAggregation exists
Dim dsoAggDim as DSO.Dimension
Set dsoAggDim = dsoAgg.Dimensions("Time")
dsoAggDim.Levels.AddNew("Year")
dsoAggDim.Levels.AddNew("Quarter")
dsoAggDim.Levels.AddNew("Month")