Section Access

[jjking58]

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;

[Anonymous]

Hi

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!!

[jonathandienst]

%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

[jjking58]

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

[Peter_Cammaert]

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.

[jjking58]

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

[jjking58]

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

[Peter_Cammaert]

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

[jjking58 · Accepted solution]

That worked. Thank you for your quick response

[Peter_Cammaert]

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?