4 Replies Latest reply: May 6, 2015 8:33 PM by Shivendoo Kumar RSS

    Based On Section Access Want to Hide 2 columns from Fact table?

    Shivendoo Kumar

      Hi Guys,

       

      Based On Section Access, I Want to Hide 2 columns from Fact table. How can I do this?

       

      For Example: In My Fact I have EmployeeKey, Salary, DepartmentID

       

      I have Implemented Section Access on Employee table using columns  ACCESS,  NTNAME, EMPLOYEEID

       

      Now for One user I don't want to show DepartmentID but for other user I want to show DepartmentID

       

      How to do this using OMIT column?

        • Re: Based On Section Access Want to Hide 2 columns from Fact table?
          sasi k

          Try like this

          Section Access:

           

          ACESS,NTNAME,EMPLOYEEID

          ADMIN, USER1,10

          USER,USER2,20

           

          NTNAME,OMIT

          USER1,FIELD1

          USEr2,FIELD2

           

          section Application;

          take the above tables in excel file and load in to the script like

           

           

          Section access:

          Tab1:

          Load

          ACCESS

          NTNAME

          EMPLOTYEEID  from table1;

           

          Tab2:

          Load

          NTNAME

          OMIT from Table2;

          Section application

            • Re: Based On Section Access Want to Hide 2 columns from Fact table?
              Shivendoo Kumar

              Hi,

               

              I tried this and is working perfectly when I hide DEPTID but not working When I hide EMPKEY

               

              Section Access;

              LOAD * INLINE [

              ACCESS, NTNAME, EMPLOYEEID, OMIT

              USER,NTSPROD\Shivendoo.Kumar,101, DEPTID

              ];

              Section Application;

               

              EMP:

              LOAD * INLINE [

              EMPLOYEEID, NAME, PROJECT, EMPKEY

              101,RAM,Final, 1

              ];

               

              DPT:

              LOAD * INLINE [

              DEPTID, DPTNAME, EMPKEY

              201,ENGINERRING, 1

              ];

               

              But why this is not working as expected:    

              Section Access;

              LOAD * INLINE [

              ACCESS, NTNAME, EMPLOYEEID, OMIT

              USER,NTSPROD\Shivendoo.Kumar,101, EMPKEY

              ];

              Section Application;

               

              EMP:

              LOAD * INLINE [

              EMPLOYEEID, NAME, PROJECT, EMPKEY

              101,RAM,Final, 1

              ];

               

              DPT:

              LOAD * INLINE [

              DEPTID, DPTNAME, EMPKEY

              201,ENGINERRING, 1

              ];

               

              So Can we hide the key column to one user and show to other user? Because in above case EMPKEY is key column for joining table EMP and DPT