Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Hi
You are restricting EMPLOYEEID and why you still want to OMIT EMPKEY,
Please try to post your app, it would be helpful
Ok Lets consider this example:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, EMPLOYEEID, OMIT
USER,NTSPROD\Shivendoo.Kumar,101, DEPTKEY
];
Section Application;
EMP:
LOAD * INLINE [
EMPLOYEEID, NAME, PROJECT, DEPTKEY
101,RAM,Final, 1
];
DPT:
LOAD * INLINE [
DEPTID, DPTNAME, DEPTKEY
201,ENGINERRING, 1
];
Now Will it hide DEPTKEY to few END users?
So My question is If the column is key column and based on that we are joining tables in Schema then USING OMIT, Can we omit those Key columns to few users?