To grant access to a cube using SQL Server Management Studio
Open SQL Management Studio.
Connect to Analysis Services using an account that has administrative rights.
Within the IT Analytics database, right-click the Roles folder.
Click New Role.
On the Create Role dialog box, enter IT Analytics Users as the role name.
Select the Read Definition database permission for the role.
On the Cubes page, set the Access drop-down list to Read for each cube that you want this role to have access to.
If you install additional cubes in the future, you need to explicitly grant the read privilege for each cube after you install it.
On the Membership page, click Add to specify users and groups for this role.
Click Object Types, and then select Groups to allow the security group to be added to the role.
Click Location and change the location to the domain for which you created the IT Analytics Users security group.
In the box for objects to select, add the IT Analytics Users group.
Members of this role now have the appropriate rights to view the cubes that this role permits. You might need to configure Notification Server security to see the IT Analytics tab and installed cubes or reports.
Imported Document ID: HOWTO62422
Subscribing will provide email updates when this Article is updated. Login is required.