Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Section access script as follows:
Section Access;
LOAD
UPPER("ACCESS") as ACCESS,
UPPER(USERID) as USERID,
Upper(Region) as Region,
Upper(Country) as Country,
Upper(LOB) as LOB
FROM [lib://$(vConnection)/Section Access.xlsx]
(ooxml, embedded labels, table is [User Access]);
Section Application;
My section access file looks like:
ACCESS | USERID | Region | Country | LOB |
ADMIN | INTERNAL\SA_SCHEDULER | ALL | ALL | ALL |
USER | domain\username | ALL | ALL | ALL |
Do you have fields in your data model named Region, Country and LOB and in those fields you have the value "ALL"?
Try removing Region Country and LOB so that you only have ACCESS and USERID. If it works, you can start experimenting with the reduction fields.
(I assume "domain\username" is just an example, and that you have actual usernames there.)