Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

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

Note Note

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

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

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

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

Note Note

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

Check

Tests the permissions defined on this pane.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.