Importing custom SQL files
The ability exists to use Interactive Reporting to run a custom SQL statement. Previous Interactive Reporting versions did not have any easy way to refresh the SQL in the document, but more recent versions of the software allow for a refresh from the source file.
In a new Query section, the File menu| Import Data | SQL menu option allows the selection of either a .txt or .sql file to be added into the blank query. When the file is selected, a window appears to set the number of columns in the Request line of the document. After specifying the number of columns, the Filter and Sort lines are removed from the Query section and the Request line appears with the column names as Column 1, Column 2, through the final number ...
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.
