OBIEE 12c: Expanding a Hierarchy Column Throws a Bad XML Instance Error or the Levels are Displayed Incorrectly (Doc ID 2218463.1)

Last updated on APRIL 28, 2017

Applies to:

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

Symptoms

After upgrading from OBIEE 11g (11.1.1.7.x) to OBIEE 12c (12.2.1.2.0), where the native Teradata ODBC driver is used to access the back-end Teradata database (the datasource for the OBIEE analyses), ragged hierarchies behave unexpectedly and/or throw an error when expanded.  See various symptoms may be encountered as below :-

1.  When expanding / drilling down on a particular level in the hierarchical column, the following error is thrown:

Error Displaying Results
The current xml is invalid with the following errors: Bad xml instance! .... Element 'target' is not valid for content model: '(staticMemberGroup,(target|measureTarget))' ... Element 'selectionGroups' is not valid for content model: '(selectionGroup,)

Error Details
Error Codes: EIRWWH9E

2.  When expanding / drilling down on a particular level in the hierarchical column, the "child" level appears above the "parent" level.  For example: 

See results after drilling to the 1st level (correct behavior):-
[+] ACME Corporation
     [+] ACME Level 1

See results after drilling to the 2nd level (incorrect behavior):-
[+] ACME Corporation
          [+] ACME Level 1.1 <<<<====== The "child" level displays above its "parent"
     [+] ACME Level 1

 3.  The root (Grand Total) is not displayed.  For example:

Organization Hierarchy
[+]                            <<<<==== The Grand Total (root level) is "blank"
    [+] ACME Level 1
    [+] ACME Level 2

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