3 Replies Latest reply: Jun 15, 2015 9:57 AM by Henrik Matz Branched to a new discussion. RSS

    Sense Section Access

    Henrik Matz

      I don’t understand how to solved this case in Sense 1.1 with Section Access.

       

      The case is:
      I have one user called USA and this user must only se data where COUNTRY_CODE is US.
      Then I have a group of users called BI-ADMIN. Members of BI-ADMIN should not have any restrictions.
      In my app, I have 10 unique values of COUNTRY_CODE.
      USA is a user and BI-ADMIN is a Group in Active directory.

       

      When I try the script below, members of BI-ADMIN can only see data where COUNTRY_CODE is US. So the script remove the nine other countries. That is not what I want.
      Can anyone see why?

       

      SECTION ACCESS;
      LOAD * INLINE [
          ACCESS, NTNAME,   REDUCTION 
          USER, DOMAIN\BI-ADMIN,  
          USER, DOMAIN \USA, 1   
      ];

      SECTION APPLICATION;
      LOAD * INLINE [
          REDUCTION,  COUNTRY_CODE
          1  US
      ];