I have a qvw file with section access. The purpose is that, I want to restrict data visibility based on the attached file(just an example). Admin can see all country data, and users can only see their country data.
When I reload the file on desktop manually which is placed inside Qlikview\SourceDocument folder it runs fine, and then I use to place the qvw inside Qlikview\documents folder so that users can access via Access point. By following this process it works.
But, I want to be a scheduled run on the server, and I have created a task in QVMC which run fine. The document is also distributed to Qlikview\documents folder.
Now when i try to access the qvw using access point I get error msg: Failed to open the document, you might not have permission.
I have also added QV_ADMIN user in the list through which all our Qlikview services runs on the server. I came to know about this somehow from the community and google.
What else I'm missing here or I need to do some other way ? Let me know if any more detail is required.
Please check the attached QV file. I have changed the NTNAME as USERID for the attached QV file to work. You should not be using a table name in section access hence I removed the "User:" table definition.
The NTNAME should contain a string corresponding to a Windows NT domain user name. Please refer the Security section in the help file for further details.
You are getting the error because your NTNAME is not matching with the NTNAME in section access. If you are using NTNAME, please make sure you provide correct windows login name.
I tried the following way you have mentioned. But I think I'm missing something here. And I have no clue what's missing ? I'm attaching my complete script(.txt) from qvw file along with excel to control visibility(this is just an example file). Can you please guide me how can I modify the script so that it should work as expected ?
One question, Roushan. What exactly do the two fields COUNTRY_CD and COUNTRY_NAME contain? If they contain different values, is there any other data source that can provide ALL possible combinations you want to map to * (star meaning everything in section access)?
Or are you absolutely sure that every value from field COUNTRY_NAME in EU_COACHING.qvd is also present in the security Excel? Refer to the case of country GRMBL in my previous story.
Replace field name COUNTRY_CD with field name COUNTRY_NAME in the two LOAD statements of table Users in Section Access.
Put the two LOAD statements of table User_Visibility at the beginning of Section Application in comments. Or delete them altogether.
Save and Reload.
Open
See what happens. This should work for QV_ADMIN, but you may have to add a domainname to the values in the NTNAME column of the security Excel workbook, and to the INLINE LOAD in Section Access.
Moreover, access to all countries will only be given to QV_ADMIN.
