Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Simple Tiered Section Access

I am attempting to setup a simple tiered Section Access for a manager employee relationship. I have reviewed the content (Authorization using a Hierarchy)  and have found it far more complicated then what is needed.

Are there any new or simple Section Access approaches to cover this scenario with the data set below: When a manager logs in they will see all the employees and when the employee logs in they only see their data?

EmployeeOrg:

LOAD * INLINE [

REPORTSTONODE, NODE

12345, 45682

12345, 54821

12345, 21214

12345, 44545

12345, 75756

12345, 45454

12345, 77572

];

Sales:

LOAD * INLINE [

NODE, Sales

45682, 1000

54821, 1000

21214, 1000

44545, 1000

75756, 1000

45454, 1000

77572, 1000

];

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

you should use

section acces:

load * inline [

USERID, ACCESS, NTNAME, NODE

BOSS, USER, BOSS, *

A, USER, ANAME, 45682

B, USER,BNAME, 54821

...

---

every user sees the nodes which are specified (if a user Needs more than 1 node, duplicate the entry)

View solution in original post

3 Replies
avinashelite

Hi Matt,

Please find the attachment for the solution.

Please you 1,2,3,4 and 5 as user id to login in and you can see the below employee hierarchy

USERID,Name,Supervisor_id

1,A,0

2,B,1

3,C,2

4,D,2

5,E,1

Not applicable
Author

The attachment did not make it..

Anonymous
Not applicable
Author

you should use

section acces:

load * inline [

USERID, ACCESS, NTNAME, NODE

BOSS, USER, BOSS, *

A, USER, ANAME, 45682

B, USER,BNAME, 54821

...

---

every user sees the nodes which are specified (if a user Needs more than 1 node, duplicate the entry)