FileNet P8 Case Analyzer, Version 5.2.1            

Adding a user to the server role in Microsoft SQL Server Analysis Services

You must add a user to the server role in Microsoft SQL Server Analysis Services to perform OLAP operations.

OLAP operations on Excel Reporting and Cognos® Business Intelligence reporting are supported on Case Analyzer if you are using a Microsoft SQL Server database in a Windows environment. DB2® for Linux, UNIX and Windows and Oracle databases use Case Monitor for reporting, not Excel Reporting or Cognos Business Intelligence.

For more information about the requirements for this procedure, see Creating required users for run time.

To add the user to the server role in Microsoft SQL Server Analysis Services (SSAS):

  1. Open Microsoft SQL Server Management Studio.
  2. In the Connect to Server window, connect to the instance of Microsoft SQL Server Analysis Services that you are using.
  3. In Object Explorer, right-click your Microsoft SQL Server Analysis Services instance name and select Properties.
  4. On the Analysis Services Properties page, in the Select a page pane, click Security. Users and Groups that are members of the server role appears in a list.
  5. Click Add.
  6. In the Select Users or Groups page, go to the Enter the object names to select field and enter ca_olap_db_administrator as the name of the account that you are adding to the server role.
  7. Click Check Name to verify that the account exists.
  8. Click OK.


Last updated: March 2016
bpmpa026.htm

© Copyright IBM Corporation 2016.