Configuring the Governance Dashboard 2.0 (Image)

[Tyler_Waterfall]

Here is a basic information about configuring the Governance Dashboard 2.0. These tool tips are available in the app itself by hovering over the titles above the input boxes.

If you have questions about the configuration, please post them here or even better to the main beta homepage.

1. Profile Directory
   1. Filepath where output QVDs from the Governance Dashboard will be stored.  If left blank, files will be stored in the same folder as the Governance Dashboard.qvw.
2. List of Files Paths to Scan
   1. List here the filepaths which include QVWs and QVDs to scan.  Separate multiple filepaths with vertical pipe | .
3. Files & Folders to Exclude

   1. List here the filenames (of QVWs and QVDs) and filepaths to EXCLUDE in the scan. Separate multiple exclusion patterns with vertical pipe | . For example, exclusion "govern" would exclude all files and folders containing the text "govern". This can be useful when this Governance Dashboard app is stored in a folder with other QVWs and QVDs that are to be scanned.

4. Server Log Path(s)
   1. List here the filepaths which include Server Logs scan.
   2. Separate multiple log filepaths with vertical pipe | .
5. Publisher Log Path(s)
   1. List here the filepaths which include Publisher Logs scan.
   2. Separate multiple log filepaths with vertical pipe | .
6. Repository (QVPR) Path(s)
   1. List here the filepaths which include QVPR files to scan.
   2. Separate multiple filepaths with vertical pipe | .
7. Months of History
   1. Select how many months of history to load in the Governance Dashboard.
   2. This will exclude any log files or QVWs and QVDs with filetimes older than the selected number of months back.
8. Heatmap & Concurrency Days
   1. Select how many days of session history to load for the Session Heatmap and Session Concurrency.
   2. This will determine the range of history presented in both the Heatmap and Session Concurrency charts.
   3. Note that the more days of history chosen here, the longer initial reload is expected.
   4. ** To change the session concurrency interval from a previously-selected interval, the following actions must be taken:
      1 - Remove the QVGD_SessionHeatmap_2.x.qvd
      2 - Remove the QVGD_SessionConcurrency_2.x.qvd
      3 - Reload the Governance Dashboard
9. Session Concurrency Interval
   1. Select the interval (minutes) for which to calculate session concurrency. Options are 1-Minute, 5-Minute, or 10-Minute interval.
   2. Note that the shorter the interval, the more time the reload will take to generate the associated concurrency data, but the more accurate the concurrency calculations will be.
   3. ** To change the session concurrency interval from a previously-selected interval, the following actions must be taken:
      1 - Remove the QVGD_Session*_2.x.Qvds: SessionHeatmap, SessionConcurrency, and Sessions.
      2 - Remove the QVGD_SessionConcurrency_2.x.qvd
      3 - Reload the Governance Dashboard
10. Keep extra fields for troubleshooting?
    1. Selecting "Yes" will retain certain fields for troubleshooting purposes. These are not needed for regular use of the Governance Dashboard.
    2. User Configuration Script?
    3. Use the UserConfig text file to manage all configuration settings.
    4. Type the filename (and path) of the userconfig script.
    5. For example: UserConfig.txt  or c:\ProgramData\QlikTech\Documents\UserConfigScript.txt
11. The UserConfig script expects the following variables: (* = required)
    1. vInputProfilePath *   (Profile directory)
    2. vInputFilePath     (File Paths to Scan)
    3. vInputServerPath   (Server Log paths)
    4. vInputPublisherPath   (Publisher Log paths)
    5. vInputQVPRPath    (QVPR paths)
    6. vInputMonthsOfHistory  (Months of History: default = 12)
    7. vInputDaysOfHeatmapHistory (Heatmap & Concurrency Days: default = 30)
    8. QMC Note: If you want to use the UserConfig option in QMC without opening and modifying the Governance Dashboard.qvw, set the task Reload Script Parameter name to vInputUserConfigFromQMC and the Parameter Value to the filename (path included) of the User Config .txt file.
12. Append custom PostScript?
    1. Use the PostScript option to append custom load script to the end of the Governance Dashboard script.
    2. Note that custom load script included here is not included in standard QlikTech support but would require Qlik Expert Services.
    3. Proceed with caution and enthusiasm.
13. Reload
    1. Reload the Governance Dashboard.

[jerrysvensson]

We use SQL Server as our QVPR database. How do we configure that?

[Tyler_Waterfall]

Jerry - We have not enabled reading SQL QVPR database. I will add this to the improvement list for 2.x.

Thanks for the question / request.

[Tyler_Waterfall]

Just updated this configuration page w/ an updated image and text.  Let me know if it is helpful - or not helpful!

[Tyler_Waterfall]

Another update (hopefully the last to the 2.0 Configuration page!).

Now with 2.0.032 you can use the "Files & Folders to Exclude" to exclude files and folders from the metadata scan (of QVWs and QVDs). Enjoy!

[#6]

Tyler, We just downloaded Governance Dashboard today. When we try to click on 'Reload' button. It does not do anything. What need to be done?

Thanks

[Tyler_Waterfall]

Hi Lakhbir -

Some questions -

1 - Are you opening the Governance Dashboard in qv.exe desktop (with a license)?

2 - After you click the button, can you continue to click around and navigate in the app?

3 - Can you try using the file menu option? File > Reload. Does this work?

[#8]

Tyler, Thanking for getting back to me.

Tyler, I think It's an license issue. Someone else ran it for me and  reload button works but throw error (log files location not found). He had license and He was running it on his desktop.

I will get back to you as soon as I get my license. I will let you know if it works or not.  

Thank a lot for your feedback.

[#9]

Hi Tyler

I was able to fix the license issue. When I run the dashboard it's throwing below error. I have to hit 'Ok' button 21 time to finish the process. It means, dashboard throw that error 21 times. At the end, it does give me some data back but I am not sure what this ERROR is about.

Some Facts:

I am running the dashboard on my desktop

I am Leasing the license from the server

Using UNC path to get to the files

Do we suppose to get anything else?

[Tyler_Waterfall]

Check the "Scan Details" page of the app.

Does it list the 21 errors there?

Note that you can click on that box with the error message and open a text file with a little more detail.

My guess is that it is failing to read metadata from a QVW - perhaps a corrupt QVW, a really old QVW, a QVW with section access, maybe?

It might also be that you have included the folder where this Governance Dashboard.qvw is stored in the "Files to scan". Or, the Profile directory for the Governance Dashboard - is a subfolder of this "Files to Scan" folder?