topic Re: Section Access not working the way I expect in QlikView

Section Access not working the way I expect

arixooo123 — Wed, 28 Jun 2017 05:13:12 GMT

Hello Guys

I am trying to add the section access for data reduction and security to my visualization layer in Qlik Sense enterprise server.

After the binary load, I added below scripts:

Section access;

load

'ADMIN' as ACCESS,

userid as USERID,

ACCESSKEY%

resident SecurityAccess;

Section Application;

load

SecurityAccess.userid as USERID,

AccessKey% as ACCESSKEY

Resident SecurityAccess;

ACCESSKEY is a composite key connected to our data specifying which rows users have access to.

When I enter 'USER' as ACCESS I get locked out of the app and when I try 'ADMIN' I can't see any data ( the app opens up with empty charts)

I appreciate your comments

Re: Section Access not working the way I expect

felipedl — Wed, 28 Jun 2017 12:14:47 GMT

Hi,

I've tested with some simple data in the attached file.

As a note, see if the option Settings -> Document Properties -> Initial Data Reduction (as below) is marked

Re: Section Access not working the way I expect

jmvilaplanap — Wed, 28 Jun 2017 14:22:35 GMT

Hi,

I show that you're using different fields for the KEY. In one is called with a % at the end. Maybe is there the problem?

Regards

Re: Section Access not working the way I expect

arixooo123 — Sun, 09 Jul 2017 02:17:38 GMT

Sorry for unmarking your answer.

Honestly, It wasn't correct but I marked it because I thought I found the solution.

I am using qlik sense,

Below script used to work: But for some reason, it doesn't now, after running this, I still have access to everything and data is not reduced.

Section access;

load

'USER' as ACCESS,

'ActiveDirectory\' & Upper(SecurityAccess.USERID) as USERID,

ACCESSKEY%

resident SecurityAccess;

Section Application;

load

'ActiveDirectory\' & Upper(SecurityAccess.USERID) as USERID,

ACCESSKEY%

Resident SecurityAccess;

Re: Section Access not working the way I expect

arixooo123 — Sun, 09 Jul 2017 22:53:00 GMT

I actually changed that a couple of times after I posted this.

It worked for once, but now is not.

You see, I used the same script in one app and It's working. But not for other apps

Re: Section Access not working the way I expect

BalaBhaskar_Qlik — Mon, 10 Jul 2017 01:53:06 GMT

may be this:

Check "prohibit binary load " in the settings\Document Properties\Opening tab.

Re: Section Access not working the way I expect

BalaBhaskar_Qlik — Mon, 10 Jul 2017 01:55:48 GMT

Create a source qlikview document that only contains the data you need in your other qlikview apps, but doesn't contain section access. Put the section access in the script of the other documents as needed, i.e. don't binary load it. You could choose to put the section access part of the script in a script file and use an include (or must_include) statement to include it in the scripts of the other documents.

Re: Section Access not working the way I expect

arixooo123 — Mon, 10 Jul 2017 02:04:47 GMT

Hi Bala,

Thanks for your response.

But I am using qlik sense.