Section Access

[alec1982]

Hi guys,

I  am building a section access dashboard and i have done several times in different ways.

Assuming I have User and Manager columns within the table i am going to use what would you think the best way to accomplish the section access dashboard giving that User can be in both User and Manager column and the manager needs access to all his/her Users.

Let me know your thoughts..

Best,

Badr

[Clever_Anjos]

Recommend reading: http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/25/hierarchy-authorization

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

[its_anandrjs]

Follow this document related to the hierarchy section access.

Section access - security | Qlik Community

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/25/hierarchy-authorization

[alec1982]

Hi,

The above solutions are helpful but not with what I have..

As I have on my question.. I have two columns Users and Managers. Managers exists within the users as follow:

User     Manager

John     John

Jason   John

George John

Dan       Dan

Emile     Dan

I am trying to have John to see his team only and Dan to see his team only while Jason can see only data related to him and same thing for the users who are not managers.

The User Column exist within the data on the only table I am using.

Thxs,

[SunilChauhan]

I understand your problem  but

can you please add sample data for what user can have access

may be 4-5 liner so that i can give a try for it

hope this helps

[alec1982]

Hi Sunil,

Here is a sample data

User     Manager     Sales Order     Amount

John          John       1234               500

Jason        John       2345               250

George      John       4323               200  

Dan           Dan         3456              345

Emile         Dan         653                345

John          John        765                654

Jason        John        876                345

George      John        987                897

Dan           Dan          543                123

Emile         Dan          2343              543

Thank you for your help!

[alec1982]

Hi Anand,

Thank you fr your input but not sure if you see the blog link already listed above. What I am trying to do here is a little different where I have users and managers and I want the users to see only their data and managers to see their users data.

Managers could be listed within the users table and couldn't.

Thxs,

Badr

[Anonymous]

I have come across this before too, my section access looks like below. Each user Stephen, Irene, Murray, Emma and Vinnie have access to their info while the managers Kim and Ernie have access to all of the staff under them.

Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD, PMSECTIONACCESS
    ADMIN, ADMIN, ADMIN,
    USER, STEPHEN, STEPHEN, STEPHEN
    USER, IRENE, IRENE, IRENE
    USER, MURRAY, MURRAY, MURRAY
    USER, KIM, KIM, STEPHEN
    USER, KIM, KIM, IRENE
    USER, KIM, KIM, MURRAY
    USER, EMMA, EMMA, EMMA
    USER, VINNIE, VINNIE, VINNIE
    USER, ERNIE, ERNIE, EMMA
    USER, ERNIE, ERNIE, VINNIE
   ];
Section Application;

[alec1982]

Hi,

Thank you for your help.. Can you send me a sample of your data how it looks like..

Thxs,

Alec

[Anonymous]

Due to confidentialty reasons no I can't post a sample QVW. but basically when a user logs in the name in the PMSECTIONACCESS is already selected in the filters they see.  For a manager mulitple names are selected.