Trouble implementing Section Access

Sat, 20 Feb 2010 00:43:49 GMT

Hi all -

I'm having a bit of trouble getting Section Access to properly reduce the data on initial load. I have the "Initial Data Reduction Based on Section Access" box checked, and "Strict Exclusion" also checked. I'm using QV 9.0 and only opening the document on my local machine using a Developer License, not from the server. Here's what a portion of my code looks like:


section access;
LOAD * INLINE [
 ACCESS, USERID
 ADMIN, ADMIN
 ADMIN, JohnDoe
 USER, JaneDoe
 ];

section application;

[User Exclusion]:
SQL SELECT
 E.EmployeeName [USERID],
 E.employee_id
FROM
 EMPLOYEES E;

If I attempt to open the QVW as JaneDoe, it won't allow me to open it, as expected, but if I open it as "JohnDoe," I can see information related to other Employees when I should only be able to information related to one.

Trouble implementing Section Access

disqr_rm — Sat, 20 Feb 2010 04:14:28 GMT

Try converting USERID to Upper Case using upper() function.

topic Trouble implementing Section Access in QlikView

Trouble implementing Section Access

Trouble implementing Section Access