topic Re: Section Access Not working in QlikView

Section Access Not working

balanandam — Wed, 18 Jul 2018 12:13:27 GMT

Hi,

In my app I have defined section access based on user login. without publisher its working but in our prod evn scheduled are happening thru Publisher. there i'm facing problem. Super user who has configured admin and configured with '*' to see complete view. when I logged with super it is working but with sub users who has configured for a particular section of data view is not working. when I logged in any sub user Access point itself getting logged out automatically..

Pls. advice if there special configuration to be set at Publisher level.

Thanks In Advance!

Br, Balanandam

Re: Section Access Not working

Anil_Babu_Samineni — Thu, 19 Jul 2018 12:39:46 GMT

In my app I have defined section access based on user login. without publisher its working but in our prod evn scheduled are happening thru Publisher. there i'm facing problem. Super user who has configured admin and configured with '*' to see complete view. when I logged with super it is working but with sub users who has configured for a particular section of data view is not working. when I logged in any sub user Access point itself getting logged out automatically..

What is the mean of Highlight one. Can you share script?

Re: Section Access Not working

balanandam — Thu, 19 Jul 2018 14:21:56 GMT

Hi Anil,

this was my code

Section Access;

LOAD *, Upper(NTNAME) as User;

LOAD * INLINE [
    ACCESS, NTNAME
    ADMIN,EC2AMAB-7GFRL3S\ADMINUSER
    USER,EC2AMAB-7GFRL3S\USER1
    USER,EC2AMAB-7GFRL3S\USER2
    USER,EC2AMAB-7GFRL3S\USER3
    USER,EC2AMAB-7GFRL3S\USER4
];

Section Application;

star is *;
User_Reduction_Data:
LOAD * Inline [
CompanyName, User
Valutech,EC2AMAB-7GFRL3S\USER1
EncoreRepair,EC2AMAB-7GFRL3S\USER2
EcoRenew,EC2AMAB-7GFRL3S\USER3
CVE,EC2AMAB-7GFRL3S\USER4
*,EC2AMAB-7GFRL3S\ADMINUSER
];
star is *;

here I'm calling ADMINUSER as super user and rest all sub user..

My dev environment it is working but not in prod, only change is Prod we have publisher that's it.

Br, Balanandam

Re: Section Access Not working

Anil_Babu_Samineni — Thu, 19 Jul 2018 15:05:56 GMT

Can you take away star is * and check one more time, Usually star is * will work up on data reduction level for all Users and Admin as well. It won't work as expected.

Re: Section Access Not working

balanandam — Thu, 19 Jul 2018 16:45:41 GMT

Anil,

I 've changed my code like below:

Section Access;

LOAD *, Upper(NTNAME) as User;

LOAD * INLINE [
    ACCESS, NTNAME
    ADMIN,EC2AMAB-7GFRL3S\ADMINUSER
    USER,EC2AMAB-7GFRL3S\USER1
    USER,EC2AMAB-7GFRL3S\USER2
    USER,EC2AMAB-7GFRL3S\USER3
    USER,EC2AMAB-7GFRL3S\USER4
];

Section Application;

User_Reduction_Data:
LOAD * Inline [
CompanyName, User
Valutech,EC2AMAB-7GFRL3S\USER1
EncoreRepair,EC2AMAB-7GFRL3S\USER2
EcoRenew,EC2AMAB-7GFRL3S\USER3
CVE,EC2AMAB-7GFRL3S\USER4
CVE,EC2AMAB-7GFRL3S\ADMINUSER
EcoRenew,EC2AMAB-7GFRL3S\ADMINUSER
EncoreRepair,EC2AMAB-7GFRL3S\ADMINUSER
Valutech,EC2AMAB-7GFRL3S\ADMINUSER
];

No change on behaviour, only no problem with super user. FYI all sub users created newly and granted licenses. Is there any thing that can cause this issue ? it might be foolish ask! but I just wanted to tell you this.

