Manager Employee Drill Down

[Anonymous]

I have the below data in excel file & have a drill down challenge.

Emp ID Name Title Manager ID

1 John CEO Null

2 Smith CFO 1

3 Jane Manager 2

4 Doe Analyst 3

How do I create a drill down hierarchy in such a way that I drill from the top all the way to the bottom?

Thanks,

Dinesh.

[johnw]

Probably with either a hierarchy load or a semantic load, depending on what you're after. I suspect you're after a hierarchy load. I haven't used them in any actual applications, but you should be able to find more information in the help text.

[Anonymous]

Dinesh,
I agree with John about hierarchy. See attached. The script for this in my example (in case you don't downlod files):

DrillDown:
HIERARCHY (EmpID, ManagerID, Name, Manager, Name,'Tree View', '/')
LOAD
 EmpID,
 Name,
 Title,
 ManagerID
RESIDENT data;
DROP TABLE data;