Section Access Issue

[John117]

Hi All,

having an issue with section access which has me stumped..

This works in my load script and applies the restriction to me (s110725) that I would expect Region = APAC.

Section Access;
Load * INLINE [
ACCESS,       USERID,                               RESTRICTION
USER,           AD_DOMAIN\ADMIN,      *
USER,           XXXX\s1100725,                APAC
];

Section Application;

[Clockify]:
NoConcatenate
Load *
,Region as RESTRICTION
from [$(vFilePath)Clockify_Time_Report_Detailed.xlsx]
(ooxml, embedded labels, table is [Detailed Report]);

If I change the load script to use another field:

Section Access;
Load * INLINE [
ACCESS,            USERID,                                RESTRICTION
USER,               AD_DOMAIN\ADMIN,         *
USER,               XXXX\s1100725,                  Formulation SG
];

Section Application;

[Clockify]:
NoConcatenate
Load *
,Group as RESTRICTION
from [$(vFilePath)Clockify_Time_Report_Detailed.xlsx]
(ooxml, embedded labels, table is [Detailed Report]);

I get this error:

'Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script.

Data has not been loaded. Please correct the error and try loading again.'

Any ideas on what could be causing this? 

Thanks.

[BrunPierre]

Hi, I know INLINE always treats data as upper case, but try changing the reduction field the with "FORMULATION SG".

[John117]

Hi,

tried that and still get the same error. 

Thanks for the reply.

[BrunPierre]

Restrictions must have their Field Names and Values in Uppercase.

Upper(Group) as RESTRICTION

[John117 · Accepted solution]

I managed to get this working by introducing another table and applying the section access there.

Section Access;
Load * INLINE [
ACCESS,            USERID,                                RESTRICTION
USER,               AD_DOMAIN\ADMIN,         *
USER,               XXXX\s1100725,                  Formulation SG
];

[ClockifyStg]:
NoConcatenate
Load *
,Group as RESTRICTION
from [$(vFilePath)Clockify_Time_Report_Detailed.xlsx]
(ooxml, embedded labels, table is [Detailed Report]);

Section Application;
[Clockify]:
NoConcatenate
Load
*
Resident [ClockifyStg];

[Hania]

hii,

[Clockify]:
NoConcatenate
Load * ,Upper(Region ) AS RESTRICTION,

from [$(vFilePath)Clockify_Time_Report_Detailed.xlsx]
(ooxml, embedded labels, table is [Detailed Report]);

Section Access;
Load * INLINE [
ACCESS,            USERID,                                RESTRICTION

ADMIN,             INTERNAL\sa_scheduler, *
USER,               AD_DOMAIN\ADMIN,         *
USER,               XXXX\s1100725,                  Formulation SG
];

Section Application;

please use  above  Highlighted script once.

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!