Cannot Connect to an OLAP Data Source

You cannot connect to an OLAP source, such as SAP BW or DB2® OLAP.

Confirm the following:

  • You can open the OLAP server from Microsoft Excel. Most OLAP vendors have a plug-in which allows connectivity through Excel.
  • You have the correct client software installed on the relevant IBM® Cognos® servers. Any IBM Cognos computer which retrieves data from the OLAP source must have the appropriate client software.
  • For MSAS, check that Pivot Table service is installed and the correct service pack is applied.
  • You can open the OLAP source through IBM Cognos Series 7.
  • You can open either the OLAP vendor samples or the IBM Cognos samples. The problem may be specific to one model, outline, or cube.
  • The user making the request from IBM Cognos software is a Domain user with the appropriate access rights.