topic Re: Omit in Section Access in QlikView

Omit in Section Access

Anonymous — Fri, 16 Jan 2015 11:13:51 GMT

Hi i am playing with Omit Groups in section Access. I am trying to restrict access to particular field using omit groups depending on roles admin and users .

Here is my sample .

Section Access;

Access:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMITGROUP

ADMIN, admin, admin,

USER, user1, user1,

USER, user2, user2, SALARYONLY

USER, user3, user3, SALARYANDABSENCE

USER, user4, user4, ABSENCEONLY

];

OmitGroups:

LOAD * INLINE [

OMITGROUP, OMIT

SALARYONLY, Salary

SALARYANDABSENCE, Salary

SALARYANDABSENCE, Absence

ABSENCEONLY, Absence

];

Section Application;

//Employees:

LOAD * INLINE [

EmpID, Name, Salary, Absence

1, Joe Bloggs, 50000, 3

2, Jane Doe, 45000, 5

3, Fred Frank, 30000, 0

4, Jeri Jublek, 19000, 12

];

I have restricted the access to Salary field for 'user2 '.But if i login with user2 credentials i can see all the data what admin can view .

Please clarify me

Thanks

Re: Omit in Section Access

alexandros17 — Fri, 16 Jan 2015 11:21:20 GMT

Try with:

Section Access;

Access:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMIT

ADMIN, admin, admin,

USER, user1, user1,

USER, user2, user2, Salary

USER, user3, user3, Salary

USER, user3, user3, Absence

USER, user4, user4, Absence

];

Let me know

Re: Omit in Section Access

Anonymous — Fri, 16 Jan 2015 11:24:10 GMT

Hi, try this:

Section Access;

Access:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMIT

ADMIN, admin, admin,

USER, user1, user1,

USER, user2, user2, Salary

USER, user3, user3, Salary

USER, user3, user3, Absence,

USER, user4, user4, Absence

];

Re: Omit in Section Access

Gysbert_Wassenaar — Fri, 16 Jan 2015 11:26:25 GMT

I think the OMIT field has to be part of the Section Access table itself.

Re: Omit in Section Access

Anonymous — Fri, 16 Jan 2015 11:32:01 GMT

It's not working .The same result what i got

Thanks

Re: Omit in Section Access

alexandros17 — Fri, 16 Jan 2015 11:33:51 GMT

Send all the script related to section access ...

Re: Omit in Section Access

Clever_Anjos — Fri, 16 Jan 2015 11:35:26 GMT

Did you tick "Initial Data Reduction..."?

Re: Omit in Section Access

Anonymous — Fri, 16 Jan 2015 11:38:44 GMT

Thank you !! Working fine