2 Replies Latest reply: Aug 30, 2016 9:56 PM by munirathnam p RSS

    Section access Issue

    munirathnam p

      Hi All,

       

      PFA

      i have implemented section access in qlik server.

      it applying security but the issue is along with the region on which i applied security remaining also coming as grayed values in the filter.

       

      can anyone help on this.

       

      Thanks,

      Muni.

        • Re: Section access Issue
          Vineeth Pujari

          please post your section access script

            • Re: Section access Issue
              munirathnam p

              Hi Vineeth,

               

              Thsnk u for your response.

               

              i am using Excel.

              PFB code

               

               

              Security:

               

              LOAD

                  "ACCESS",

                  "USERID",

                  "USER NAME",

                  Q01A_BUSINESS_REGION_NAME,

                  Q01B_BUSINESS_REGION_NAME,

                  Q01C_BUSINESS_REGION_NAME,

                  Q01V_BUSINESS_REGION_NAME,

                  Q02_BUSINESS_REGION_NAME,

                  Q03_BUSINESS_REGION_NAME,

                  Q05_BUSINESS_REGION_NAME,

                  Q06_BUSINESS_REGION_NAME,

                  Q061_BUSINESS_REGION_NAME,

                  Q08_BUSINESS_REGION,

                  Q09_BUSINESS_REGION,

                  Q10_BUSINESS_REGION_NAME,

                  Q11_GLOBAL_REGION,

                  Q14_BUSINESS_REGION_NAME,

                  Q15_BUSINESS_REGION_NAME,

                  Q16_BUSINESS_REGION_NAME,

                  Q21_REGION

              FROM [lib://Files/EP_EMEA_SECTION_ACCESS.xlsx]

              (ooxml, embedded labels, table is SectionAccess_Admin);

              Concatenate(Security)

              LOAD

                  "ACCESS",

                  "USERID",

                  "USER NAME",

                  Q01A_BUSINESS_REGION_NAME,

                  Q01B_BUSINESS_REGION_NAME,

                  Q01C_BUSINESS_REGION_NAME,

                  Q01V_BUSINESS_REGION_NAME,

                  Q02_BUSINESS_REGION_NAME,

                  Q03_BUSINESS_REGION_NAME,

                  Q05_BUSINESS_REGION_NAME,

                  Q06_BUSINESS_REGION_NAME,

                  Q061_BUSINESS_REGION_NAME,

                  Q08_BUSINESS_REGION,

                  Q09_BUSINESS_REGION,

                  Q10_BUSINESS_REGION_NAME,

                  Q11_GLOBAL_REGION,

                  Q14_BUSINESS_REGION_NAME,

                  Q15_BUSINESS_REGION_NAME,

                  Q16_BUSINESS_REGION_NAME,

                  Q21_REGION

              FROM [lib://Files/EP_EMEA_SECTION_ACCESS.xlsx]

              (ooxml, embedded labels, table is SectionAccess_User);

               

               

              Section Access;

              LOAD

                  "ACCESS",

                  "USERID",

                  "USER NAME",

                  Q01A_BUSINESS_REGION_NAME,

                  Q01B_BUSINESS_REGION_NAME,

                  Q01C_BUSINESS_REGION_NAME,

                  Q01V_BUSINESS_REGION_NAME,

                  Q02_BUSINESS_REGION_NAME,

                  Q03_BUSINESS_REGION_NAME,

                  Q05_BUSINESS_REGION_NAME,

                  Q06_BUSINESS_REGION_NAME,

                  Q061_BUSINESS_REGION_NAME,

                  Q08_BUSINESS_REGION,

                  Q09_BUSINESS_REGION,

                  Q10_BUSINESS_REGION_NAME,

                  Q11_GLOBAL_REGION,

                  Q14_BUSINESS_REGION_NAME,

                  Q15_BUSINESS_REGION_NAME,

                  Q16_BUSINESS_REGION_NAME,

                  Q21_REGION

              Resident Security;

              Section Application;

              Star is '*';

              //drop Table Security;

               

               

              Thanks,

              Muni