Oracle 6.0 Hierarchy Display Setting

Question

Content

I'm looking for a setting/work around for displaying a hierarchy in Oracle Analytics Cloud DV. By default in OAC 6.0 the hierarchies display top-down, displaying children below the parent.

I'm looking to build a P&L, which would require the ability to open bottom-up with the children displaying above the parent. Are there any settings/plug-ins that can accommodate this requirement?

Version

OAC 6.0

Amrita Gupta-Oracle · Answer

Hi Joshua,

One way to drill up is making use of the Preferred Drill Path in the logical level of the hierarchy, where in  you select the immediate level above the selected level as the drill path. The below blog provides an example of the same -

http://obiee101.blogspot.com/2009/02/obiee-simulating-drill-up.html

Regards,

Amrita

Amrita Gupta-Oracle · Answer

Hi Joshua,

One way to drill up is making use of the Preferred Drill Path in the logical level of the hierarchy, where in  you select the immediate level above the selected level as the drill path. The below blog provides an example of the same -

http://obiee101.blogspot.com/2009/02/obiee-simulating-drill-up.html

Joshua C. Stewart · Answer

We are using a user define subject area as the data source - built from relational tables.

The hierarchy is built out correctly - the issue is with the display in OAC DV. It is currently displaying Top-Down, whereas, we need it displayed Bottom-Up. See image for details.