Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents
Contents

Using a Saved Analysis as a Filter

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

To create a filter based on the results of another saved analysis:

  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.