CustomProperties Collection


  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 CustomProperties collection applies to all Decision Support Objects (DSO) objects and enables you to define unique properties for DSO objects. The CustomProperties collection contains Property objects that you define to store information you want to associate with a DSO object. For more information about defining custom properties, see Property Object.




The CustomProperties collection implements its own methods and properties, which operate differently than those of other DSO collections.


Use the following code example to add and retrieve custom property objects:

' Assume the existence of an object of ClassType clsDimension.
' Add a custom property.
  Dim dsoProp As DSO.Property
  Set dsoProp = dsoDim.CustomProperties.Add(55, "Age", vbInteger)

' Retrieve custom property values.
  Dim dsoProp2 As DSO.Property
  Set dsoProp2 = dsoDim.CustomProperties(1)
  Debug.Print dsoProp2.Name, dsoProp2.Value