CustomProperties (Dimension Interface)
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 CustomProperties collection allows you to assign unique properties to objects that implement the Dimension interface.
Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension
Access
Read/write
Remarks
The CustomProperties collection contains properties that accept user-defined values that are stored in the repository and can be used as needed. For example, an application can use this collection to store user interface parameters that are specific to this dimension (and might change) rather than storing them in the registry.
Example
The following example associates a custom property called Icon with a Geography dimension and gives it a string value of "GeographyIcon":
' Assume the existence of a Geography dimension object (dsoGeographyDim)
' of ClassType clsDimension.
' Add a custom property to the dimension.
Dim dsoProp As DSO.Property
Set dsoProp = dsoGeographyDim.CustomProperties.Add("GeographyIcon", "Icon", vbString)
' Retrieve custom property values.
Dim dsoProp2 As DSO.Property
Set dsoProp2 = dsoDim.CustomProperties("Icon")
Debug.Print dsoProp2.Name, dsoProp2.Value
See Also
Reference
CustomProperties Collection
Dimension Interface