Discussion Board for collaboration on QlikView Security and Governance.
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
take the above tables in excel file and load in to the script like
EMPLOTYEEID from table1;
OMIT from Table2;
I tried this and is working perfectly when I hide DEPTID but not working When I hide EMPKEY
LOAD * INLINE [
ACCESS, NTNAME, EMPLOYEEID, OMIT
EMPLOYEEID, NAME, PROJECT, EMPKEY
DEPTID, DPTNAME, EMPKEY
But why this is not working as expected:
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
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:
EMPLOYEEID, NAME, PROJECT, DEPTKEY
DEPTID, DPTNAME, DEPTKEY
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?