How to combine multiple criteria to set dynamic datareduction with section access

kristien — Fri, 13 Oct 2017 12:04:54 GMT

Hi,

I want to set up dynamic datareduction in a sales application.

The purpose is that a sales representative can only see what belongs to him.

The problem is that there are 2 levels where a salesrep is linked: each customer is linked to a salesrep , and each order is also linked to a salesrep, normaly this will be the salesrep that is linked to the customer, but sometimes it may be another salesrep.

The purpose is that a salesrep may see all facts that are linked to his customer + all facts where he is directly linked to

i.e. 3 salesreps: X, Y and Z:

		SALESREP_CUSTOMER	SALESREP_SALES	Access for
Customer A	Order 1	X	X	X
	Order 2	X	Z	X + Z
	Order 3	X	X	X
Customer B	Order 4	Y	Y	Y
	Order 5	Y	Z	Y + Z

Salesrep X may see Order 1, Order 2, Order 3 (because he is linked to the customer)

Salesrep Y may see Order 4 and Order 5 (because he is linked to the customer)

Salesrep Z may see Order 2 and Order 5 (because he is linked to the order)

Is this possible to set up security for this in Section Access?

I.e: can I Load 2 tables in Section Access, one referring the first dimension and the second referring to the second dimension? And will the 2 rules be added, or will the second overrule the first?

Like this:

section access;

LOAD * inline [

ACCESS, USERID, SALESREP_CUSTOMER,OMIT

USER,AD_DOMAIN\X,X,

USER,AD_DOMAIN\Y,Y,

USER,AD_DOMAIN\Z,Z,

];

LOAD * inline [

ACCESS, USERID, SALESREP_SALES,OMIT

USER,AD_DOMAIN\X,X,

USER,AD_DOMAIN\Y,Y,

USER,AD_DOMAIN\Z,Z,

];

regards,

Kristien

topic How to combine multiple criteria to set dynamic datareduction with section access in App Development

How to combine multiple criteria to set dynamic datareduction with section access