Hi Team,
We have an application of customer monitor in qlikview which does the moniotring of qlikview tasks, we are trying to deploy the same application in qliksense SAAS but we face an issue with the section access of the file.
We can open open the application fine in Qlikview Accesspoint, but cannot open the same application in Qliksense SAAS and we get the "Failed to open document, You donot have access to the document" attached screenshot for the same.
We are attaching the section access script for you also, please find below and update how we can fix this:
AccessInput:
load * inline
[
ACCESS, NTNAME
ADMIN, AD00XX\XXXXXX
];
concatenate load
ACCESS,
UPPER('DASH\'&NTNAME) as NTNAME,
UPPER(SHARE) as GROUP
from $(user_access)/qlikview_share_users.xlsx (ooxml, embedded labels, table is Sheet1);
Access:
load
ACCESS,
NTNAME,
GROUP,
if(match(GROUP, '<ANY>', '*') > 0, 'UserGID') as Omit
resident AccessInput;
Groups:
load
upper(fieldValue('Share', recNo())) as GROUP,
upper(fieldValue('Share', recNo())) as Share
autoGenerate(fieldValueCount('Share'));
load distinct
'<ANY>' as GROUP,
upper(fieldValue('Share', recNo())) as Share
autoGenerate(fieldValueCount('Share'));
Section Access;
load * resident Access;
load * resident Groups;
Section Application;
drop tables AccessInput, Access, Groups;
Best Regards.
