The query log and exporting SQL

The Query Log is an extremely useful resource for debugging and understanding queries sent to the database. When the Query Log is opened, the log will record any query executed from the software and allows the user to copy the contents to another utility for further analysis. The Query Log is opened by selecting the Query Log option in the View menu. The log opens in a new window embedded in the tool and contains a table with two columns: a number of the order the query was run and a column to capture the query sent to the database. The following screenshot shows an open Query Log with a query processed.

The query log and exporting SQL

The SQL of ...

Get The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.