Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

QMC Task & QVD Analyser & QSR DB Viewer - No Data.qvf

cheenu_janakira
Contributor

QMC Task & QVD Analyser & QSR DB Viewer - No Data.qvf

  1. View Task Information (runs in a few seconds based on info in QSR, as opposed to full log files);
  2. View QVD information (tables and names) and
  3. View QSR tables and names for further development of app and needs.



Please share your work for unlocking server information in QSR.


Creating LIB connection to QSR:

1. Use "Qlik ODBC Connector Package": driver for 'PostgreSQL'.

2. Hostname = 'localhost'.

3. Port = '4432'.

4. Database = 'QSR'.

5. User name = 'postgres'.

6. Password = '[insert the QlikSense super user password]'.

Extensions needed:

QlikSense Timeline

http://branch.qlik.com/#!/project/56728f52d1e497241ae697ef

Script adjustments:

1. Fields "[... - Adjusted Time] have been added in due to using AWS server where machine time was not local time. Edit the script with a new 'time difference' (referred to in the variables) even if it is "zero/nil".

2. Suggested reload task scheduling: every one hour.

3. Adjust QVD information reload (look at if/then/else statements using "QVDcreatetime()" in order to minimise 'unnecessary' long reloads. QVDs don't need to be analysed more that on a daily basis.

4. Edit the "Full_Paths_To_Folder" table to include all the LIBs where your QVDs reside.

CONTENT in Sheets:


1. Daily Tasks - Waterfall

Gantt chart of tasks. Use "Task Date Grouping" to view 24 hour of reloads.

Since our reloads run from 6PM onwards, each 'grouping' runs from 6PM one day to the next. You can edit this in the script at "Hour([Task Execution Start Time]) >= 18" by changing the start time (24-hour clock, where 18 is 6PM).

2.Task Time Analysis & Details

Bar chart: Average times for reloads.

Tables: Unsuccesful reloads.

Variations in Reload Time (based on one standard deviation of task reload time).

Reload Details.

3. Task Intensity

Bar-chart: Number of tasks & QVD Records generated by (reload start) Hour of Day.

Table: Task Intensity based on Averages.

4. Task Duration Trend over time

Line chart: Trend of Task Duration over time.

5. Cumulative Task Reload Time by Hour of Day

Line chart: Task Duration by Task Start Hour (of day)

6. Current Users

Table showing potential current logged in users. 'Potential' because it is based on 'last activity' within past 2 hours. I don't know how/when this data gets updated in QSR.

7. QVD Tables & Fields

Tables

8. QSR Table & Columns

Table containing QSRs tables and fields.

Tags (1)
Attachments
Version history
Revision #:
1 of 1
Last update:
‎08-23-2017 05:50 PM
Updated by: