IsChanging (Dimension Interface)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
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.
Remarks
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.
See Also
Reference
Dimension Interface
StorageMode (Dimension Interface)