topic Authentication for data reduction not working in QlikView

Authentication for data reduction not working

nsm1234567 — Mon, 16 Feb 2015 11:20:34 GMT

Hi there,

I'm hoping someone might be able to assist me. I can't get the data in this model to reduce the way I want it to. What I want is that, when the "User" logs in, they only see the "Branch" Project. The login details for both "admin" and "user" are "admin123". Password for the hidden script is password.

Can someone please check where I'm going wrong?

Thanks for your assistance.

Re: Authentication for data reduction not working

maxgro — Mon, 16 Feb 2015 11:34:41 GMT

use uppercase

set strict exclusion in settings --> document properties-->opening

Re: Authentication for data reduction not working

fashid — Mon, 16 Feb 2015 12:34:48 GMT

Hi,

Please mark the question as answered if this is what you were looking for . It encourages others to answer questions.

Regards,

Nadeem

Re: Authentication for data reduction not working

nsm1234567 — Mon, 16 Feb 2015 13:03:36 GMT

Hey There, thanks for this. Why though, when the admin user logs in, can they only view branch data until such time as the model is reloaded (at which point the admin user can see all the projects)? Should the admin not be able to see all of the projects?

Re: Authentication for data reduction not working

maxgro — Mon, 16 Feb 2015 13:23:00 GMT

add other project for ADMIN if ADMIN needs to see other project (LIFESTYLE in example below)

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, PROJECT

ADMIN, ADMIN, ADMIN123, *

USER, USER, ADMIN123, BRANCH

ADMIN, ADMIN, ADMIN123, LIFESTYLE

];

Re: Authentication for data reduction not working

maxgro — Mon, 16 Feb 2015 13:27:02 GMT

A wildcard, i. e. *, is interpreted as all (listed) values of this field (PROJECT field), i.e. a value listed elsewhere in this table.

Re: Authentication for data reduction not working

nsm1234567 — Mon, 16 Feb 2015 13:34:51 GMT

Ah ok, that makes sense. So I can theoretically create a dummy "user" that has access to each project and then the "wildcard" will work as I'm expecting it to? Seems a bit strange, but thanks for the help.