Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone !
I would like to share with you my most recent work about an automation script for securitization by Section Access because I think it could be useful to anyone who struggle or spends too much time to put it in place and maintain it 🙂
My objective was to find a solution to the following points :
Here are the main features of the solution I was able to put in place :
Basic
- All values: '*'
- Single value: 'UK'
- Multiple values (two possible ways):
-> Across multiple lines (one value per line, the same you have to do when writing the access section table by yourself)
-> Across a single line using a specific separator : 'UK;IT;ES'
Advanced
- Support for wildcards "*" and "?" in reduction values which makes it possible to write rules of the type "LIKE".
The creation of generic keys in the data model to satisfy more complex cases is no longer mandatory because you can use wildcard (https://community.qlik.com/t5/Qlik-Design-Blog/Basics-for-complex-authorization/ba-p/1465872).
Example : the rule 'B*;U*' will grant access to all values starting with the letters 'B' and 'U'.
- Support rules in exclusion mode.
Instead of listing the allowed values (default), now you can do the opposite by listing the prohibited values, which is much quicker to formulate in some cases.
To do this, the value or list of values must be prefixed with "[*-]" which means "everything but".
Example : if dataset has 100 country codes and I wish they were all accessible EXCEPT two of them, then I can write : "[*-]UK;USA"
********************************************************************************************
All necessary files are available in the attached Zip archive.
Almost all resources are commented in both English and French (including the implementation guide) to allow anyone to use it.
(Only the script itself is written in French with English comments for editable settings).
I'll be very happy to have your feedback 😊
Don't hesitate to ask if you have any problems or to suggest improvements.
Have a nice day !