[Mondrian] need to get SQL queries from MDX

JS Ubei jsubei at yahoo.fr
Mon Feb 21 09:04:15 EST 2011


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


      



More information about the Mondrian mailing list