1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Report Data
  3. Filter and Select Data for Analyses
  4. Use a Saved Analysis as a Filter

Use a Saved Analysis as a Filter

You can create a filter based on the values that are returned by another analysis. You can use any saved analysis that returns a column of values to filter the matching column in an analysis.

For example, you can create a filter that is based on the results of the Brand Revenue analysis.

  1. Create or open a named filter or analysis to which you want to apply an inline filter.
  2. Find the filter.
    • If you’re working with a named filter, then locate the Saved Filter pane. From the Subject Areas pane, select the column for which you want to create a filter.
    • If you’re working with an inline filter, then locate the Filters Pane. From the Filters Pane toolbar, click Create a filter for the current Subject Area. Select the column for which you want to create the filter.
  3. In the Operator field of the New Filter dialog, select is based on the results of another analysis.
  4. In the Saved Analysis field, enter the path to the analysis or click Browse to locate it.
  5. Select a column name from the Use Values in Column menu.
  6. In the Relationship field, select the appropriate relationship between the results and the column to be filtered.
  7. Click OK.