Connecting to an IBM Cognos TM1 cube to export data

To export data to an IBM Cognos TM1 database, on the Connection tab of the IBM Cognos TM1 dialog box, specify the server connection details and select the associated cube and data details.

Note: Only actual "null" values will be discarded when exporting data to TM1. Zero (0) values will be exported as a valid value. Also note that only fields with a storage type of string can be mapped to dimensions on the Mapping tab. Before exporting to TM1, you must use IBM® SPSS® Modeler client to convert non-string data types to string.

Connection Type. Select Admin Server or TM1 Server. Note that the Admin Server has been removed from Planning Analytics on Cloud, so if you have old streams that connect to an old Admin Server, you can modify them to point to Planning Analytics on Cloud instead. If you select Admin Server here, then you must enter the URL for the server (the host name of the REST API) and the name of the server. If you select TM1 Server, proceed to the following sections.

TM1 Server URL. Type the URL of the administration host where the TM1 server you want to connect to is installed. The administration host is defined as a single URL for all TM1 servers. From this URL, all IBM Cognos TM1 servers installed and running on your environment can be discovered and accessed. Click Login. If you have not previously connected to this server you are prompted to enter your User name and Password; alternatively, you can search for previously entered login details that you have saved as a Stored Credential.

Select a TM1 cube to export Displays the name of the cubes within the TM1 server into which you can export data.

To choose the data to export, select the cube and click the right arrow to move the cube into the Export to cube field. When you have selected the cube, use the Mapping tab to map the TM1 dimensions and measures to the relevant SPSS fields or to a fixed value (Select operation).