OBIEE 11G Drilldown Displays The Columns In Incorrect Order
Last updated on JULY 17, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.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.
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.
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