Before a user can run Excel reports and Cognos® Business Intelligence reports for Case Analyzer, you must grant that user
access to the Case Analyzer OLAP
database.
Use the Microsoft SQL Server Management
Studio to create roles and assign users. See the online help for Microsoft SQL Server for more information
and detailed instructions.
Attention: Users who want
to access reports must belong to the same domain as the Microsoft SQL Server Analysis server. If
a user does not belong to this same domain, one option is to create
a matching local user on the Microsoft SQL Server Analysis
server and assign the local user permissions to the Case Analyzer OLAP database.
Important: Because security requirements differ at each site,
use the procedure for creating user roles in the following steps as
a guide only.
To grant access rights to the Case Analyzer OLAP database:
- Go to .
- Connect to your analysis services instance.
- Expand .
Tip: If you are using the default instance, no instance name
is appended.
- Right-click Roles and select New
Role.
- Give the user access to the OLAP cubes.
- Enter the Role Name and Description. For
example, enter a descriptive name for the role and describe how that
role is used in the Description field.
- Set the database permissions for this role to be Full
control (Administrator).
- Select the Membership tab.
- Click Add and select the domain
user or group of users that you wish to give access to the Case Analyzer OLAP database.
- Click Add. If you want to add
more than one user or group, you must add them separately by repeating
the previous 3 steps.
- Click OK.
- Click OK.