Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I get the credentials (e.g. email address) of the user accessing the qlikview document?
Here is my scenario:
We have a qlikview report that displays data by countries
User A has access to countries a, b, c
User B has access to countries d, e, f
User C has access to countries a, e, g
When user A access the qlikview report he should only see data rows for countries a, b, c
When user B access the qliview report he should only see data rows for countries d, e, f
Same with user C.
All of these users can access the report simultaneously, so it is important that we get the credential of each user accessing the report.
We have the full qlikview setup: server, publisher and user accessing from browser.
The user is authenticated through ActivIdentiy (using the user's email address).
We are not allowed to use macros.
Any help is greatly appreciated.
Thank you very much.
Hey,
With the function OSuser() you can see which user is logging in.
Your problem sounds like something you can solve with section access.
Search the community for section access and you should be albe to find it.
Or check this topic for example:
http://community.qlik.com/thread/37211
Hope this helps,
gr.
Frank
Hi,
See the attachment.
Use user name as following and password also same
ADMIN, ADMIN
USER, USER1
USER, USER2
Regards,
Nirav Bhimani
You can resolve this issue by using Section Access, see attached document.
The attached version is a simple version and checks for the NTNAME Windows NT Domain user (user login) to see if the user can access the report.
The data is then reduced by the DR_COUNTRY (country) field.
Open the attached and change my NTNAME to yours. Save the document and then make a backup. Once the backup has been created go to Settings > Document Properties > Opening > Select "Initial Data Reduction Based on Section Access".
Reload the document and save and close. Reopen the document and you will see the data has been reduced to the countries you have specified.
A word of warning all the data in Section Access has to be UPPER case!
Thank you for the reply, but I think OSuser will give me the user who is logged in to the server (which most probably is a system user ID). That's not what I need.
I need the credentials of the user accessing/browsing the report. And this user was authenticated through ActivIdentity.
You see, we have a table where all the user authorizations are stored. So, I need to get the credential of the user accessing/browsing the report so I can get his authorization from our authorization table and display the data based on those authorizations.
Thank you for the reply. But please see my previous reply frankcrezee
Thank you for the reply, but I cannot open the qvw file that you attached eventhough my qlikview is licensed.
Oops, forgot to comment out the Section Access!
See attached updated version.
Have you tried using OSUser()? Create a textbox with =OSUser() and see what the value is when opening it online.
We are also using a single-sign-on system and when using OSUser() I get the user identity from the authorization table.
gr.
Frank
Hi Frank,
I will try your suggestion and will let you know.
Thank you very much for taking the time to reply.
Regards,
Rhea