IsChanging (Dimension Interface)

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

The IsChanging property of the Dimension interface indicates whether the members and/or levels of the dimension are expected to change on a regular basis.

Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension

Data Type

Boolean

Access

Access depends on the value of the ClassType property of the object.

Class type	Access
clsDatabaseDimension	R/W*
clsCubeDimension	R
clsPartitionDimension	R
clsAggregationDimension	R

* For more information about read/write access, see Remarks later in this topic.

Замечания

For all Dimension objects, the IsChanging property always returns a certain value depending on other property settings for the object:

• If the SubClassType property is sbclsLinked, the IsChanging property returns False.
• If the SubClassType property is sbclsParentChild or sbclsMining, or if the object is a virtual dimension, or if the StorageMode property is storeasROLAP, the IsChanging property returns True.
• If the object is a virtual dimension created in Microsoft® SQL Server™ 7.0 OLAP Services, the property returns False.

For objects of ClassType clsDatabaseDimension, read/write access is further qualified by several other factors. The IsChanging property for objects of ClassType clsDatabaseDimension is read-only if:

• The SubClassType property is sbclsParentChild, sbclsMining, or sbclsLinked.
  -or-
• The StorageMode property is set to storeasROLAP.
  -or-
• The object of ClassType clsDatabaseDimension is a virtual dimension created using SQL Server 7.0 OLAP Services.

If IsChanging is set to True, levels other than the first and last of the dimension can be added, moved, deleted, or changed without requiring that you fully reprocess all cubes that use the dimension. Also, members that belong to any level other than the first or last level can be added, moved, deleted, or changed without reprocessing cubes that use the dimension.

For dimensions that are not virtual, the IsUnique property must be set to True for the last level of the dimension before the IsChanging property can be set to True.

In addition to these requirements, the value of the IsChanging property can restrict the acceptable values for the AggregationUsage property of a dimension that is not virtual. The following table shows the values that are valid for dimensions with the IsChanging property set to True.

Aggregation usage	Dimensions with an (All) level	Dimensions without an (All) level
DimAggUsageCustom	n/a	n/a
DimAggUsageDetailsOnly	valid	valid
DimAggUsageStandard	valid	valid
DimAggUsageTopOnly	valid	n/a
dimAggUsageTopAndDetailsOnly	valid	n/a
DimAggUsageStandard	valid	valid

For more information about processing requirements for ROLAP dimensions, see StorageMode.

См. также

Справочник

Dimension Interface
StorageMode (Dimension Interface)

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

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