1 Reply Latest reply: Feb 23, 2016 11:52 AM by Gysbert Wassenaar RSS

    Why doesn't this load? (Qlik Sense Section access)

    Wouter Trappers

      Why doesn't this load in Qlik Sense server (it loads withing 20" when the section access and section application are commented)

       

      Section access;

       

      Security:

      load *;

      SQL SELECT distinct

            'USER' as 'ACCESS',

             upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

            'DOMAIN1\'+ upper(ltrim(rtrim([user_id]))) as USERID

      FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

            union all

      SELECT distinct

            'USER' as 'ACCESS',

             upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

            'DOMAIN2\'+ upper(ltrim(rtrim([user_id]))) as USERID

      FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

                 where isnumeric(substring([user_id],5,100))=0 and

               substring([user_id],5,100) like '%.%';

      Concatenate

      LOAD * INLINE [

      ACCESS, USERID, REDUCTION

      USER, INTERNAL\SA_SCHEDULER,         *

      ];

       

      Section application;  

       

      Securityapp:

      load *;

      SQL SELECT

             [KEY_AD_GROUP] as REDUCTION,

             key_business+'_'+key_market as BusinessMarket

      FROM [WH_ID_EMEA].[cfg].[AD_Access];

        • Re: Why doesn't this load? (Qlik Sense Section access)
          Gysbert Wassenaar

          Have you tried it this way?

           

          Security:

          SQL SELECT distinct

                'USER' as 'ACCESS',

                 upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

                'DOMAIN1\'+ upper(ltrim(rtrim([user_id]))) as USERID

          FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

                union all

          SELECT distinct

                'USER' as 'ACCESS',

                 upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

                'DOMAIN2\'+ upper(ltrim(rtrim([user_id]))) as USERID

          FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

                     where isnumeric(substring([user_id],5,100))=0 and

                   substring([user_id],5,100) like '%.%';

           

          CONCATENATE (Security)

           

          LOAD * INLINE [

          ACCESS, USERID, REDUCTION

          USER, INTERNAL\SA_SCHEDULER,         *

          ];

           

          Section access;

          LOAD * RESIDENT Security;

           

          Section Application;

          ...etc