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)