IBM Cognos TM1 Source Node

The IBM Cognos TM1 source node enables you to bring Cognos TM1 data into your data mining session. In this way, you can combine the enterprise planning features of Cognos with the predictive analytics capabilities of IBM® SPSS® Modeler. You can import a flattened version of the multidimensional OLAP cube data.

Note: The TM1 user needs the following permissions: Write privilege of cubes, Read privilege of dimensions, and Write privilege of dimension elements. In addition, IBM Cognos TM1 10.2 Fix Pack 3, or later, is required before SPSS Modeler can import and export Cognos TM1 data. Existing streams that were based on previous versions will still function.

Administrator credentials are not required for this node. But if you are still using the old legacy pre-17.1 TM1 node, administrator credentials are still required.

SPSS Modeler only supports working with Cognos TM1 via IntegratedSecurityMode 1, 4, and 5.

You need to modify the data in TM1 before the data is imported. The data to be imported must be in UTF-8 format.

From an IBM Cognos TM1 administration host connection, you first select a TM1 server from which to import the data; a server contains one or more TM1 cubes. You then select the required cube and within the cube you select the columns and rows you want to import.

Note: Before you can use the TM1 Source or Export nodes in SPSS Modeler, you must verify some settings in the tm1s.cfg file; this is the TM1 server configuration file in the root directory of the TM1 server.
  • HTTPPortNumber - set a valid port number; typically 1-65535. Note that this is not the port number you subsequently specify in the connection in the node; it is an internal port used by TM1 that is disabled by default. If necessary, contact your TM1 administrator to confirm the valid setting for this port.
  • UseSSL - if you set this to True, HTTPS is used as the transport protocol. In this case you must import the TM1 certification to the SPSS Modeler Server JRE.