-
Re: Section Access not working as expected in qliksense
Andrei Kaliahin Apr 12, 2018 1:31 AM (in response to Nikhil Garg)Hello,
Could you give more details on what's not working exactly?
User access? Data reduction?
It could whatever, so you definitely missing something.
//Andrei
-
Re: Section Access not working as expected in qliksense
Nikhil Garg Apr 12, 2018 1:47 AM (in response to Andrei Kaliahin )When i am logging in on access point, it is asking me for credentials. When i am enetring my credentials(as ADMIN), it is giving error "Access Denied"
-
Re: Section Access not working as expected in qliksense
Andrei Kaliahin Apr 12, 2018 2:05 AM (in response to Nikhil Garg)Are you including DOMAIN\ both in SA and when entering credentials?
Have a look into https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/Security/manage-security-with-section-ac…
USERID Contains a string corresponding to a Qlik Sense user name. Qlik Sense will get the login information from the proxy and compare it to the value in this field.
Hope this helps/Andrei
-
Re: Section Access not working as expected in qliksense
Nikhil Garg Apr 12, 2018 2:06 AM (in response to Andrei Kaliahin )Yes, my domain name is included in NTNAME
-
Re: Section Access not working as expected in qliksense
Andrei Kaliahin Apr 12, 2018 2:21 AM (in response to Nikhil Garg)Check available fields for SA in Qlik Sense They're different to QlikView...
Link to help provided earlier
There is no NTNAME anymore
//Andrei
-
Re: Section Access not working as expected in qliksense
Nikhil Garg Apr 12, 2018 3:26 AM (in response to Andrei Kaliahin )Thanks, this helps
-
-
-
-
-
Re: Section Access not working as expected in qliksense
Nikhil Garg Apr 12, 2018 1:57 AM (in response to Andrei Kaliahin )I have written following script:
Section Access;
LOAD
upper("Access") as ACCESS,
upper(NTNAME) as NTNAME,
upper(Region) as REGIONCODE;
SQL SELECT "emp_code",
"emp_fname",
"emp_lname",
"emp_Emailid",
Status,
"emp_password",
"Access",
NTNAME,
Role,
Region
FROM "QlikSense".dbo.LoginMaster;
Section Application;
LOAD
REGIONCODE,
SALES
FROM [lib://Desktop (abcd)/SectionAccess.xlsx]
(ooxml, embedded labels, table is Sheet1);
-