article QlikView Governance Dashboard - June 2019 is now available! in Member Articles

QlikView Governance Dashboard - June 2019 is now available!

John_Teichman — Wed, 21 Sep 2022 17:07:35 GMT

Hello all Qlikkies!

QlikView Governance Dashboard: provides QlikView customers with an easy way to determine how compatible and convertible their QV apps are to Qlik Sense -- using a customizable "Sense Profile Score" that assists them in their planning and implementation efforts to migrate from QlikView to Qlik Sense. The App include new "Sense Profile" sheet with tables showing

Sense Profile Score: Composite score of weighted User Adoption, Object Density, and Object Compatibility scores.
User Adoption Score: How much is each app used and how recently? (Graded usage count for past 90 days.)
Object Density Score: How many sheet objects per sheet in the QV App? (Over 12 can be difficult to re-create in a Sense app!)
Object Compatibility Score: How many QV sheet objects in each app are not compatible in Sense?

Additional features included:

Unused Sheets by app to indicate which sheets should be considered for removal before re-scoring and prioritizing for migration to Sense.
Custom Configuration of profile scoring -- threshold and relative weight of each component of the Sense Profile Score.

Qlik Sense License monitor: Allows Qlik Sense Administrators ability to holistically monitor their analyzer & professional license consumption across QlikView & Qlik Sense (windows, eFe & QCS deployments) to answer the following business questions:

Are we running out of licenses?
What is the history of usage?

*This needs to be done at a aggregate level without violating GDPR regulations on personal data

Re: QlikView Governance Dashboard - June 2019 is now available!

nenadvukovic — Tue, 10 Sep 2019 13:35:56 GMT

Hi John,

The latest version I was able to find in the QV section is 2.1.2, and this has one has several bugs. For example:

Thank you

Re: QlikView Governance Dashboard - June 2019 is now available!

sascha_holland — Mon, 23 Sep 2019 15:28:45 GMT

Hello,

with the versions 2.1.1 and 2.1.2, I'm getting the following error:

Field not found - <AuditTimestamp>
Join (SOE)
Load
Replace(Audit_FileName,'/','\') & '|Document\' & Replace(AuditId,'Document\','') AS ObjectKey,
Sum(Audit_Count) as sense_profile_sheet_audit_count
Resident SessionTaskAuditMaster
Where AuditTimestamp >= 43641
AND (AuditType = 'Sheet'
OR (AuditType = 'Document' AND AuditMessage = 'Open')
)
Group by Audit_FileName,AuditId

Version 2.0.2 works flawlessly...

Thanks in advance

Re: QlikView Governance Dashboard - June 2019 is now available!

nenadvukovic — Tue, 24 Sep 2019 08:11:08 GMT

Hello,

I was able to get 2.1.2 work after activating the "Enabling Audit Logging" and setting the "Split Files to Daily" logging properties in the QMC.

Thanks

Re: QlikView Governance Dashboard - June 2019 is now available!

sascha_holland — Tue, 24 Sep 2019 13:28:31 GMT

Hello Nenadvukovic,

"Enabling Audit Logging" in QMC did it for me, thanks a lot!

BR Sascha

Re: QlikView Governance Dashboard - June 2019 is now available!

PabloOrtiz — Tue, 24 Sep 2019 13:46:18 GMT

Hello, i have the same error:

2019-09-24 13:40:16 2623 Join (SOE)
2019-09-24 13:40:16 2624 Load
2019-09-24 13:40:16 2625 Replace(Audit_FileName,'/','\') & '|Document\' & Replace(AuditId,'Document\','') AS ObjectKey,
2019-09-24 13:40:16 2626 Sum(Audit_Count) as sense_profile_sheet_audit_count
2019-09-24 13:40:16 2627 Resident SessionTaskAuditMaster
2019-09-24 13:40:16 2628 Where AuditTimestamp >= 43642
2019-09-24 13:40:16 2629 AND (AuditType = 'Sheet'
2019-09-24 13:40:16 2630 OR (AuditType = 'Document' AND AuditMessage = 'Open')
2019-09-24 13:40:16 2631 )
2019-09-24 13:40:16 2632 Group by Audit_FileName,AuditId
2019-09-24 13:40:16 Error: Field 'AuditTimestamp' not found
2019-09-24 13:45:28 Falló la Ejecución
2019-09-24 13:45:28 Ejecución finalizada.

Re: QlikView Governance Dashboard - June 2019 is now available!

nenadvukovic — Tue, 24 Sep 2019 13:51:30 GMT

Pablo, try this: activate the "Enabling Audit Logging" parameter and set the "Split Files to Daily" logging properties in the QMC.

Re: QlikView Governance Dashboard - June 2019 is now available!

PabloOrtiz — Tue, 24 Sep 2019 15:24:06 GMT

Hi, Nenadvukovic, i checked it, but the same reults, error.

thanks.

Re: QlikView Governance Dashboard - June 2019 is now available!

felipestall — Tue, 03 Dec 2019 19:48:48 GMT

How do I download this?

Re: QlikView Governance Dashboard - June 2019 is now available!

Nicole_Tamms — Tue, 03 Dec 2019 20:41:18 GMT

You can download the Governance Dashboard from the Qlik Download site: https://us-b.demo.qlik.com/download/ Search for "Governance Dashboard" and away you go!

Thanks,

Nicole Tamms

Sr. PMM

Re: QlikView Governance Dashboard - June 2019 is now available!

felipestall — Tue, 03 Dec 2019 20:49:05 GMT

The downloads link take me to a page different than the usual.

Then when I click "View resources" it takes me to a blank page...

Re: QlikView Governance Dashboard - June 2019 is now available!

Nicole_Tamms — Tue, 03 Dec 2019 20:54:05 GMT

From the Qlik.com home page, go to Support, Product Downloads and Upgrades, Login, click Search (upper right hand side): Governance Dashboard.

Thanks,

Nicole

Re: QlikView Governance Dashboard - June 2019 is now available!

PabloOrtiz — Tue, 10 Dec 2019 15:25:27 GMT

Hello,

Thanks Nenadvukovic

At last it works

1. Activate the "Enabling Audit Logging" parameter

2. Set the "Split Files to Daily" logging properties in the QMC.

3. RESTART SERVICES

Re: QlikView Governance Dashboard - June 2019 is now available!

Brett_Bleess — Wed, 15 Apr 2020 13:11:37 GMT

You can find the latest Governance Dashboard application at the following link:

https://community.qlik.com/t5/Qlik-Monitoring-Administration/QlikView-Governance-Dashboard/gpm-p/1578596

The one on the download site is not likely the latest version... The above page is where any new versions will be placed. The Help site link has been changed as well.

Regards,
Brett