Creating Cube Roles
For each cube in the database, select the database roles that can access it. Each selection creates a cube role with the same name as the database role. A cube role's defaults are derived from the selected database role, but you can change some of the default values in the cube role.
Alternatively, you can create a cube role without selecting an existing database role. This action creates a database role with the same name as the new cube role.
In a cube role, you can also specify cell security, which cannot be defined in database roles. Specifying cell security is optional.
To create a cube role, change its default values, and specify cell security, use Cube Role Manager and the Cube Role dialog box.
To create a cube role, change its default values, and specify cell security