Within this table I have got data like so (using the fields above):
ADMIN, *, *, JOE BLOGGS, *, *, *, TEST REPORT
USER, *, *, JOHN SMITH, *, *, *, TEST REPORT
USER, *, *, JOHN DOE, *, SALES, 10, TEST REPORT
USER, *, *, LISA JONES, *, ACCOUNTS, 11, TEST REPORT
Within the qlik report in Document Properties I have checked 'Initial Data Reduction Based On Section Access' and 'Strict Exclusion' and 'Prohibit Binary Load'.
In the Section Access section in Edit Script I need to link 'ACCESS_DEPARTMENT' from the table above to a field called Company_Department that is currently displayed in the report.
For example I would want JOE BLOGGS and JOHN SMITH to be able to access the report and view all departments as they have an asterisk in the ACCESS_DEPARTMENT and ACCESS_DEPTCODE fields. However I would then want JOHN DOE to only be able to access the SALES department and for LISA JONES to only be able to access the ACCOUNTS department.
Does that make sense?
I think my issue is with the Load bit of Section Access. Does this look right? Also I don't want anyone to be prompted for a UserId or Password.
Load ACCESS,USERID,NTNAME,SERIAL,UPPER(ACCESS_DEPARTMENT) as Company_Department,ACCESS_DEPTCODE;
Also NTNAME always uses the form DIRECTORY\USERNAME where DIRECTORY is your security directory as defined in the QMC > System > Setup > Directory Service Connectors or the AD if you are using NTFS authorization
Regarding the '*' in the section access table, which means he will not have access to all the values present in the model under that field.
ADMIN, JOE BLOGGS, *
USER, JOHN SMITH, *,
USER, JOHN DOE, SALES,
USER, LISA JONES, ACCOUNTS
USER, JOHN ,
JOE BLOGGS, JOHN SMITH will have access to company department (SALES,ACCOUNTS) but not all the company departments.
JOHN DOE will have access to only SALES dept.
LISA JONES will have access to only ACCOUNTS
But the last JOHN will have access to all the values present under the COMPANY_DEPARTMENT field.
If I want people to access ALL departments what do I need to have in the COMPANY_DEPARTMENT field in the table? Is it a *, a NULL or leave it blank?
From what I'm understanding if the users have an asterisk * in this field then they can only see the departments that have been added to this table (i.e. SALES and ACCOUNTS) but if another Department has not yet been added to this table such as I.T. then they won't be able to see any data for the I.T. department. Is that correct?