I've used section access on several occasions and it has generally been straightforward to implement, however I'm having a "Failed to open document" error through Access Point. I've checked various forum posts and the account that runs the services is added to the spreadsheet that controls access and everything looks ok from my end. Also it works fine when running locally through QV Desktop, the issue is only from the Access Point.
My script is below:
star is *;
Section Access; SATABLE: LOAD
upper(ACCESS) as ACCESS, upper(NTNAME) as NTNAME, upper(SAUSER) as SAUSER FROM
(ooxml, embedded labels, table is Sheet1);
Section Application; DocSecurity: LOAD
upper(SAUSER) as SAUSER, upper(FIELDACCESS.SCHOOLFILTER) as Employee.link FROM (ooxml, embedded labels, table is Sheet1);
You are using "Data Reduction based oin Section Access".
Does your account have a valid value (1 or more) in FIELDACCESS.SCHOOLFILTER? BTW you do not have to convert that value to upper case, as it's only used in Section Application and may not provide a correct link value to to the other Employee.link values.
Also: access to protected documents will always work in QV Desktop for all users with ACCESS=ADMIN, while in the AP it may not because of all users being ACCESS=USER anyway and Data reduction prohibiting access when the data model reduces to nothing...
It is hard to help with a script when you are loading data from an Excel file and we can't see the data. What I would do is start with an Inline load with the basic data and see if that works. Then move to the Excel file.