Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an issue with user access in webview.
I can open the qvw in desktop, and I can see the qvw when published in QMC, but it back to login frame in webview when I click the qvw.
Below is user Section, and how should I modify it or configure QMC?
ACCESS | NTNAME | CATEGORY | PRODUCT |
---|---|---|---|
USER | USER1 | A | a |
USER | USER2 | B | b |
USER | USER3 | * | c |
ADMIN | ACCESSPOINT | A | * |
ADMIN | ACCESSPOINT | B | * |
ADMIN | ACCESSPOINT | * | a |
ADMIN | ACCESSPOINT | * | b |
ADMIN | ACCESSPOINT | * | c |
I attached two qvw files:
access.qvw work fine, but it take lot of time and space.
access2.qvw can not be opened in webview.
The NTNAME field format is "ACCOUNT" not "DIRECTORY\ACCOUNT" in my useraccess.xlsx, and working well.
Best Regards
Ming
Use section access first without any reduction field and verify that it works as expected and that the username, domain, etc. are passing through just fine.
For the reduction fields yes, I would recommend to create a key in the section access which links to another table in the data model and resolves such key. Start with a simple user, one with access to only one of the values in those fields, make sure it works and keep adding more complex users.
Note that what section access does roughly speaking is what you can do in the Desktop using menu File > Reduce Data > Keep Possible Values. So if you add the users table to the script, but without the lines section access / section application, you should be able to select one user and see the required white values for each of the reduction fields this user has assigned.
If you don't, then the reduction table is not working. I would develop this way, instead of enabling section access, until I'm sure all users see what they are expected to see.
Check that the NTNAME matches with the output of OSUser() for any given user.
It usually returns a value in the form "DIRECTORY\ACCOUNT". If so, you need to include the part in bold as well.
Thanks your suggestion,
I had attached the qvw, could you help to review the code in script?
The NTNAME field format is "ACCOUNT" not "DIRECTORY\ACCOUNT" in my useraccess.xlsx, and working well in access.qvw.
Hi,
as miguel suggested when you login on access point then what is outcome of osuser(). You have to use that name in your section access script
If you don't get it.
try below step.
1: create blank qlikview application.
2: use text object > write expression > = osuser()
3: save it.
4: publish it on server.
5: open that application in access point.
6: check what is value coming in that text object.
Regards,
Hi Max,
I'll try your steps later, thank you~
NTNAME must coincide with the output of the OSUser() function, which returns the account name as seen by QlikView when any user logs in. In most cases -if not all, this follows that convention: DIRECTORY\ACCOUNT
DIRECTORY usually refers to the name of the user directory, active directory, SSO, LDAP, etc. as it is specified in the QMC > Director Service Connectors > Directory Label or the domain in the case of Windows.
Hi Max,
I've updated to "DIRECTORY\ACCOUNT",but it still go back to login frame.
Hi Miguel,
Thanks for your detailed explanation,
but it still go back to login frame while I've updated to "DIRECTORY\ACCOUNT" format.
Is your authorization in QMC set to NTFS or DMS?
Is the format the same as returned by the function OSUser()?
Are the web servers set to authenticate accordingly NTLM, Header, etc?
Hi Miguel,
Is your authorization in QMC set to NTFS or DMS?
DMS
Is the format the same as returned by the function OSUser()?
Yes, Same as OSUser()
Are the web servers set to authenticate accordingly NTLM, Header, etc?
We use custom user.