Day: May 5, 2005

MSAS – Applying security to a Dimension

Exforsys
When roles are assigned for cubes the user has access or no access to the cube. When roles are assigned to a dimension, the user gains only partial access to parts of the cube. The simplest method of restricting access to a dimension is to prevent access to all levels except the top level of the dimension. In the Cube role dialog box all users were given complete access to the sales cube. Let us restrict the access of users by permitting them to see only values broken out by… Read More

Tutorial 65: MSAS – Managing Cube Roles

Exforsys
In the Analysis Manager console tree, expand the cubes folder and right click the Sales cube and click Manage roles The Cube Role Manager Dialog box appears. The dialog box shows all the users whose roles have been already assigned in the database. It also allows us to create a new role. On clicking the New button, new roles can be added to the Cube role dialog box. The create a cube role dialog box appears. Type in the name for the cube role and click Add button. The Add… Read More

MSAS – Understanding Database Roles

Exforsys
When a new database is created a default role is created for all OLAP Administrators to have access to the Analysis Manager. However, other users have to be given rights to access the database and its objects. Users can be given rights to Browse the cubes and objects but not to use Analysis Manager. If the user has to be given a right to use both the database objects and the Analysis Manager, specific rights have to be assigned. To assign database roles to users, right click the database and… Read More