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.
I can't provide example code, I'll need an example model for that from you.
But the changes are simple.
In table Users, rename the COUNTRY_CD field to LINKFIELD, or something else.
Delete everything you listed in the above section application. Why? Identities and authentication belong in Section Access. In Section Application you'll provide authorizations only, which in your case means a simple link table listing individual countries.
In Section Application, create a new User_Visibility table and fill it with the country values that occur in your facts tables further on in your data model. Because this table in essence doesn't really do anything except "link", create rows with two fields (e.g. LINKFIELD and COUNTRY_CD) with identical values. If COUNTRY_CD is not the field that connects to the rest of the data model, replace it by something else. However, make sure that LINKFIELD still contains COUNTRY_CD values.
There are multiple solutions for this problem, but they differ mostly because of particular details in your application. And we have no information about that.
And by the way, you may ask yourself how you can fill User_Visibility when the facts haven't even been loaded yet... Section Access doesn't have to be at the front of your script, you can put it at the end without any problems.
