Data Reduction in Section Access

[Anonymous]

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

[sasiparupudi1]

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;