Oracle Analytics Cloud and Server

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

Oracle Analytics Desktop

Received Response
41
Views
1
Comments

Summary

Hierarchy Level in Oracle Analytics Desktop using Analytic Views

Content

Hi ,

I need to create a product hierarchy level report in Oracle Analytics Desktop using Analytic Views.

Please suggest on this.

 

Regards,

Gunalan S

Version

Oracle Analytics Desktop(5.7)

Answers

  • Juan Diego Ruiz-Oracle
    Juan Diego Ruiz-Oracle Rank 4 - Community Specialist

    Hi Gunalan S.,

     

    In OAD you do not need to create the hiearchies or do anything spetial. Just create the dataset to the DB using e.g. SQL if needed and show the info in the vizualization you want. E.g. Pivot table.

     

    Hope it helps.

     

    Regards,

    Juan Diego