Importing HCL Workload Automation reports

This topic describes the Tivoli Common Reporting sample, historical and analytical reports available with HCL Workload Automation

1. Copy the packages from the installation media to the following path:

   On Windows operating systems:

   <JAZZSM_INSTALL_DIR>\reporting\cognos\deployment

   On UNIX and Linux operating systems:

   <JAZZSM_INSTALL_DIR>/reporting/cognos/deployment

2. From the navigation toolbar, click Reporting > Common Reporting. The IBM Cognos Connection interface is displayed.
3. Click Launch > Administration.
4. Select the Configuration tab.
5. Click Content Administration in the left-side pane.
6. Click the New Import icon and select one or more packages depending on which reports you want to import and the installed database type.
7. You can optionally select the reports to be imported for each package.
8. Maintain all the default values and follow the wizard.
9. Click Run to run the imported reports immediately.

Results

The following sample reports are available:

Table 1. Sample report types

Report Name	Description	Supported environment	Available in package
Job Run History	A report collecting the historical job run data during a specified time interval. It is useful to detect which jobs ended in error or were late, as well as critical and promoted jobs and the latest time within which the job can start without causing the critical job miss its deadline. It also shows which jobs missed their deadline, long duration jobs, and rerun indicators for reruns.	Distributed and z/OS	IWSReportsSamples _for_TCR.zip TWSReportsSamples _for_TCR_for_ zOS.zip
Job Run Statistics Chart	A report collecting the job run statistics, which returns output in chart format. It is useful to detect success, error rates; minimum, maximum, and average duration; late and long duration statistics; however, it might take some time to generate.	Distributed	IWSReportsSamples _for_TCR.zip
Job Run Statistics Table	A report collecting the job run statistics, which returns output in table format. It is useful to detect success, error rates; minimum, maximum, and average duration; late and long duration statistics.	Distributed	IWSReportsSamples _for_TCR.zip

The following analytical reports are available:

Table 2. Analytical report types

Report Name	Description	Supported environment	Available in package
Analysis Job Duration Estimation Error	A report that shows the average estimation error. It is useful to detect whether a job ends in frequent errors, ends in error, or if the jobs have unsatisfactory accuracy rates. You can then drill down to display all the jobs that are in that threshold and finally you can visualize charts that will help you to identify the jobs that have a high estimated error rate allowing you to intervene beforehand on those jobs. Note: When specifying the filter criteria for the Thresholds of this report, consider that the "Correct interval" threshold cannot be higher than the "Wrong interval".	Distributed and z/OS	Historical_ Report.zip Historical_ Report_ for_zOS.zip
Analysis Job Duration Standard Deviation	A report showing variances in job duration. The variance is calculated as a percentage and according to which variance level the jobs are they will be presented as follows: High variability, Medium variability or a Low variability. You can drill down to display all the jobs that are in that threshold which then returns output in a chart format. This report is useful to identify the run that had a greater duration.	Distributed and z/OS	Historical_ Report.zip Historical_ Report_ for_zOS.zip

Note: To be included in the analytical report, jobs must have a planned duration higher than 0 and have ran successfully

The following auditing report is available:

Table 3. Auditing report types

Report Name	Description	Supported environment	Available in package
Audit Reporting	A report that provides an audit trail, consisting of detailed information about the user who performed the change, the time and date when the change was performed, the reason why the change was implemented, and the details of the change for every modified item.	Distributed	Auditing_Report.zip

You can now use IBM Cognos to create and customize reports on the HCL Workload Automation database. For more information, see the IBM Cognos documentation.