Reading Cognos TM1 data
If you have access to an IBM® Cognos® TM1® database, you can import TM1 data from a specified view into IBM SPSS® Statistics. The multidimensional OLAP cube data from TM1 is flattened when read into SPSS Statistics.
Important: To enable the exchange of data between SPSS Statistics and
TM1, you must copy the following three processes from SPSS Statistics to
the TM1 server: ExportToSPSS.pro, ImportFromSPSS.pro,
and SPSSCreateNewMeasures.pro. To add these processes to the TM1 server,
you must copy them to the data directory of the TM1 server and restart the TM1 server. These
files are available from the common/scripts/TM1 directory under the SPSS Statistics
installation directory.
Restriction:
- The TM1 view from which you import must include one or more elements from a measure dimension.
- The data to be imported from TM1 must be in UTF-8 format.
All of the data in the specified TM1 view are imported. It is therefore best to limit the view to the data that are required for the analysis. Any necessary filtering of the data is best done in TM1, for example with the TM1 Subset Editor.
To read TM1 data:
- From the menus, choose:
- Connect to the TM1 Performance Management system.
- Log in to the TM1 server.
- Select a TM1 cube and select the view that you want to import.
Optionally, you can override the default names of the SPSS Statistics variables that are created from the names of the TM1 dimensions and measures.
- PM System
- The URL of the Performance Management system that contains the TM1 server to which you want to connect. The Performance Management system is defined as a single URL for all TM1 servers. From this URL, all TM1 servers that are installed and running on your environment can be discovered and accessed. Enter the URL and click Connect.
- TM1 Server
- When the connection to the Performance Management system is established, select the server
that contains the data you want to import and click Login. If you did
not previously connect to this server, you are prompted to log in.
- Username and password
- Select this option to log in with a specific username and password. If the server uses authentication mode 5 (IBM Cognos security), then select the namespace that identifies the security authentication provider from the available list.
- Stored credential
- Select this option to use the login information from a stored credential. To use a stored credential, you must be connected to the IBM SPSS Collaboration and Deployment Services Repository that contains the credential. After you are connected to the repository, click Browse to see the list of available credentials.
- Select a TM1 cube view to import
- Lists the names of the cubes within the TM1 server from which you can import data. Double-click a cube to display a list of the views that you can import. Select a view and click the right arrow to move it into the View to import field.
- Column dimension(s)
- Lists the names of the column dimensions in the selected view.
- Row dimension(s)
- Lists the names of the row dimensions in the selected view.
- Context dimension(s)
- Lists the names of the context dimensions in the selected view.
Note:
- When the data are imported, a separate SPSS Statistics variable is created for each regular dimension and for each element in the measure dimension.
- Empty cells and cells with a value of zero in TM1 are converted to the system-missing value.
- Cells with string values that cannot be converted to a numeric value are converted to the system-missing value.