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
After you change a cube role for a cube, you must process dependent virtual cubes to provide users continuing access to them. (This processing is much faster than processing the component cubes if the structures of the component cubes have not changed since their last processing.) When you change the cube role, virtual cube users connected to the server computer are unaffected as long as they remain connected. However, until you process the dependent virtual cubes, users who connect cannot see them.