Property Object (DSO)
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.
Use the Property object to save user-defined items to a CustomPropertiescollection. You can define Property objects and add them to the CustomProperties collection of any Decision Support Objects (DSO) object to store information you want to associate with the DSO object. You provide a name, value, and data type for each Property object.
Creating a New Custom Property
Use the following code to create a new custom property:
'Assume an object of ClassType clsDimension exists. '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