Using a Saved Oracle BI Request as a Filter

Any saved request that returns a column of values can be used to filter the selected column in your request.

Step1 : create a request with column(s) that will be used as a filter for any column of new request.

save the request.(In my case path : users/jaga/req_filter)

Step2 : Let us create a new request where we want to use previous request as filter for columns.
Add any column to the request, then click on the filter button.

         

Step3 : Next, click on then Advanced button and select "Filter based on results of another request" option.

Step4 : From the Relationship dropdown select the operator, then type/browse the path of the saved request which you want to use a filter for this column.

Step4 : Now we can select the any column of saved request (to be used as filter) using the "Use values in Column" dropdown.

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.
Then Click OK . Now you can notice that the filter have been added to the request.

Now click on the "Results" tab to see results.
Comparison of result of new request and saved request.
Result of saved reuest :

Result of New Request :

We can see that the "E05 Manager Name" column is filtered by the "E05 Manager Name" column of saved request.