Oracle^® Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide > Filtering Requests in Oracle BI Answers >

Using a Saved Oracle BI Request as a Filter

Filters can be combined with other filters, as well as be based on the values returned by another request. Any saved request that returns a column of values can be used to filter the selected column in your request.

To create a filter based on the results of another saved request

1. At the Filter on Saved Request dialog box, select the appropriate relationship between the results and the column to be filtered from the Relationship drop-down list.
2. Browse to navigate to the saved request, or type the complete path into the text box.

   If the saved request contains a matching column name, it appears in the Use Values in Column drop-down list. If you want to use another column, select it instead.

3. Click OK.

   The filter appears in the Filters area on the Criteria tab.

Related Topic

Using Column Filters in an Oracle BI Request