topic Re: Report Utilization Dashboard in QlikView

Report Utilization Dashboard

Fri, 22 May 2015 17:09:45 GMT

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

Re: Report Utilization Dashboard

Clever_Anjos — Fri, 22 May 2015 17:39:08 GMT

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

Re: Report Utilization Dashboard

Tue, 26 May 2015 20:07:13 GMT

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

Re: Report Utilization Dashboard

Clever_Anjos — Tue, 26 May 2015 20:26:53 GMT

Sorry, @rtz have removed the Audit Sheet

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

Re: Report Utilization Dashboard

Wed, 27 May 2015 17:55:38 GMT

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

Re: Report Utilization Dashboard

Clever_Anjos — Wed, 27 May 2015 18:04:04 GMT

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

Re: Report Utilization Dashboard

MarcoWedel — Wed, 27 May 2015 18:44:11 GMT

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

Re: Report Utilization Dashboard

Wed, 27 May 2015 20:18:24 GMT

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

Re: Report Utilization Dashboard

Wed, 27 May 2015 20:20:22 GMT

Hi Marco,

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

Regards,

Janaki

Re: Report Utilization Dashboard

Clever_Anjos — Wed, 27 May 2015 20:30:17 GMT

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

Re: Report Utilization Dashboard

Thu, 28 May 2015 20:59:04 GMT

Hi Clever,

I am having issues joining the two tables

1. Document Name, Sheet ID, User Name (From Audit logs which contains dashboards that are not longer used)

2. Document Name, Sheet ID, Sheet Name (From the code above)

Regards,

Janaki

Re: Report Utilization Dashboard

Clever_Anjos — Thu, 28 May 2015 21:09:05 GMT

What kind of issues?

Re: Report Utilization Dashboard

Thu, 28 May 2015 23:14:29 GMT

Hi Clever,

In Table 1 like I mentioned above I get old dashboard details which I don't want anymore. I am not able to make a unique id for both the tables because of that.

Table 1

Audit_Log:

LOAD

//[Server Started],

//Timestamp,

SubField(Document, '\', 4) as DashboardName,

//Type,

User,

// Message

//SubField(Message, 'SH', 2) as Message,

('SH' & SubField(Message, 'SH', 2)) as SheetID

//DashboardName & ' ' & SheetID as PrimaryKey

FROM

(txt, utf8, embedded labels, delimiter is '\t', msq)

where Type = 'Sheet';

Table 2

Set vDocument=C:\DashboardQVW\*.qvw;

Sheets:

LOAD SubField('$(vDocument)', '\', 😎 as DocumentName,

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

Title as SheetName

// DocumentName & ' ' & SheetID as PrimaryKey

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

Re: Report Utilization Dashboard

Clever_Anjos — Fri, 29 May 2015 12:53:30 GMT

Would you mind posting your qvw?

Re: Report Utilization Dashboard

Fri, 29 May 2015 15:02:47 GMT

Hi Clever,

Sorry but the qvw file has details that I cannot share and I am not able to create a dummy qvw.

Regards,

Janaki