Cell Data (Role Designer) (SSAS)

Use the Cell Data page of Role Designer to specify cell permissions for the role.

Note

All options on this page are not available if Full control (Administrator) is selected on the General page of Role Designer.

Options

Term

Definition

Cube

Selects the cube that contains the cells for which you want to specify access permissions.

Test cube security

Analyzes existing cube security. The role must be deployed to test existing cell security.

Note:

This option is available only in Business Intelligence Development Studio, and is not available if the Access column of the Cube grid on the Cubes page is set to None for the selected cube.

Enable read permissions

Allows the role read-only access to the cells in the selected cube.

Note:

This option is not available if the Access column of the Cube grid on the Cubes page is set to None for the selected cube.

Allow reading of cube content

Type the Multidimensional Expressions (MDX) statement used to define the read-only permissions. Click Edit MDX to open the MDX Builder dialog box in which you can edit the MDX statement that defines the read permissions. For more information, see MDX Builder Dialog Box (SSAS).

Note:

This option is not available if Enable read permissions is not selected.

Enable read-contingent permissions

Allows the role read-contingent access to the cells in the selected cube.

Note:

This option is not available if the Access column of the Cube grid on the Cubes page is set to None for the selected cube.

Allow reading of cell content contingent on cell security

Type the MDX statement used to define the read-contingent permissions. Click Edit MDX to open the MDX Builder dialog box in which you can edit the MDX statement that defines the read-contingent permissions. For more information, see MDX Builder Dialog Box (SSAS).

Note:

This option is not available if Enable read-contingent permissions is not selected.

Enable read/write permissions

Allows the role read-write access to the cells in the selected cube.

Note:

This option is not available if the Access column of the Cube grid on the Cubes page is set to None for the selected cube.

Allow reading and writing of cube content

Type the MDX statement used to define the read-write permissions. Click Edit MDX to open the MDX Builder dialog box in which you can edit the MDX statement that defines the read-write permissions. For more information, see MDX Builder Dialog Box (SSAS).

Note:

This option is not available if Enable read/write permissions is not selected.

Check

Tests the permissions defined on this pane.

See Also

Reference

Role Designer (SSAS)

Other Resources

Roles (Analysis Services)
Multidimensional Expressions (MDX) Reference

Help and Information

Getting SQL Server 2005 Assistance