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 O’Reilly online learning.

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