• Article

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