• Articolo

IsChanging (Dimension Interface)

Nota

  Questa caratteristica verrà rimossa a partire dalla prossima versione di Microsoft SQL Server. Non utilizzare questa caratteristica in un nuovo progetto di sviluppo e modificare non appena possibile le applicazioni in cui è attualmente implementata.

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.

Osservazioni

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.