2 Replies Latest reply: Jul 6, 2017 11:19 AM by Christian Schmitz RSS

    Section Access, how to give * rights by default, if there are no red field loaded for specific user?

    Christian Schmitz

      Hi all,

       

      I am using following Section Access code, it works fine - but I dont have a clue, if a user is loaded in the QV Authentication Table which does not get a SEC_GROUP (that's my reducing field), how to give give him by default rights to see all (listed) regions with *? How should the script look like for this approach?

       

      Thanks for your help,

       

      Chris

       

       

      Section Access;

      [QV Authentication]:
      LOAD
      ACCESS,
      NTNAME,
      USER_GROUP
      FROM
      [$(QVDPath)sec_admins.qvd] (
      qvd)
      WHERE
      TRUE(); //disable optimized load



      Concatenate ([QV Authentication])
      LOAD ACCESS,
      NTNAME,
      USER_GROUP
      FROM
      [$(QVDPath)sec_user_groups.qvd] (
      qvd)
      WHERE

        WildMatch(USER_GROUP,
      'QV_REPORT1',
      'QV_REPORT2');



      // ----------------------------------------
      // Security Group from Teamsite
      // ----------------------------------------
      SEC_GROUP:
      Left Join ([QV Authentication])
      LOAD

      upper(trim(ID)) as NTNAME,
      Sec   as SEC_GROUP
      FROM
      [$(TeamSite_Shared_Path)Test Users  Reports.xlsx]

      (ooxml, embedded labels, header is 5 lines, table is Report);


      Concatenate ([QV Authentication]) Load  * INLINE [
      ACCESS, NTNAME, USER_GROUP, SEC_GROUP
      USER, NELCH, QV_REPORT1, *
      USER, NELCH, QV_REPORT2, *]
      ;

      Section Application;
      Star is *; // Required if wildcard characters are used in Section Application
      SA_REDUCTION:
      LOAD * INLINE [
      SEC_GROUP, key_sec
      ASIA, ASIA
      LATAM, LAT AMERICA
      AFRICA, AFRICA
      OTHER, other
        ]
      ;