I believe <span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; "><b>mondrian.trace.level</b> 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.</span><div>
<font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><br></span></font></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><div>
<category name="mondrian.sql"></div><div> <priority value="DEBUG"/></div><div> <appender-ref ref="SQLLOG"/></div><div> <appender-ref ref="CONSOLE"/></div>
<div> </category></div><div><br></div><div><br></div><div>(there's also a mondrian.mdx logger).</div><div><br></div><div><br></div></span></font><br><div class="gmail_quote">On Mon, Mar 22, 2010 at 11:09 AM, Bruno Gomes <span dir="ltr"><<a href="mailto:semog15@gmail.com">semog15@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi, i want to trace the SQL statments, i have follow the mondrian<br>
technical guide, and added to mondrian.properties the follow<br>
properties:<br>
----<br>
#Tracing<br>
mondrian.trace.level=5<br>
mondrian.debug.out.file=./traceLog.out<br>
----<br>
I have putted the mondrian.properties in the<br>
[Tomcat_Path]/webapps/mondrian/WEB-INF/classes<br>
But now, i can't find the output file (traceLog.out), is the location<br>
of mondrian.properties right?<br>
<br>
Thanks for the help in advance.<br>
Best regards.<br>
<font color="#888888"><br>
--<br>
Bruno Gomes<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</font></blockquote></div><br></div>