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 188.8.131.52.150120 and later
Information in this document applies to any platform.
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.
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