13 Replies Latest reply: Mar 3, 2014 7:10 AM by Sudhakar Siram RSS

    Login issue

    Sudhakar Siram

      Hi ,

      I have developed one dashboard with Section access. Am able to access the application with my id in server, once published the same app I am getting don't have permission error.

       

      I have an  license and  configured my id in the section script also.

       

      Kindly help on this issue.

       

      thanks in Advance,

       

      Regards,

      sudhakar

        • Re: Login issue
          NAGA CHIRANJEEVI THOTA

          Hi,

           

          Are you able to access the same application from access point if you remove section access code ?

          • Re: Login issue
            Peter Cammaert

            You must be using the NTNAME field in your section access table. Did you enter your credentials as domainname\username ?

             

            Peter

            • Re: Login issue
              Karthikeyan Subramaniam

              Sudhakar,

               

              Give admin rights to the service account (Qlikview service account) in your section access table. Run the task and see if your access is permitted.

               

              Regards,

              Karthi

              • Re: Login issue
                neetha P

                Hi Sudhakar,

                 

                Can you post sample script.

                  • Re: Login issue
                    Sudhakar Siram

                    Please find the below sample script. which I have implemented

                     

                    Section Access;
                    LOAD * INLINE [

                        ACCESS, NTNAME, %SBU, %LOB, %REGION
                        ADMIN, Domain\zzzz,ALL,ALL,ALL
                        ADMIN, Domain\yyyy,ALL,ALL,ALL
                        ADMIN,Domain\XXXX,ALL,ALL,ALL
                    ]
                    ;
                    Section Application;

                    LOAD * INLINE [
                        SBU, %SBU
                        AA, ALL_AA
                        Others, ALL_OTHERS
                        GM, ALL_GM
                        Go., ALL_GO
                        HL, ALL_HL
                        EN, ALL_EN
                    ]
                    ;
                    LOAD * INLINE [

                        LOB, %LOB

                        A, ALL_A

                        B, ALL_B

                        C, ALL_C

                        D, ALL_D

                        E, ALL_E

                        F, ALL_F



                    ]
                    ;


                    LOAD * INLINE [

                        Region, %REGION

                        West, ALL_WEST

                        South1, ALL_SOUTH1

                        Gulf, ALL_GULF

                    ]
                    ;


                      • Re: Login issue
                        NAGA CHIRANJEEVI THOTA

                        remove % from section access columns.it did not work for me in our application

                        • Re: Login issue
                          Peter Cammaert

                          Also, the 'ALL' value in your three section access fields doesn't link to anything because it is a distinct but meaningless value to QlikView. Replace it with a *, and put the following statement before your section access LOAD statement:

                           

                          STAR IS *;

                           

                          Keep in mind also that if you are defined as ADMIN in section access, you will always be able to open a QVW document in desktop because the data reduction rules are partially switched off. In the AccessPoint however, this nice trick won't work and you will be treated as any other USER.

                           

                          Best,

                           

                          Peter

                          • Re: Login issue
                            neetha P

                            HI Sudhakar,

                             

                            Replace All with * and use STAR IS *;

                            As per my knowledge even * includes only values in Section access code and there are no values other then *  in access section.

                             

                            For Ex:

                             

                            Section Access;

                            LOAD * INLINE [

                            ACCESS, USERID, PASSWORD, REGION

                            ADMIN, ADMIN, ADMIN,

                            USER, USER1, U1, AFRICA

                            USER, USER2, U2, AMERICA

                            USER, USER3, U3, ASIA

                            USER, USER4, U4, EUROPE

                            USER, USER5, U4, AMERICA

                            USER, USER5, U5, *

                            ];

                            Section Application;

                            SALES:

                            LOAD * INLINE [

                            REGION, PROFIT

                            AFRICA, 1000

                            AMERICA, 2000

                            ASIA, 3000

                            EUROPE, 4000

                            OCEANIA, 5000

                            ];

                             

                            USER5 will be able to see all regions listed in the reduction field REGION except for

                            1. OCEANIA.

                            Even if USER5 has “*“ for the REGION reduction field, star means “all listed values”

                            not all values for the field. Since no USER has OCEANIA listed for the REGION field,

                            USER5 will not have access to the values for OCEANIA.

                            If we want USER5 to see OCEANIA as well, we need to add an extra line in our section

                            access solution

                            USER, USER5, U5, OCEANIA

                             

                            Hope this helps.