<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">Hi Luc,<br><br>One more time, thank you.<br>Wonderfull this feature ... but I can't wait !<br><br>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 mondrian.<br><br>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 ?<br><br><br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">De :</span></b> Luc Boudreau <lucboudreau@gmail.com><br><b><span style="font-weight: bold;">À :</span></b>
Mondrian developer mailing list <mondrian@pentaho.org><br><b><span style="font-weight: bold;">Cc :</span></b> JS Ubei <jsubei@yahoo.fr><br><b><span style="font-weight: bold;">Envoyé le :</span></b> Lun 21 février 2011, 13h 39min 31s<br><b><span style="font-weight: bold;">Objet :</span></b> Re: [Mondrian] need to get SQL queries from MDX<br></font><br>Norbie,<br><br>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.<br>
<br><a rel="nofollow" target="_blank" href="http://jira.pentaho.com/browse/MONDRIAN-856">http://jira.pentaho.com/browse/MONDRIAN-856</a><br><br><br><br><br><div class="gmail_quote">On Mon, Feb 21, 2011 at 9:04 AM, JS Ubei <span dir="ltr"><<a rel="nofollow" ymailto="mailto:jsubei@yahoo.fr" target="_blank" href="mailto:jsubei@yahoo.fr">jsubei@yahoo.fr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Dear mondrian community,<br>
<br>
In a starting project I plan to use mondrian for MDX queries facilitiy. But in<br>
another part of the project we need to have the SQL resulting queries to use<br>
with an external tool (GIS).<br>
How can I do with the API ?<br>
Idealy, something like :<br>
<br>
//********************<br>
Query query = connection.parseQuery(...)<br>
String sql_query = connection.getSQL(query)<br>
//*******************<br>
<br>
Is the SqlStatement.execute() a good starting point to explore ?<br>
<br>
Best regards,<br>
Norbie<br>
<br>
<br>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a rel="nofollow" ymailto="mailto:Mondrian@pentaho.org" target="_blank" href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a rel="nofollow" target="_blank" href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</blockquote></div><br>
</div></div>
</div><br>
</body></html>