IBM Support

How to set connection for Cognos BI and TM1 with Cognos Analysis for Excel?

Technote (FAQ)


Question

Set connection for Cognos BI & TM1 with CAFE

Answer

· Launch Microsoft Excel and select IBM Cognos from excel menu bar
· Select Option from CAFE menu.
· Select IBM Cognos and click Add.

Configure Cognos BI Connection:
· Select IBM Cognos BI as Datasource Type
· Enter System URL like, http://Serverhostname/ibmcognos/cgi-bin/cognos.cgi
· Enter friendly name.
· Test the connection and click ok.

Configure TM1 Connection:
· Select IBM Cognos TM1 as Datasource Type
· Enter System URL like, http://Serverhostname:9510
· Enter friendly name.
· Test the connection and click OK


Cross reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos Analysis for Microsoft Excel

Document information

More support for: Cognos Analysis for Microsoft Excel
Analysis for Excel

Software version: 10.2, 10.2.2

Operating system(s): Windows

Reference #: 1686274

Modified date: 07 October 2014


Translate this page: