Click the filter tab at the top of the Unify workspace. The filters panel is displayed.
Click the > icon to expand a folder in the Subject Area pane.
Double-click or drag-and-drop a dimension or measure to add to the filter group.
The default filter condition is Equal/In, click the drop-down to select a different condition.
Click the drop-down in the empty field to select values for the filter condition.
Click the magnifying glass to the right of the empty field to search for values.
Click the X to remove the filter condition.
Create Filter Groups
Click the + icon in the Filter Group heading to create a new Filter Group.
Click the X icon in the Filter Group heading to remove the Filter Group.
“Combining and grouping filters with AND and OR Boolean operators enables you to create complex filters without requiring you to know SQL statements. Grouping enables you to establish the precedence in which Oracle BI EE filters an analysis.” (From the Oracle help documents.)