OBIEE 11g | 12c - The Value of Dashboard Prompt with 'Limit values by' Changes to "All Column Values" Unexpectedly (Doc ID 2209561.1)

Last updated on JULY 26, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150120 to 12.2.1.1.0 [Release 11g to 12c]
Information in this document applies to any platform.

Symptoms

If you create a prompt with 'Limit values by' a prompt, the Value can change by other prompts.

You can reproduces the issue with SampleAppLite.rpd.

Reproducible steps:

1. Create a dashboard prompt based on "Sample Sales Lite" using the following columns.

"Products"."LOB"
-Include "All Column Values" choice in the list : Enable checkbox

"Products"."Product Type"
-Include "All Column Values" choice in the list : Enable checkbox
-Limit values by : "LOB"

"Offices"."Company"
-Include "All Column Values" choice in the list : Enable checkbox

"Offices"."Department"
-Include "All Column Values" choice in the list : Enable checkbox
-Limit values by : "Office"

2. Place the prompt on a dashboard page and run it.

3. Select any value for the first prompt (say "Products"."LOB").
   This automatically sets the value of 4th prompt ("Offices"."Department") as "All Column Values".

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