OBIEE12c: Unexpected Value May Be Returned When Using "Drill in Place"

(Doc ID 2231897.1)

Last updated on FEBRUARY 28, 2017

Applies to:

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

Symptoms

Unexpected Value may be returned when you select "Drill in Place" in Dashboard.

Steps to reproduce using the Sample Sales Lite:

1. Select the following columns to create an analysis.

"Product"."Product Type"
"Product"."Product"
"Base Facts".Revenue"
"Base Facts".Billed Quantity"

2.Go to 'Result Tab' and Select 'Table' > 'Edit View'

3. Set the 'Layout' as follows.

<Columns and Measures>
"Product"."Product"
"Base Facts".Revenue"
"Base Facts".Billed Quantity"

<Table prompts>
"Product"."Product Type"

4. Click Done and Save Analysis.

5. Go to 'Prompts Tab' and Select 'New' > 'Column Prompt' > 'More Columns' > "Product"."Brand".

6. Set the 'New Prompt' as follows.

<New Prompt>
Operator: is equal to / is in
User Input: Choice List

Options:
Choice List Values : All Column Values

-Select the following items.
Enable user to select multiple values
Include "All Column Values" choice in the list

7. Click OK and Save Analysis

8. Create New Dashboard and Add the analysis created from above.

9. Select "Drill in Place" on properties of 'Section' area and Save.

10. Open Dashboard created from above.

11. Select 'Biz Tech' from prompt and Click 'OK'.

12. You can select the following Product Type from the list.  The following list of value is as expected.

- Accessories
- Audio
- Cell Phone
- Smart Phone

13. Select 'Cell Phone' from the list of 'Product Type' and Click 'Return'.

14. Next, Select 'FunPod' from prompt and Click 'OK'.

15. Even though you select 'FunPod', or the other list of value, the same list of value on step#12 returns.

- Accessories
- Audio
- Cell Phone
- Smart Phone


If you select 'FunPod', the following Product Type from list should be returned.

- Camera
- Fixed
- Portable

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