Star is *;
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, LINK,REGION
ADMIN, MALABARGROUP\rchand, *,*
USER, MALABARGROUP\vvijay,DEVP,KARNATAKA
USER, MALABARGROUP\qlikadmin, BI_MANG,KERALA
USER, MALABARGROUP\knishanth,UAT_TEST,TELANGANA
ADMIN, SERVICEACCOUNT\QMC,*,*
];
SA:
LOAD * INLINE [
LINK, REGION
DEVP, KARNATAKA
UAT_TEST, TELANGANA
BI_MANG, KERALA
RChand,*
];
Section Application;
Try the above script, it should work.
What it does is
rchand is an ADMIN and will have access to 3 Regions, while other users will be only limited to their designated regions.
You must have 'Star is *;' included in script which would mean as TOTAL. So whosoever has * for their field, they will have full access to that field.
To verify if the Star is *; working for you, add SA table after Section Application and you'll see RChand having 'Total' as a value when * is assigned.
//For testing
Star is *;
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, LINK,REGION
ADMIN, MALABARGROUP\rchand, *,*
USER, MALABARGROUP\vvijay,DEVP,KARNATAKA
USER, MALABARGROUP\qlikadmin, BI_MANG,KERALA
USER, MALABARGROUP\knishanth,UAT_TEST,TELANGANA
ADMIN, SERVICEACCOUNT\QMC,*,*
];
SA:
LOAD * INLINE [
LINK, REGION
DEVP, KARNATAKA
UAT_TEST, TELANGANA
BI_MANG, KERALA
RChand,*
];
Section Application;
SAS:
LOAD * INLINE [
LINK, REGION
DEVP, KARNATAKA
UAT_TEST, TELANGANA
BI_MANG, KERALA
RChand,*
];
And include your Inline load within Section Application plus also include your service account. You'd need Service account to run this script in QMC or it will fail. Service Account will be the Admin for QMC.
