1 Reply Latest reply: Apr 5, 2018 9:50 AM by Sasidhar Parupudi RSS

    Data Reduction in Section Access

    Mark Perreault

      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
          Sasidhar Parupudi

          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;