My Oracle Support Banner

OBIEE 11G: Issue In Creating Bins With Multiple Columns (Doc ID 2462185.1)

Last updated on OCTOBER 26, 2018

Applies to:

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

Symptoms

Creating an extra bucket "NULL" when using multiple columns in creating bins

Steps to reproduce the issue:

Created a sample custom column Bin report:  Refer the Image in the cause section

 

 Formula used to create the custom column Bin:


CASE WHEN ("EOE") IN ('86') AND ("Cost Center") IN ('1751','1754') THEN 'Automotive Engineering (Vehicle Fuel Cost)'
WHEN ("EOE") NOT IN ('86') AND ("Cost Center") IN ('1751','1754') THEN 'Transportation Operations'
ELSE 'CENTRAL (see table below)' END

Based on the case statement: When EOE is not in '86' and cost center in '1751' the entry should fall under 'Transportation Operations' bucket . But if you look into the above table a separate bucket has been created at the bottom as 'NULL' which is not correct.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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