Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks everyone, all your suggestions worked. The final issue was related to me not listing all possible values for at least one user.
Awesome explanation.... thanks mbaeyens for further expanding on this.