[Mondrian] SQL Tracing

[Julian Hyde]

Matt is correct. There is documentation on how to set up logging here:
 
http://mondrian.pentaho.org/documentation/configuration.php#Statement_Loggin
g
 
Julian


  _____  

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"/>
   </category>


(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
properties:
----
#Tracing
mondrian.trace.level=5
mondrian.debug.out.file=./traceLog.out
----
I have putted the mondrian.properties in the
[Tomcat_Path]/webapps/mondrian/WEB-INF/classes
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
http://lists.pentaho.org/mailman/listinfo/mondrian



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