Share via


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.