Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

how to create Hierarchy that can skip a level when getting null data

Received Response
21
Views
3
Comments
User_9XA6O
User_9XA6O Rank 3 - Community Apprentice
edited August 13 in Oracle Analytics Cloud and Server

Hello all,

I have developed  a Level base hierarchy like Manager --> Submanager-->TL--->consultant

it works fine, now my requirement is if I do not get any data for particular level (or get NULL DATA for any level)  while drill-down then it should skip that level and directly jump to next level. It should not display null data for that level at report level.

e.g.:

IF I don't have data(NULL VALUES) for level submanager  in above hierarchy then when would I click on Manager level it will directly redirect to TL level, it would not display submanager level.

same thing happen with other level also if it will not have any data(NULL VALUES)

Manager --> TL-->consultant in report level.

Please let me know how I can achieve this.

Thanks

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi,

    More performant would be to get your ETL process to populate all levels with the same parent as previously where they are currently missing, I have done this previously using coalesce as the means to 'push' the values into the gaps.

    Otherwise I do not believe that there is the means to fulfil your full requirement using out of the box functionality.

    Best Regards,

    Robert.

  • Joel
    Joel Rank 8 - Analytics Strategist

    If you're referring to skipped level hierarchies, then you can create a level based hierarchy and define the structure as Skipped Levels:

    pastedImage_0.png

  • User_9XA6O
    User_9XA6O Rank 3 - Community Apprentice

    Thanks for your input.