Tasks in a Gantt Chart (requires Google timeline extension).
Show Task intensity.
QVDs with all their metadata information, including fields.
Scripts analysis (via logs) and the dependencies of your scripts for the QVDs they use. Useful to debug and see the pain points in your scripts and how much time these portions take to load).
Gantt chart of TasksTask intensityQVD info - tables and fieldsScript analysis - load time and key words searchCross table of QVD tables and fields
You will need to run a script to loop through all the Governance Dashboard table in order to store them in QVDs.
This loop is available in the "05a*. CONFIG" tab.
The tabs 05a to 05f are to analyse log files and link them back to the tasks. It then will follows the logic and data model which goes from Task > App ( > Script) > QVD.
Set the library connection to "vQMC_QVD_Store" where the Governance Dashboard QVDs are contained.
Set the URL to the QlikSense server you are analysing in "vQlikSenseServer".
In the "Full_Paths_To_Folder" inline table, set the library paths to the folders where you generate and store your QVDs from your scripts.
Please check the script portion just above this table, as you can set times during the day when you run the QVD files analyses. The QVD analysis portion of script can take long depending on the amount of QVDs you have. The rest of the task analysis portion should take less than a minute.
In order to run the script analysis test, set "vRunLogAnalysis" to 'Yes' and set the location of the folder where the log files are contained in "vScriptLogFolder".
If you use standardised sub-routines (Calls) you can set the wildmatch-string search in the "Script_KeyWords_Categorisation_List" table.
The 05g tab will run a dependency table that will link all your tasks and apps depdendency on QVDs as written in your script logs.