Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Have you enabled 'Initial Data Reduction Based on Section Access' in the document properties settings?
Yes. I forgot to change the ORG name. Thanks Avinash.
Yes tresesco. It is working for other Users. Some users only having this issue.
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).
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:
BTW what's the second SA table used for? Isn't the first with just fields ACCESS, NTNAME and ORG enough?
Could you please share the associated tables details and script ?? will check how the data association is working the model
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..
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.