Creating a Filter Based on the Results of a Saved Analysis

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. If you are working with a named filter, then locate the Saved Filter pane and from the Subject Areas pane, select the column for which you want to create a filter.
   If you are working with an inline filter, then locate the Filters Pane, and from the Filters Pane toolbar, click the Create a filter for the current Subject Area button and select the column for which you want to create the filter.
   The New Filter dialog is displayed.
3. In the Operator field, select is based on the results of another analysis.
   The Saved Analysis, Relationship, and Use values in Column fields are displayed.
4. In the Saved Analysis field, either enter the complete path to the saved analysis or click the Browse button to locate the analysis upon which to base the filter.
   The column names from the saved analysis are displayed in the Use Values in Column drop-down list.
5. Select a column name from the Use Values in Column field, and in the Relationship field, select the appropriate relationship between the results and the column to be filtered.
6. Click OK.