My Oracle Support Banner

OBIEE 12c : In Bar Graph Drill Down Option With Primary Interaction As "None" Causes the Drill Down to Work (Doc ID 2571939.1)

Last updated on JANUARY 24, 2022

Applies to:

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


On Oracle Business Intelligence Enterprise Edition (OBIEE) Version 12c, Analytics

Bar Graph drilling further even after removing the Drill functionality by setting Primary Interaction as "None" In "Column Properties -> Interaction".

With table view, everything works fine as expected.

Steps to Reproduce the Issue:-

1. Create a sample report with below columns.

Per Name year, Product and revenue as shown below.

2. Set the Primary Interaction as "None" in the column properties for the "Per Name Year" Column as below which means , this column shouldn't drill down further on the analysis.

Please note that by default it will be "Default (Drill)".

3. Click on the Results . Choose the New View >> Graph >> Bar >> Stacked vertical

4. Chart results are below.

5. In the above graph results shown for the years 2008, 2009 and 2010 respectively.

6. Now, click on the 2008 Year data.  Data gets drill down to the further level which is 2008 HY1 and 2008 HY2. And again click on the HY1 , it will drill down further as shown in the below screenshots.

7. logically it shouldn't drill down as we have set the Drill to "None" for the Year column in the in the column properties >> Interaction tab.


 Creating the Bar Chart


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.