11 Replies Latest reply: Oct 30, 2013 11:24 AM by Deepak Tibhe RSS

    Authorization in qlikview

    Deepak Tibhe

       

      Hello Expert,

       

      Can you please help me how to perform authorization in qlikview.

       

      Below  is my requirement.

       

       

      Authorization:

       

      Case: There is one All India Head  Mr. Ram who can view the Records
      at All India Level (North, South, East and West)

       

       

      4 Regional Managers reporting to him can see data for their respective
      Region.

       

       

      1. Amità Regional Manager for East
      2. Sumità Regional Manager for West
      3. Suhasà Regional Manager for North
      4. Nitinà Regional Manager for South

       

       

       

      Can you please help us out how toachieve end result in this.

       

       

       

      Thanks,

        • Re: Authorization in qlikview

          Hi Deepak,

           

          First create a section accession where to set the rights:

          Section Access;

           

          LOAD

           

           

          * INLINE

          [
          ACCESS, USERID, PASSWORD, REGION

          ADMIN, ADMIN, ADMIN123, *

          USER, HEAD,HEAD123,*
          USER, A, USER123, EAST
          USER, B, USER456, WEST
          USER, C, USER789, NORTH

          USER, D, USER345, SOUTH
          ]
          ;

          If a user may see severel regions, just repeat the line but with another REGION.

          Take care also that the fields MUST be UPPERCASE

          Take care also that the * does NOT mean anything, but everything listed below (here it is OK because you have the 4 regions)

           

          SECTION Application;

          Here you will your data. I assume you have a REGION field to do the link with the rights.

           

          If you need to intersect (REGION / PRODUCT) you will need to create a composite key.

          Fabrice

          • Re: Authorization in qlikview
            Deepak Tibhe

            Hello Expert,

             

            When I have created script as per mentioned above right now it is showing data only for west region.

            Though I have removed the hidden script the problem still occurs.I am only able to see data for west region.

             

            Can you please suggest on this.

             

             

             

            Thanks,

            • Re: Authorization in qlikview
              Pradip Sen

              Hi Deepak,

               

              You can use either Section Access and Section Application feature in QlikView or impliment this through QlikView Publisher.

               

              Hope it will help.

                • Re: Authorization in qlikview
                  Deepak Tibhe

                  Please find below code for section access.

                  It is working fine as it is.

                  Section Access;


                  LOAD * INLINE



                  [

                  ACCESS, USERID, PASSWORD



                  ADMIN, ADMIN, ADMIN123



                  USER, HEAD,HEAD123

                  USER, A, USER123

                  ]
                  ;

                   

                   

                   

                  Section Application;




                  LOAD * INLINE



                  [

                  USERID, Region



                  ADMIN,North

                  ADMIN,South

                  ADMIN,East

                  ADMIN,West

                  HEAD,North

                  A,South

                  ]
                  ;

                   

                   

                  But as per requirement I need to put all my user id pw and corresponding regions(Code for section access and section application) in another excel file.But after putting  access ,userid and password in excel and after calling the same it is not working can you please suggest on this.

                   

                   

                  Thanks in advance.

                   

                   

                  Regards,

                  Deepak

                • Re: Authorization in qlikview
                  Deepak Tibhe

                  Please find below code for section access.

                  It is working fine as it is.

                  Section Access;


                  LOAD * INLINE



                  [

                  ACCESS, USERID, PASSWORD



                  ADMIN, ADMIN, ADMIN123



                  USER, HEAD,HEAD123

                  USER, A, USER123

                  ]
                  ;

                   

                   

                   

                  Section Application;




                  LOAD * INLINE



                  [

                  USERID, Region



                  ADMIN,North

                  ADMIN,South

                  ADMIN,East

                  ADMIN,West

                  HEAD,North

                  A,South

                  ]
                  ;

                   

                   

                  But as per requirement I need to put all my user id pw and corresponding regions(Code for section access and section application) in another excel file.But after putting  access ,userid and password in excel and after calling the same it is not working can you please suggest on this.

                   

                   

                  Thanks in advance.

                   

                   

                  Regards,

                  Deepak


                  • Re: Authorization in qlikview
                    Deepak Tibhe

                    Please find below code for section access.

                    It is working fine as it is.

                    Section Access;


                    LOAD * INLINE



                    [

                    ACCESS, USERID, PASSWORD



                    ADMIN, ADMIN, ADMIN123



                    USER, HEAD,HEAD123

                    USER, A, USER123

                    ]
                    ;

                     

                     

                     

                    Section Application;




                    LOAD * INLINE



                    [

                    USERID, Region



                    ADMIN,North

                    ADMIN,South

                    ADMIN,East

                    ADMIN,West

                    HEAD,North

                    A,South

                    ]
                    ;

                     

                     

                    But as per requirement I need to put all my user id pw and corresponding regions(Code for section access and section application) in another excel file.But after putting  access ,userid and password in excel and after calling the same it is not working can you please suggest on this.

                     

                     

                    Thanks in advance.

                     

                     

                    Regards,

                    Deepak