OBIEE 11.1.1.7.141014 Limit Prompt Values Bug Workaround

There’s a strange bug since 11.1.1.7.140715 which is when you want to limit prompt values by another prompt, the All Column Values default selection gets reverted to — Select Value–. Here’s what happens and the workaround to fix it.

Lets start by creating a Dashboard Prompt

Create OBIEE Prompt

Next, we’ll use Sample Sales Lite as an example.

OBIEE-Limit-Prompt-Bug-010

We will need to create 2 Column Prompt

OBIEE-Limit-Prompt-Bug-009

We will need Office and Organization for this example. Click Office for now.

OBIEE-Limit-Prompt-Bug-008

In Options, Choice List Values, select All Column Values, then select Include All Column Values as well as the last 4 checkboxes. The Default selection, we’ll use All Column Values. You can follow the below screenshot.

OBIEE-Limit-Prompt-Bug-007

For Organization, we will need to limit values by All Prompts and uncheck Enable user to type values. Default selection will be All Column Values. Follow below screenshot.

OBIEE-Limit-Prompt-Bug-006

Next save the prompt, add to my dashboard and view the dashboard.

OBIEE-Limit-Prompt-Bug-005

OBIEE-Limit-Prompt-Bug-004

OBIEE-Limit-Prompt-Bug-003

If you change the Office selection to Montgomery Office, you will see that Organization will be –Select Value–. This should actually be All Column Values in previous versions.

OBIEE-Limit-Prompt-Bug-002

To fix this problem, go back and view the prompt. You will see that the options for Organization has been rolled back.

OBIEE-Limit-Prompt-Bug-001

All you need to do is to set the prompt like before but also check “Enable user to type values”. Then everything will work fine again. Please note that this is a bug and I will raise an SR soon.

 

Advertisements

Author: Steve Yeung

Being in the EPM & BI field for more than 8 years, it's about time I contribute to newcomers! As a founder of MondayBI.com I wish to give you all the help I can. Feel free to give any suggestions or questions. Hope you will all enjoy this blog! William Wong Essbase Certified Specialist OBIEE Certified Specialist

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s