Categories
Ability To Have Drop Downs From Hierarchies
For one of the reports that we are trying to recreate it has the ability to look at a top level of a hierarchy and click an arrow that drops down to the level below it and includes the measures (Revenue) for it. Would it be possible to have an interactive column that allows the user to just click it and it can go down a level? For example, for Balancing Segment level 31 is top level and does not house that much data, but dependent on the user of the report they can go more in depth and hit Balancing Segment level 29. I think this would allow the reports to be more interactive and dynamic for its users. Would love to hear others thoughts on this capability!
Comments
-
You can use the Hierarchy Column in the Fusion Analytics Warehouse. Below is a screenshot.
1 -
Thank you @Krishna Prasad Kotti-Oracle! Is there ability to filter it to an account like Revenue rather than the top level of natural accounts??? For example, I would like this report to only show Natural Account level 30 and below rather than showing 32 and 31.
0 -
You can add columns to the filter like Natural Account Level 31 Code etc.
2 -
@Cade Johnston - I know this is an old post, but I wanted to make you aware that a new feature should be coming to FDI soon called Selection Steps (it came out for Oracle Analytics Cloud customers in the May 2025 update): check out this video:
https://www.youtube.com/watch?v=J2jSMZNFyJk0
