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

Symptoms

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.



STEPS TO REPRODUCE
--------------------

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


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