AE DB Reporting Tool

The utility AE DB Reporting Tool (ucydbrt) provides evaluation reports about tasks within your AE system depending on whether you query object contents (definitions), future executions (forecasts) or past executions (statistics). For example, you can list all jobs that were processed in a specific period, or were created by a specific user. Queries always refer to one client.

This page includes the following:

Overview

This utility has a graphical user interface where you define and store your evaluation criteria called queries. You can define as many queries as you like. Once the queries are defined, you can start the utility in batch mode. Data is retrieved from the client in which the query is defined.

The formats CSV and HTML are available for your report files and you can specify a stylesheet of your choice for HTML which is integrated in the report file.

Important!

Create Queries by Using the Reporting Tool's GUI

The graphical user interface is available on UNIX and Windows. Use following command to start it: java -jar ./ucyrepg.jar

To Create Queries

  1. Select New query in the File menu or right-click the corresponding submenu item in the left window half. An assistant opens and guides you through the various definitions that can be made.
  2. Assign a significant query name 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.
  3. Select the fields that should be shown in the evaluation report. Click the arrow buttons to sort the columns.
    Tip: To have columns automatically sorted, set the parameter fixFieldOrder=1 in the INI file.
  4. In the next dialog, you can specify the filter criteria that should be used as the basis for the evaluation.
    Tip: 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.
  5. Determine the report's name, the maximum number of lines that should be output and the output order. You can define the report's format (CSV or HTML) and in HTML you can even integrate a stylesheet.
  6. Click Finish to store your definitions.

Stored queries are listed in the left window area in their corresponding evaluation areas. You can change your definitions at any time by double-clicking a query. The right window then shows all entries where you can make your changes. You can even open several queries at a time. The tabs at the upper edge can be used to navigate between the individual form sheets.

Query File Formats

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

Example

The following example shows a query that returns a list of all a client's jobs that use a specific 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 specific host by adding the criterion "Host corresponds to WIN01".
  4. Determine a name for the output file and the maximum number of lines.
  5. Call the utility in batch mode and indicate the created query file as a parameter to create the evaluation report.

Create Evaluation Reports

The utility creates reports in batch mode. Call it from the command line by using the following parameters:

UCYBDBRT -Xquery file [-Cclient -IINI file-Llanguage -Rreference date -S-Ooutput file-Tfile type]

All parameters are optional, only the query file must be specified. For a list of all values, see Start Parameters - Utilities.

In batch mode, this utility reads the information for the evaluation report directly from the AE database. You can specify the parameters for the database in the corresponding configuration file, see Utility DB Reporting Tool.

The following line shows an example. An evaluation report is created from the query that is defined for client 100 in the file jobtop10.d.xml.

UCYBDBRT -C0100 -XC:\AUTOMIC\Utilities\evaluation_reports\jobtop10.d.xml

The information that is provided in the report depends on the fields you defined in your query. The following fields are available for all the three evaluation areas, for definitions, forecasts and statistics, unless otherwise stated:

XML Files of Queries

Queries are stored in the sub-folder "queries" in the form of XML files that the utility generates. No manual adjustment is required for these entries that include the following parameters:

Example of a Query File

<?xml version="1.0" encoding="UTF-8" ?>
<QUERY version="12.1.0">
<file type="CSV">Output_SAPjobs.html</file>
<client>0098</client>
<max_rows>1000</max_rows>
<source>DEFINITION</source>
<selection>
<include name="OBJECT_TYPE" value="JOBS" />
<include name="JOB_TYPE" value="R3" />
<include name="OBJECT_NAME" value="*T01*" />
</selection>
<output order="ascending" sort="OBJECT_NAME">
<field name="OBJECT_NAME" />
<field name="LOGIN" />
<field name="SAP_CLIENT" />
<field name="SAP_USER" />
<field name="MODIFIED_DATE" />
<field name="LAST_USE_DATE" />
</output>
</QUERY>

See also:

Start Parameters - Utilities