Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an QlikView Application with Section Access. Every User is allocated to one or more categories, so that he only see the data from categories he is allocated to.
So far Section Access is working fine. Now I got the Challenge, that a few Users should have Access to data of categories that are not allocated to them, when the data is allocated to n suppliers. I'm searching for Ideas, how I could build this with Section Access.
Example of the existing Script:
Section Access;
Control:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME, GROUP
USER, '', '',USER1, GROUP1
USER, '', '',USER2, GROUP2
USER, '', '',USER3, GROUP2
];
Section Application;
Category:
LOAD * INLINE [
GROUP, CATEGORY
GROUP1, CATEGORY1
GROUP2, CATEGORY2
];
Example of the problem:
USER1 generally is not allowed to see the data of CATEGORY2. Only the data of SUPPPLIER_X in CATEGORY2 is allowed to see by USER1.
Thanks in advance
Hi Torsten,
I'd suggest reading this article -
http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization
This should help.
Marcus
You'd have to be more granular on your Section Categories. Have you tried using Composite keys for Category + Supplier? Even if you have a lot of Suppliers, you only have to define the ones you'd need specific access to.
Category: | |||
GROUP | CATEGORY | SUPPLIER | _KEY |
GROUP1 | CATEGORY1 | * | CATEGORY1_ |
GROUP2 | CATEGORY2 | * | CATEGORY2_ |
GROUP3 | CATEGORY2 | SUPPLIER_X | CATEGORY2_SUPPLIER_X |
Then have a mapping for your Suppliers:
SuppliersAccessMap:
Supplier, Include
SUPPLIER_X, 1
SUPPLIER_Y, 0
(the include is just a flag you can use)
In the script you can then map these to be able to create the proper keys.
...
....
CATEGORY + '_' + APPLYMAP('SuppliersAccessMap',SUPPLIER,'') as _KEY,
...
HTH!