My Oracle Support Banner

How To Set Request Variable From Variable Prompt (Doc ID 2756968.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

Oracle Business Intelligence Enterprise Edition - Version to N/A
Oracle Analytics Server - Version 5.5.0 to [Release 5]
Information in this document applies to any platform.


Following is the requirement to be accomplished:
1. From the variable prompt on the report user chooses schema values. This needs to populate a session variable which is used to substitute user name in RPD connection pool.
2. The second prompt returns results based on an SQL. The SQL results depend on which schema the query is sent to.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.