Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Qliksense - Data Row level Security
We have a Filter called Department(Dimension) Which has values as Mentioned below:
IT
Mechanical
Admin
While we try to implement the Section Access for a particular user(Ex: User RR1234 Via Section access it is not restricting the data)
EX: RR1234 User should not get the option to filter Admin in the department column.Please advise.
Section Access;
Load * Inline [
ACCESS, USERID, DEPT,SHEET1,SHEET2
USER, DOMAIN\RR1234,ADMIN,0,0
ADMIN, DOMAIN\RR3213,*,*,1
USER, DOMAIN\RR4321,MECHANICAL,1,1
];
Section Application;
so you need:
Section Access;
Load * Inline [
ACCESS, USERID, DEPT,SHEET1,SHEET2
USER, DOMAIN\RR1234,IT,0,0
USER, DOMAIN\RR1234,MECHANICAL,0,0
ADMIN, DOMAIN\RR3213,*,*,1
USER, DOMAIN\RR4321,MECHANICAL,1,1
];
also, your data model needs a field DEPT which is
upper(Department) as DEPT
section access requires upper field names and upper values.
Regards
Yes Bro.I kept both(Section and my main table) the fields as UPPER(DEPT) still it doesn't turn-on.