2 Replies Latest reply: Aug 3, 2017 3:18 AM by Nina Zhao RSS

    Qs - Section Access - Access Denied

    Alvaro Garcia

      Hello everyone,

       

      Trying to use Section Access in my project i found a problem what i can't solve alone.

       

      When i apply Section Access ( Doesn't matters if is to a USER or ADMIN ), after recharge the app, the user recieve an "Access Denied" to the App.

       

      I follow all of tutorials in QS Wiki, and my own developer book but still show me this message.

       

      Actually i use section access from Excel with this script:

       

      section access;
      DATA:
      LOAD
          "ACCESS",
          "USERID",
          "GROUP",
          "ORGANIZACIÓN VENTA",
          "ZONA DE VENTA",
          "TIPO MATERIAL",
          "SUBTIPO MATERIAL",
          "NOMBRE JV",
          "VERSIÓN FCST",
          "RAMO TIPO"
      FROM [lib://DEV_APPS_SALES_CFG/SECTION_ACCESS_TABLE.xlsx]
      (ooxml, embedded labels, table is Hoja1);
      
      
      Section Application;
      

       

      and inside the excel i have :

       

      section access.PNG

       

      The version of my platform is:

      version de qlik sense.png

       

      My questions are:

       

      • I place this script at the total begining of the app. Does i need to put this script after something ?

       

      • I need enable some configuration in QMC to use Section Access ?

       

      • I need place all field than i have in my data model to use Section Access ?
        • Re: Qs - Section Access - Access Denied
          Tim Driller

          Hi Alvaro,

           

          1) there is no ADMIN row in your Section Access Table. You need at least one.

          2) try upper(USER_ID) to get everything in Uppercase

           

          to your questions:

           

          • I place this script at the total begining of the app. Does i need to put this script after something ?
            • thats ok. In Qlikview there was a Hidden Script where you need to put your Section Access code. I dont know if that is the case for Sense too.

           

          • I need enable some configuration in QMC to use Section Access ?
            • Your Script should work.if your usernames are AD names, make sure that the username is used with domain prefix and this domain is added as "User directory connector" in QMC.

           

          regards

          tim

          • Re: Qs - Section Access - Access Denied
            Nina Zhao

            Hi Alvaro,

             

            just change USERID to Upper(USERID) as USERID, in Section Access, the value of USERID need be upper case.

             

            Regards,

            Nina