Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
limingthefirst
New 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

Tags (3)
1 Solution

Accepted Solutions

Re: Access in webview

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.

13 Replies

Re: Access in webview

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
New Contributor III

Re: Access in webview

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
Contributor III

Re: Access in webview

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
New Contributor III

Re: Access in webview

Hi Max,

I'll try your steps later, thank you~

Re: Access in webview

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
New Contributor III

Re: Access in webview

Hi Max,

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

limingthefirst
New Contributor III

Re: Access in webview

Hi Miguel,

Thanks for your detailed explanation,

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

Re: Access in webview

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
New Contributor III

Re: Access in webview

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.