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 12.2.1.0.0 to N/A
Oracle Analytics Server - Version 5.5.0 to 5.5.0.0.201216 [Release 5]
Information in this document applies to any platform.

Goal

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.

Solution

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
Goal
Solution
References


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