When you process a query, Interactive Reporting translates your graphical request into an SQL or other query statement (MDX – OLEDB and OLAP servers, and Essbase also have their own languages), which in turn is forwarded to the database server. You can view the generated query statement in any section by displaying the Query Log window.
To display the SQL Log, select View, then Query Log.
When this feature is active, the Query log is treated as an open window. You can bring it to the front by clicking Windows, then Query Log. The Query log closes and drops from the Window menu when it is deactivated on the View menu.
To save the contents of the SQL Log to a file, select File, then Export, and then Query Log.
The Export File dialog box prompts you to enter document and directory names for the new file.