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.