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".

Components

Filters Pane Toolbar

The toolbar contains the following buttons.

Create a filter for the current subject area — Use this button to choose an attribute column or measure column from a list of the columns that are currently selected for the analysis. You can also select the More columns option to display the "Select Column dialog", where you can select an attribute column or a measure column from the current subject area. If your repository is configured for double columns, typically, you choose a display column on which to filter. However, you can choose a code column on which to filter but only if the code column is exposed in the Presentation layer in the Oracle BI EE repository. For more information on the Presentation layer, see Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.

After you select a column, the "New Filter dialog" displays where you specify the new filter's criteria.
Remove All Filters — Use this button to delete all of the filter items in the Filters pane. To delete a selected filter item, you must go to the listing of filter items in the Filters pane and click the Delete button for the item to remove.
More Options — Click this button to access the following options:
- Save Filters — Use this option to save the filter and all of its contents to the catalog. Filters saved to the catalog are called named filters and can be added to other analyses and dashboards. If you save the filter as a named filter and then continue to work on the filter within the Filters pane, any changes that you make are not automatically saved to the catalog. To re-save the named filter, you must again click the Save Filters option. Note that selecting the Save Filters option does not save the analysis and inline filter upon which you are working. To save the inline filter with the analysis, go to the Analysis Editor's toolbar and click the Save button.
- Add EVALUATE_PREDICATE Function — Use this option to display the "New EVALUATE_PREDICATE Function dialog", where you create a function.

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:

Edit Filter — Use this button to display the "Edit Filter dialog", where you edit the filter item's criteria.
Copy Filter — Use this button to copy the filter item. When you click this button, a copy of the filter displays below the original filter item. You can use this functionality to save time by copying an existing filter item upon which to base a new filter item rather than creating a new filter item from scratch.
Delete— Use this button to delete the filter item.

Operator

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:

Ungroup — Use this option to ungroup the highlighted filters group. If you are working with a group that has several layers of groupings, then clicking this option ungroups only the highlighted group.
Delete Group — Use this option to delete the highlighted filter group from the filter.

Duplicate Group — Use this option to copy and paste the highlighted filter group. When you click this option, Oracle BI EE pastes the copy below the copied filter group. The copied filter group is also nested within the filter group from which it was copied.