topic Re: Section access asks for login credentials?! in QlikView

Section access asks for login credentials?!

alec1982 — Wed, 30 Apr 2014 15:36:17 GMT

Hi guys,

I have the following section access to reduce data

Section Access;

LOAD NTNAME,

NTDOMAINSID,

[ACCESS],

UPPER(MANAGER)&'|'& UPPER(NAME) as %AuthID

FROM

(ooxml, embedded labels, table is Sheet1);

Section Application;

and not sure why the users are able to access the access point but when they click on the dashboard it askes them for user name and Password?

Any idea?

Thxs

Anonymous — Wed, 30 Apr 2014 15:46:21 GMT

It may happen if the NTNAME login fails.

BTW, the reduction field name must be all caps, not only the values.

alec1982 — Wed, 30 Apr 2014 15:50:55 GMT

Hi,

If I sign in as an admin with my ID everything works.. so I am assuming there is no issues with the fields, right?

when I try to login on one of the users machine I get question for username and password even the user accessed the access point.

Wed, 30 Apr 2014 15:53:12 GMT

if you sign in as ADMIN even your reduction field doesn't match, it will allow you to open. Reduction field name must be in caps.

Anonymous — Wed, 30 Apr 2014 15:57:18 GMT

Besides, always use upper() function in section access, unless you use inline load. Even if you know that the data is in upper case already.

Section Access;

LOAD

upper(NTNAME) as NTNAME,

upper(NTDOMAINSID) as NTDOMAINSID,

upper(ACCESS) as ACCESS,

UPPER(MANAGER)&'|'& UPPER(NAME) as AUTHID

FROM

(ooxml, embedded labels, table is Sheet1);

Section Application;