PDA

View Full Version : getting java result set or sql query



tricia993
07-24-2003, 05:19 AM
What command can I use to get the JAVA result set sent to mondrian? I want to capture the raw sql? Is there a way to do this? thanks, -T

jhyde
07-24-2003, 03:51 PM
A Mondrian result is usually made up of several SQL statements; and some of the results may come from the cache populated by earlier SQL statements. So there isn't a unique 'result set' which we could return.
There is a method 'String mondrian.olap.Cell.getDrillThroughSQL'. Applied to a particular cell object, it returns a SQL statement to retrieve all of the fact table rows which contributed to that cell's total.
Is that what you're looking for?