[Mondrian] retrieve currently executing sql queries

Matt Campbell mcampbell at pentaho.com
Fri Mar 8 14:10:01 EST 2013

A simple option is to turn on DEBUG logging in your log4j.xml.  Setting both mondrian.sql and mondrian.mdx to DEBUG is often useful.

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

   <category name="mondrian.mdx">
      <priority value="DEBUG"/>
      <appender-ref ref="MDXLOG"/>

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Domen Pogacnik
Sent: Friday, March 08, 2013 2:00 PM
To: mondrian at pentaho.org
Subject: [Mondrian] retrieve currently executing sql queries

Hi all,

since I have some MDX queries that fails to execute, I would like to retrieve as many information about Mondrian state as possible. I know that I can use Monitor object, but I would also like to retrieve SQL statements that are still executing. As far as I know with Monitor I can only get statement ID, but not the actual statement. Any suggestion?

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

More information about the Mondrian mailing list