You must install the required Microsoft SQL Server add on software to run IBM®
Cognos® Business Intelligence reports on Case Analyzer.
The
Case Analyzer user workstations
that run
IBM
Cognos Business Intelligence reports
must have the Microsoft Analysis
Services 10.0 OLE DB Provider for
Microsoft SQL Server running on them. The
appropriate package for the version of the
SQL Server must be installed.
Tip: This add-on is available for download from Microsoft. For more information, see the
system requirements technical support document that is appropriate
for your configuration. Then find the requirements for
IBM Case Foundation on Windows, and view the information about the
Microsoft SQL Server database. See the
IBM
FileNet® P8 system
requirements or the
IBM Content Foundation system
requirements.
If the OLAP Microsoft SQL Server database
is remote from the IBM
Cognos Business Intelligence server,
the Microsoft SQL Server Client
software must be installed on the IBM
Cognos Business Intelligence server.
You must also grant access rights to the Case Analyzer OLAP database. See Granting access rights to the Case Analyzer OLAP database for more information.