Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table like below :
TAB:
LOAD
EMP_NAME,
MANAGER_NAME,
SALARY
FROM ...TEST.XLSX;
How can I create section access so that each employee when log in can see their own data and when manager log in they can see their data as well as their reportees data.
Actually I checked the blog but how can I implement that in my structure.
Any help on this??
I have written the script like below but it is not working:
SECTION Access;
LOAD 'USER' as ACCESS,
[Staff Name] as STAFF_NAME,
Upper([Staff Name]) as PERMISSION
FROM
[C:\Users\manda\Desktop\Hierarchy_test_data.xlsx]
(ooxml, embedded labels, table is Sheet1);
SECTION Application;
THierarchy:
HierarchyBelongsTo([Staff Name],[Manager Name],DESIGNATION,AncestorID,AncestorDesignation)
LOAD [Staff Name],
[Manager Name],
DESIGNATION
FROM
[C:\Users\manda\Desktop\Hierarchy_test_data.xlsx]
(ooxml, embedded labels, table is Sheet1);
Hierarchy:
Load
[Staff Name] as NAME,
AncestorID,
Upper(AncestorID) as PERMISSION
Resident THierarchy;
DROP Table THierarchy;
Fact:
load * inline
[
NAME,SALARY,PROJECT
A,10000,QA
B,40000,QIS
C,25000,QCT
D,30000,SFDC
E,45000,LMS
F,15000,TMS
G,65000,HMS
];