Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
That worked. Thank you for your quick response
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!!
%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
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
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.
Thanks, I'm reworking my logic and will let everyone know the results
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
What happens if you add a Section Application; statement right after the LOAD INLINE of your SA table?
That worked. Thank you for your quick response
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?