Section Access reduction not working: QMC and Access Point
I'm having a problem with implementing field reduction with section access, to be viewed via Qlikview Access Point. I've created a hidden script tab with the criteria filled in below; using NT names (this is required) and reduction on the DEPARTMENT field:
Star is *;
LOAD * INLINE [
ACCESS, NTNAME, DEPARTMENT
ADMIN, DOMAIN\QMC, *
ADMIN, DOMAIN\ME, *
USER, DOMAIN\USER1, CORPORATEFINANCE
USER, DOMAIN\USER1, NA
USER, DOMAIN\USER2, GLOBALMARKETS
USER, DOMAIN\USER2, NA
All of the values in the 'DEPARTMENT' field are in uppercase, and when I test this locally (commenting out the section access line and creating a listbox for NTNAME to select each user) then USER1 will only show 'CORPORATEFINANCE' and 'NA' records and USER2 will only show 'GLOBALMARKETS and 'NA' records, which is what I'm looking for. However, when I load the file through the Qlikview Management Console, and then ask USER1 to load the document on the web via Qlikview Access Point, that user can see all departments rather than just 'CORPORATEFINANCE' records, which is not what I'm looking for.
I've tried listing the field names that I want to match with no quotes, single quotes and double quotes but the section access reduction just doesn't seem to work through qlikview access point. Does anyone know what I may be doing wrong?
Thanks for the reply - I have both of those options set. It just seems to be ignoring it completely. It's perfectly fine when I load the document locally and can see changes, for example, when I check and uncheck boxes on the security tab.
Hi Avinash - Perhaps I have missed something regarding reduction. After Section Application, I'm just loading the QVD files, which contains the "department" field. Is there something I should be adding in between section application and loading QVDs?