Discussion Board for collaboration on QlikView Security and Governance.
Which is the proper way to write the section access to allow a user to view two values from one particular field using REDUCTION in section access?
LOAD * INLINE [
ACCESS, NTNAME, DEPT, DEPT, DEPT
ADMIN, DOMAIN\ADMIN, *
USER, DOMAIN\USER1, DEPT1, DEPT2, DEPT3
USER, DOMAIN\USER2, DEPT2, DEPT3
USER, DOMAIN\USER3, DEPT3
or should it be:
ACCESS, NTNAME, DEPT
USER, DOMAIN\USER1, DEPT1
USER, DOMAIN\USER1, DEPT2
USER, DOMAIN\USER1, DEPT3
USER, DOMAIN\USER2, DEPT2
USER, DOMAIN\USER2, DEPT3
Any help would be greatly appreciated! Cheers
The second one is the proper solution. The first one is not feasible because you are trying to create in the same table many fields with the same name.
In fact, your section access is a table like every others but just hidden in your datamodel.
An even better solution may be something like this:
ACCESS, NTNAME, LINK
USER, DOMAIN\USER1, USR1
USER, DOMAIN\USER2, USR2
USER, DOMAIN\USER3, USR3
This code allows you to put your section access code in a hidden script, while the actual data permissions table can be edited in your regular script (or read from an Excel).