Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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?
Have you read this: might be helpful in your monitoring
Improving Governance / Monitoring Apps in Sense (Operations Monitor, License Monitor)