Dependent Dropdown In OTBI Prompts

(Doc ID 2296414.1)

Last updated on DECEMBER 20, 2017

Applies to:

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

Goal

Dependent Dropdown in OTBI Prompts

We have prompts that are based on analysis SQL and we use the same in BI dashboards. We have a need to make drop down values of one prompt to depend on the values selected on the prompt.

This dependency works fine when we use the subject area and no analysi sql in the prompt.

How we can make this dependency work if we use analysis SQL in the prompts.
 

Solution

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