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.

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