Cell Data (Role Designer) (Analysis Services - Multidimensional Data)

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 SQL Server Data Tools (SSDT), 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 (Analysis Services - Multidimensional Data).

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 (Analysis Services - Multidimensional Data).

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 (Analysis Services - Multidimensional Data).

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 (Analysis Services - Multidimensional Data)

Concepts

Security Roles (Analysis Services - Multidimensional Data)

Other Resources

Multidimensional Expressions (MDX) Reference