topic Re: Section Access in QlikView

Section Access

alec1982 — Sat, 26 Apr 2014 17:53:47 GMT

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

Re: Section Access

Clever_Anjos — Sat, 26 Apr 2014 18:08:57 GMT

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

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

Re: Section Access

its_anandrjs — Sat, 26 Apr 2014 18:14:25 GMT

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

Re: Section Access

alec1982 — Sun, 27 Apr 2014 03:37:11 GMT

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,

Re: Section Access

SunilChauhan — Sun, 27 Apr 2014 03:49:23 GMT

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

Re: Section Access

alec1982 — Sun, 27 Apr 2014 04:45:22 GMT

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!

Re: Section Access

alec1982 — Sun, 27 Apr 2014 14:08:39 GMT

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

Re: Section Access

Anonymous — Sun, 27 Apr 2014 21:00:08 GMT

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;

Re: Section Access

alec1982 — Sun, 27 Apr 2014 21:39:16 GMT

Hi,

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

Thxs,

Alec

Re: Section Access

Anonymous — Sun, 27 Apr 2014 21:55:41 GMT

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.

Re: Section Access

alec1982 — Sun, 27 Apr 2014 22:01:03 GMT

Thank you Bella,

Would it be possible to just show three columns headers of the data table with no data in it..

Thxs,

Alec

Re: Section Access

Anonymous — Sun, 27 Apr 2014 22:12:31 GMT

I'm not sure what you mean by data table. The section access inline table is above. The column headings

ACCESS, - whether admin or user

USERID, - log in

PASSWORD, - password

PMSECTIONACCESS - this is a field in the database that I filter my users on.

Re: Section Access

alec1982 — Sun, 27 Apr 2014 22:18:38 GMT

Thank you Bella..

I will try to build it and let you know if it works.. I think it will not work as I don't see how the manager can be authorized to see his/her users data.. how is the relationship between the Manager and the user is defined within section access if we are using only one column of the database.

Best,

Alec

Re: Section Access

alec1982 — Mon, 28 Apr 2014 03:36:22 GMT

This hasn't been a success for me with having the two columns Users and Managers to work with. Anyone can help.

Best,

Alec

Re: Section Access

Anonymous — Mon, 28 Apr 2014 04:03:18 GMT

What is it you are trying to filter on?

In section access you can only have two types of users - admin and users

so your section access table will need to have (all needs to be in caps)

ACCESS, USERID, PASSWORD, [FIELD]

ADMIN, ADMIN, ADMIN1

USER, JOHN, PASSWORD1

USER, JASON, PASSWORD2

USER, GEORGE, PASSWORD3

USER, DAN, PASSWORD4

USER, EMILIE, PASSWORD5

the first three will set up the profiles for your users and assign a username and password but then you need to have a field that their access will be filtered/reduced by given the information you have provided that would most likely need to be the staff name but this needs to be in your main dataset.

ACCESS, USERID, PASSWORD, STAFFNAME

ADMIN, ADMIN, ADMIN1

USER, JOHN, PASSWORD1, JOHN

USER, JOHN, PASSWORD1, JASON

USER, JOHN, PASSWORD1, GEORGE

USER, JASON, PASSWORD2, JASON

USER, GEORGE, PASSWORD3, GEORGE

USER, DAN, PASSWORD4, DAN

USER, DAN, PASSWORD4, EMILE

USER, EMILIE, PASSWORD5, EMILE

things you need to check

a) this is in the first tab of scripting

b) you field (staffname) is all in caps and with no spaces (can use Upper(purgechar([field], ' ')) to make sure of that

c) do not use * for all just leave blank.

If you are able to send me through your QVW and let me know what field you want to filter on I can have a play and try and knock something up for you.

Re: Section Access

alec1982 — Mon, 28 Apr 2014 12:46:32 GMT

Hi Bella,

The isse is not within the section access table. the difference between my data model and yours is that you are filtering data on one column while i have two Users and Managers..

Thxs,

Alec

Re: Section Access

Mon, 28 Apr 2014 13:00:35 GMT

Don't treat a manager and a user differently, The data is different

Example

User, FieldJoiningToData

StaffMemberBill,StaffMemberBill

ManagerJohn,ManagerJohn

ManagerJohn,*

Star is all previously mentioned values, so John inthe above example can see himself and Bill

Re: Section Access

Mon, 28 Apr 2014 13:01:20 GMT

I recently built a 5 tier heirachy sing 30 lines of code with loops and concats using the above logic

Re: Section Access

alec1982 — Mon, 28 Apr 2014 13:06:38 GMT

Thank you Felmin,

The issue is that some managers don't exist within the users in fact they are just managers and they need to see their users.