[OBI11g] ESSBASE Unbalanced Hierarchy Dimension returns Wrong Value instead of NULL

(Doc ID 2004152.1)

Last updated on MAY 22, 2015

Applies to:

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


Importing Essbase Sample cube and try to view Essbase unbalanced hierarchy on BIEE.
The data shown on OBIEE should be same as Essbase, but instead Essbase Unbalanced Hierarchy Dimension
does not have a corresponding data, OBIEE returns member names from ancestor leaf members.


1. Import Basic Essbase Outline into BIEE repository.
2. Create request with the following:
   Gen3,Measures - Long Names
   Gen4,Measures - Member_Name
   Gen4,Measures - Long Names


BIEE should not return member names from ancestor leaf members;
Column "Gen4,Measures - Long Names" should be NULL.

Sales -> Revenue                   OK
COGS -> Cost of Goods Sold  OK
Marketing -> Marketing          OK
Payroll -> Payroll                    OK
Misc -> Miscelleneous             OK
NULL -> Opening Inventory    NG
NULL -> Additions                  NG
NULL -> Ending Inventory      NG
NULL -> Margin %                  NG
NULL -> Profit %                    NG
NULL -> Profit per Ounce        NG



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