clsAggregationLevel

An object of ClassType clsAggregationLevel provides a specific implementation of the Decision Support Objects (DSO) Level interface. It is used to maintain the level objects associated with an MDStore object having a ClassType of clsAggregation. This object provides collections and properties through the Level interface. There are no methods associated with an object of ClassType clsAggregationLevel.

For more information, see About Decision Support Objects.

Remarks

Levels describe the dimension hierarchy from the highest (most aggregated) level to the lowest (most detailed) level of data. The All level of a dimension is the top level of a dimension; it includes all the members of subordinate levels.

The following table shows an example of the level positions of a time dimension in which the most detailed (daily) values are included in the next level (monthly), which are in turn included in the next level (quarterly) and so on:

Note The number of members in any level must always be greater than, or equal to, the number of members in the parent level.

Example

' Assume the existence of an object (myAgg) of ClassType clsPartition

Dim myLev As DSO.Level

Set myLev = myAgg.Levels.AddNew("Brand Name")

See Also