clsAggregationDimension

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.

Remarks

An aggregation for a partition will by default aggregate values based on the top-most levels within the partition. To specify a different granularity, that is degree to which an aggregation is precalculated, you will need to 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 would inherit all of the partition’s dimensions, but only the top-most or default All level. To precalculate a greater detail of data (more granularity) over the Time dimension, you will need to add one or more of the levels Year, Quarter, and Month.

For more information, see About Decision Support Objects.

Example

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

See Also