QlikView Governance Dashboard - June 2019 is now available!

[John_Teichman]

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

[nenadvukovic]

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

[sascha_holland]

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

[nenadvukovic]

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

[sascha_holland]

Hello Nenadvukovic,

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

BR Sascha

[PabloOrtiz]

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.

[nenadvukovic]

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

[PabloOrtiz]

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

thanks.

[felipestall]

How do I download this?

[Nicole_Tamms]

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

[felipestall]

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...