[OBI11g] ESSBASE Unbalanced Hierarchy Dimension returns Wrong Value instead of NULL
Last updated on MAY 22, 2015
Applies to:Business Intelligence Server Enterprise Edition - Version 126.96.36.199.12 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.
STEPS TO REPRODUCE
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
EXPECTED BEHAVIOR (*)
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
Million Knowledge Articles and hundreds of Community platforms