topic Re: Configuring the Governance Dashboard 2.0 (Image) in Archived Groups

Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Thu, 08 May 2025 20:40:30 GMT

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.

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.
List of Files Paths to Scan
1. List here the filepaths which include QVWs and QVDs to scan. Separate multiple filepaths with vertical pipe | .
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.
Server Log Path(s)
1. List here the filepaths which include Server Logs scan.
2. Separate multiple log filepaths with vertical pipe | .
Publisher Log Path(s)
1. List here the filepaths which include Publisher Logs scan.
2. Separate multiple log filepaths with vertical pipe | .
Repository (QVPR) Path(s)
1. List here the filepaths which include QVPR files to scan.
2. Separate multiple filepaths with vertical pipe | .
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.
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
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
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
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.
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.
Reload
1. Reload the Governance Dashboard.

Re: Configuring the Governance Dashboard 2.0 (Image)

jerrysvensson — Fri, 08 Jan 2016 09:23:22 GMT

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

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Fri, 08 Jan 2016 12:43:06 GMT

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.

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Wed, 13 Jan 2016 20:54:51 GMT

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

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Tue, 19 Jan 2016 16:40:55 GMT

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!

Re: Configuring the Governance Dashboard 2.0 (Image)

Thu, 18 Feb 2016 17:09:48 GMT

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

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Thu, 18 Feb 2016 18:59:55 GMT

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?

Re: Configuring the Governance Dashboard 2.0 (Image)

Thu, 18 Feb 2016 19:59:56 GMT

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.

Re: Configuring the Governance Dashboard 2.0 (Image)

Fri, 19 Feb 2016 15:28:36 GMT

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?

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Fri, 19 Feb 2016 18:46:25 GMT

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?

Re: Configuring the Governance Dashboard 2.0 (Image)

davidmc1 — Thu, 25 Feb 2016 14:27:32 GMT

Great stuff Tyker, thank you very much!

I have an issue with publisher tasks execution date/time.

Any suggestions?

Thanks!

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Fri, 26 Feb 2016 21:54:47 GMT

Thank you David.

Concerning Publisher timestamp format, can you open one of the TaskExecutionHistory.xml files in E:\QlikView\Publisher\TaskExecutionHistory\ folder and copy one of the lines of the xml? (Mainly interested in the timestamp format used).

Also, tell me - are you reloading the Governance dashboard on a machine set with the same locale settings (like windows datetime format) as the server running QV Publisher?

Re: Configuring the Governance Dashboard 2.0 (Image)

davidmc1 — Mon, 29 Feb 2016 07:35:16 GMT

Hi Tyler;

Same locale settings, same windows datetime format:

Thank you!

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Mon, 29 Feb 2016 19:32:20 GMT

David -

Gracias por la información. Yo pensé que eso no sucedería si la applicación fuera updated en un servidor o ordenador que usara la misma config de fecha y hora. Pero parece que esto no es el caso.

Voy a escribir algo sobre este tema pronto y te avisaré cuando ya esté listo.

David - thanks for the info. I though this wouldn't happen if the app were reloaded on a server or computer with the same datetime settings. But it looks like that's not the case.

I will be posting something about this shortly.

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Wed, 02 Mar 2016 15:01:12 GMT

See Governance Dashboard Publisher timestamp issue

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Tue, 08 Mar 2016 14:53:19 GMT

All -

The Governance Dashboard 2.0.1 is now available! This SR1 fixes the Complexity Analysis issue present in v 2.0.

Find it on Qlik Market: QlikView Governance Dashboard

Or on the main Qlik download site.

No other changes here - so you can just copy the values from your current 2.0 app into the configuration and run with it.

Thanks!

Tyler

Re: Configuring the Governance Dashboard 2.0 (Image)

Anonymous — Tue, 29 Mar 2016 20:06:23 GMT

Hello Tyler,

I also received the error about hidden files.

Mine shows

2016-03-29 12:56:28

"86 errors encountered during this reload: General Error

This is loaded on a terminal server pointing to our production box.

The directory the Governance Dashboard is in is not located within the scanned path.

Thank you.

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Wed, 30 Mar 2016 14:57:39 GMT

Darrin -

We would need more information to troubleshoot. Can you unhide the script (open the script editor, File > Edit Hidden Script > put in the password as it states in the load script) and then reload the app. Capture the error message.

Note that the 86 errors encountered ... might be due to improperly formed metadata in apps - will not cause a reload failure (in majority of cases).

But send a screen capture of the error message when the script is unhidden. Thanks!

Re: Configuring the Governance Dashboard 2.0 (Image)

Anonymous — Wed, 30 Mar 2016 18:42:30 GMT

Looks like it was a typo on one of the paths for the log files. All is working properly.

Thank you.

Re: Configuring the Governance Dashboard 2.0 (Image)

Tyler_Waterfall — Wed, 30 Mar 2016 20:35:27 GMT

That was easy! Glad it's working now.