[Mondrian] need to get SQL queries from MDX

Luc Boudreau lucboudreau at gmail.com
Mon Feb 21 11:39:31 EST 2011


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20110221/db0b739d/attachment.html 

More information about the Mondrian mailing list