Dear Qv Expert,
I was trying to implement the sheet level access, its working fine If i do a manual reload but if I reload it through QMC (publisher) then it wont work, I have cross check the NT User credential in my Source Document & User Document file. In both the place its showing me different user. My problem is with the User Document, after distribution it always shows the local user credential data & sheet accordingly, no matter which credential you are using on access point.
Local user has a Admin Rights with all sheet access.
Script:
Section Access;
LOAD ACCESS,
UPPER(NTNAME) as NTNAME,
UPPER([SUB REGION]) as Region,
UPPER(TaskRegion) as TaskRegion,
UPPER(SHIPPINGCOUNTRY) as ShippingCountry
FROM
[..\Qvds\Users-QlikView_Dev.xlsx]
(ooxml, embedded labels, table is [SECTION ACCESS]);
Section Application;
LOAD Upper(NTNAME) as NTNAME,
SH36,
SH39,
SH09,
SH28,
SH19,
SH25,
SH26,
SH18,
SH06,
SH37,
SH38,
SH11,
SH35,
SH20,
SH31,
SH32
FROM
[..\Qvds\Users-QlikView_Dev.xlsx]
(ooxml, embedded labels, table is [SHEET ACCESS]);
Sheet Level Condition:
e.g. = IF(SUM(SH26)>=1,1,0)
Document Setting:
Initial data reduction based on section access is checked
Prohibit Binary reload is checked
Admin Override security is checked
I have cross check the below thread for the same but couldn't resolve this issue.
Thread:
Section Access does not work after publisher reload
Can any one help me to resolve this.
Thanks & Regards,
Nirav Bhimani
