Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

lokeshwer
New Contributor

"Database driven" Dynamic Data Reduction

I made use of dynamic data reduction to restrict access to content (filter rows) based on your roles / user.

section access;

LOAD * inline [

ACCESS, USERID,REDUCTION, OMIT

USER, AD_DOMAIN\ADMIN,*,

USER, AD_DOMAIN\A,1,

USER, AD_DOMAIN\B, 2,NUM

USER, AD_DOMAIN\C, 3, ALPHA

];

This way (explicit access to each user in "every script") is not convenient for us. Will this work the same way if I replace the inline script with some external database / file mapping?

2 Replies
stigchel
Honored Contributor

Re: "Database driven" Dynamic Data Reduction

In short, Yes

lokeshwer
New Contributor

Re: "Database driven" Dynamic Data Reduction

Yes it works only after I sign out and sign in to hub. I did data load as well. I am not sure if there is a better way. Doing this every time is frustrating. Anyways thanks it works at least for now.

Community Browser