Product:
Cognos Tm1 version 9.5.2
Cognos BI version 10.1
Symptom:
When user try to surf to TM1 contributor website get following error message:
The planning service parameter was not specified or is not one of the configured locations
Background:
Installed on 3 Microsoft Windows 2008 R2 servers with Cognos BI 10.1 64 bit report services on one server and the Cognos BI 10.1 32 bit Gateway functions on a separate server and Cognos TM1 9.5.2 on another server.
The following steps are done:
A TM1 application is created and setup with IntegratedSecurityMode=5 in the tm1s.cfg file
(This give that we use the Cognos BI authentication manager (CAM) for the TM1 application)
TM1 contributor is setup in an own TOMCAT instance (in folder D:\tomcat6).
TM1 portlet are installed the Cognos BI report server.
Installation of portlets will create the variables_tm1.xml in folder d:\Program Files\ibm\cognos\c10_64\templates\ps\portal on the Cognos BI server.
The file variables_tm1.xml is updated with the URL to the TM1 server as shown below
<CRNenv>
<urls>
<url is-regex=”true”>http://srv001/TM1Web/TM1WebLogin.aspx</url>
<url is-regex=”true”>http://srv001/TM1Web/TM1WebLoginHandler.aspx</url>
<url is-regex=”true”>http://srv001/TM1Web/TM1WebMain.aspx</url>
<url is-regex=”true”>http://srv001.work.domain.lan/TM1Web/TM1WebLogin.aspx</url>
<url is-regex=”true”>http://srv001.work.domain.lan/TM1Web/TM1WebLoginHandler.aspx</url>
<url is-regex=”true”>http://srv001.work.domain.lan/TM1Web/TM1WebMain.aspx</url>
</urls>
<cookies>
<param name=”cam_passport”/>
</cookies>
</CRNenv>
Any extra and should be removed from the sample file, and then the file is saved without the sample extension, to be named variables_TM1.xml
The variables_plan.xml file is copied untouch from folder D:\Program Files\Cognos\TM1\Cadmin\gateway on TM1 server to folder D:\Program Files\ibm\cognos\c10_64\templates\ps\portal on the Cognos BI report server.
The planning.html file is copied from folder D:\Program Files\Cognos\TM1\Cadmin\gateway on the TM1 server to folder d:\Program Files (x86)\ibm\cognos\c10\webcontent\ on the Cognos BI gateway server.
The icon_active_application.gif file is copied from the D:\Program Files\Cognos\TM1\Cadmin\gateway folder on the TM1 server to the
D:\Program Files (x86)\ibm\cognos\c10\webcontent\ps\portal\images folder on the Cognos BI gateway server.
This is the icon for the published TM1 Contributor application in Cognos Connection folder “IBM Cognos TM1 Contributor Applications”.
Solution:
Open the planning.html file in notepad from folder C:\Program Files (x86)\ibm\cognos\c10\webcontent on the Cognos BI gateway server.
Change line
// Update the following to point to the location of the planning service(s)
var planningServices = [“http://localhost:8080”];
to
var planningServices = [“http://SRV001.work.company.lan:8080”];
So you use the FQDN that is for the TM1 server where you have installed Tomcat and TM1 Contributor.
Save file and test again.
Workaround:
A not supported workaround is to change the planning.html to an older version.
If you have Cognos TM1 version 9.5.1 – you can copy that planning.html file from the D:\Program Files\Cognos\TM1\Cadmin\gateway folder – to the new installed Cognos BI server, and replace the planning.html file.
Then you use the not so secure planning.html file that was part of Cognos TM1 version 9.5.1.
This should you not do – it is not supported by Cognos.