This topic has not yet been rated - Rate this topic

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

SQL Server 2008

Use the Dimensions page of Role Designer to grant or revoke access to dimensions within the selected database for users in the selected role.

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

Select Dimension Set

Selects the set of dimensions to be displayed on the Dimensions page.

Dimensions

Select the dimension listed in the grid to modify its permissions. The grid contains the columns listed in the following table.

Column	Description
Dimension Name	Displays the name of the dimension.
Access	Select the access level that the users in this role will have when accessing the associated dimension. ValueDescription NoneUsers are unable to read information from the dimension. ReadUsers are able to read information from the dimension. Read/WriteUsers are able to read and write information from the dimension.
Read Definition	Grants users who are in this role permission to read the metadata associated with the dimension. Note This option is selected but not available if the Read definition option is selected on the General page of Role Designer.
Process	Grants users who are in this role permission to process the selected cube. Note This option is selected but not available if the Process database option is selected on the General page of Role Designer.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