Restrict a Database Role to Specific Members of a Dimension

Complete the following procedure to restrict a database role to specific members
of a dimension.

For example, the cubes that are included with Microsoft Dynamics AX have a
Company dimension. By default, each role has access to data in all company
accounts. You can restrict a role to specific company accounts in the Company
dimension.

1. In SQL Server Management Studio, connect to your Analysis
Services instance.

2. In the tree view, expand the Databases > [Database Name] > Roles node.

3. Right-click the appropriate role and click Properties. The Edit Role
– [Role Name] form is displayed.

4. In the Select a page area, click Dimension Data. From theDimension list, select a dimension. For example, to restrict the role
to specific company accounts, select the Company dimension.

5. On the Basic tab, select the same dimension from the list. Then
select the members of the dimension that the role should have access to.

6. For example, if you selected the Company dimension, you would
now select the specific company accounts (or dimension members)
the role should have access to.

7. Click OK.

Regards,
Hossein Karimi