3.2.2 Outputting aggregated data to periodic reports

To output periodic (for example, weekly or monthly) reports, download the aggregated Item data from the Item management server and then execute an Excel macro.

Prerequisites

This operation is performed by the incident management administrator or the problem management administrator.

Procedure

1. In the main window (Item list view), click the Switch from the main screen button .

   

   The main window (Item status view) appears.

2. From the menu of the main window (Item status view), select Accumulation data output to file.

   

   The Accumulation data output to file window appears.

3. Specify conditions about the aggregated data to be output.

   Specify settings, by referring to the examples in the following table.

   Item	Configuration information
   System	Business system
   Process	Incident management
   Accumulation unit	Day unit
   Accumulation range	2015/10/01 to 2015/10/31
   Data type	[Item data CSV]

   Note

   The aggregated data to be output varies depending on Data type. For details, see Outputting accumulated Item data to a file in the JP1/Service Support Configuration and Administration Guide.

4. Click the Download data button.

   The dialog box for downloading the aggregated data appears.

5. Save the aggregated data in a location of your choice.

6. From the menu of the Accumulation data output to file window, select Download macro.

   

   The dialog box for downloading the macro appears.

7. Save the macro in the location where you saved the aggregated data in step 5.

8. In Excel, open the macro that was saved in step 7.

   

   Note

   If Security Warning Macros have been disabled appears, click the Options button to display the Microsoft Office Security Options dialog box. In the dialog box, select Enable this content, and then click the OK button.

9. Select the report to be created, and then click the Generate report button.

   In this example, select Average required time and then click the Generate report button.

   The macro runs, and the report is automatically created.

Related topics

• Outputting accumulated Item data to a file of the JP1/Service Support Configuration and Administration Guide

To Page Top