Qlik Sense QVD load monitoring

[AlipNath]

Hello Qlik Friends!

We are looking at best practices /techniques to keep track of QVD loading process on a daily basis.

Basically, a handy way to have a summary dashboard which would show the rows loaded on a full load, daily incremental load status and all the other good stuffs.

I am thinking of building a quick stop app for the purpose.

Any pointers would really help!

Thanks,

Alip

[Gabriel]

Hi,

I think you need possibly SUB Routine to handle a script like this

QVDTracker:

LOAD

'$(vStoredTableName)'                                                                 AS [Table Name],

QVDTABLENAME('$(vStorePath)$(vStoredTableName).QVD')       AS [QVD Name], QVDNOOFFIELDS('$(vStorePath)$(vStoredTableName).QVD')     AS [QVD No Of FIelds],

QVDNOOFRECORDS('$(vStorePath)$(vStoredTableName).QVD') AS [QVD No Of Records]

AUTOGENERATE(1);

Hopefully this starts an idea for you.

[AlipNath]

Hello Good People,

Hoping if some one has already been working on a App like this as yet.

I tried create an app as per suggestions from Gabriel above. However, that approach has limitation in terms findings details on total load time at each run and the corresponding tasks.

I understand the OOB monitoring app Operation Monitor captures a quite bit of details at task reloads level.

Has anyone worked on similar app or have re-engineered the same?

[rupamjyotidas]

Have you read this: might be helpful in your monitoring

Improving Governance / Monitoring Apps in Sense (Operations Monitor, License Monitor)