Is such drill down possible

[Former Member]

I have recursive hierarchy of person and manager. We have flattened the hierarchy and added five levels like Level1-> Level2(which reports to level1)->Level3(which reports to level2)...and so on.

Reporting requirement:

Need output like this:

Level1 Level2

On drill down

Level2 Level3

On drilling down

Level3 Level4

I am not getting this in webi. Is this possible?

Current output:

Level1 Level2

On drill down

Level3 Level2

On drill down

Level4 Level2

Do you know if my requirement is achievable or not?

Thanks,

Raghvendra

[Former Member]

Hi

Did You checked in universe hierarchies if not goto-->tools -->hierarchies -->custom hierarchies -->Add objects like

example

1)Continent

2)Country

3)state

4)city

and in webi enable drill down on Continent

Hope this helps u

Sunil