SECTION ACCES

[souadouert]

HI,
i have questions about using the dct section access and data reduction, i followed the next step.
I defined in my script the access table: user_id, password, privilege
then I enabled the data reduction feature in the document properties.
at this step, I did not understand how used the where to reduce the data,
  load * from X where REGION = (the user)
and a second point if I will not use the password is that it poses a problem

THANK YOU

[sunny_talwar]

Already back to working?

I am not sure I understand your question, would you be able to elaborate a little?

[souadouert]

Hello suuny 

yes I work hahaha
I solved my problem the idea is to reduce the data according to the connected user profile

[Brett_Bleess · Accepted solution]

Just a potential help for you going forward if you get into more complex setups, here is a Design Blog post from Henric Cronstrom on Section Access, there are some associated links at the bottom of the post as well to other related topics, this should be a big help hopefully.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Oh, and one troubleshooting step I use is to comment the Section Access line of the script, but I leave the rest of the table load, this way it becomes part of the visible data model, so you can check things out that way to be sure things are connecting properly, and you can then also use List Boxes to be sure when you select a user, the other fields reduce down properly etc., and once you know you are good, then uncomment the Section Access line again and put it out there for final testing.  As always, when doing Section Access, be sure to keep a backup of the file without Section Access somewhere in case you lock yourself out of the app! 🙂

Regards,
Brett