2 Replies Latest reply: Feb 4, 2013 9:42 AM by Peter Delvito RSS

    Section Access, Reduction Matrix Accesspoint error

    Peter Delvito

      Hello,

       

      I am using NT based section access with the reduction matrix. I am hiding one sheet which works correctly in the client version. When the application is moved to the accesspoint only users with associated to group 1 are able to get into the document. They are asked to put in their username and password, when they shouldn't need to. Has anyone else had this issue? Please help

       

      Here is the Section access script

      GetAE:

      LOAD distinct

      UPPER(Salesrep) as SALESREP,

      UPPER(Salesregion) as SALESREGION

      FROM



      (
      ooxml, embedded labels, table is Sheet1);



      star is *;

      Section Access;



      Load

      'ADMIN'
      as ACCESS,

      '\qlikview'
      as NTNAME,

       
      SALESREP,

       
      SALESREGION

      Resident GetAE;



      Concatenate



      LOAD ACCESS,

          
      DOMAIN & UID as NTNAME,

          
      UPPER(SALESREP) as SALESREP,

          
      UPPER(SALESREGION) as SALESREGION,

          
      GROUP

      FROM



      (
      biff, embedded labels, table is AE$);



      Section Application;

      star is *;





      LOAD GROUP,

          
      SHEET1

      FROM



      (
      biff, embedded labels, table is GROUP$);





      Drop Table GetAE;