[Mondrian] need to get SQL queries from MDX

Nicholas Goodman ngoodman at bayontechnologies.com
Mon Feb 21 12:02:00 EST 2011

You can also see this information in the SQL logs. Not programatically and
it's not a complete solution (for instance , SQL q no 3 changes based on
result of q 2) and caching has to be off to get full SQL.

Check out Mondrian.SQL log4j logging topic/configuration .

Sent from my iPhone

On Feb 21, 2011, at 8:40 AM, Luc Boudreau <lucboudreau at gmail.com> wrote:


The feature you are searching for doesn't exist yet. But good news for you,
it is on the roadmap for this year. We included it in a feature request
called "Explain Query Feature". The end result will do exactly what you are
looking for, and then more. Keep a watch on the following Jira case for
updates. Should you decide to contribute to parts of this feature, don't
hesitate to get in touch with us.


On Mon, Feb 21, 2011 at 9:04 AM, JS Ubei <jsubei at yahoo.fr> wrote:

> Dear mondrian community,
> In a starting project I plan to use mondrian for MDX queries facilitiy. But
> in
> another part of the project we need to have the SQL resulting queries to
> use
> with an external tool (GIS).
> How can I do with the API ?
> Idealy, something like :
> //********************
> Query query = connection.parseQuery(...)
> String sql_query = connection.getSQL(query)
> //*******************
> Is the SqlStatement.execute() a good starting point to explore ?
> Best regards,
> Norbie
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

Mondrian mailing list
Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20110221/d3eff663/attachment.html 

More information about the Mondrian mailing list