Perhaps I'm not following Richa's instructions but I don't believe that will work the way we need it to, at least in OAS at this time. The issue is that we need the users to be able to select a specific filter value in one workbook, pass those filter selections into a second workbook that would then return it's results to the first workbook. We use this today in Answers to resolve one-to-many issues in data.

I need to somehow make the logical sql statement dynamic so that it passes in whatever values are stored in the filter prompt into the WHERE clause.

Sub queries from another reports are very commonly used one.

Many good functionalities in OBIEE is ignored in OAC DVs.

Finally Parameter functionality is came but it has limitation of 1000 results output using logical SQL.