topic Section Access prob in QlikView

Section Access prob

nikhilgarg — Wed, 05 Aug 2015 12:10:07 GMT

Hey,

I applied the section access in my application as:

LOAD * Inline [

ACCESS , USERID , PASSWORD

ADMIN, ADMIN, ADMIN

SASH,SASH,SASH

LORNE,LORNE,LORNE

];

Section Application;

But when i opened it again, and provide the userid and password as SASH, i am getting all data rather than SASH data only.

Where am i wrong?

Thanks

Re: Section Access prob

daniel_kusiak — Wed, 05 Aug 2015 12:15:04 GMT

Is it the same with LORNE?

Re: Section Access prob

qlikmsg4u — Wed, 05 Aug 2015 12:16:51 GMT

You need to specify Access type As ADMIN or USER

LOAD * Inline [

ACCESS , USERID , PASSWORD

ADMIN, ADMIN, ADMIN

USER,SASH,SASH

USER,LORNE,LORNE

];

Section Application;

Re: Section Access prob

PrashantSangle — Wed, 05 Aug 2015 12:16:52 GMT

Hi,

LOAD * Inline [

ACCESS , USERID , PASSWORD

ADMIN, ADMIN, ADMIN

USER,SASH,SASH

USER,LORNE,LORNE

];

Section Application;

Then go to Document Property->Opening->Select Initial Data Reduction Based on Section Access.

Regards

Re: Section Access prob

awhitfield — Wed, 05 Aug 2015 12:17:13 GMT

Hi Nikhil,

is that your entire Section Access Script? All that's doing is making a user enter a user name and password.

Andy

Re: Section Access prob

nikhilgarg — Wed, 05 Aug 2015 12:17:20 GMT

YES, can you suggest something?

Re: Section Access prob

daniel_kusiak — Wed, 05 Aug 2015 12:26:34 GMT

Add Section Access; before LOAD * INLINE.

It should look like this:

Section Access;

LOAD * Inline [

ACCESS , USERID , PASSWORD

ADMIN, ADMIN, ADMIN

USER,SASH,SASH

USER,LORNE,LORNE

];

Section Application;

Then go to Settings->Document Properties->Opening and set Initial Data Reduction Based on Section Access.

After that you can omit data for user like SASH or LORNE by adding OMIT to INLINE. You can also set user privilages

Settings->Document Properties->Security. Remeber to set Admin Override Security.

Re: Section Access prob

nikhilgarg — Wed, 05 Aug 2015 12:38:41 GMT

Ohk, so what should i do ?

My first statement is binary load then:

Section Access;

LOAD * Inline [

ACCESS , USERID , PASSWORD

ADMIN, ADMIN, ADMIN

USER,SASH,SASH

USER,LORNE,LORNE

];

Section Application;

In document setting , i have checked :

1: Initial data reduction based on section access

2: Section Exclusion

Re: Section Access prob

daniel_kusiak — Wed, 05 Aug 2015 12:46:09 GMT

Do you do INLINE by Insert->Section Acces->Inline?

Re: Section Access prob

awhitfield — Wed, 05 Aug 2015 13:07:55 GMT

HI Nikhil,

maybe you should check out the attached document

Re: Section Access prob

antoniotiman — Wed, 05 Aug 2015 13:19:52 GMT

Hi,

Your Section Access simply means only 3 Users gain access to the document whitout any restriction.

Could You explain 'rather than SASH data only' ?

Have You any Conditional Expression like QVUser()='SASH' in Sheet or Objects ?

Re: Section Access prob

nikhilgarg — Wed, 05 Aug 2015 13:22:58 GMT

Yes,

I did the same way

Re: Section Access prob

jonathandienst — Wed, 05 Aug 2015 13:29:38 GMT

For data reduction, you will need to specify in the load some sort of key value that exists outside of Section access. Something like this:

Data:

LOAD ....

Upper(IDDiv) As DIVCODE,

....

Section Access;

LOAD * Inline [

ACCESS , USERID , PASSWORD, DIVCODE

ADMIN, ADMIN, ADMIN,

USER,SASH,SASH, 123

USER,LORNE,LORNE, 456

];

Section Application;

ADMIN can access all, SASH can access 123, LORNE can access 456

Update to use a relevant key for your application.

Re: Section Access prob

daniel_kusiak — Wed, 05 Aug 2015 13:37:52 GMT

I made a test for:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMIT

ADMIN, ADMIN, ADMIN,

USER, DANIEL, DANIEL, UNIT NAME

];

SECTION Application;

As a ADMIN i can see all data. As a Daniel i see all data without UNIT NAME

In load script i have alias unit_n as [Unit Name]. In Section application i've used name after alias.

Re: Section Access prob

jonathandienst — Wed, 05 Aug 2015 13:52:47 GMT

OMIT is for column security, so you can hide a specific column. Data reduction is for row security, so you can hide data rows completely. You can combine both types of security into a single model if required.

Re: Section Access prob

Gabriel — Wed, 05 Aug 2015 15:01:01 GMT

Hi,

Reading your explanations of the issue, it sounds to me that you want to do Dynamic Data Reduction.

If this is the case, your Section Access script has no Reduction Field.

You have to reduce user's access based on one field. Page 9 of the file attached by awhitfield talks about Reduction Field

Hope this help