Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello my dear fellow qlikview experts
I need your help !
I want to make a variable which catches my url in a variable from my accespoint due to i want to make some urlbased security.
EG.
I have this url: http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local from my accesspoint when i open QVtest.qvw
In my document i have a textbox with a variable which is hardcoded to: http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local
But what i get a login parameter so my url becomes to this instead:
http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local&Kunde=Hansi
How can i make my textbox show this by a variable then? How can i catch my url, even if it changes...?
you mean you want your textbox show:
http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local
even if your url is :
http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local&Kunde=Hansi
am i right?
No!!
I want it to be able to change!! I want it to be dynamic!
If i log into accespoint a click on my first document QVtest.qvw - Then my textbox will show
http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local
This is my standard URL when click on QVtest.qvw
- But if i want to make my url as a LOGIN so when i click on QVtest.qvw it goes to
http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local&Kunde=Hansi
Kunde = Customer
Hans = Customers name
I want my text box change whether is standing behind my orginal url. So when Hans log in he will only be avaiable to see his own data. Cause it is his own url. It could also have been &Kunde=Diana - Then it should show that.
This seems like an attempt to circumvent security protocols? Why no use section access? Are the users in your domain?
No no users in my domain. All users will come from external and login to a controlpanel - where they should be able to through an iframe to see their qlikview report, without logging in twice! Therefore i need the url based security. And therefore i need to bring down the url in a variable..
or is there other ways?
Anyone with suggestions how to solve the problem??!
If you add a Text Object with the function: =OSUser()
What does it say as username when Hans or Diana log in?
It sound like if your authentication system supports passing the authenticated username in the HTTP header you could use this with QlikView to remove the need of authenticating twice and it should be the equivalence of NTNAME in Section access so you can use that to reduce data based on logged in user.
Im not sure i totally understand you?
I have not set an login for Hans og Diana.
1. I have 2 different users - Hans and Diana
2. Hans and Diana logs in to a controlpanel
3. Through the controlpanel they can access qlikview through an iframe (they should access without password, due to its not userfriendly to have to logins.) I will make the access in the url by some paramaters like &kunde=Hans
4. How can i make qlikview understand that it is HANS who is logged in and not Diana for an example?
5. And how do i do, so i only shows HANS data.
For point 2, "Hans and Diana logs in to a controlpanel", how do they login?
Are you using an existing system like Tivoli Access Manager, or are you creating your own login mechanism?
ITs my own login mechanisme
But the thing I would like is that they would be known by qlikview on the last parameter in the url. eg &kunde=Hans.
I could then at some point maybe create a new dimension called DimSecurity, wherein i will put the customerid and a guid.
My controlpanel will make the parameter, but i just need qlikview how to understand that its a user, who can only see his own data.