OBIEE12c: Previously Selected Prompt Values May Not Be Refreshed When using SQL Results Based on a Presentation Variable

(Doc ID 2334503.1)

Last updated on DECEMBER 18, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

- Dashboard Prompts is created hierarchic structure:

- The first level of choices list of values are inserted into Presentation Variable (ex. Test_Org).
- And the next level of Choice List Values of dashboard prompt is defined as SQL RESULTS using presentation variable:

SELECT "Offices"."Office" FROM "Sample Sales Lite"
WHERE "Offices"."Department" IN ('@{Test_Org}[@]')

- The third level of choices list of values are "Limit values By" All Prompts.


Now, you select one of the values (say Genmind Corp) on the top level of dashboard prompt. Then the next level of dashboard prompt will narrow down. The list of values for Organizations is within Genmind Corp. When you select one of the organizations, Franchises Org. for instance, Department list of values are narrow down within the Franchises Org. This is expected.

The issue is here when you change the value on the top level of dashboard prompt (say "Genmind Corp" to "Stockplus Inc"); the list of values on the second level of dashboard prompt (here example Organization) does not change to organizations with in "Stockplus Inc".

In other words, previously selected prompt values of second level may not be refreshed even when the top level dashboard prompt value has changed.

 

Cause

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