Unify BI: Create Filters
- 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.
- Filters within a filter group are AND by default. Click the OR button in the filter group bar to change it.
Note: If a filter is created on a date dimension, it will be displayed in the filters pane with the format DD/MM/YYYY. When the data is returned to Tableau, the dates can be formatted in any style.
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.
Adding columns to Filter Groups
If you have multiple filter groups defined, double-clicking a column will only add the column to the first filter group. If you want to add a column to any other group, you will need to drag the column and drop it on the Filter Group bar.
"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.)