I am new to Section Access and I am having some difficulty getting data reduction to load properly.
I have the following script:
Section access;
Load * Inline [
ACCESS, USERID, EmployeeIdOriginal
ADMIN, x\MP11111111, 18190
];
section application;
LIB CONNECT TO 'BI';
LOAD
RoleName,
EmployeeIdOriginal,
RoleSystemCode;
SQL SELECT RoleName,
EmployeeIdOriginal,
RoleSystemCode
FROM "BI".BI.RoleView;
Exit Script;
When I open a sheet in the app I only expect to see a RoleName and RoleSystemCode for the EmployeeIdOriginal of 18190 however I am still getting all of the data. I know that my username is correct because I tested and successfully omitted a field. Does anyone know why this is occurring?
