This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

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 that has 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.


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.


Use the following code to reference a level of an existing aggregation:

' Assume the existence of an object (myAgg) of 
' ClassType clsAggregationDimension
Dim myLev As DSO.Level
Set myLev = myAgg.Levels("Brand Name")