My Oracle Support Banner

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

Last updated on MAY 09, 2018

Applies to:

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

Goal

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

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!


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