Oracle Business Intelligence

Products Banner

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

Received Response
16
Views
3
Comments

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