OBIEE 11G Drilldown Displays The Columns In Incorrect Order (Doc ID 2036561.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

On : 11.1.1.7.140415 version, Analytics


The problem is the drilldown on the dimension based on the hierarchy level.

When the user creates an analysis based on a dimension based on hierarchy level. The order of columns is not matching the dimension level. The example below describes this scenario.

If there is a 4 level hierarchy in the RPD as  Segment -> Family -> Class -> Commodity. In report when clicking on 'Segment', OBIEE created a new column just to the right of 'Segment' to display the Family.

If  we click again on 'Segment', OBIEE creates another column just to the right of Segment but this time to display 'Class', so the output will be Segment -> Class -> Family instead of Segment -> Family -> Class.

 

EXPECTED BEHAVIOR
---------------

Report containing dimension based on hierarchy level when drilled down on hierarchy column, should list column in same order as hierarchy, even if the top most level of hierarchy is clicked again and again to list the Child members of hierarchy.

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