Administration Guide > Utilities > AE DB Reporting Tool > Graphical Interface of the Reporting Tool

 Graphical Interface of the Reporting Tool

You can define evaluation criteria by using the utility's graphical interface.

This view consists of two halves. The left side shows a tree structure which includes the three areas of evaluation:

Your queries for the evaluation reports are listed below the three main areas.

The right side of the view supplies information about your queries and can be used for the subsequent modification of the corresponding criteria.

Depending on the language settings specified on your computer, the interface is displayed either in German, English or French.

Starting the Reporting Tool's Interface 

This utility's graphical interface is available on UNIX and Windows.

You can use the following command in order to start the utility (UNIX and Windows):
java -jar ./ucyrepg.jar

Creating Queries

Call the required evaluation area by using the menu File -> New query or right-click the corresponding submenu item in the left window half. An assistant opens and guides you through the various specifications that can be made.

  1. Assign a significant name for the query and a client. A period must be assigned in forecasts and statistics. If you select the option "Today", the utility uses the current date for creating the report. If you select "Now", the current date plus the time are used.
    The specified client's time zone is used for evaluations. If it does not include any time-zone specifications, the system uses the time zone of client 0.
  2. Select the fields that should be shown in the evaluation report. Click the arrow buttons in order to sort the columns.
     Note that the utility automatically sorts columns if the parameter fixFieldOrder=1 has been specified in the INI file.

  3. Use the next mask in order to specify the filter criteria that should be used as the basis for the evaluation.
     Specify the object type Job in the filter criteria if the fields that should be shown in the evaluation report occur in jobs. For example: Login object. The utility automatically inserts this filter criterion.

  4. Determine the report name, the maximum number of lines that should be output and the output order. The report format can also be specified. In HTML, you can also integrate a style sheet.

The Finish button stores the specified evaluation criteria. Specifications can be changed subsequently by double-clicking the query. Stored queries are listed in the left window area below the corresponding evaluation area. The right window then shows a list of all forms. Modify the settings if necessary and store your modifications by using the shortcut CTRL-S or the corresponding command in the menu bar.

You can open several queries at a time. The tabs at the upper edge can be used to navigate between the individual form sheets.

Query Files

The utility stores your queries in the subfolder "queries" in the form of XML files. The file endings depend on the area that has been queried:

By calling the utility in batch mode using the specified evaluation criteria, you can create reports.

Example 

The following example shows a query that returns a list of all a client's jobs that use a particular host (WIN01) in the evaluation report.

  1. Create a new query, assign a suitable name and select a client.
  2. Select the following fields that should be displayed in the output file: object name, object type, host and host type.
  3. Selection criteria: After selecting "Host" as a field in the evaluation report, the filter "Object type corresponds to JOBS" is automatically inserted. You can select a particular host by adding the criterion "Host corresponds to WIN01".
  4. Determine a name for the output file and the maximum number of lines.

Call the utility (UCYBDBRT) in batch mode and indicate the created query file as a parameter in order to create the evaluation report.

 

See also:

Task Evaluations
Creating Evaluation Reports