Drill Down in WebI 4.1

Question

Let's say 2 fact tables Employee_Fact and Manager_Fact are available. And the dimension tables like Organisation_Dim, Location_Dim, Department_Dim, Calender_Dim.

Employee_Fact is connected with all the dimension Tables and Manager_Fact is connected with the alias of the same dimension tables.

In Report 1, I have a table that gives the Organisation_Name, Department_Name, Employee_Salary, Manager Name and Manager Salary. In this report I need the filter Organisation Name, Region. Also, the drill down from Organisation Name --> Department Name --> Location --> Manager Name --> Employee Name.

I have 2nd Report that shows the Organisation Name, Department Name, Department Amount, Location Name, no of Employee. Here I have drill down from Organisation name --> Department name --> Location.

How can I obtain drill down in this scenario? Do I need to add 2 different hierarchies or only one hierarchy is needed? This confusion occurred as I take values from both fact tables in 1st report.

Answer 1

It was a mistake that I did not select the same drill down objects in my Report too. Rather I selected from other Class Folder which did not give correct hierarchy.

Thanks

Niki