CustomProperties (Dimension Interface)

Примечание.
В следующей версии Microsoft SQL Server эта возможность будет удалена. Не используйте ее при работе над новыми приложениями и как можно быстрее измените приложения, в которых она в настоящее время используется.

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

Замечания

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.

Пример

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

См. также

Справочник

CustomProperties Collection
Dimension Interface

Справка и поддержка

Получение помощи по SQL Server 2005