Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have a large and complicated document which needs a clean out.
Specifically, we are looking to remove objects, fields and possibly even sheets that are rarely if ever used.
What I am hoping to get from the GD is a report that will list the objects/fields and include a date/time field showing when the objects were last used and/or indeed the amount of times they are used.. From this, we would ascertain what can be stripped out.
Does anyone know if this type of report exists in the GD?
If not, can anyone suggest the best way of going about this work? The less time-consuming the better!
We do intend to recreate a fully revised version of the document in a future project.
For now, we are looking to spend some time reducing the footprint of the current document.
Thanks in advance,
Ciaran
Ciaran Hayes - You have a very common desire - one which I personally have felt when I was a Qlik developer at my previous company.
The Governance Dashboard can support your efforts to some degree, though you will find some large gaps in getting a complete and accurate view of which objects are and are not being used.
GD does include:
What's missing from the GD is a more complete object-level user activity log:
Some of this missing data in the Audit.log files will become available with 11.20 SR9.
Also, stay tuned for other tools specifically focused on meeting the need that you describe.
Thanks for this Tyler.
For now, I am focussing on the User Activity (Audit Log) report.
Taking a count of sheet occurrences will help in some way to narrow down what is important and what is less so.
If you come across a better method in the meantime, please let me know.
Thanks again,
Ciaran