topic Re: Help with setting up access in QlikView

Help with setting up access

Wed, 24 May 2017 06:34:59 GMT

Hi everyone,

I have set up a hidden access script, see it below:

Section Access;
LOAD ACCESS,
NTNAME,
USER,
CC_Description
FROM
[\\auqldrv00fil1bi\work\qlikview\Corporate Accounting\SG&A Report\MasterData.xlsx]
(ooxml, embedded labels, table is Access);

Section Application;

and I have attached the masterdata spread sheet where is looking the data for the security.

I would like to have it user only seeing your department and only some users to see everything.

however it is not working and everyone can see everything. The way I am filtering it is based on the CC_description which is in my data scrip as a group.

maybe that is the reason? does anyone has any light?

Thanks so much

Re: Help with setting up access

micheledenardi — Wed, 24 May 2017 06:44:45 GMT

Have you checked the relatives checkbox in order to "enable" the section access restriction ?

Re: Help with setting up access

Peter_Cammaert — Wed, 24 May 2017 06:44:48 GMT

Are the CC_description values in your DD_GL table in Section Application all in upper case? If not, create a copy of that field with the UPPER() function, call it CC_DESCRIPTION_SA and rename the corresponding Section Access field to CC_DESCRIPTION_SA

Re: Help with setting up access

Peter_Cammaert — Wed, 24 May 2017 06:46:14 GMT

In section Access, both the field names and their values are silently converted to upper case. That's a side effect of Section Access...

Re: Help with setting up access

Peter_Cammaert — Wed, 24 May 2017 06:47:49 GMT

Also, IIRC enabling Data reduction and Strict exclusion but without having a proper link field means NO REDUCTION AT ALL... Nice huh?

Re: Help with setting up access

sibusiso90 — Wed, 24 May 2017 06:48:16 GMT

Hi Joana

Please find the following it will help you with any security you need to do. While I look at your definitions. It will come in handy in future as well