Thanks for the response . Here I mean the heirarchy is ragged . See below the sample heirrachy where the leaf levels are E,X,Q ,S etc...
Level1 Level2 Level3 Level4 Level5 Level6 Hierarchy_Id A B C D E null 1 A B X null null null 2 A N P Q null null 3 Z S null null null null 4
We have handles drill thorugh in obiee11g using RDBMS as data source by making this ragged heirarchy - a psedo balanced heirarchy by repeating the last level till the end. and then using the last level as the column for drill through parameter.
Level1 Level2 Level3 Level4 Level5 Level6 Hierarchy_Id A B C D E E 1 A B X X X X 2 A N P Q Q Q 3 Z S S S S S 4
But the problem is we cannot do this essbase cube . Pls. suggest how tohandle this in cube where we cannot manipulate teh ragged heirarchy.