How to use Presnetation Variable in SQL of Dashboard Prompt ?
(Doc ID 2396942.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.0 version, Analytics
All Column Values are not working with presentation variables in BI Dashboard
Customer use case
a. Customer has a Dashboard Prompt (say 1) on which the values are populated using SQL.
b. On this Prompt 1, customer has also selected the option 'Include "All Column Values" choice in the list'
c. On this Prompt 1, customer has set a Presentation Variable (say O_NAME)
d. Now customer has created another Prompt (say 2) values for which are populated using an SQL with WHERE on earlier Presentation Variable O_NAME
How to build an SQL on second prompt in order for "All Column Values" to work when Presentation variable is used.
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