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":"BU053","label":"Cloud & Data Platform"},"Component":"Analysis for Excel","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSHM9K","label":"Cognos Analysis for Microsoft Excel"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21686274