FileNet P8 Case Analyzer, Version 5.2.1            

Granting access rights to the Case Analyzer OLAP database

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:

  1. Go to Start > All Programs > Microsoft SQL Server 2012 > SQL Server Management Studio.
  2. Connect to your analysis services instance.
  3. Expand Databases > OLAP_database_name.
    Tip: If you are using the default instance, no instance name is appended.
  4. Right-click Roles and select New Role.
  5. Give the user access to the OLAP cubes.
    1. 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.
    2. Set the database permissions for this role to be Full control (Administrator).
    3. Select the Membership tab.
    4. Click Add and select the domain user or group of users that you wish to give access to the Case Analyzer OLAP database.
    5. Click Add. If you want to add more than one user or group, you must add them separately by repeating the previous 3 steps.
    6. Click OK.
    7. Click OK.


Last updated: March 2016
bpmia007.htm

© Copyright IBM Corporation 2016.