Good morning experts,
I have an issues with SA. Every time i try to access the file, sense turn to me an "Access Denied" error. USERID is equal to Sense User name.
Thanks in andvance,
PS the same SA works in QlikView
'USER' AS ACCESS
,upper(USERID) as USERID
,NTNAME as USER
FROM [$(pathXLS)\Nuti.xls] (biff, embedded labels, table is Restrizioni$)
where not isNull(NTNAME);
concatenate (Accessi) load
'ADMIN' as ACCESS
,upper(trim(subfield('$(RestrictionsSuperusers)', ','))) as USERID
,'*' as USER
Solved! Go to Solution.
in Qlik Sense the section access table doesn't have NTNAME field anymore but only USERID field.
USERID for domain users must be as "domain\username" of course.
I don't use NTNAME as SectioinAccess field. As you can see i rename it as USER because it's the field which I use to connect the SA table to the data model.
first of all let's try to comment out the section access and check with OSUser() function if the user logged in the app match with your section access USERID entry.
I've already done, and thre OSUser match with USERID.
It's in lowercase (OSUser) but if I remember it is automatically changed in uppercase
Have your tried to check if the domain name registered on licenses have a prefix instead of a single user name?
Anyway, the Section Access must be applyed on the APP, the document reloading and publishing it in a stream. All fields must be uppercase also.
Recommend that you close the Browser then try to access in the stream.
Yes i've checked that. There is no prefix, only a single user name.
I have published it and relogged into sense by closing and opening the browser again. But when i try to access to the app it return to me Access Denied error
Ok, try to reproduce the same code below, changin the user name only.
We need to know either the problem is code or product.