The integration of Cognos Analytics and Planning Analytics (or Cognos Business Intelligence with Cognos TM1) is often seen as a complex topic, especially when it comes to troubleshooting. This document will provide a walkthrough of the integration between Cognos Analytics and Planning Analytics, and will list regular scenarios and it´s resolution. This integration is often also referred to as “using CAM Security”.

Just as a short recap, tm1s.cfg has the following content after the changes in Part 1:

[TM1S]
IntegratedSecurityMode=5
UseSSL=T
ServerName=Walkthrough
AdminHost=pa-adminhost
PortNumber=12346
HTTPPortNumber=8010
DataBaseDirectory=.
ServerCAMURI=http://ca-host:9300/p2pd/servlet/dispatch
ServerCAMURI=http://ca-host:9400/p2pd/servlet/dispatch
ClientCAMURI=http://web-host:80/ibmcognos/bi/v1/disp
ServerCAMURIRetryAttempts=2

Using IntegratedSecurityMode=5 with TM1 Applications (pmpsvc)

Prerequisite: Section Change Security Mode of the TM1 Server of Part 1 needs to be completed prior.

Step 1: Configure planning.html

Similar to tm1web.html, a configuration file on the Cognos Analytics server needs to be adjusted with the URLs used for Planning Analytics.

This configuration is done in planning.html, which has been copied as part of the bi_interop.zip in the first step of the integration. The file is located in the <cognos analytics gateway>\webcontent directory of the Cognos Analytics Gateway installation. The URL that is used to open TM1 Applications Portal, will need to be added to a list of allowed referrers.
1. Open <cognos analytics gateway>\webcontent\planning.html in an editor
2. Search for “var planningServices”
3. Expand the list of URLs from

var planningServices= ["http://localhost:8080", "http://localhost:9510"];
to
var planningServices= ["http://localhost:8080", "http://localhost:9510", "http://pa-host:9510"];

Assuming your users would not access TM1 Applications through pa-host, but through pa-host.domain.com or through a proxy (proxy.domain.com), these URLs needs to be added to the list as well. For example:
var planningServices=["http://localhost:8080", "http://localhost:9510", "http://pa-host:9510","http://pa-host.domain.com:9510", "http://proxy.domain.com:9510"];

Step 2: Configure the Cognos Analytics URLs in Planning Analytics Applications Portal

The configuration of Cognos Analytics needs to be made aware to the TM1 Application Portal. This is done in the initial configuration of TM1 Applications.

1. Open http://pa-host:9510/pmpsvc in a browser

2. Enter the Planning Analytics Server details. The URLs will be pre-populated by the configuration of tm1s.cfg. Correct the URLs if they are not as expected.

3. Select Ok.

This configuration is stored in \webapps\pmpsvc\WEB-INF\configuration\fpmsvc_config.xml.

Step 3: Verify the login in pmpsvc

1. In a browser, open http://pa-host:9510/pmpsvc

2. The Cognos Analytics login screen appears. Enter the credentials of a valid Cognos user, that has TM1ADMIN access.
3. Select the Performance Modeler icon.

If Performance Modeler has not been installed before, Performance Modeler will now be installed.
4. Performance Modeler will be opened with your user credentials
5. Close Performance Modeler

Repeat the same for Cognos Insight.

Step 5: Integrate TM1 applications in Team Content of Cognos Analytics

Cognos Analytics can be configured to contain links to published applications in Planning Analytics. This needs to be configured before the publish happens.

1. Open Cognos Configuration of Planning Analytics
2. On the Environment entry, enter the details of the Cognos Analytics environment

3. Save and re-start the IBM Cognos TM1 Service.

Create and publish an application through Performance Modeler afterwards. The applications will be available in Team Content > IBM Cognos TM1 Application – My Applications by default.

Common problems during this step of the integration

"The planning service parameter was not specified or is not one of the configured locations” or a white page.

 

The file "portal\variables_plan.xml" could not be opened

 

Team Content of Cognos Analytics is displayed, instead of TM1 Applications Portal

The Gateway URL has been incorrectly defined. Open <PA install>\webapps\webapps\pmpsvc\WEB-INF\configuration\fpmsvc_config.xml in an editor, and correct <gateway uri="http://web-host:80/ibmcognos/bi/v1/disp"/> to the proper URL. A restart of the IBM Cognos TM1 Service is required.

The header of the TM1 Applications Portal is not displayed, or Performance Modeler or Cognos Insight can´t be opened

TM1 Applications is configured to show in Compatibility view in Internet Explorer.

Error 404: javax.servlet.ServletException: java.io.FileNotFoundException: SRVE0190E: File not found: /disp

This error might be happening when one of the applications is opened in Team Content of Cognos Analytics. This is due to an incorrect URL reference (more information APAR PI79680).
To resolve this edit the URL object, and change the beginning of the URL from ./disp to ./v1/disp .

Using IntegratedSecurityMode=5 with TM1 Operations Console (pmhub)

Prerequisite: Section Change Security Mode of the TM1 Server of Part 1 needs to be completed prior.
Step 1: Configure pmhub.html

In addition to the tm1web.html and planning.html configuration, a configuration file also exists for TM1 Operations Console.

var pmhubURLs= ["http://localhost:8080", "http://localhost:9510"];
to
var pmhubURLs= ["http://localhost:8080", "http://localhost:9510", "http://pa-host:9510"];

Assuming your users would not access TM1 Applications through pa-host, but through pa-host.domain.com or through a proxy (proxy.domain.com), these URLs needs to be added to the list as well. For example:
var pmhubURLs=["http://localhost:8080", "http://localhost:9510", "http://pa-host:9510","http://pa-host.domain.com:9510", "http://proxy.domain.com:9510"]; 

Step 2: Configure TM1 Operations Console

TM1 Operations Console is configured in a web interface. This UI presents multiple options of configuration, including the references to the Cognos Analytics environment.

2. Expand configurations
3. Select PM Hub-Security
4. Enter the URLs from the Cognos Analytics environment

 

Step 3: Verify the login in pmhub

White page being displayed

The file "portal\variables_plan.xml" could not be opened

A loop happening between the Cognos Analytics Gateway and the TM1 Operations Console URL