Integration of TM1 in Business Insights

[Rahul Ganguli]

Hi,

I am trying to integrate the TM1 Data Server with Business Insights, I have followed all the steps mentioned in the installation and configuration guide, but it is not working.
My TM1 Data Server is integrated with Cognos BI and works fine, reports ar running fine on top of TM1 Data Source.

I have followed the steps metioned in the following link
http://publib.boulder.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.inst_cr_winux.10.1.0.doc%2Finst_cr_winux_id25179cnfgBUX4TM1.html

I can see an icon for TM1 server in Business Insight but am not able to browse through it.

Has anybody faced this issue in past? It would be great if you can share you experience on integarting TM1 with Business Insight.

Cognos version: 10.1.1 FP1
TM1 Version : 9.5.2 FP2

Regards,
Rahul

[Rahul Ganguli]

Following are my environment details

Cognos:
Redhat 6 Linux 64 bit
Websphere
IBM HTTP Server

TM1
Windows server 2008, 64 bit
IIS

[jparramore]

I went thru a similar exercise some months back and had them working in Business Insight after some trouble.  I'll see if I can find any notes about it that I took (no guarantees that I will, though... sorry).

[MFGF]

I would guess that you might be missing some of the &amp qualifiers after your hostname etc in the atom file. Either that, or you are using a hostname in the atom file and a different hostname (such as localhost) in your cognos BI configuration. Everything needs to coincide exactly.  The final thing to check is security - are you using CAM integrated security or TM1 native security? If the former, you need to configure your TM1s.cfg file to set the security flag to 5. If the latter, you need your TM1 user name and password configuring in the atom file.

Good luck!!

MF.

[Rahul Ganguli]

The issue was becuase of SSL settings in Websphere, we have to add the SSL information of TM1 Server in Websphere too. Finally sorted this out.