topic Re: Qlikview Dashbaord is not asking for authentication in QlikView

Qlikview Dashbaord is not asking for authentication

viveksingh — Sat, 16 Nov 2024 01:00:53 GMT

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.

Re: Qlikview Dashbaord is not asking for authentication

martinpohl — Fri, 20 Mar 2020 07:35:01 GMT

what does your section access looks like?

only access, ntname or additional fields?

Can you post the SA script here?

Regards

Re: Qlikview Dashbaord is not asking for authentication

viveksingh — Fri, 20 Mar 2020 08:36:48 GMT

Below is the script

Section access;
LOAD
ACCESS,
UPPER(NTNAME)as NTNAME,
CUSTOMER_TYPE,
CUSTOMER_SUBTYPE

FROM SECTION_ACCESS.qvd(qvd);

Re: Qlikview Dashbaord is not asking for authentication

viveksingh — Mon, 23 Mar 2020 02:53:39 GMT

Hi All,

Any inputs please

Re: Qlikview Dashbaord is not asking for authentication

Brett_Bleess — Tue, 14 Apr 2020 19:16:00 GMT

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