Level (Decision Support Objects)

Analysis Services Programming

Analysis Services Programming

Level (Decision Support Objects)

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.

See Also

clsDatabaseLevel

clsCubeLevel

clsPartitionLevel

clsAggregationLevel

Dimension (Decision Support Objects)

Levels

Working with Dimensions and Levels