Ambiguous Hierarchy for drill in IDT

[former_member640919]

Hi,

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.

Org Unit

Org Structure"

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.

[former_member203850]

Hi Jyothy ,

Can you please confirm whether it worked or not ?

Regards,

Pranay

[former_member203850]

Hi Jyothy ,

If you use the same set of objects in two different hierachy , then you will get the prompt message in webi report.

It would be better if you create two different class in universe and pull the objects in hierachy 1and 2  from the different class A and B respectively. For example:

1. Class A.level 5 ->Class A.level 6 -> Class A. Emp Full Name

2.Class B.level 5 -> Class B.level 6

Hope it helps

Regards,

Pranay