Hey! I'm currently working on a section access script. The script is working in filtering the data. However, I would like to allow a/more AD group(s) to have full access, such that that, the people in the AD group(s) can view all the data.
Can anybody help here?
To elaborate, my script is made up of 2 sections:
Section 1) Connect Qlik to an internal database, where BU and EMPLOYEEGUID is loaded whenever an account log-in:
[CustomerTable]:
LOAD BU,
EMPLOYEEGUID;
SQL SELECT
BU,
EMPLOYEEGUID
FROM
"Maconomy_comp_Kunder".dbo."T_Maconomy_Employees"
WHERE
LEN(EMPLOYEEGUID) >0 AND LEN(BU) > 0;
Section 2) Matches the loaded BU with the BU from the data and make section access based upon this:
Section Access;
[SectionAccessTable]:
NoConcatenate
LOAD
'USER' as ACCESS,
'GLB\' & UPPER(EMPLOYEEGUID) AS USERID,
BU as HistoriskBU
Resident CustomerTable;
Temp_HistoriskBU:
NoConcatenate
LOAD DISTINCT
HistoriskBU
RESIDENT [Jobdata];
Concatenate([SectionAccessTable])
LOAD
'INTERNAL\SA_SCHEDULER' AS USERID,
'ADMIN' AS ACCESS,
HistoriskBU
RESIDENT Temp_HistoriskBU;
DROP TABLE Temp_HistoriskBU;
Section Application;
