topic Re: Section Access with multiple Dimensions in QlikView

Section Access with multiple Dimensions

Thu, 03 Apr 2014 15:12:20 GMT

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

Re: Section Access with multiple Dimensions

marcus_malinow — Thu, 03 Apr 2014 15:31:03 GMT

Hi Torsten,

I'd suggest reading this article -

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

This should help.

Marcus

Re: Section Access with multiple Dimensions

Thu, 03 Apr 2014 15:51:48 GMT

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!