Data Reduction in Section Access

Anonymous — Wed, 04 Apr 2018 15:37:47 GMT

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?

Thanks

Re: Data Reduction in Section Access

sasiparupudi1 — Thu, 05 Apr 2018 13:50:47 GMT

Try

Load * Inline [

ACCESS, USERID, EMPLOYEEIDORIGINAL

ADMIN, x\MP11111111, 18190

];

section application;

LIB CONNECT TO 'BI';

LOAD

RoleName,

EmployeeIdOriginal As EMPLOYEEIDORIGINAL,

EmployeeIdOriginal,

RoleSystemCode;

SQL SELECT RoleName,

EmployeeIdOriginal,

RoleSystemCode

FROM "BI".BI.RoleView;

Exit Script;

topic Data Reduction in Section Access in App Development

Data Reduction in Section Access

Re: Data Reduction in Section Access