Level (Decision Support Objects)

Nota

  Questa caratteristica verrà rimossa a partire dalla prossima versione di Microsoft SQL Server. Non utilizzare questa caratteristica in un nuovo progetto di sviluppo e modificare non appena possibile le applicazioni in cui è attualmente implementata.

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.