with sub I can log into access point and there I can see accessible Dash board, when I can click on the Dashboard it is getting logged out.

Br, Balanandam

Re: Section Access Not working

PabloTrevisan — Thu, 19 Jul 2018 17:15:15 GMT

Hi Balanadam, to use reduction try this format..

Section Access;

LOAD * inline [

ACCESS, USERID, REDUCTION

ADMIN, DOMAIN\USER1, USER1

USER, DOMAIN\USER2, USER2

USER, INTERNAL\SA_SCHEDULER,,,*

];

Section Application;

Star is *;

REDUCT:

Load * InLine [

REDUCTION, CONTRY

USER1, *

USER2, USA

];

Re: Section Access Not working

balanandam — Fri, 20 Jul 2018 11:38:19 GMT

No Luck again!

Br, Balanandam

Re: Section Access Not working

Anil_Babu_Samineni — Fri, 20 Jul 2018 11:54:20 GMT

Instead, Can you try simple and test from Prod using below.

LOAD *, Upper(NTNAME) as User;

LOAD * INLINE [
    ACCESS, NTNAME, CompanyName
    ADMIN,EC2AMAB-7GFRL3S\ADMINUSER, *
    USER,EC2AMAB-7GFRL3S\USER1, Valutech
    USER,EC2AMAB-7GFRL3S\USER2, EncoreRepair
    USER,EC2AMAB-7GFRL3S\USER3, EcoRenew
    USER,EC2AMAB-7GFRL3S\USER4, CVE
];

Re: Section Access Not working

balanandam — Fri, 20 Jul 2018 12:39:37 GMT

Anil, I changed this way as suggested

Section Access;

LOAD *, Upper(NTNAME) as User;

LOAD * INLINE [

ACCESS, NTNAME, CompanyName

ADMIN,EC2AMAB-7GFRL3S\ADMINUSER, *

USER,EC2AMAB-7GFRL3S\USER1, Valutech

USER,EC2AMAB-7GFRL3S\USER2, EncoreRepair

USER,EC2AMAB-7GFRL3S\USER3, EcoRenew

USER,EC2AMAB-7GFRL3S\USER4, CVE

];

Section Application;

Now I was able to login with sub users, but data reduction not happening, means Section access not working at all and I could see all the data as like ADMINUSER.

Br, Balanandam

Re: Section Access Not working

Anil_Babu_Samineni — Fri, 20 Jul 2018 12:47:28 GMT

I believe try from very static level and advance we can try. Can you check this?

LOAD * INLINE [

ACCESS, USERID, PASSWORD, CompanyName

ADMIN,EC2AMAB-7GFRL3S\ADMINUSER, 123, *

USER,EC2AMAB-7GFRL3S\USER1, 456, Valutech

USER,EC2AMAB-7GFRL3S\USER2, 789, EncoreRepair

USER,EC2AMAB-7GFRL3S\USER3, 012, EcoRenew

USER,EC2AMAB-7GFRL3S\USER4, 013, CVE

];

Re: Section Access Not working

balanandam — Fri, 20 Jul 2018 17:45:30 GMT

Reload failing. I think, expecting userid and password to proceed ?

got the below note from task log:

(7/20/2018 5:34:28 PM) Error: Document open call failed. The document might require username and password.

Br, Balanandam

Re: Section Access Not working

vishsaggi — Fri, 20 Jul 2018 17:53:53 GMT

Can you uncheck strict exclusion and run again and see?

Re: Section Access Not working

balanandam — Fri, 20 Jul 2018 18:00:18 GMT

Anil, I was able to load the doc now. But the result is same, that all users can log now but reduction not happening as per the section access just like earlier, only additional thing is this time, just prompting for credentials before opening.

Br, Balanandam

Re: Section Access Not working

Anil_Babu_Samineni — Mon, 23 Jul 2018 13:58:36 GMT

Screenshot please which you have the script?