5 Replies Latest reply: May 9, 2014 4:58 AM by Tresesco B RSS

    Section Access help

    Derek Keeble

      Morning All

       

      Hopefully someone can help and highlight what I am doing wrong.

       

      Attached is a very simple file using section access, and I am trying to set U1 (User 1) has admin rights and can see all and U2 (User 2) can only see part of the the data as a user.

       

      However when I log in as U2 I get access denied (I am assuming it is because there are no matches as it allows access when strict Exclusion is unticked ?)

       

      Log in as U1 to see script, and can anyone see what I have done wrong ?

      I am sure it is something obvious but I am struggling to see it

        • Re: Section Access help
          Tresesco B

          Problem is in Capitalization (Upper Case) of the section access field. Try like:

          SECTION  Access;


          LOAD * INLINE [
              ACCESS, USERID, COMPANY_ID
              ADMIN, U1, Comp1
              ADMIN, U1, Comp2
              ADMIN, U1, Comp3
              ADMIN, U1, Comp7
              USER, U2, COMP1
              USER, U2, COMP2
          ];

           

          SECTION Application;

           

          Company_Data:
          LOAD * INLINE [
              COMPANY_ID, COMPANY_ NAME
              COMP2, Company1
              COMP2, Company2
              Comp3, Company3
              Comp7, Company7
          ];

           

          Exit Script;

           

          Note:

          After user login QlikView will attempt to copy the selections in

          fields in section access to any fields in section application with exactly the same field names (the field

          names must be written in UPPER CASE)

           

           

          Hence, ideally you should load your Section Application data using Upper() like:

           

          SECTION Application;

           

          Load

                    Upper(COMPANY_ID) as COMPANY_ID,

                    COMPANY_NAME;

           

          Company_Data:
          LOAD * INLINE [
              COMPANY_ID, COMPANY_ NAME
              Comp1, Company1
              Comp2, Company2
              Comp3, Company3
              Comp7, Company7
          ];

          • Re: Section Access help
            Amit Saini

            Hi Derek,

             

            Please see the attachment, this appliaction will help you to build Section Access concept. Below are the credentials to open the application.

             

            Username: admin

            Pass: admin

             

            Thanks,

            AS

            • Re: Section Access help
              Sunil Chauhan

              see the attched file

               

              take user ID as urs.....U1,U2

               

              hope this helps