Hierarchy roll up questions

[alexpanjhc]

Hi experts

I am trying to build an HR hierarchy that i need to know who manages what.

For example I have a list of managers:

MangerID	Department	Department ID	Location	LocationID
1	Total Products	0	World	1
123	Clothing	1	USA	1011
321	Woman's Clothing	20	World	1
213	Man's Clothing	30	Asia	1003
312	Shoes	2	North America	1000

For Each Employee    

EmployeeID	Department	Department ID	Location	Location ID		Header 7
456	Women's Sweater	2025	NYC	100001
564	Boots	3075	Vancouver	100070
654	Men's ties	4073	Hongkong	100084
444	underwear	252	Chicago	100045
555	Sleepwear	111	USA	1011

I do have the hierarchy for the department and location

Department ID	Parent ID
2025	20
20	1
30	1
3075	2
1	0
4073	30
252	1
111	1
2	0

Location ID	Parent Location ID
1011	1000
1000	1
10001	1000
100084	1003
100074	1000
100045	1000
100070	1000
1000	1

How do I create a model so it rolls up and I can tell who is under the manager given? Or do i need more information to get what i want?

thanks!         

[alexpanjhc]

Up

[oscar_ortiz]

Alex,

I would start with a couple of write ups that hic‌ put together:

Hierarchies

Unbalanced, n-level hierarchies‌

Good luck!

Oscar