Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle 6.0 Hierarchy Display Setting

Received Response
51
Views
4
Comments

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 4 - Community Specialist

    Just a curious query, if you are using EPM as source for building P&L report then it should be really easy. 

    If you are having any other source system and have GL Account dimension in place having roll-ups of oracle account (GL Account number) till BS or PL then define hierarchy in RPD  (data model) and leverage it in OAC to build user stories or visualization

  • Rank 5 - Community Champion

    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.

    image.png

  • Rank 6 - Analytics Lead

    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

  • Rank 6 - Analytics Lead

    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 -


    Regards,

    Amrita

Welcome!

It looks like you're new here. Sign in or register to get started.