Partager via


Collections (DSO)

ms133452.note(fr-fr,SQL.90).gifRemarque :
  Cette fonctionnalité sera supprimée dans la prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et modifiez dès que possible les applications qui utilisent actuellement cette fonctionnalité.

Collections used in Decision Support Objects (DSO) generally operate the way standard Microsoft® Visual Basic® collections do. However, there are several differences specific to DSO. DSO collections contain methods and properties that have implementations specifically designed for the DSO object model.

Unlike typical Visual Basic collections, DSO collections can contain only objects of the same type. For example, a Dimensions collection can contain only objects of the object classes that apply to dimensions, such as ClassType clsDatabaseDimension, clsCubeDimension, clsPartitionDimension, and clsAggregationDimension. The parent object of a collection determines the specific ClassType property value for the collection. For example, a Dimensions collection whose parent is of ClassType clsDatabase can contain only objects of ClassType clsDatabaseDimension.

A collection is considered to be static for an object if the range of acceptable objects in the collection is restricted. For example, the Roles collection for an object of ClassType clsCube is a static collection because it can only contain role objects that are defined for the cube's parent database object.

The following table lists the collections used in the DSO object model. With the exception of CustomProperties, all collections implement the methods and properties supported by the clsCollection object. For more information about the implemented properties and methods for clsCollection objects, see clsCollection.

Collection Contains objects of ClassType

Commands

clsCubeCommand, clsDatabaseCommand

Columns

Column objects that make up a mining model's structure (ClassType does not apply)

CustomProperties

Property Object (ClassType does not apply)

DataSources

clsDataSource

Dimensions

clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension

Levels

clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel

MDStores

clsAggregation, clsCube, clsDatabase, clsPartition

Measures

clsAggregationMeasure, clsCubeMeasure, clsPartitionMeasure

MemberProperties

clsMemberProperty

MiningModels

clsMiningModel

Roles

clsCubeRole, clsDatabaseRole

Voir aussi

Référence

Methods, clsCollection
Properties, clsCollection
Nested Collections

Aide et Informations

Assistance sur SQL Server 2005