The transaction log file

The IBM® Cognos® TM1® server logs all transactions made by each user in the transaction log file.

For example, suppose USR2 makes a change in a number in the xbudget cube on the TM1 server. When this happens, a record is automatically added to the transaction log file. The record contains the following information:

  • The date and time the change was made.
  • The name of the user who made the change.
  • The name of the cube in which the change was made.
  • The value before it was changed.
  • The value after the change.
  • The intersection of the cube that was changed.

This file is used to recover crashed TM1. It also provides a complete audit trail of all changes to the server. ChangeSets are stored in the transaction log to implement the Undo/Redo feature.

Transaction Logging must be turned on using a configuration setting. When transaction logging is enabled, access the transaction log file, by right-clicking the TM1 server in TM1 Architect and choose View Transaction Log.