How to combine multiple criteria to set dynamic datareduction with section access
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:
X + 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?