I have weekly receiving files, where i have 4 fields namely Employee name, Emp id and Manager name, Mgr id
Those who are in Managers can come under Employee also, as they have their respective Managers.
Similarly i have 650 reporting managers
I have created a hierarchy using Employee Field with Hierarchy function
Table1 :
Hierarchy (Emp id ,Mgr id,Employee name,,Employee name,[Resource Path],'|',[Resource Depth])
Load
..
Emp id &'|'&Mgr id&'|'&Week as hierarchy_key
and HierarchyBelongsTo function,
Table2:
HierarchyBelongsTo (Hierachykey1, hierarchy_key, [Resource Path], TreeID, TreeName)
Load
..
Emp id &'|'&Mgr id&'|'&Week as hierarchy_key1,
[Resource Path]
Resident Table1;
i got 8 levels of hierarchy with Employee as Employee 1,2,..8. And have created a Reduction field called PERMISSIONS
(i.e)
Upper([Resource Path]) as PERMISSION.
PERMISSIONS
A
A|B|B1|B2
A|C|C1|C2|C3
A|C|C1|C2|C5
A|C|C1|C2|C4
D|E
D|F1|F2|G1|G2
So, every time ill look for Reporting Managers name from Reporting Managers field (eg: C2), ill search and select that name in the Hierarchy fields which were created i.e., in Employee 1,2,3..8 and put that selected rows from PERMISSIONS field and put it in Section access, and ill have to enter his ID (NTNAME same as ID) against it.
ill do the same manual work for all 650 managers, that is very difficult. And every week data changes and will have to do every week.
How can i automatically do that ?
OR how can i add his ID to the respective rows he belongs to ?
PERMISSIONS ID(NTNAME)
A|C|C1|C2|C3 C101 ( this ID belongs to C2, if he access app in access point)
A|C|C1|C2|C5 C101
A|C|C1|C2|C4 C101
OR is there any way that i could have his name in first hierarchy like below, so that i can add first name's ID as second column and i can pull this data to section access
PERMISSIONS ID(NTNAME)
C2|C3 C101 ( this ID belongs to C2, if he access app in access point)
C2|C5 C101
C2|C4 C101
This is an urgent requirement . Please help me in this.
