My Oracle Support Banner

How to use Presnetation Variable in SQL of Dashboard Prompt ? (Doc ID 2396942.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : 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

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