Filters

Filters provide the ability to return a subset of data in the model by a field or combination of fields from the data model. Interactive Reporting provides a very robust filtering capability, where complex filters can be added to queries through an easy-to-use interface.

A filter is easily added to the query by adding the item to the Filter line. Items are added to the filter line by using one of the following two methods:

Right-click method

Drag-and-drop method

Highlight the column in the table of interest.

Highlight the column in the table of interest.

Right-click and select Filter.

Drag-and-drop the column into the Filter line.

Since the filter must be configured after it is added, only one column can be added to the Filter line ...

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.