Share via


IsReadWrite (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 IsReadWrite property of the Dimension interface determines whether dimension writebacks are available to end users who have been granted appropriate permissions.

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

* Read/write for clsDatabaseDimension objects with a SubClassType of sbclsParentChild, read-only for all other clsDatabaseDimension objects.

Remarks

Setting the IsReadWrite property to True allows end users who have been granted appropriate permissions to modify the contents of a parent-child dimension. They can add or remove dimension levels, members, and member properties.

A write-enabled dimension cannot be added to a cube that contains a remote partition. An error occurs if you try to:

  • Add a write-enabled dimension to a cube with at least one remote partition.

  • Add a remote partition to a cube that contains at least one write-enabled dimension.

  • Set the IsReadWrite property to True for a dimension used by a cube that has a remote partition.

See Also

Reference