0 Replies Latest reply: Oct 13, 2017 8:04 AM by Kristien Reynaert RSS

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

    Kristien Reynaert

      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