Hello I want to implement a partial reload for my application. I want to only reload the section access every evening. Partial reload works but I don't think it refreshes the access. This is how I tested it: I gave myself access, did a full reload, all normal. Then took away my access and did a partial reload and I still had access.
This is my code:
section access;
Let vLastReloadMode = If(IsPartialReload(), 'Partial', 'Full');
when section access file has changes, do a full refresh and not any partial loads as with the latter theres always connections to other datasets/tables. that wont be refreshed/relations wont be refreshed.
technically you can but most of the time we encounter with issues like not proper data reduction etc. in your case i believe the section access tables is not completely replaced by the new one. Try below:
Section Access; LOAD * INLINE [ ACCESS, USERID ];
If IsPartialReload() Then //Replace the section access table with the new data if partial reload Section Access; SecurityScheduler: Load * Inline [ ACCESS, USERID ADMIN, INTERNAL\SA_SCHEDULER]; CONCATENATE(SecurityScheduler) LOAD 'ADMIN' as ACCESS, if(MEG = 1, 'REDACTED\'&Upper(SapUser)) as USERID FROM [lib://REDACTED/EmployeesFunction*.xlsx] (ooxml, embedded labels, table is Sheet1) where 1=1; Else // Full Reload Section Access; Load * INLINE [ ACCESS, USERID ADMIN, INTERNAL\SA_SCHEDULER]; End If;
Section Application;
EXIT SCRIPT;
i havent run this script as i dont have any sample data to test. so let me know how that goes with code above.
