hello friends,
am using excel file for section access and columns are like below
| ACCESS | NTNAME | PLANTCODE | USER | SH14 | SH11 | SH12 | SH13 | SH15 |
| ADMIN | DOMAINNAME\ADMINISTRATOR | <ALL> | DOMAINNAME\ADMINISTRATOR | 1 | 1 | 1 | 0 | 1 |
| USER | DOMAINNAME\SACHIN | 1100 | DOMAINNAME\SACHIN | 1 | 1 | 0 | 0 | 1 |
| USER | DOMAINNAME\RAHUL | 1200 | DOMAINNAME\RAHUL | 1 | 1 | 0 | 0 | 0 |
| USER | DOMAINNAME\RAHUL | 1300 | DOMAINNAME\RAHUL | 1 | 1 | 0 | 0 | 0 |
below code i have used in application:
SECTION Access;
Access:
LOAD Upper (ACCESS) as ACCESS,
Upper (NTNAME) as NTNAME,
Upper (PLANTCODE) as PLANTCODE,
Upper (USER) as USER
FROM
[$(vSectionAccess)SectionAccess - Operations.xlsx]
(ooxml, embedded labels, table is Sheet1);
SECTION Application;
Sheetlevel:
LOAD Upper (USER) as USER,
SH14,
SH11,
SH13,
SH12,
SH15
FROM
[$(vSectionAccess)SectionAccess .xlsx]
(ooxml, embedded labels, table is Sheet1);
and added condition in sheet properties:
=USER = Only({<SH11={1}>} USER)
Unfortunately this is not working as expected. PLANCODE Wise access restriction is working but sheet level access is not working. all sheets are visible to all users. please help to restrict sheet level access.
Thanks in advance
