Ambiguous Hierarchy for drill in IDT
I have created a two Hierarchies in Navigational path in IDT. Both hierarchies use the same dimensions
Org Unit: Level1,Level2,Level3,Level4,Level5,Level6,Emp Full Name
(ii) Org Structure: Level1,Level2,Level3,Level4
The (2) Hierarchies are used in two different reports.
It is prompting me with the below dialog box in my 2nd report.
"You performed a drill action on a dimension that belongs to multiple hierarchies.
Select a dimension hierarchy.
Is there a way to avoid prompting the dialog box, while drilling down?
If I am using only Org Unit hierarchy, then it is drilling down to level1 .. Emp Full Name even though I specify scope of analysis to level3 in webi.