Oracle Analytics Cloud and Server
Oracle 6.0 Hierarchy Display Setting
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
Answers
-
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
-
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.
-
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
-
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
