11 Replies Latest reply: Nov 1, 2017 7:09 AM by Sunny Talwar RSS

    Section Access change of roles from ADMIN to USER

    Sunny Talwar

      Hello All -

       

      I have a weird section access question, which I hope someone can share some light on. I am working on a dashboard where I wanted to test section access for a user. So, I decided that I will test it under my name (as USER) and then revert back to ADMIN.

       

      I ran the script with this

       

      Section Access;

      LOAD ACCESS,

      Upper(NTNAME) as NTNAME,

      Text(SECTION_ACCESS_FIELD) as SECTION_ACCESS_FIELD;

      LOAD * INLINE [

          ACCESS, NTNAME, SECTION_ACCESS_FIELD

          USER, domain\talwar, ABC

          ADMIN, domain\qlikview, *

      ];

      Section Application;

       

      Running the above worked beautifully and it just gave me access to rows related to ABC.

       

      Once this was done, I wanted to go back to my ADMIN Role.... but it just wouldn't go back to my normal view.

       

      Section Access;

      LOAD ACCESS,

      Upper(NTNAME) as NTNAME,

      Text(SECTION_ACCESS_FIELD) as SECTION_ACCESS_FIELD;

      LOAD * INLINE [

          ACCESS, NTNAME, SECTION_ACCESS_FIELD

          ADMIN, domain\talwar, *

          ADMIN, domain\qlikview, *

      ];

      Section Application;

       

      I have tried to remove section access completely and then bring it back. I have also, tried to remove 'Initial Data Reduction Based on Section Access' and 'Strict Exclusion'. Nothing seem to have worked.

       

      Any ideas why am I seeing this behavior? Is this a bug or by design?

       

      Thanks,

      Sunny