Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a dashboard with section access and when one of new team member getting "ACCESS DENIED" error. But I added his NTName in qvd and reloaded. When he try to open the dashboard, it doesn't prompt for user authentication but shows directly access denied.
please help to provide your inputs.
what does your section access looks like?
only access, ntname or additional fields?
Can you post the SA script here?
Regards
Below is the script
Section access;
LOAD
ACCESS,
UPPER(NTNAME)as NTNAME,
CUSTOMER_TYPE,
CUSTOMER_SUBTYPE
FROM SECTION_ACCESS.qvd(qvd);
Hi All,
Any inputs please
I would recommend reviewing the following Design Blog post and the two Dynamic Data Reduction links at the bottom too:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766
Here is the Help link:
https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm
That will allow you to review to ensure you have not missed something as far as the setup of things. The thing I recommend folks do when troubleshooting Section Access reduction issues is start basic, ensure Section Access without reduction fields work first, then add in the reduction field etc. Another good thing to do is comment out the Section Access line of that table load, this way it loads visible into the data model, which will allow you to check directly how things are linked and if you see the correct reductions based upon selections etc... About the best I have to try to help you move it forward, hopefully it helps. You may want to load that QVD file you use into a new QlikView app just to ensure the record for the new user is as you thought it was input, confirmation is always good there too. Sorry I do not have anything better for you.
Regards,
Brett