clsAggregationDimension
Nota
Esta característica se quitará en la versión siguiente de Microsoft SQL Server. No utilice esta característica en nuevos trabajos de desarrollo y modifique lo antes posible las aplicaciones que actualmente la utilizan.
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.
Comentarios
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.
Ejemplo
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")
Vea también