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.