Skip to main content
Hitachi VantaraPentaho Documentation
Pentaho Documentation

Analysis SQL Output Logging

Follow the directions below to turn on logging for SQL generation in the BA Server or Mondrian engine. If you are aware of other log4j classes that will assist you in configuration troubleshooting or performance-tuning, you can add them during this process.

  1. Stop the BA Server or standalone Mondrian engine.
  2. Edit the log4j.xml file in the /WEB-INF/classes/ directory inside of the deployed pentaho.war or Mondrian engine.
    Note: In some Mondrian implementations, this file is log4j.properties. Substitute this filename accordingly if you do not see a log4j.xml file.
  3. Add the following line anywhere inside of the </log4j:configuration> node (but not inside of other constituent node tags):
    log4j.logger.mondrian.sql=DEBUG
  4. Save and close the file.
  5. Start the BA Server or Mondrian engine.
A significant amount of Analysis SQL query debugging information will now be available in your application server's logs. Some data about the segment cache plugin will also appear, but there are some other steps to take beyond this if you want log data specific to the segment cache. Refer to Enabling Segment Cache Logging for more information.