topic Re: Section Access in QlikView

Section Access

jjking58 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm setting up security in the hidden script and can not get a successful load. Can someone show me what i'm doing wrong

I've included the table used to compare the data and my hidden script

Thanks in advance

InvHeader:

Load

Inv_Number,

DBCR,

IHINYY,

IHORNO,

IHIDAT,

Customer,

IHCMPD,

IHMSPC,

IHMSPL,

NANAME,

Company,

Salesman,

Company&'|'&Salesman as AuthID

FROM C:\QlikviewProject\Data Library\Sales\SROISH.qvd

(qvd);

-----------------------------------------------------------------------------------------------------------------------------------------------------

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, %AUTHID

ADMIN, ADMIN, ADMIN,

USER, TPADGETT, TPADGETT, <ANY>|Tim Padgett,

USER, MCETINICH, MCETINICH, <ANY>|Mike Cetinich,

USER, RBARNES, RBARNES, I|<ANY>,

USER, MCLEARY, MCLEARY, I|<ANY>

];

Section Application;

Load Company'|'& Salesman as AuthID, %AUTHID Resident InvHeader;

Re: Section Access

Anonymous — Fri, 19 May 2017 09:17:07 GMT

Are you getting any error? Please attach screen shot

After Scripting part is done then open the document properties (Ctrl + Alt + D) and tick below options present on Opening tab.

Initial Data Reduction Based On Section Access

Strict Exclusion

Save the application and close.

Now, while opening the document application will ask for credentials. Enter the respective credentials to get the desired results.

Hope it helps!!

Re: Section Access

jonathandienst — Fri, 19 May 2017 09:40:31 GMT

%AUTHID does not exist in InvHeader, so the link table load wont work. You will need to create %AUTHID in the link table.

This article may help you

Generic keys

Re: Section Access

jjking58 — Fri, 19 May 2017 13:02:15 GMT

The InvHeader is being loaded after the hidden script. How can i run the InvHeader first. I think this would clear up my problem. Also InvHeader references a few mapload file as well that are loaded after the hidden script as well

Re: Section Access

Peter_Cammaert — Fri, 19 May 2017 14:13:47 GMT

Also if value "<ANY>" doesn't occur in your Company and/or Salesman fields in InvHeader (whether you load it before or afterwards), nothing from your data model will link to any of the SectionAccess entries. Moving your LOAD statement won't fix that.

Re: Section Access

jjking58 — Fri, 19 May 2017 14:16:18 GMT

Thanks, I'm reworking my logic and will let everyone know the results

Re: Section Access

jjking58 — Mon, 22 May 2017 11:56:44 GMT

Sorry for the late response, but I've been trying different things to get the section access to work. I added the following to the hidden script. I'm not sure if it will work because now i receive a problem with some of my table loads. These all worked fine before adding the section access code. I've attached the section access code along with my main reload, error log and QVD list. I would appreciate any help on this matter thanks.

QVD List

Main

Section Access

Error log

Re: Section Access

Peter_Cammaert — Mon, 22 May 2017 12:09:43 GMT

What happens if you add a Section Application; statement right after the LOAD INLINE of your SA table?

Re: Section Access

jjking58 — Mon, 22 May 2017 12:32:22 GMT

That worked. Thank you for your quick response

Re: Section Access

Peter_Cammaert — Mon, 22 May 2017 12:45:47 GMT

I think you're a bit difficult to follow, as you are posting a reply to your own Original Post. What worked? And what in your last reply is the answer to your own question and deserves a "Correct Answer" marking?