Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Hope you all are safe in Lock Down!
I have a situation where my EAME Clients should see there EmpID and EmpName in "******" instead of Full ID and Name while for the rest these fields can be visible.
Needful fields from the Sample Data from the QVD:-
EMPID, EmpName, Region, CountryCode
E101, Pradnya, APAC, IN
E102, Salman, APAC, IN
E103, Shahid, EAME, FR
E104, Ananya, EAME, HU
E105, Alia, EAME, FR
E106, Aditya, LATAM, PA
];
Section Access Code which I'm currently using in the Dashboard:-
TECC:
LOAD
ACCESS,
USERID,
Upper(Region) &'-'& Upper("Employee Country Code") as Region_Code_Key
FROM [lib://SharedFolder/Concur Excel/New Data/T&E Section Access.xlsx]
(ooxml, embedded labels, table is [PROD SA List]);
Concatenate(TECC)
LOAD Distinct 'DUMMY' as USERID,
Region_Code_Key
Resident Key;
SECTION Access;
STAR is *;
LOAD Distinct Upper(ACCESS) as ACCESS,
Upper(USERID) as USERID,
Region_Code_Key
Resident TECC;
SECTION Application;
DROP Table TECC;
EXIT SCRIPT
Sample from Excel File used for section access:-
ACCESS | USERID | Region | Employee Country Code |
USER | APAC\s1005229 | APAC | IN |
USER | APAC\u897130 | APAC | IN |
USER | EAME\S952204 | EAME | FR |
USER | EAME\u971880 | EAME | * |
Take a look here: Mask or de-identify data for certain users using Section Access
- Marcus