topic Re: Section Access Issue in QlikView

Section Access Issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a requirement where only the Managers have to login with their login credentials, to see all the employee data working under him and his own data in the dashboard.

Example:

Dept Manager Employee Emp credit

health A E 10

health A F 20

health A G 30

sports B A 10

sports B R 10

Finance D F 20

If Manager 'A' logs in he should see only employee data of E, F, G and his own data also , along with respective emp credit in the dashboard.

I have already segregated the data in an excel file, and using that in the section access code in the script.

The issue is, as you can see one Employee is having more than one Manager,

Example:

Employee F is having two managers => A and D.

If A logs in, only A should be present under Manager's field, as F is having two managers. I could see two Managers A and D in it.

How can i restrict data only to that manager. Am i missing something.?? or How should i segregate the data in section access

Help me in finding out

Thanks you..

Re: Section Access Issue

ravikumar_iyana — Sun, 24 Sep 2017 05:44:56 GMT

Hi Kishore,

Creating Section Access purpose:

Go to Edit Script: File(menu)>Create Hidden Script<mention user name & password for Admin>

It will create new window (Hidden Script)

Insert> Section Access> Inline> Access Restriction Table Types> Basic NT Security(Select)

note: Basic NT Security-> it will creates security based on their login credentials

Example:

Dept Manager Employee Emp credit

health A E 10

health A F 20

health A G 30

sports B A 10

sports B R 10

Finance D F 20

U can try this it will more than sufficient

Re: Section Access Issue

swuehl — Sun, 24 Sep 2017 08:12:57 GMT

Maybe create a canonical Manager/Employee field similar to what is shown with a date field here:

Canonical Date

Then use this field as reduction field in SA.

See also this for potential other options

Authorization using a Hierarchy

Data Reduction Using Multiple Fields

Basics for complex authorization

Re: Section Access Issue

Anonymous — Mon, 25 Sep 2017 10:32:46 GMT

can you explain how can i create a canonical Manager/Employee field with the data ?

Re: Section Access Issue

ravikumar_iyana — Mon, 25 Sep 2017 13:48:41 GMT

Hi Kishore,

Stafen wuhl given links plz refer go through links i dont it is very helpful easily understanding way.