Level (Decision Support Objects)
Note
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.
The Level object in Decision Support Objects (DSO) provides access to levels associated with dimensions in Microsoft® SQL Server™ 2000 Analysis Services. The Levels collection of the DSO Dimension object provides access to DSO Level objects. In addition, the Levels collection is supported by the Cube, Aggregation, and Partition DSO objects.
All four types of levels are supported with DSO objects. Each level object detailed in the following table uses the Level interface, with the ClassType property set to the appropriate value for the level type as shown.
Level type |
Level object |
Level class type |
|---|---|---|
Database level |
DbLevel |
clsDatabaseLevel |
Cube level |
CubeLevel |
clsCubeLevel |
Partition level |
PartitionLevel |
clsPartitionLevel |
Aggregation level |
AggregationLevel |
clsAggregationLevel |
The Level object is used to:
Provide access to the member properties associated with a level.
Edit the properties, such as level type and custom rollup expression, associated with a level.