topic Re: Section Access issue in QlikView

Section Access issue

settu_periasamy — Fri, 08 Jun 2018 09:37:48 GMT

Hi All,

Anyone faced the below scenario while implementing the Section Access.

In the below script, We have provided the Same Access to USER1, USER2 and USER4.

It is working for USER1 and USER2. But for USER4 show all the data instead of ORG ->1000

I have tested exact below scenario with Multiple users.

Not properly working for some users. Instead of restriction, It shows all the data.

SECTION ACCESS ;
LOAD
ZQVACCESS as ACCESS,
UPPER(ZQVNTNAME) as NTNAME,
ORG;

LOAD * INLINE [
ZQVACCESS, ZQVNTNAME, ORG

ADMIN,DOMAIN\SETTU, *
USER, DOMAIN\USER1, 1000
USER, DOMAIN\USER2, 2000
USER, DOMAIN\USER3, 1000
USER, DOMAIN\USER4, 1000

];

SECTION APPLICATION;
STAR IS *;

ORGTable:
LOAD * INLINE [
ORG
1000
2000
3000
];

Qlikview Version : 12.10 SR7

Let me know, if you need any further information.

Edited : ORG Names

Re: Section Access issue

avinashelite — Fri, 08 Jun 2018 09:52:00 GMT

I test your code its working fine for me you had missed the ORG names as per the access table I just added the data and tested it . if am missing anything let me know

Re: Section Access issue

tresB — Fri, 08 Jun 2018 09:56:11 GMT

Have you enabled 'Initial Data Reduction Based on Section Access' in the document properties settings?

Re: Section Access issue

settu_periasamy — Fri, 08 Jun 2018 10:35:44 GMT

Yes. I forgot to change the ORG name. Thanks Avinash.

Re: Section Access issue

settu_periasamy — Fri, 08 Jun 2018 10:36:52 GMT

Yes tresesco‌. It is working for other Users. Some users only having this issue.

Re: Section Access issue

tresB — Fri, 08 Jun 2018 10:42:01 GMT

Yes, I see now that you already mentioned that. . Try to prob and find if there is any pattern of the error. Is the user somehow distinct from others (may be any special character in name/id).

Re: Section Access issue

Peter_Cammaert — Fri, 08 Jun 2018 10:54:10 GMT

On first sight, this means that you have not enabled "strict exclusion" and that in your actual document the Link field value specified by Section Access has no corresponding value in you Section Application data model. That's the most probable cause of Section Access granting access to all data.

A couple of tips:

put a text box with =OSUser() on a sheet and check the actual domain name of the user that is currently viewing your document
temporarily comment out the Section Access; statement, reload and use a listbox for field NTNAME and a table box for other data in your data model to check the Linking and selection of data rows for each individual NTNAME

BTW what's the second SA table used for? Isn't the first with just fields ACCESS, NTNAME and ORG enough?

Re: Section Access issue

avinashelite — Fri, 08 Jun 2018 11:24:51 GMT

Could you please share the associated tables details and script ?? will check how the data association is working the model

Re: Section Access issue

settu_periasamy — Fri, 08 Jun 2018 11:45:25 GMT

As i said earlier, I have tested the exactly same script which i mentioned (Just changed NTNAME).

In our original application, we have a associated tables after this implement..

Re: Section Access issue

settu_periasamy — Fri, 08 Jun 2018 11:55:57 GMT

Thanks. Checked that one also.

Testing purpose, I used conditional hidden sheet with Same name (OsUser()). It is working perfectly.

But, the data only not restricted.

Re: Section Access issue

avinashelite — Fri, 08 Jun 2018 12:05:44 GMT

Hmm then I feel you need to check your data set and access part once

Re: Section Access issue

settu_periasamy — Fri, 08 Jun 2018 13:37:45 GMT

Hi Peter,

I tried the same what you have mentioned.

See my exact sample script and output.

1. Script:

2. List Box (Removed Section Access Line and checked)

3. Out Put for Issued User (from Access Point )

4. Same Access working for the another User

Still now, i found this kind of issue for 7 User out of 100. I'm not sure why it is happening like this.

Re: Section Access issue

olivierrobin — Fri, 08 Jun 2018 13:42:58 GMT

hello

are you sure of the windows user code ?

it looks as if you didn't connect with the user you mention in your section access ....

try to display osuser()

Re: Section Access issue

settu_periasamy — Fri, 08 Jun 2018 13:57:33 GMT

Hi Olivier,

In the Text Object, I have added the OSUser().

The screen shot from Access point. I took the screen shot from two User.

Re: Section Access issue

olivierrobin — Fri, 08 Jun 2018 14:01:34 GMT

and it's exactly the on in your file ? no extra character like space, tabulation or so on ?

the domain is the same ?

Re: Section Access issue

settu_periasamy — Fri, 08 Jun 2018 14:08:30 GMT

I have checked character by character and checked with Admin team also.

Nothing is different. Even I tried to give single ORG (1000) for the user. Still i have an issue.

Re: Section Access issue

olivierrobin — Fri, 08 Jun 2018 14:11:06 GMT

did you check he has a license assigned and anonymous access disallowed ?

Re: Section Access issue

avinashelite — Fri, 08 Jun 2018 14:35:35 GMT

Settu , could you share the sample data with the exact names or similar names will see whats happening ...I worked on similar example but I didn't faced any issue and I am not able to replicate the issue also at my end

Re: Section Access issue

avinashelite — Fri, 08 Jun 2018 14:39:21 GMT

settu , I feel for few user the NTNAME is mapped in a different way ...try like this instead of the ORG add a name column and see whats the name its getting mapped in NTNAME because the OSUSER() and NTNAME might not be the same always

Hope you got my point

Re: Section Access issue

settu_periasamy — Fri, 08 Jun 2018 14:50:54 GMT

Hi Avinash,

Sure. I will send via mail.