topic Re: Simple Tiered Section Access in QlikView

Simple Tiered Section Access

Wed, 11 Feb 2015 15:04:23 GMT

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

];

Re: Simple Tiered Section Access

avinashelite — Wed, 11 Feb 2015 15:09:37 GMT

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

Re: Simple Tiered Section Access

Thu, 12 Feb 2015 15:10:26 GMT

The attachment did not make it..

Re: Simple Tiered Section Access

Anonymous — Thu, 12 Feb 2015 15:15:51 GMT

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)