My Oracle Support Banner

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

Last updated on MAY 01, 2018

Applies to:

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


On : 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.



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.


To view full details, 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 a vibrant support community of peers and Oracle experts.