Setting of the Access Rights on Dimension Members

Let us show how it is possible to quickly set the access rights on dimension members with the help of a special wizard and user parameters. Go to the “Cubes” tab. Select the item “Edit Permissions on Dimensions” in the context menu for the cube “Adventure Works”:

The wizard will be opened. This wizard asks you to select the dimension and attribute hierarchy. Select everything as shown in the picture and move to the next step:

On the step 2 select the “Country Managers” role from the drop-down:

In the list below you will see the users assigned to that role. The access rights will be set for every user selected in the list.

Press «Next».

On the step 3 select the parameter “Country” from the drop-down and from the drop-down at the bottom select the level “Country” (the level for which you are setting up the access rights).

Move on to the step 4:

On this step you can review the rights for every user. These rights will be set on the dimension data in the cube “Adventure Works”. If necessary, you can still modify them.

After pressing «Next» button you will receive the message about the successful operation execution:

You can verify that the access rights for users on dimensions are set up, using Management Studio:

If you open the report in the report module under the user “john”, create a separate page, place on the rows the level “Country” from “Geography” hierarchy, you will see the following:

The user can see only two countries: Australia and Canada.