You could use a subquery within otbi ie "results based upon another analysis ie the subquery returns a list of managers, then the main query gets the term date details for these people. select worker number, term date where worker number in (select manager number…..)

Another option is you can use usage tracking ie "OTBI Usage Real time" subject area which will return the Logical SQL which will then tell you the filters used in the reports that have been run.

we need this functionality too - to remove need to update URLs for every POD refresh. enhancement request "SR 3-31263643601" doesn't seem to be publicly visible

Can't see this link : https://community.oracle.com/customerconnect/discussion/525699/repository-session-variable-with-hostname-for-drill-down Get :Permission Problem

Agreed - not a good user experience. We've just gone live with Payroll, so only a hand full of subject areas are relevant but have to search through a long list.- I've been going to Manage privileges and changing the permissions to "deny" . Bit of a painful task but this works. However, gets reset when next patch is applied