Overview (GETTM1 command)

GETTM1 reads the data from an IBM® Cognos® TM1® cube view. The multidimensional OLAP cube data is flattened when read into IBM SPSS® Statistics. You must have access to a TM1 Performance Management system and an associated TM1 server to use this feature.

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.

Syntax Rules

  • The CONNECTION and VIEW subcommands are required.

Limitations

  • 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.

Operations

  • 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.
  • When the data are imported, a separate SPSS Statistics variable is created for each regular dimension and for each element in the measure dimension.
  • 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.