Report Utilization Dashboard

[#1]

Hi,

I was wondering if there any dashboard/report which we can use to track which dashboards and which sheets on each dashboard are being visited widely. I went through the Audit logs and also tried using the sheet details that I could extract from the Document Analyzer to produce a particular dashboard.

Below is the code to extract details from Document Analyzer qvw:

Set vDocument=C:\Project\QlikView\XYZApp.qvw;   

  Sheets:

  LOAD '$(vDocument)' as DocumentName,

  SubField(SheetId, '\', 2) as SheetID,

  Title as SheetName

  FROM [$(vDocument)] (XmlSimple, Table is [DocumentSummary/Sheet]);

Regards,

Janaki

[Clever_Anjos]

There´s one application ready for this: QlikView Application: System Monitor v5.1.23

[#3]

Hi Clever,

The System Monitor doesn't provide the details I am looking for.

This is the chart/table I am looking for

Dashboard Name

User Name

Sheet ID

Sheet Name

Time-stamp

Can get the Dashboard Name, Sheet ID, Time-stamp and User Details from Audit Logging. Need to map that Sheet ID with the Sheet ID that I will get from the above code and also get the respective sheet name.

Hope I explained in detail.

Regards,

Janaki

[Clever_Anjos]

Sorry, @rtz have removed the Audit Sheet

Please refer to this doc : https://community.qlikview.com/docs/DOC-4332 QVS Audit Log sheet

[#5]

Hi Clever,

The QVS Audit Sheet is great but it doesn't provide me with the Sheet Name and Username mapping. It provides me just with the Sheet ID.

Regards,

Janaki

[Clever_Anjos]

I don´t think Sheet Name is stored into QVS logs, could you check this?

[MarcoWedel]

Hi,

you should also take a look at the Governance Dashboard:

QlikView Governance Dashboard 1.0

QlikView Governance Dashboard 1.1 SR1 Available for Download

regards

Marco

[#8]

Hi Clever,

To get Sheet Name I used the below code:

Set vDocument=C:\Project\QlikView\XYZApp.qvw; 

  Sheets:

  LOAD '$(vDocument)' as DocumentName,

  SubField(SheetId, '\', 2) as SheetID,

  Title as SheetName

  FROM [$(vDocument)] (XmlSimple, Table is [DocumentSummary/Sheet]);

I am looking for a way to map these two tables using Document Name & Sheet ID. One which I get from Audit Logs and the other one I get from Individual Dashboards (using the above code).

But I am having some issues.

Regards,

janaki

[#9]

Hi Marco,

Thanks for the reply but Governance Dashboard doesn't give me the table structure/data that I need.

Regards,

Janaki

[Clever_Anjos]

Well, you could start with SystemMonitor, add your script and create a link between your table and remaing tables.

So you could add SheetName to that report