[Mondrian] need to get SQL queries from MDX

JS Ubei jsubei at yahoo.fr
Mon Feb 21 11:59:40 EST 2011

Hi Luc,

One more time, thank you.
Wonderfull this feature ... but I can't wait !

I will try to evaluate the difficulty to do this myself and if it's too hard or 
"time consumer" I will do my multidimensional database exploration without 

And what the problem if I just, to begin, add a flag to know if I really want 
execute the query (i.e. fetch results) or if I just want the SQL query building 
part ?

De : Luc Boudreau <lucboudreau at gmail.com>
À : Mondrian developer mailing list <mondrian at pentaho.org>
Cc : JS Ubei <jsubei at yahoo.fr>
Envoyé le : Lun 21 février 2011, 13h 39min 31s
Objet : Re: [Mondrian] need to get SQL queries from MDX


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,
>Mondrian mailing list
>Mondrian at pentaho.org

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

More information about the Mondrian mailing list