Discussion Board for collaboration related to QlikView App Development.
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 ;
ZQVACCESS as ACCESS,
UPPER(ZQVNTNAME) as NTNAME,
LOAD * INLINE [
ZQVACCESS, ZQVNTNAME, ORG
USER, DOMAIN\USER1, 1000
USER, DOMAIN\USER2, 2000
USER, DOMAIN\USER3, 1000
USER, DOMAIN\USER4, 1000
STAR IS *;
LOAD * INLINE [
Qlikview Version : 12.10 SR7
Let me know, if you need any further information.
Edited : ORG Names
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?
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.