Importing IBM Cognos TM1 data

To import data from an IBM Cognos TM1 database, on the Data tab of the IBM Cognos TM1 dialog box, specify the server connection details and select the cube and data details.

Note: Before importing data you must carry out some preprocessing within TM1 to ensure the data is in a format that's recognizable to IBM® SPSS® Modeler. This involves filtering your data using the Subset Editor to get the view into the correct size and shape for import.

Note that zero (0) values imported from TM1 will be treated as "null" values (TM1 does not distinguish between blank and zero values). Also, note that non-numeric data (or metadata) from regular dimensions can be imported into IBM SPSS Modeler. But importing non-numeric measures is not currently supported.

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 view to import. Displays the name of the cubes within the TM1 server from which you can import data. Double-click a cube to display the view data you can import.

Note:

Only cubes with a dimension can be imported into IBM SPSS Modeler.

If an alias has been defined for an element in your TM1 cube (for example, if a value of 23277 has an alias of Sales), the value will be imported – not the alias.

To choose data to import, select the view and click the right arrow to move it into the View to import field. If the view you require isn't visible, double-click a cube to expand its list of views. You can select a public or a private view.

Row dimension(s). Lists the name of the row dimension in the data that you have chosen to import. Scroll through the list of levels and select the one you require.

Column dimension. Lists the name of the column dimension in the data that you have chosen to import. Scroll through the list of levels and select the one you require.

Context dimension(s). Display only. Shows the context dimensions that relate to the selected columns and rows.