Discoverer cunningly builds an sql statement
Not trivial! Difficult queries! Lots of grouping on lots of levels! Beware!
No. But at one time in my career I was responsible for solving issues like: "My figure in my report is wrong and it worked last month and I got this report from Jim who has left the company". I would then ask Discoverer to show me the sql statement it generated for that report, and would track back from there to the source data.
Do you have any internas on this?
These queries could be rather complex if the report was using summaries, grouping, breaks, totals, ... at various levels.