0 Replies Latest reply: Aug 30, 2011 10:13 AM by Joachim Boivie RSS

    Problem with section access

    Joachim Boivie

      Hi,

       

      i was running section access on QV 10 SR1 and upgraded to SR3 (and also a new environment). Now it has stopped working.

       

      I do the following, (for reducing countrycode for specific users)

       

      Section Access;

      LOAD * INLINE [

          ACCESS, NTNAME, NTDOMAINSID, COUNTRYCODE

          ADMIN, mydomain\qlikview.admin, S-X-Y-ZZ-XXXX-ZZZZZZ-YYYYYYYYYYYY-XXXXXXXXXXXXX,

      ];

      Concatenate

      LOAD

          UPPER([ACCESS]) AS ACCESS,

          UPPER(NTNAME) AS NTNAME,

          UPPER(S-X-Y-ZZ-XXXX-ZZZZZZ-YYYYYYYYYYYY-XXXXXXXXXXXXX') as NTDOMAINSID,

          UPPER(COUNTRYCODE) AS COUNTRYCODE

      FROM

      [..\1. Data source\SectionAccess.xls]

      (biff, embedded labels, table is [sectionaccess$]);

       

      But as I wrote above, this code is not working. If I trying to open the document as a user from the xls file I will be denied access.

       

      Any ideas?