Discussion Board for collaboration related to QlikView App Development.
I would like to create a reference to help our IT support team resolve issues related to access. The use case is that an end user will say "I need access to Click View" and the support team needs to be able to determine which application they are talking about in order to help them obtain the appropriate access. Access is managed by AD Security groups. So, ideally, what I want to see is a list of all published documents, by category, with their associated distribution lists. Even if the support desk can't access the QVW, I could export it and manage it periodically if I could get this meta data into a QlikView I create.
In your case, there are two possible paths to follow:
Also note that access to documents often isn't managed just by way of distribution lists. Licenses and Section Access entries may also play a part in this deduction. But maybe not (yet) in your environment...
thanks; now I remember using that QVPR app before for something similar. Maybe I can set up our nprinting to email me a simplified report or something
I think your initial idea of creating a QlikView document (for administrator use only) is a better match. The associative logic offers you a method of selecting a document and/or existing users, and let QlikView figure out what must be done to add another user with the same access rights.
the key piece...how do I find out what groups are being distributed to for each document? Right now, I would go on the QMC and look up the refresh task to see what the group is for a given app. I would look at the access point to search for apps and view them by category.
IMHO categories have nothing to do with access or security. They're just a nice touch to group documents in the AccessPoint.
AD groups to which documents are being distributed can be lifted from the QVPR. See the Recipient Name field on the Distribution tab in Rob's QVPR Analyser.
BTW QlikView has no idea about how AD Groups work. They just grant access to a lot more people than a single user account.
We also use AD groups for section access. It gets complicated. It would be nice if I could create a self-service portal to overlay the whole access point. What happens now is users call a general support line and it often takes a while for everyone to figure out how to get assistance since our organization supports hundreds of applications (other than Qlik) for almost 40,000 users. We added QlikSense into the mix now too and there is another non-reporting application called "Clickview"...
That's an entirely different issue than the one in your original post, and I'm not entirely sure that we can solve this in this or another community discussion.
But let me just share with you the following reflections:
The big advantage was that in large enterprises, stuff like distribution and acces management is pulled away from general IT services and being managed by people who understand the architecture and how it operates. As a result, requests for granting/denying access to documents are serviced much quicker than via a support ticket that first has to travel to a support department at the other side of the globe.
Of course, your mileage will vary.