Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

Hierarchy building capability in data visualization to avoid additional work in data modeler or RPD

Under Review
191
Views
8
Comments
krishna kishore reddy
krishna kishore reddy Rank 1 - Community Starter
in Oracle Analytics Cloud and Server Idea Lab

Organization Name

xerox corporation

Description

We need hierarchy building capability on data set directly in data visualization data plane. This feature is already exist in tableau, power bi etc analytics tool and it helps to build hierarchies on the fly. To build hierarchies we need to work on data modeler but we found a bug that detailed column in hierarchy is avoiding distinct in physical queries and causing duplicate rows. So we need to use RPD to achieve hierarchy and to avoid duplicates.

Use Case and Business Need

Business users can directly build hierarchies on relevant fields with out IT people help.  

More details

We thought of building hierarchy reports without using RPD but due to lack of this capability we have to chose either thin client or RPD. For some reports data modeler is enough but choosing either RPD or data modeler is restricting to build some important reports.

Original Idea Number: c8944097a2

Tagged:
23
Up
23 votes

Under Oracle Review · Last Updated

Thanks for submitting and voting on this idea. This feature is currently under review. Once it makes progress in the review process, we will update the idea status

Comments

  • Michal Zima
    Michal Zima Rank 6 - Analytics Lead

    One addition to this requirement - capability of building/designing hierachies should be available in data set definition. And this hierarchy should be exposed (in DV projects visualization) in similar way as hierarchical columns in Answers.

  • Subhakara Netala-Oracle
    Subhakara Netala-Oracle Rank 6 - Analytics Lead

    Hierarchy building capability in DV Dataset is very useful. Customers are asking for this functionality. Is there any update on this from Product Development Team?

  • Aaron Epstein-261578
    Aaron Epstein-261578 Rank 4 - Community Specialist

    This would be incredibly helpful for some reporting that we're trying to stand up here too that doesn't exist in our RPD model.

  • Greg Faris
    Greg Faris Rank 5 - Community Champion
    edited August 2023

    We really need this feature to build hierarchical dimensions with defined drill-paths in dataset-based DV reports similar to what can be accomplished with different levels in logical dimensions in an RPD. It's a gap of functionality that exists in many other BI tools as mentioned above. It is preventing us from being able to migrate reports from other platforms into OAS.

    Can someone from Oracle please provide an update on when this feature is planned for implementation?

    Note that the initial Idea is 3 years old, so it would be good to know that it's on the roadmap in the near future at this point.

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics Lead

    Yes. It will help lot.

    Qlik has this capability.

  • Benjamin Arnulf-Oracle
    Benjamin Arnulf-Oracle Admin

    I agree. It would be extremely helpful. We need more votes on this idea. Adding my vote.

  • user6766570
    user6766570 Rank 1 - Community Starter

    I agree. It would be extremely helpful. We need more votes on this idea. Adding my vote.

  • User_FBG8L
    User_FBG8L Rank 3 - Community Apprentice

    It was this the lack of this feature & another one that prevented our client months ago from taking OACs over Power BI. Their users could not contemplate having to go through an RPD to build something they thought was super simple. Please add this as it make reports much easier to consume.