Combining and Grouping Column Filters

Before you start

You must have one of the following user type permissions:

• BI Author Limited

• BI Author Developer

• BI Tenant Administrator

Home > Oracle Business Intelligence > Catalog or, for Oracle Analytics,

Home > Oracle Analytics > Catalog

Here's what to do

1. Create or open a named filter or analysis that contains an inline filter.
2. Note: If you want to group filters, then the filter must contain three or more filter items.
   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.
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 "Inlined or Named Objects."

   .