Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
limingthefirst
Contributor III
Contributor III

Access in webview

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?

ACCESSNTNAMECATEGORYPRODUCT
USERUSER1Aa
USERUSER2Bb
USERUSER3*c
ADMINACCESSPOINTA*
ADMINACCESSPOINTB*
ADMINACCESSPOINT*a
ADMINACCESSPOINT*b
ADMINACCESSPOINT*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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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.

View solution in original post

13 Replies
Miguel_Angel_Baeyens

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.

limingthefirst
Contributor III
Contributor III
Author

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.


big_dreams
Creator III
Creator III

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,

limingthefirst
Contributor III
Contributor III
Author

Hi Max,

I'll try your steps later, thank you~

Miguel_Angel_Baeyens

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.

limingthefirst
Contributor III
Contributor III
Author

Hi Max,

I've updated to "DIRECTORY\ACCOUNT",but it still go back to login frame.

limingthefirst
Contributor III
Contributor III
Author

Hi Miguel,

Thanks for your detailed explanation,

but it still go back to login frame while I've updated to "DIRECTORY\ACCOUNT" format.

Miguel_Angel_Baeyens

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?

limingthefirst
Contributor III
Contributor III
Author

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.