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
