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):
- Open Microsoft SQL Server Management
Studio.
- In the Connect to Server window, connect
to the instance of Microsoft SQL Server Analysis
Services that you are using.
- In Object Explorer, right-click your Microsoft SQL Server Analysis Services instance
name and select Properties.
- 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.
- Click Add.
- 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.
- Click Check Name to verify that
the account exists.
- Click OK.