1 Reply Latest reply: Jul 14, 2015 7:41 AM by Arthur Molino RSS

    SECTION ACCESS WITH AD GROUPS NOT WORKING IN SENSE

    John Ramirez

      Hi All,

       

      The Problem --> Qlik Sense section access is working with USERID, NTNAME, but not ADGROUPS.

       

      Currently we use LDAP to grab users from Active Directory.

       

      EXAMPLE:

      ADGROUP SYNTAX --> EXAMPLE1: Call.Center.MGMT

                                            EXAMPLE2: Sales.Account.Team

       

      NTNAME-->  EXAMPLE1: JRAM

                          EXAMPLE2: SREE

       

      USERID SYNTAX --> EXAMPLE1: JRAM

                                        EXAMPLE2: SREE

       

      JRAM is a part of Call.Center.MGMT

      SREE is a part of Sales.Account.Team

       

      DOMAIN --> QLIKWORKS

       

      OSUSER() --> QLIKWORKS\JRAM

       

      HERE IS WHAT WORKS AND WHAT DOESN'T WORK:

       

      USERID WORKS:

      SECTION ACCESS;

      LOAD * INLINE [

          ACCESS, USERID, AREAID, REGIONID, TERRITORYID

      ADMIN, QVSENSE

      USER, INTERNAL\SA_SCHEDULER

      USER, DOMAIN\USERID

      USER, DOMAIN\USERID, 01

      USER, DOMAIN\USERID, 02, P111111

      USER, DOMAIN\USERID, 08, K111111

      ];

      SECTION APPLICATION;


      NTNAME WORKS:

      SECTION ACCESS;

      LOAD * INLINE [

          ACCESS, NTNAME, AREAID, REGIONID, TERRITORYID

      ADMIN, QVSENSE

      USER, INTERNAL\SA_SCHEDULER

      USER, DOMAIN\NTNAME

      USER, DOMAIN\NTNAME, 01

      USER, DOMAIN\NTNAME, 02, P111111

      USER, DOMAIN\NTNAME, 08, K111111

      ];

      SECTION APPLICATION;

       

      ADGROUP DOES NOT WORK:

      SECTION ACCESS;

      LOAD * INLINE [

          ACCESS, NTNAME, AREAID, REGIONID, TERRITORYID

      ADMIN, QVSENSE

      USER, INTERNAL\SA_SCHEDULER

      USER, DOMAIN\ADGROUP

      USER, DOMAIN\ADGROUP, 01

      USER, DOMAIN\ADGROUP, 02, P111111

      USER, DOMAIN\ADGROUP, 08, K111111

      ];

      SECTION APPLICATION;


      Any Ideas?


      I have tried UPPER(NTNAME), and also doing all caps on the ADGROUP field without the upper function.


      THANKS!