Filtering in the Results and Table section provides the user with significant flexibility to add, modify, and remove custom filters without the need to reprocess the query. Since the query does not need to be rerun, filtering is quick and easy in the section. In addition, Interactive Reporting documents can be saved to the local workstation populated with data allowing the document to be taken offline where the user can continue to perform filtering and analysis on the data stored in the document without needing to connect back to the database.

Creating filters

Filters can be created in a Results and Table section through the different options shown in the following table:

Double-click method

Drag-and-drop method

Right-click method

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.