IBM Cognos TM1 Export Node

The IBM Cognos Export node enables you to export data from an SPSS® Modeler stream to Cognos TM1. In this way, Cognos Analytics can make use of transformed or scored data from SPSS Modeler.

Note: You can export only measures, not context dimension data; alternatively, you can add new elements to the cube.

To export data to Cognos Analytics, you need to specify the following:

The connection to the Cognos TM1 server.
The Cube into which the data will be exported.
The mapping from the SPSS data names to the equivalent TM1 dimensions and measures.

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.

As with any other export node, you can also use the Publish tab of the node dialog box to publish the stream for deployment using IBM® SPSS Modeler Solution Publisher.

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.