Partilhar via

  • Artigo

IsChanging (Dimension Interface)

ObservaçãoObservação

  Esse recurso será removido na próxima versão do Microsoft SQL Server. Não utilize esse recurso em desenvolvimentos novos e modifique, assim que possível, os aplicativos que atualmente o utilizam.

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.

Comentários

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.