What is the URL for Cognos Analysis for Microsoft Excel to access TM1 server?

Post Reply
Stanislav2
Posts: 31
Joined: Tue Aug 20, 2013 5:53 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: -

What is the URL for Cognos Analysis for Microsoft Excel to access TM1 server?

Post by Stanislav2 »

Hi,
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.
On Windows server (where Cognos BI and Cognos TM1 server are installed, both are installed on the same server) in cmd I have executed:

Code: Select all

netstat -ano -p tcp | find "LISTENING"
to see which servers are listening on TCP connection and there is no 9510 port. I am 100% sure I have installed all Cognos servers with default ports.

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
kangkc
Community Contributor
Posts: 206
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1, PA , TMVGate
Version: 2.x
Excel Version: 36x
Location: Singapore
Contact:

Re: What is the URL for Cognos Analysis for Microsoft Excel to access TM1 server?

Post by kangkc »

CAFE connection URL to TM1 : http://server:9510

Application Server must be installed and started.

I would test it by going to http://server:9510/pmpsvc
Post Reply