Assigning access permissions via the DAC cube

To assign access permissions via the DAC cube:

  1. Click Cubes in the Database group on the ribbon.
  2. Double-click the DAC cube to edit.
    In this cube you can assign access permissions for all dimension elements.
  3. Select the cell at the intersection of the required element and role.

    If you have created roles in the Repository, you must first update your #_GRP_ dimension, before you can assign access permissions to those new roles. Click Update Roles on the toolbar. After updating the #_GRP_ dimension you must close the DAC and reopen it.

  4. Select an access level from the Access Control toolbar.
    The Levels are:
    • None
    • Read
    • Write
    • Administer
    • Default

    The permissions are written back to the cube.