How to use Presnetation Variable in SQL of Dashboard Prompt ?
Last updated on MAY 09, 2018
Applies to:Oracle Fusion Sales Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms