Advanced filtering
The Filter window contains advanced options to provide additional flexibility for filtering in a query. The Advanced Filter Options provide the ability to add user-defined SQL to the filter condition as well as the ability to create a SubQuery or import a list of filter definitions into the Filter window as demonstrated in the Chapter 2, Filters section.
Custom SQL filter option
The Custom SQL filter option allows the user to leverage SQL to create a custom-defined filter in the Filter window. When the Custom SQL button is clicked from the Filter window, the field definition of the filter is shown in the editable textbox as shown in the following screenshot:
While adding Custom SQL to the interface, both the left and right-hand ...
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.
