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 SQL of ...
Get The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
