Hello community,
I'm currently working on an app that reduces data using "Session Access".
This app will be accessed from 2 ways :
1 - Admin (me) : I can see everything.
2 - Users (a lots, more than 800) : only see their personnal data.
For the session access I wrote something like this :
LOAD
'USER' AS ACCESS
,'MYSERVER\' & Lower(ID) AS USERID
,Upper(NOM) & ' ' & Upper(Prénom) AS RDVVENDEUR
,Upper(NOM) & ' ' & Upper(Prénom) AS RDVVERBATIM
,null() AS OMIT
FROM [lib://Folder/ExcelFileWithUsers.xlsx]
(ooxml, embedded labels, table is [tab1]);
Concatenate LOAD
ACCESS
,USERID
,RDVVENDEUR
,RDVVERBATIM
,OMIT
Inline [
ACCESS,USERID,RDVVENDEUR,RDVVERBATIM,OMIT
ADMIN,INTERNAL\SA_SCHEDULER,*,*,
ADMIN,MYSERVER\mylogin,*,*,
];
The part with "inline" that contains my login and admin right works.
But the part with the excel file looks to fail.
Is there a restricted use to only inline ?
Thanks in advance,
Adams
