on my Windows 7 I have installed "Cognos Analysis for Microsoft Excel v10.2.2" and also installed fixpack 5 for this product. I started Microsoft Excel 2013 and I can see "IBM Cognos" tab. Clicking on Options button I can configure URL for "IBM Cognos BI" server and I can without a problem get data from this server, so I assume "Cognos Analysis for Microsoft Excel" is correctly installed.
Now I would also like to get data directly from TM1 Server, so in Options I have selected "Source data type": "IBM Cognos TM1" and now I am required to enter an URL for this server. In official documentation PDF file: IBM Cognos Analysis for Microsoft Excel Version 10.2.2 User Guide on page 21 there is info:
Code: Select all
An example URL for a Cognos TM1 system is:
http://server_name:port_number
"server_name" is either the IP address of the computer or the computer name.
"port_number" is the port set by the administrator for application server on the Cognos TM1 system. The default port is 9510.
Code: Select all
netstat -ano -p tcp | find "LISTENING"
Currently on Windows server machine is installed:
- Apache Http server (listening on port 80),
- Cognos BI including Apache Tomcat (build-in server) (URL: http://myserver.com/ibmcognos/cgi-bin/cognos.cgi - so also port 80),
- Cognos TM1 (only server! is installed).
Do I also need to install some application server for "Cognos TM1" system from Cognos TM1 installation CD? Or is there something else I am missing?
Thanks