IBM Cognos TM1 Operations Console Installation

This post describes how to install and enable the IBM Cognos TM1 Operations Console. As always it is not difficult to do, but it is not available or working out of the box. The below is tested for TM1 10.1.1 on a 64bit Windows machine using the default Apache web server.

Also check this post: IBM Cognos TM1 Operations Console Configuration

1. Install the TM1 Operations Console

The first thing is to verify if you actually installed the TM1 Operations Console. On the machine where you want to run the TM1 Operations Console, go to “C:\TM1 Installation Location\webapps\”. If there is a folder named “tm1operationsconsole” then you are good to go (Replace “TM1 Installation Location” with your actual TM1 installation location). If not, then find your installation files and run them again to install the TM1 Operations Console. You should look for the TM1 server installation files, not the client files. In the component section pane you can find it under “Web Application Tier”.

Install IBM Cognos TM1 Operations Console

2. Make sure the TM1 Server and application server is running

Just check if everything is running, including the application server you want to access. Not strictly necessary, but you have to add a group in a minute.

3. Add certificates of the TM1 Operations Console to the JRE keystore

The IBM Cognos TM1 Operations Console requires a certificate to be added in the Java Runtime Environment (JRE) keystore.
 
  • Run a command line as admin (“C:\Windows\SysWOW64\cmd.exe”)
  • Change the current location to “C:\TM1 Installation Location\bin64\jre\6.0\bin” where “TM1 Installation Location” is your actual TM1 installation location.
  • Run the following command: “keytool -import -file “C:\TM1 Installation Location\bin64\ssl\applixca.pem” -keystore “C:\TM1 Installation Location\bin64\jre\6.0\lib\security\cacerts” -storepass “changeit””
  • You should see some pre-IBM era messages and at the end you type “yes” to trust the certificate and it should confirm with “Certificate was added to the keystore“.
Full commands and pic:

C:\Windows\SysWOW64>chdir C:\TM1 Installation Location\bin64\jre\6.0\bin

C:\TM1 Installation Location\bin64\jre\6.0\bin>keytool -import -file “C:\TM1 Installation Location\bin64\ssl\applixca.pem” -keystore “C:\TM1 Installation Location\bin64\jre\6.0\lib\security\cacerts” -storepass “changeit”

C:\TM1 Installation Location\bin64\jre\6.0\bin>

Owner: OU=”Applix, Inc.”, O=”Applix, Inc.”, L=Westboro, ST=Massachusetts, C=US

Issuer: OU=”Applix, Inc.”, O=”Applix, Inc.”, L=Westboro, ST=Massachusetts, C=US

Serial number: c7cb4af62c85650a

Valid from: 27/11/06 21:48 until: 24/11/16 21:48

Certificate fingerprints:

MD5:  D9:2F:A5:40:3E:89:04:83:0F:F6:0E:25:54:2C:2A:A9

SHA1: AC:69:F8:FE:6F:37:5D:D6:90:90:8F:C8:99:9A:F0:EA:C3:2B:0C:E9

Trust this certificate? [no]:  yes

Certificate was added to keystore

C:\TM1 Installation Location\bin64\jre\6.0\bin>

IBM Cognos TM1 Operations Console Add certificates to the JRE keystore

4. Create a security group in TM1 Architect

Next create a security group in TM1 Architect to the application server you want to monitor and add a user to it. This group should be intended for monitoring purposes only. In the image below a group “Monitor” is created and the administrator is assigned to that group.

IBM Cognos TM1 Operations Console create group

5. Adapt the OpsConfig.xml file

Next step is to adapt the OpsConfig.xml file. This file is located under “C:\TM1 Installation Location\webapps\tm1operationsconsole\WEB-INFO\.

Make sure the file content looks something like this:

<?xml version=”1.0″ encoding=”UTF-8″?>

<ops>

<adminhost name=”localhost”>

<server name = “RateCardModel_2”>

<group>monitor</group>

</server>

</adminhost>

<DashboardRefreshRate>5</DashboardRefreshRate>

<EnhancedStatusDetail>true</EnhancedStatusDetail>

</ops>

Adminhost should be the server host name of the machine where you installed TM1, server name is the application server name of the server you want to monitor and group is the name of the security group you created to do the monitoring.

IBM Cognos TM1 Operations Console Edit the OpsConfig.xml file

6. Restart the TM1 Services

Restart the TM1 Server…

Install IBM Cognos TM1 Operations Console Restart

7. Test if the TM1 Operations Console can be accessed

Now browse to “http://server_name:port_number/tm1operationsconsole” where “server_name” should be your actual server name and “port_number” your server port number, usually this is 9510. So in my case “http://localhost:9510/tm1operationsconsole“. If everything went well you should land on the TM1 Operations Console log-in screen where you can select the server and log-in with your credentials.

IBM Cognos TM1 Operations Console Login 1

IBM Cognos TM1 Operations Console Login 2

IBM Cognos TM1 Operations Console Login 3

That should do it. Note that with a 32bit installation you need to register with the 32bit keystore and locations will be slightly different.

Cognos Service