The Qlikview Management Console (QMC) is used to define Reload and Distribution tasks for your Qlikview documents. These definitions are stored in a set of XML files — the Qikview Repository (QVPR) — located in C:ProgramDataQlikTechManagementServiceQVPR on your server.
The QMC provides a good overview of scheduled tasks, but a better analysis is sometimes need to answer questions like:
- What documents are being scheduled on a Monthly schedule? Weekly?
- What documents are using Dynamic Distribution (reduction) and what field controls the distribution?
- Which administrator modified this task and when?
- What documents are being distributed to group Accounting?
- How many documents are being distributed as PDF?
- Do I have logical errors in my QVPR?
- When was my server upgraded?
I’ve produced a “QVPR Analysis” tool that loads the QVPR XML files and makes them available for Qlikview analysis to answer the above questions and more. You can download the QVPR Analysis tool from the “Tools” menu of QlikviewCookbook.com.
The download link above contains some screenshots from the tool (names are scrambled in the images).
You can load directly from the server QVPR folder or an offline local copy obtained from the server. The offline capability makes the tool especially useful for remote consultants who can analyze a customer’s configuration without having QMC access.
This is the same tool provided to Masters Summit for Qlikview attendees last year. If you’ve already received a copy, no need to download again. I plan to continue enhancing the tool and will release further updates on QlikviewCookbook.com.
The analysis is pretty much text and tables which has suited my needs just fine. I’ve used the tool several times to solve some tricky customer problems or get someone out of a jam.
If you have Qlikview Publisher, you’ll get detailed information on Distribution tasks. If you don’t have Publisher, you won’t have distribution information but you’ll still get useful information on reload schedules and QVPR structure.
If you build some new analysis or find the tool useful, drop me a comment.