Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

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

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?

4 Replies
sasikanth
Valued Contributor III

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

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

Not applicable

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

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

sasikanth
Valued Contributor III

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

Hi

You are restricting EMPLOYEEID  and why  you still  want to OMIT EMPKEY,

Please try to post your app, it would be helpful

Not applicable

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

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?

Community Browser