Overview (SAVETM1 command)

SAVETM1 saves data from the active dataset to an IBM® Cognos® TM1® cube. This feature is particularly useful when you import data from TM1, transform or score the data in SPSS® Statistics, and then want to export the results back to TM1. 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.
  • All subcommands are required.
  • The TM1 cube to which you export must include a measure dimension.
  • System-missing and user-missing values of fields that are mapped to elements in the measure dimension of the TM1 cube are ignored on export. The associated cells in the TM1 cube are unchanged.
  • Fields with a value of zero, that are mapped to elements in the measure dimension, are exported as a valid value.