CustomProperties (Dimension Interface)

Notes

  Cette fonctionnalité sera supprimée dans la prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et modifiez dès que possible les applications qui utilisent actuellement cette fonctionnalité.

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

Notes

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.

Exemple

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