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
- 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.
- 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.
- Click OK.
The filter appears in the Filters area on the Criteria tab.