Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents

Filters pane

Use this dialog to create or edit a named filter or inline filter.

For more information, see:

This pane is part of the "Analysis editor: Criteria tab."

This pane also displays as the Saved Filter pane on the "Filter editor."


Filters Pane Toolbar

The toolbar contains the following buttons:

Filter Item Toolbar

The filter item toolbar is the collection of buttons that displays when you hover over a filter item within the list of filter items. It includes the following buttons:


Click the operator to toggle between AND and OR. When you add a filter item, the default operator is AND. The AND operator means that the criteria specified in each filter must be met. This is the default method for combining column filters. The OR operator means that the criteria that is specified in at least one of the column filters must be met.

If you have specified three or more filters and click AND, then Oracle BI EE automatically groups the filter item with the filter item above it. Grouped filters are indented in the filters list. You can click the operator to group the filters in several layers. Grouped filters are always processed before ungrouped filters.

Edit Filter Group

This button displays when you hover over a collection of grouped filters. Use this button to specify what you want to do with the corresponding group. If you are working with a multi-level group, then ensure that you are clicking on the correct Edit Filter Group button. Note the following options: