topic Re: Section Access Along with a partial reload in App Development

Section Access Along with a partial reload

Shouq — Fri, 25 Oct 2024 08:37:02 GMT

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');

Replace 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;

Concatenate

SecurityScheduler:

Load * Inline

[ ACCESS, USERID

ADMIN, INTERNAL\SA_SCHEDULER];

section application;

Re: Section Access Along with a partial reload

Qrishna — Fri, 25 Oct 2024 10:21:19 GMT

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.

Re: Section Access Along with a partial reload

Shouq — Fri, 25 Oct 2024 10:45:08 GMT

@Qrishna Thank you for the reply. Does this mean that there is no way of applying a successful partial reload to a section access?

Re: Section Access Along with a partial reload

Qrishna — Fri, 25 Oct 2024 11:40:16 GMT

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.