ContainedClassType (clsCollection)
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 ContainedClassType property of a Decision Support Objects (DSO) collection returns the class type of the items contained within the collection. This property does not apply to CustomProperties collections.
Access
Read-only
Remarks
The DSO object model uses the properties ClassType and SubClassType to identify the object. All DSO objects, with the exception of those of ClassType clsCube, clsLevel, and clsMiningModel, return a SubClassType of sbclsRegular. In addition to sbclsRegular, an object of ClassType clsCube or clsLevel can have a SubClassType of sbclsVirtual,which identifies the object as a virtual cube or a virtual (calculated) level. Objects of ClassType clsMiningModel return a SubClassType of sbclsOLAP or sbclsRelational, depending on the type of mining model defined by the object.
Example
Use the following code to return a collection object's ContainedClassType and determine which class type has been returned:
Dim ctVar As ClassTypes
ctVar = CollectionObject.ContainedClassType
Select Case ctVar
Case clsCubeMeasure
' Insert code for a cube measure.
Case clsCubeDimension
' Insert code for a cube dimension.
Case clsCubeLevel
' Insert code for a cube level.
Case clsCubeCommand
' Insert code for a cube command.
Case clsCubeRole
' Insert code for a cube role.
Case Else
' Insert code for other objects.
End Select