Collections used in Microsoft® SQL Server™ Decision Support Objects (DSO) operate in general the way standard Microsoft Visual Basic® collections do, but there are several differences in the way they are used within 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. A collection’s parent object 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 listed in Collection Methods and Collection Properties.
For methods and properties that apply to the CustomProperties collection, see CustomProperties.
| Collections Cross-Reference | Nested Collections |
| Collection Methods | Collection Properties |