IBM Support

How to enable MDX Debug logging on the TM1 Server

How To


Summary

This document is applicable to anyone who wants to better understand performance for specific MDX queries on the TM1 Server.

Steps

  • Open/edit the tm1s-log.properties file
    • The file must reside in the same directory as the tm1s.cfg file for the server you wish to debug
    • If the file does not exist, you may copy one from the \tm1_64\samples\ folder
  • At the bottom of the file, add the following DEBUG lines:
    • log4j.logger.TM1.MdxViewCreate=DEBUG
    • log4j.logger.TM1.MdxLogger=DEBUG
  • Rerun your test and review the DEBUG output written to the tm1server.log file

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 December 2019

UID

ibm11120035