The RelationShip is like SR->SS->ASM>RSM->GSM

but the intermediate linkages like ss,asm,rsm or gsm might not always be present.

for eg some employee might be directly reporting to senior manager as ther no...

The Problem with the solution is SR->SS->ASm->RSM->Gsm is not always true.

Sometime SR->Asm or SS->RSM and so on,is there any way can we join the dimension as we do in...

yes the Dimesion builds properly with Only Seq.I am able to drill down and viceversa.

SR can have only one SS but SS can have more than one SR.(similar to employee...

While Deploying it states that duplicate key found,but the duplicate will exist as it is hierarchical.I have attached the screenshot for your reference

Thx for the Reply

The dimension Mon Reln Hist (SR Detail Seq) ->Related to Fact(SF Detail Seq)

What i want is Instead of drilling through there sequence i want to drill...