Combining and Grouping Column Filters

Combining and grouping column 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.

To combine a column filter with other column filters:

1. Create or open a named filter or analysis that contains an inline filter.

2. If you are working with a named filter, then locate the Saved Filter pane and confirm that the filter contains two or more filter items. If you are working with an inline filter, then locate the Filters Pane and confirm that the filter contains two or more filter items.

   After you add the second filter item, the AND operator is displayed before the second filter item.

   
   

   Note: If you want to group filters, then the filter must contain three or more filter items.

   
   

3. To change an AND operator to an OR operator, click the word AND. You can toggle between AND and OR this way. Note the following information:

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

4. As you add filter items, click AND and OR operators as necessary to construct the appropriate filter combinations.

5. Save the filter in one of the following ways:

   • From the Analysis Editor, you can select Save Analysis to save the filter as an inline filter.

   • From the Filter Editor, you can select Save Filter to save the filter as a named filter.

   For more information, see "Saving Objects as Inline or Named".