12 Replies Latest reply: Dec 3, 2015 10:38 AM by Andrew Whitfield RSS

    Section Access not working from Access Point

    Umer Ikhlas

      Hi fellow members,

      Hope you all are good.

       

      I am facing a problem with the authorization of security (data reduction) where I have only QlikView Server (No publisher).

       

      I am using section access with NTNAME, ACCESS, and Fields I want to reduce the data from, I have used everything in upper case (FIELDS as well as VALUES in it), checked the "initial data reduction....." in document properties - opening tab.

       

      After reload, When I open it from QlikView Desktop it works as it should (means reduction applied properly and section access works fine), but when I access the same document from access point it says "Access denied for the user".

       

      Any help would be highly appreciated as it is URGENT and IMPORTANT.

       

      Thanks in advance

      UI

        • Re: Section Access not working from Access Point
          Mark Little

          Hi,

           

          How is it applied?

          When you are accessing from desktop are you saving coming out and back in?

          When using access point are you going directly from your machine or remote on server?

          Long shot on the problem, but you given the service account admin right in the section Access?

           

          Mark

            • Re: Section Access not working from Access Point
              Umer Ikhlas

              How is it applied?

               

              I have to reduce the data on three fields user wise i.e. Deposit_Group (Table: Dep), Region (Table: GeoDist) and Cluster (Table: GeoDist)

               

              I have done the following for Section Access application.

               

              First I made three resident link tables to have values and column names in upper case and to avoid the synthetic and circular references since two fields are coming from one table (GeoDist) that is the reason I have made link tables and not directly put the data model fields in section access.

               

              PortfolioLink:

              LOAD Deposit_Group,

                   Upper(Deposit_Group) as DEPOSIT_GROUP_LINK

              Resident

              Dep;

               

              RegionLink:

              LOAD Region,

                   Upper(Region) as REGION_LINK

              Resident

              GeoDist;

               

              ClusterLink:

              LOAD Cluster,

                   Upper(Cluster) as CLUSTER_LINK

              Resident

              GeoDist;

               

              Section Access;

               

              LOAD

                   ACCESS,

                   NTNAME,

                   DEPOSIT_GROUP_LINK,

                   CLUSTER_LINK,

                   REGION_LINK

              FROM

              [...\QV Users List.xlsx]

              (ooxml, embedded labels, table is [User Rights]);

               

              Section Application;

              • Re: Section Access not working from Access Point
                Umer Ikhlas

                When you are accessing from desktop are you saving coming out and back in?

                Yes after reload I saved the application and the re-open it to verify the section access functionality. Works fine on desktop client.

                 

                 

                When using access point are you going directly from your machine or remote on server?

                In both cases it says "access denied" while accessing from access point, Checked!

                 

                 

                Long shot on the problem, but you given the service account admin right in the section Access?

                Yes, I have given the NTNAME and ACCESS as ADMIN for Service Account.

              • Re: Section Access not working from Access Point

                Hi Umer,

                 

                  Could you check whether the user has data in dataset.

                 

                One more work around you can do is go to Document setting -> Opening Tab -> uncheck strict exclusion (now it should open for user even if there is no data in dataset).

                • Re: Section Access not working from Access Point
                  Tharindu Ranathunge

                  Hi,

                  Did you give that access permissions (Folder level) to the Domain user accounts??? And while opening through desktop what user names you are using?

                  Check who is the user when you are accessing the document through Desktop version and then check the credentials you are entering through Access point whether they are tallying or not.

                   

                  BR,

                  Dinu1

                  • Re: Section Access not working from Access Point
                    Prashant Sangle

                    Hi,

                     

                    Test your section Access by following below steps:

                     

                    1: Load Dashboard without section access. save and check that are you able to access it on Access Point.

                    2: If Yes, Then Access point -> On Dashboard -> right Click -> Add Object -> Add Text Object -> write expression

                    =OSuser()

                    3: Copy that OSUser name and add it in section access under NTNAME Column and then again reload your dashboard and check are you still able to access it on Access Point.

                     

                    If you get any error. take screen shot of it and attached here so that we can help you more better ways.

                     

                    Regards

                    • Re: Section Access not working from Access Point
                      Umer Ikhlas

                      Hi fellow members,

                       

                      Some progress in the work!

                       

                      I have identified an issue. & it seems it has solved my problem for now.

                       

                      In excel sheet where I defined Section Access fields, for the field I want to reduce (apply section access) i.e. DEPOSIT_GROUP_LINK, CLUSTER_LINK and REGION_LINK in my case. I have placed 'ALL' for all access and value for reduction. Access denied error is coming only if it finds ALL for the user. For that I have unchecked the 'strict exclusion' and that solved my problem.

                      But this is not the proper solution, if by mistake someone enter value other than field value because of not 'strict exclusion' it will show full dashboard.

                      Note: I have also checked Star is *; but it seems I am unable to use it.

                      Do anyone have any idea where to place Star is *; ? Before Section Access? Under Section Access Script or after?

                      I have tried all, but didn't get the desired result.

                      • Re: Section Access not working from Access Point
                        Andrew Whitfield

                        Hi Umer,

                         

                         

                        check out the attached document.

                         

                        HTH

                         

                        Andy