August 24, 2010 at 10:30 pm
Hi All,
We have analysis process cube but one of my team member not able to process the cube"She is getting an error don't have privilages to process the cube.
She is having db_owner access on all the Databases which are used by Cube.
I am not much understanding with Analysis service please help me .
Thanks,
Gangadhar
August 24, 2010 at 11:56 pm
To give a database role permission to process a cube
1. In SQL Server Management Studio, connect to the instance of Analysis Services, expand Roles for the appropriate database in Object Explorer, and then double-click a database role (or right-click Roles and select New Role to create a new database role). If this is a new role, make sure that you enter a name for the role in the Role name box.
2. Click Cubes in the Select a Page pane, locate the cube in the Cube list, and then select the Process check box for the cube.
3. Click the OK button.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply