[Mondrian] SQL Tracing

Julian Hyde jhyde at pentaho.com
Wed Mar 24 19:07:30 EDT 2010

Matt is correct. There is documentation on how to set up logging here:


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Matt Campbell
Sent: Monday, March 22, 2010 8:26 AM
To: Mondrian developer mailing list
Subject: Re: [Mondrian] SQL Tracing

I believe mondrian.trace.level is obsolete.  You should be able to get all
SQL statements by setting up log4j appropriately, though.  Edit log4j.xml
and set the following category to log to your appender of choice, e.g. 

   <category name="mondrian.sql">
      <priority value="DEBUG"/>
      <appender-ref ref="SQLLOG"/>
      <appender-ref ref="CONSOLE"/>

(there's also a mondrian.mdx logger).

On Mon, Mar 22, 2010 at 11:09 AM, Bruno Gomes <semog15 at gmail.com> wrote:

Hi, i want to trace the SQL statments, i have follow the mondrian
technical guide, and added to mondrian.properties the follow
I have putted the mondrian.properties in the
But now, i can't find the output file (traceLog.out), is the location
of mondrian.properties right?

Thanks for the help in advance.
Best regards.

Bruno Gomes
Mondrian mailing list
Mondrian at pentaho.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100324/182c167f/attachment.html 

More information about the Mondrian mailing list