IBM Support

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

Question & Answer


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

[{"Product":{"code":"SSHM9K","label":"Cognos Analysis for Microsoft Excel"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":"Analysis for Excel","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.2","Edition":""},{"Product":{"code":"SSHM9K","label":"Cognos Analysis for Microsoft Excel"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":""}]

Document Information

Modified date:
15 June 2018

UID

swg21686274