Oracle Analytics and AI

User_9XA6O

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

Robert Angel

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.