My Oracle Support Banner

Dependent Dropdown In OTBI Prompts (Doc ID 2296414.1)

Last updated on AUGUST 31, 2024

Applies to:

Oracle Fusion CX 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

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
Goal
Solution
References


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