Changing TM1 Server Log Time Zone Stamp

Ever wondered how to set the TM1 log to use local time? One of the things that has frustrated me about TM1 is that the Message Log records all messages in GMT (UTC).  Well, that’s either 8, 9 or 10 hours off my local time zone, so being able to easily see what “real” time it is, was painful.  Then I discovered the settings in tm1s-log.properties.

How to Set TM1 Logging to use Local Time

  1. Place tm1s-log.properties into your TM1 config folder (the same location as tm1s.cfg).
  2. Edit the entry “log4j.appender.S1.TimeZone=GMT” to “log4j.appender.S1.TimeZone=local”

For most TM1 environments you will have a defined config folder. For Cognos Express up to 10.2.2, the default location for tm1s.cfg is at C:\Program Files\IBM\Cognos Express\Xcelerator\Custom\TM1Data\CXMD.

No more damned GMT!

If you need it, a working copy of tm1s-log.properties can be downloaded here tm1s-log.properties. This download needs to then be changed from “GMT” to “Local”.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.