TM1 Forum

Hi Kangkc,

In the installation of the BI runtime (bi_runtime_64b_10.2_win_ml.tar) there is no content store database available to install, the content manager is there but no content store (the apache derby bundled database). To get the content store database i tried the full BI install (bi_svr_64b_10.2_win_ml.tar) which does include the content store database. I tried getting this database to fire up but got this error message:
[ ERROR ] Content Manager failed to connect to the content store. The connection string is "jdbc:derby://serverdb1.mycompany.com:51527/cm". The error encountered is: "java.security.PrivilegedActionException : Error opening socket to server serverdb1.mycompany.com on port 51527 with message : java.net.ConnectException: Connection refused: connect"
I tried these links to get the apache derby db fired up:
http://www-01.ibm.com/support/docview.w ... wg1PI14141
http://www-01.ibm.com/support/docview.w ... wg21673320

To no avail. I'm now looking at installing IBM DB2 Express-C Edition and creating this DB first and then using the 'DDL' script to create the required tablespace.
I don't see a BI server in version 10.2.2 (see http://www-01.ibm.com/support/docview.w ... 529&tpl=17). What is the equivalent of bi_svr_64b_10.2_win_ml.tar in version 10.2.2? In other words, in order to get CAM working with the most basic BI install, what is the minimum required set of BI components needing to be installed in BI version 10.2.2? Thanks.

From our notes on BI/TM1 integration:

Huge step forward (for TM1 users at least) – there is now a Quick Setup option which installs all BI components, plus DB2 for the content store, on one box. Only requirements are X64 and absence of a prior DB2 install. Still extremely slow – suggest leaving it running overnight.

This was 10.2.2 BI and TM1.

Hi David,

Thanks for sharing. Using the product code I found version 10.2.2 and at least that install routine gets the DB2 database installed and configured.
As you're been through this, would you mind elaborating on your setting for
ClientCAMURI in tm1s.cfg file
I see the notes here
https://www.ibm.com/support/knowledgece ... urity.html
say contact the Cognos admin. The web page is not very detailed - are you aware of a more detailed article on getting TM1 configured to use CAM without going into an unnecessarily detailed BI config (that's not required to get TM1 working with CAM authentication).

I searched for cognos.cgi in the file system and found it here: C:\Program Files\ibm\cognos\c10_64\cgi-bin\cognos.cgi
As an example I used
http://cogserver.mycompany.com/ibmcogno ... cognos.cgi

I see you referred to your "Notes on TM1/BI integration". do you take bitcoins?

Tempt me, why don't you....
We found Rebecca Hansen's excellent "IBM Cognos Express Installation and Migration Guide" at
http://www-01.ibm.com/support/docview.w ... wg27045726
to provide the details IBM had not previously made visible. Although it is for CX 10.2.2, since 10.2.2 is now standard between CX and TM1/BI, it should give you what you want.

David, a big thank you! that guide is what I used to get BI and TM1 talking to each other.

For those of you who are not using BI for reporting and only for the CAM functionality, have you managed to turn off any of the default BI services that get installed with a default BI install routine? I'm trying to get only the CAM functionality in place and turn off any other unnecessary overhead as these services will be living on an existing TM1 server.
Many thanks.

Turns out through a bit of trial and error I can get CAM running with only these services enabled: Out of curiosity, have any of you been able to get multiple TM1 web servers working with a single BI server? I mean using the web services residing on each TM1 server and all of these TM1 web servers making use of the single BI server?

By removing the admin host parameter in the tm1web_config.xml file on the TM1 web server I can specify multiple admin hosts (so I can use CAM in DEV, QA and PROD) but this is using the one web server URI but I don't see how I could make use of multiple TM1 web URI's using CAM with only a single BI server? it looks like the config on the BI server (variables_TM1.xml and tm1web.html) is limited to specifying only a single TM1 web server. Any ideas on this?

Thanks.

You can specify multiple TM1Web servers on a single Cognos BI Server. Just separate each server with a comma.