OBIEE 11g/12c : Issue With Drill Down Functionality In Charts

(Doc ID 2394425.1)

Last updated on JUNE 13, 2018

Applies to:

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

Symptoms

On Oracle Business Intelligence Enterprise Edition (OBIEE)

Drill down of charts in analytics is not working properly

Example :

1) Create a new sample report from sample app lite RPD

2) Drag product, Time->time 02 per Name month and Revenue 

3) Add bucket using case statement for month :

    case when "Time"."T02 Per Name Month" = '2013 / 01' then 'JAN' when "Time"."T02 Per Name Month" = '2013 / 02' then 'FEB' else 'ALL' end

4) Disable drill option for month

5) Drill the product , and Observe that it shows month detail information.


However It should show only product detail information

Changes

 N/A

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