empty drop down list in TM1 Cube Viewer Selection

by ·0 Comments

Product:
TM1 Version 9.5.1 portlet
Cognos BI version 8.4.1

Symptom:
There are a empty drop down list in TM1 Cube Viewer Selection when you try to add a TM1 view to a Cognos Connection Dashboard.

You have installed Cognos BI 8.4.1 Server and Gateway on one server, and Cognos TM1 9.5.1 server and TM1web on another server.

Workaround:
You need to tell the TM1 cube viewer where the TM1 are.
In the TM1Web options of the TM1 portlet definition page, you should mark Enter TM1Web URL and enter the TM1Web Server URL:

http://TM1ServerName/Tm1web

Then you will get the selection of TM1 Cube Viewer Selection.
You must have created VIEWs in the TM1 Cube with TM1 Architect first.

Cause:
The file variables_TM1.xml is not used to render web pages; it is for checking security.

Solution:
You must install TM1Web on both Cognos BI gateway and TM1 server.
When you Install TM1 on the Cognos BI server you can deselect TM1 Server and
Admin server.
You must update the variables_TM1.xml to contain all instances of TM1web e.g. both the BI server and the TM1 server.
You find the variables_TM1.xml file in folder C:\Program Files\cognos\c8\templates\ps\portal

Example of the variables_TM1.xml file:

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

<!–

IBM Confidential

OCO Source Materials

BI and PM: tm1fragments

(C) Copyright IBM Corp. 2008, 2009

 

The source code for this program is not published or otherwise

divested of its trade secrets, irrespective of what has been

deposited with the U.S. Copyright Office.

–>

<CRNenv>

<urls>

<url>http://BiServerName/TM1Web/TM1WebLoginHandler.aspx</url>

<url>http:// BiServerName /TM1Web/TM1WebMain.aspx</url>

<url>http://TM1serverName/TM1Web/TM1WebLoginHandler.aspx</url>

<url>http://TM1serverName/TM1Web/TM1WebMain.aspx</url>

</urls>

<cookies>

<param name=”cam_passport”/>

</cookies>

</CRNenv>