I'm playing around with inline section access to test out functionality. I'm having trouble logging in with USERs. ADMINs just fine.
here is my code:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMINPWD
USER, BOB, BOBPWD
];
Section Application;
LOAD * INLINE [
USERID, Representative
BOB, BOB
];
When opening the document using the admin user, it opens just fine. If I try to use a USER userid, I get "Access denied to this Qlikview document"
Anyone know what I'm doing wrong? I have reloaded after adding. I have "Initial Data Redectuion Based on Section Access" and "Strict Exclusion" checked.
You need to make the Reduction field and Section Access Fields in UPPER CASE. Although, if you are using INLINE Load then QlikView implicitly converts them to UPPER CASE. But if you are loading from Excel / Databases / Other Sources then you need to make the field values in UPPER CASE.
Please be very careful using the '*' (Wildcard) because it doesn't mean all the values in the Actual Field. It means distinct values you have specified in Section Access Table. Unless you have specified all the distinct values within Section Access.
Please read this thread for detailed information and example:
Yep, this is what I was doing. I thought only the field name had to be upper, not the actual values. Thank you for the help. Sometimes I feel like an idiot.
You are welcome Nigel. Also, remember the reduction field name can be in mixed or lower case but the field values should be in upper case. This applies to the Section Access Reduction Field & also original Field Values. I had provided detailed explanation in the above link with sample script.
