1.5.3 Windows for creating and editing report definitions

The windows for creating and editing report definitions are used to create a new report definition and to change an existing report definition. To display these windows, in the Reports window, from the method frame, choose either New Report or Edit.

The following describes each window.

Organization of this subsection

(1) New Report > Name and Type window or Edit > Name and Type window
(2) New Report > Field window or Edit > Field window
(3) New Report > Field > Search Fields or Edit > Field > Search Fields window
(4) New Report > Filter window or Edit > Filter window
(5) New Report > Indication Settings window or Edit > Indication Settings window
(6) New Report > Components window or Edit > Components window
(7) New Report > Graph window or Edit > Graph window
(8) New Report > Drilldown window or Edit > Drilldown window
(9) New Report > Drilldown > Select Report window or Edit > Drilldown > Select Report window
(10) New Report > Drilldown > Edit Conditional Expression for Drilldown window or Edit > Drilldown > Select Report > Edit Conditional Expression for Drilldown window

(1) New Report > Name and Type window or Edit > Name and Type window

The New Report > Name and Type window or Edit > Name and Type window is used to specify a name for a report definition, the product to be reported on, and the type of report.

The following figure shows the New Report > Name and Type window.

Figure 1‒82: New Report > Name and Type window

The following describes the items displayed in these windows:

Cancel button

Displays a message box for confirming your intention to cancel the operation. Clicking the OK button in the message box cancels the processing and clears the information frame.

Next > button

Displays the New Report > Field window or Edit > Field window. When a new report is being created, this button is enabled only when entries have been made in Report name and Product.

Finish button

For creating a new report

This button is displayed only when a value has been set in the window displayed by clicking the Next > button. Clicking the Finish button saves the settings.
For editing an existing report

Clicking the Finish button saves the settings.

Report name

For creating a new report

Enter a report definition name by using 1 to 64 single-byte or two-byte characters. You can enter both single-byte and two-byte characters for a report definition name.
For editing an existing report

Displays the report name. This name cannot be changed.

Product

For creating a new report

Select the type (product) of PFM - Agent or PFM - RM for which the report is set. If multiple data model versions are installed for a single product, also select the data model version to be used.
For editing an existing report

This information cannot be changed.

Report type

Select one of the following as the report's type:

Realtime (Single Agent)

Select this to display, as a realtime report, the performance data of one instance of PFM - Agent or PFM - RM.
Historical (Single Agent)

Select this to display, as a historical report, the performance data accumulated by one instance of PFM - Agent or PFM - RM.
Historical (Multiple Agents)

Select this to display in one window, as a historical report, the performance data accumulated by multiple instances of PFM - Agent or PFM - RM. If you select this item, you cannot select a multi-instance record in the New Report > Field window or the Edit > Field window.

To Page Top

(2) New Report > Field window or Edit > Field window

The New Report > Field window or Edit > Field window is used to specify the fields that you want to display in reports.

The following figure shows the New Report > Field window.

Figure 1‒83: New Report > Field window

The following describes the items displayed in these windows:

Description (next to the window title)

Displays the Description of Record and Fields window, which describes the record selected in Record in the New Report > Field or Edit > Field window and its fields, as a separate window.

Cancel button

Displays a message box for confirming your intention to cancel the operation. Clicking the OK button in the message box cancels the processing and clears the information frame.

< Back button

Returns to the New Report > Name and Type window or the Edit > Name and Type window.

Next > button

Displays the New Report > Filter window or the Edit > Filter window.

When a new report is being created, this button is enabled only when there is at least one field set in Selected fields.

Finish button

For creating a new report

This button is displayed only when a value has been set in the window displayed by clicking the Next > button. Clicking the Finish button saves the settings.
For editing an existing report

Clicking the Finish button saves the settings.

Record

From the pull-down menu, select a record to be reported. The text box displays the selected record's type ((This is a single-instance record.) or (This is a multi-instance record.)). A single-instance record is a record consisting of a single row, and a multi-instance record is a record consisting of multiple rows.

If in the New Report > Name and Type window or the Edit > Name and Type window, Historical (Multiple Agents) is selected for Report type, only single-instance records are displayed in the pull-down menu.

Description button

Displays the Description of Record and Fields window, which describes the record selected in Record and its fields, as a separate window.

Search Fields button

Displays the New Report > Field > Search Fields or Edit > Field > Search Fields window. This button is not displayed if the data model description file has not been stored. If the data model description file has not been stored, see the PFM - Web Console setup procedure to register PFM - Agent or PFM - RM. For details, see the chapter that explains installation and setup in the JP1/Performance Management Planning and Configuration Guide.

For details about the New Report > Field > Search Fields or Edit > Field > Search Fields window, see 1.5.3(3) New Report > Field > Search Fields or Edit > Field > Search Fields window.

All fields

Displays a list of the fields in the record that was selected in Record. Use the [Figure] and buttons to move into Selected fields the fields that you wish to display in the report.

You can use the Shift and Ctrl keys to select multiple fields.

button

Moves the fields selected in All fields to Selected fields.

button

Moves the fields selected in Selected fields back to All fields.

Selected fields

Displays a list of the fields that you wish to have displayed in the report. In the case of a report in table or list format, the fields are displayed in the order they are displayed here. You can use the [Figure] and buttons to change the order of fields.

button

Moves the field selected in Selected fields so that it precedes the field immediately above it. You can move multiple fields together.

button

Moves the field selected in Selected fields so that it is below the field located immediately below it. You can move multiple fields together.

Explanation of fields:

Displays an explanation of the fields selected in either All fields or Selected fields.

To Page Top

(3) New Report > Field > Search Fields or Edit > Field > Search Fields window

This window can be used to search fields by their characters. You can search a maximum of 50 fields by default. The fields found by the search can be set for Selected fields in the New Report > Field or the Edit > Field window, from which this window was displayed.

The maximum search number can be set in searchLimit of the initialization file (config.xml). For details about the initialization file (config.xml), see Initialization file (config.xml).

Note that if you select a record here that is different from the one selected in the New Report > Field or the Edit > Field window, from which this window is opened, the fields selected in that previous window will be cleared.

The following figure shows the New Report > Field > Search Fields window.

Figure 1‒84: New Report > Field > Search Fields window

The following describes the displayed items:

Cancel button

Displays the New Report > Field > Search Fields window or the Edit > Field > Search Fields window again.

Keywords to find

Enter a maximum of 64 characters for the search keywords (including spaces as delimiters). Observe the following precautions related to a search:

To perform a multiple keywords search by using AND, delimit keywords by using a single-byte or two-byte space.
An OR search cannot be performed.
Wildcard characters cannot be used.
A keyword search that consists only of spaces cannot be specified.
Spaces entered at the beginning and ending of a keyword are excluded.
If the search keyword includes spaces, the search will not be performed as intended.
The search is not case sensitive.
In the search keyword, a two-byte character and a single-byte character are recognized as different characters.
A search keyword that includes a line feed code cannot be entered.

After entering the search keyword, click the Search button. The search results will be displayed.

Search results are displayed, depending on the selection in the Records to search pull-down menu, in the following different windows:

If --All records-- is selected in Records to search

The search results are displayed in the "Search results: number-of-records record(s)" window.
If a record name is selected in Records to search

The search results are displayed in the "Search results: List of number-of-fields field(s) found in record record-name" window.

Search button

Performs a search.

Records to search

From the pull-down menu, select the records to search. By default, the records selected in Record: in the New Report > Field window or the Edit > Field window are displayed.

In the pull-down menu, the following items are displayed:

--All records--

Select this item to search all records.
List of record names of the selected agent

Displays a list of record names of the selected agent in alphabetical order.

(a) Search results: number-of-records record(s) window

This window displays the number of fields found by the search for each record when --All records-- was selected in Records to search in the New Report > Field > Search Fields or the Edit > Field > Search Fields window. In the search results, the record names are displayed in alphabetical order.

Cancel button

Returns to the New Report > Field or Edit > Field window.

Keywords to find

Enter search keywords. For details, see 1.5.3(3) New Report > Field > Search Fields or Edit > Field > Search Fields window.

Search button

Performs a search.

Records to search

From the pull-down menu, select the records you want to search. For details, see 1.5.3(3) New Report > Field > Search Fields or Edit > Field > Search Fields window.

Record name

A record name is followed by the following information:

Number of fields that correspond to the search result
Description of the record

If there is no description, (No explanation provided) is displayed.
Instance type

(This record is a single-instance record.) or (This record is a multi-instance record.) is displayed.

Clicking the menu of a record name lists the corresponding fields of the selected record in the "Search results: List of number-of-fields field(s) found in record record-name" window.

(b) Search results: List of number-of-fields field(s) found in record record-name window

A list of fields is displayed as the search result.

Cancel button

Returns to the New Report > Field or Edit > Field window.

Keywords to find

Enter search keywords. For details, see 1.4.3(1) Quick Guide > Search Fields window.

Search button

Performs a search.

Records to search

From the pull-down menu, select the records you want to search. For details, see 1.4.3(1) Quick Guide > Search Fields window.

Go to Record List button

Displays the "Search results: number-of-records record(s)" window again. This button is displayed only if you moved to this window from the "Search results: number-of-records record(s)" window.

OK button

Displays the New Report > Field window or the Edit > Field window again, and the selected fields are displayed in Selected fields.

Check boxes

Select one or more fields.

If you select fields and then click the OK button, you will return to the New Report > Field or Edit > Field window, and the selected fields will appear in Selected fields.

Note that if you return to the "Search results: number-of-records record(s)" window by clicking the Go to Record List button, the check boxes are cleared.

Field name

Displays field names in alphabetical order. Bold characters indicate the characters that match with the search keyword.

Format

Displays the attribute of the corresponding field by using the following icons:

: Numeric attribute
: String attribute

Description

Displays a description of the field. Bold characters indicate the characters that match with the search keyword.

To Page Top

(4) New Report > Filter window or Edit > Filter window

The New Report > Filter window or Edit > Filter window is used to set a filtering condition.

The following figure shows the New Report > Filter window.

Figure 1‒85: New Report > Filter window

The following describes the items displayed in these windows:

Description

Displays the Description of Record and Fields window, which describes the record selected in Record in the New Report > Field or Edit > Field window and its fields, as a separate window.

Cancel button

Displays a message box for confirming your intention to cancel the operation. Clicking the OK button in the message box cancels the processing and clears the information frame.

< Back button

Returns to the New Report > Field window or the Edit > Field window.

Next > button

Displays one of the following windows, depending on the circumstances:

When Realtime (Single Agent) is selected

Clicking this button displays the New Report > Indication Settings (Realtime) window or the Edit > Indication Settings (Realtime) window.
Other

Clicking this button displays the New Report > Indication Settings (Historical) window or the Edit > Indication Settings (Historical) window.

Finish button

When creating a new report

This button is displayed only when a value has been set in the window displayed by clicking the Next > button. Clicking the Finish button saves the settings.
When editing an existing report

Clicking the Finish button saves the settings.

Field

From the pull-down menu, select the fields to be filtered.

Condition

From the pull-down menu, select the operator to be used for the conditional expression. The following table lists and describes the operands that can be selected:

Operand	Description
`=`	The value in Field is equal to the value in Value.
`<`	The value in Field is smaller than the value in Value. For a character string field, comparisons are made in ascending order of the ASCII codes.
`<=`	The value in Field is smaller than or equal to the value in Value. For a character string field, comparisons are made in ascending order of the ASCII codes.
`>`	The value in Field is greater than the value in Value. For a character string field, comparisons are made in ascending order of the ASCII codes.
`>=`	The value in Field is greater than or equal to the value in Value. For a character string field, comparisons are made in ascending order of the ASCII codes.
`<>`	The value in Field is any value other than the value in Value.

Value

Specify the value to be compared by using an integer value, a decimal value, or a character string consisting of no more than 2,048 bytes of single-byte or two-byte characters. The permissible values depend on the field. The permitted values are displayed to the right of the text box.

By selecting Specify when displayed, you can omit this value specification.

Specify when displayed

Specifies that a conditional expression value will be specified when a report is displayed. This option applies to each individual conditional expression, not to the entire filter. Therefore, this option is enabled only when a conditional expression is added or updated.

AND

Joins with AND the conditional expression set in Field, Condition, and the target of comparison (Value or Field) and the conditional expressions displayed in Conditional expression. This option is enabled only when at least one conditional expression is set in Conditional expression.

OR

Joins with OR the conditional expression set in Field, Condition, and the target of comparison (Value or Field) and the conditional expressions displayed in Conditional expression. This option is enabled only when at least one conditional expression is set in Conditional expression.

Add button

Adds to Conditional expression the conditional expression set in Field, Condition, and Value or Specify when displayed.

Update button

Replaces the conditional expression selected in Conditional expression with the conditional expression set in Field, Condition, and Value or Specified when displayed. This option is enabled only when at least one conditional expression is set in Conditional expression.

Conditional expression

Displays the conditional expressions that have been created. The value in a conditional expression for which Specify when displayed was selected is displayed in the format prompt ("value").

Simple

Handles the conditional expression selected in Conditional expression as a simple expression. This option is enabled only when at least one conditional expression is set in Conditional expression.

Complex

Handles the conditional expressions selected in Conditional expression as a compound expression. However, if it is not possible to handle them as a compound expression, they are handled as simple expressions. This option is enabled only when at least two conditional expressions are set in Conditional expression.

AND <--> OR button

Toggles between AND and OR for the conditional expression selected in Conditional expression. This option is enabled only when the conditional expression selected in Conditional expression is not on the first line and Simple is selected.

Edit button

Displays in Field, Condition, and Value or Specify when displayed the conditional expression selected in Conditional expression to enable it to be edited. This option is enabled only when at least one conditional expression is set in Conditional expression.

Delete button

Deletes the conditional expression selected in Conditional expression. This option is enabled only when a conditional expression is selected in Conditional expression. When Simple is selected, clicking this button executes deletion. When Complex is selected, a message box for confirming your intention to delete all the compound conditions is displayed.

Delete All button

Deletes all conditional expressions set in Conditional expression. This option is enabled only when at least one conditional expression is set in Conditional expression.

To Page Top

(5) New Report > Indication Settings window or Edit > Indication Settings window

The New Report > Indication Settings window and the Edit > Indication Settings window are used to specify conditions for displaying a field in a realtime report. The window that is displayed depends on the report type selected in Report type in the New Report > Name and Type window or the Edit > Name and Type window.

When Realtime (Single Agent) is selected

The New Report > Indication Settings (Realtime) window or the Edit > Indication Settings (Realtime) window is displayed.
When Historical (Single Agent) or Historical (Multiple Agents) is selected

The New Report > Indication Settings (Historical) window or the Edit > Indication Settings (Historical) window is displayed.

The following describes each window.

(a) New Report > Indication Settings (Realtime) window or Edit > Indication Settings (Realtime) window

The New Report > Indication Settings (Realtime) window and the Edit > Indication Settings (Realtime) window are used to set conditions for displaying a field in a realtime report.

The following figure shows the New Report > Indication Settings (Realtime) window.

Figure 1‒86: New Report > Indication Settings (Realtime) window

The following describes the items displayed in these windows:

Description

Displays the Description of Record and Fields window, which describes the record selected in Record in the New Report > Field or Edit > Field window and its fields, as a separate window.

Cancel button

Displays a message box for confirming your intention to cancel the operation. Clicking the OK button in the message box cancels the processing and clears the information frame.

< Back button

Returns to the New Report > Filter window or the Edit > Filter window.

Next > button

Displays the New Report > Indication Settings window or the Edit > Indication Settings window.

Finish button

Saves the settings.

Specify when displayed

Select this option to specify settings when a report is displayed.

Indicate delta value

Specifies that data displayed in a report is to be changed to delta values.

The data displayed in a report differs according to the following conditions:

Whether or not Indicate delta value is selected
Whether or not delta values are collected in the field of the record displayed in the report

Whether or not delta values are collected in a record field depends on the field. For details about delta values and whether or not delta values are to be collected in the record's fields, see the chapter in the PFM - Agent or PFM - RM manuals that describes the records (list of fields in each record).

The following table shows the correspondence between the conditions and the value that is displayed in the report:

Conditions		Displayed value
Indicate delta value check box	Field to be displayed in report	Displayed value
Selected	Delta values are collected	Amount of change from the previously collected performance data to the currently collected performance data
Selected	Delta values are not collected	Most recently collected value
Cleared	Delta values are collected	Accumulated value since collection of performance data began^#
Cleared	Delta values are not collected	Most recently collected value

#: In PFM - Agent for Oracle, the amount of change is displayed, not the accumulated value.

Refresh interval

Specify whether or not the displayed realtime report is to be refreshed automatically; if so, specify the refresh interval (the default is 60 (seconds)).

Do not refresh automatically

Specifies that the displayed report is not to be refreshed automatically.

Initial value

If the displayed report is to be refreshed automatically, specify the refresh interval for the report. You can also change this value when the View Reports window is displayed. You must specify an integer in the range from the value set in Minimum value to 3600 (seconds). The default is 60 seconds. When Do not refresh automatically is selected, this option is disabled.

Minimum value

Set as an integer the minimum value that can be specified in Initial value, in the range 10 to 3600 (seconds). The default is 60 seconds. The value set here is also applied to the minimum value for Refresh interval in the Show Options page of the View Report window.

If Do not refresh automatically is selected, this option is disabled.

Display by ranking

Specifies that data is to be arranged in the report in an ascending or a descending order.

This item is displayed when both of the following conditions are satisfied:

Multi-row (multi-instance) records are displayed.
A numeric input field is selected in Field in the New Report > Filter window or the Edit > Filter window.

Field: Select the field on which arranging in ascending or descending order is to be based.
Display number: Specify the number of data items to be displayed, as an integer in the range 1 to 100. Only as many items as specified here will be displayed in the arranged order. This option is enabled only when a field is selected in Field.
In descending order: Specifies that the data is to be arranged in descending order of the values in the field specified in Field. When this option is selected, data is arranged in descending order from higher- to lower-order data. The default is ascending order, in which case data is arranged from lower- to higher-order data.

(b) New Report > Indication Settings (Historical) window or Edit > Indication Settings (Historical) window

The New Report > Indication Settings (Historical) window and Edit > Indication Settings (Historical) window are used to set conditions for displaying a field in a historical report.

The following figure shows the New Report > Indication Settings (Historical) window.

Figure 1‒87: New Report > Indication Settings (Historical) window

The following describes the items displayed in these windows:

Description

Displays a new window containing the description of the record selected in Record in the New Report > Field window or the Edit > Field window and the fields that belong to that record.

Cancel button

Displays a message box for confirming your intention to cancel the operation. Clicking the OK button in the message box cancels the processing and clears the information frame.

< Back button

Returns to the New Report > Filter window or the Edit > Filter window.

Next > button

Displays the New Report > Indication Settings window or the Edit > Indication Settings window.

Finish button

Saves the settings.

Specify when displayed

Select this option to specify settings when a report is displayed.

Settings for the report display period

Specifies the period for which data is to be displayed in the report.

Date range

Select the date range for the performance data that is to be collected for display in the report. The default is Specify when displayed.

The following table lists and describes the periods that can be selected as the date range for collecting performance data:

Value	Description
Specify when displayed	Specifies that a date range will be specified when a report is displayed.
Within the past hour	Displays data collected within the past hour.
Within the past 24 hours	Displays data collected within the past 24 hours.
Within the past 7 days	Displays data collected within the past 7 days.
Within the past month	Displays data collected within the past month.
Within the past year	Displays data collected within the past year.

Report interval

Select the report display interval. This item is displayed only for records of the PI record type.

If you select any interval other than Minute, you can display a drilldown report by clicking the location where the time is displayed on the table in the View Report window.

The following table lists and describes the intervals that can be selected as the report display interval and the drilldown reports that can be displayed:

Item	Description	Value displayed in report	Displayed drilldown report
Minute	Displays reports at 1-minute intervals.	The summary result of the data collected between `XX`:`YY`:00 and `XX`:`YY`:59 is displayed as the data for `XX`:`YY`:00. (`XX` is a value between 0 and 23 and `YY` is a value between 0 and 59.)	(Not displayed)
Hour	Displays reports at 1-hour intervals.	The summary result of the data collected between `XX`:00:00 and `XX`:59:00 is displayed as the data for `XX`:00:00. (`XX` is a value between 0 and 23.)	Report with a report interval of Minute covering minute 0 to 59 of the time that is selected by clicking
Day	Displays reports at 1-day intervals	The summary result of the data collected between 00:00 and 23:59 on a day is displayed as the data for 00:00:00 of that date.	Report with a report interval of Hour covering 00:00 to 23:00 of the date that is selected by clicking
Week	Displays reports at 1-week intervals.	The summary result of the data collected between Monday and Sunday is displayed as the data for Monday at 00:00:00.	Report with a report interval of Day covering Monday through Sunday of the week that is selected by clicking
Month	Displays reports at 1-month intervals.	The summary result of the data collected each month is displayed as the data for the 1st of that month at 00:00:00.	Report with a report interval of Week covering the 1st through the 31st of the month that is selected by clicking
Year	Displays reports at 1-year intervals.	The summary result of the data collected each year is displayed as the data for January 1st of that year at 00:00:00.	Report with a report interval of Month covering January through December of the year that is selected by clicking

For details about summary of data, see the chapter that explains the Performance Management functionality in the JP1/Performance Management Planning and Configuration Guide.

Note

If the data collection interval (Collection Interval) at the agent is greater than the interval selected in Report interval, the actual display interval will be the data collection interval (Collection Interval) at the agent.

Peak time

Specifies that the display is to be of only the data at the time at which the field specified in Field contains its maximum value for the day (the peak time).

Field

Select the field whose peak-time data is to be displayed.

The record displayed for a day will report the data for the selected field at the time the field's value reached its peak. This item is enabled when all the following conditions are satisfied:

When a single-row record is selected in Record in the New Report > Field window or the Edit > Field window
When a numeric input field is selected in Field in the New Report > Field window or the Edit > Field window
When Hour is selected in Report interval

Maximum number of records

Specify the maximum number of records to be displayed in a report, as an integer in the range of 1 to 2,147,483,647.

For creating a new report, the default is 1,440.

To Page Top

(6) New Report > Components window or Edit > Components window

The New Report > Components window and Edit > Components window are used to specify the report display format.

The following figure shows the New Report > Components window.

Figure 1‒88: New Report > Components window

The following describes the items displayed in these windows:

Description

Displays the Description of Record and Fields window, which describes the record selected in Record in the New Report > Field or Edit > Field window and its fields, as a separate window.

Cancel button

Displays a message box for confirming your intention to cancel the operation. Clicking the OK button in the message box cancels the processing and clears the information frame.

< Back button

Displays one of the following windows according to the circumstances:

When Realtime (Single Agent) is selected

Clicking this button displays the New Report > Indication Settings (Realtime) window or the Edit > Indication Settings (Realtime) window.
Other

Clicking this button displays the New Report > Indication Settings (Historical) window or the Edit > Indication Settings (Historical) window.

Next > button

When at least one Graph is selected

Clicking this button displays the New Report > Graph window or the Edit > Graph window.
When no Graph is selected

Clicking this button displays the New Report > Drilldown window or the Edit > Drilldown window.

Finish button

Saves the settings.

Fields

Displays the field selected in the New Report > Field window or the Edit > Field window.

Table

Specifies that the report containing the selected field is to be displayed in table format.

In a table-format report, data for each field is displayed in time series.

List

Specifies that that report containing the selected field is to be displayed as a list per agent or instance.

In a list-format report, field values for each agent or instance are displayed in units of data groups.

Reference: A data group is a set of data for different agents or instances that is grouped by time.

Graph

Select to display the selected numeric field in a graph format. Select only one in the following cases:

When you select Historical (Multiple Agents) for Report type in the New Report > Name and Type or Edit > Name and Type window, and you want to select Line, Area, or Stacked area for Graph types in the New Report > Graph or Edit > Graph window
When you select multi-row records (multi-instance records) for Record in the New Report > Field or Edit > Field window, and you want to select Line, Area, or Stacked area for Graph types in the Graph window

Display name

Specify the name that you want to use as a column name in a table or a list, or the title of a graph by using 0 to 24 single-byte or two-byte characters.

If nothing is specified, the field name is displayed in the report.

Display key

Sets the field to be used as the key for sorting data in multi-row records (multi-instance records).

This option is disabled in the following cases:

The type of this report is Historical (Multiple Agents).
A Line, Area, or Stacked area graph is to be displayed.

Field

From the pull-down menu, select the field to be used as a key for sorting and displaying data.

In descending order

Specifies that data is to be sorted in descending order. This option is enabled when a value other than (none) is selected in Field.

Notes:

When a display key is set, a report takes longer to display. Therefore, if a large number of records are to be displayed, a timeout error might occur. If an error occurs, consider reducing the number of records to be displayed.
The sort order of records that have the same display key is not determined.

If you want to display records for certain instances in chronological order, filter the fields.

To Page Top

(7) New Report > Graph window or Edit > Graph window

The New Report > Graph window and Edit > Graph window are used to specify the type and format of a graph.

The following figure shows the New Report > Graph window.

Figure 1‒89: New Report > Graph window

The following describes the items displayed in these windows:

Description

Displays the Description of Record and Fields window, which describes the record selected in Record in the New Report > Field or Edit > Field window and their fields, as a separate window.

Cancel button

Displays a message box for confirming your intention to cancel the operation. Clicking the OK button in the message box cancels the processing and clears the information frame.

< Back button

Returns to the New Report > Indication Settings window or the Edit > Indication Settings window.

Next > button

Displays the New Report > Drilldown window or the Edit > Drilldown window.

Finish button

Saves the settings.

Graph types

Select a graph type. Line, Area, and Stacked area cannot be selected in the following cases:

The type of this report is Historical (Multiple Agents) and more than one field is to be displayed.
The report is for multi-row records (multi-instance records) and more than one field is to be displayed.
In the New Report > Components window or the Edit > Components window, a value is selected in Field under Display key.

Available graph types are as follows:

Column: Displays vertical bar graphs. Graphs for the most recent data group are displayed in snapshot form.^#
Stacked column: Displays stacked vertical bar graphs, in which bars that indicate multiple items are stacked on top of each other. Graphs for the most recent data group are displayed in snapshot form.^#
Bar: Displays horizontal bar graphs. Graphs for the most recent data group are displayed in snapshot form.^#
Stacked bar: Displays stacked horizontal bar graphs, in which bars that indicate multiple items are stacked on the right of each other. A graph for the most recent data group is displayed in snapshot form.^#
Pie: Displays pie graphs. Graphs for the most recent data group are displayed in snapshot form.^#
Line: Displays line graphs, in which lines show the data change. The horizontal axis indicates time.
Area: Displays area graphs, in which areas show the data change. The horizontal axis indicates time.
Stacked area: Displays stacked area graphs, in which areas that indicate multiple items are stacked on top of each other. The horizontal axis indicates time.

#: For a historical report, the most recent data group within the collection time is displayed. You can also display a past data group by clicking the data group button in the View Report window.

Show areas of missing data

Select in the situation where some data is missing for a reason such as the agent was not active and you want the areas of missing data to be included in the graph.

This option is applicable only when Line, Area, or Stacked area is selected in Graph types.

A graph with areas for missing data can be displayed when all the following conditions are satisfied:

The target to be reported is multi-row records (multi-instance records) or multiple agents.
There is data for other lines or agents covering each time period for which data is missing.

Depending on the type of a graph, some data in a graph might be lost for the following reasons:

For a line graph: A line for missing data is hidden.
For an area graph or a stacked area graph: Assuming a value of 0 for the missing data, the missing data point and the point where the data exists are connected with a straight line to create the display area. If there is missing data for multiple intervals, connect the next previous point where data exists and the point of the last missing data (the value is 0) with a straight line. This will create a display area.

Series direction

Specify the unit used to display data.

By row: Displays a graph by row (record).
By column: Displays a graph by column (field).

Axis labels

Sets character strings to be displayed as the labels for the X and Y axes in the report.

This option is disabled when Pie is selected in Graph types.

X-axis: Specify a string consisting of 0 to 40 single-byte or two-byte characters for the title of the X axis. A two-byte character is counted as one word.
Y-axis: Specify a string consisting of 0 to 40 single-byte or two-byte characters for the title of the Y axis. A two-byte character is counted as one word.

Data label

Sets a maximum of two fields whose data values are to be displayed in the graph.

Data label 1

From the pull-down menu, select the data value of the first field to be displayed in the graph.

When this option is not specified, the first ODBC key field will be set as Data label 1. In this case, if there are multiple ODBC key fields, the second ODBC key field will be set as Data label 2; if there are no ODBC fields, Data label 1 will not be set.

Data label 2

From the pull-down menu, select the data value of the second field to be displayed in the graph. A value for the field selected in Data label 2 is displayed in parentheses following the corresponding value for the field selected in Data label 1.

To set this item, you must set Data label 1 first.

To Page Top

(8) New Report > Drilldown window or Edit > Drilldown window

The New Report > Drilldown window and the Edit > Drilldown window are used to set the drilldown reports at the report and field level that can be accessed from the View Report window.

The following figure shows the New Report > Drilldown window.

Figure 1‒90: New Report > Drilldown window

The following describes the items displayed in these windows:

Description

Displays the Description of Record and Fields window, which describes the records selected in Record in the New Report > Field or Edit > Field window and its fields, as a separate window.

Cancel button

Displays a message box for confirming your intention to cancel the operation. Clicking the OK button in the message box cancels the processing and clears the information frame.

< Back button

When at least one graph is selected in the New Report > Indication Settings window or the Edit > Indication Settings window

Clicking this button returns to the New Report > Graph window or the Edit > Graph window.
Other

Clicking this button returns to the New Report > Indication Settings window or the Edit > Indication Settings window.

Finish button

Saves the settings.

Report drilldown

Sets the drilldown reports for the report level. Select the drilldown reports from existing report definitions or bookmarks.

Report

Lists the drilldown reports that have been added by using the Add button. The reports or bookmarks that are added here are set as drilldown reports.

You can select multiple drilldown reports.

Add button

Adds a drilldown report to Report.

Clicking this button displays the New Report > Drilldown > Select Report window or the Edit > Drilldown > Select Report window.

Change button

Changes the drilldown report selected in Report to become a drilldown report for another report.

Clicking this button displays the New Report > Drilldown > Select Report window or the Edit > Drilldown > Select Report window.

Delete button

Deletes the drilldown report selected in Report.

Field drilldown

Sets a drilldown report at the field level. A drilldown report is selected from the existing report definitions.

Bind button: Sets (binds) the drilldown report in the field selected in Select. Clicking this button displays the New Report > Drilldown > Select Report window or the Edit > Drilldown > Select Report window.
Unbind button: Releases the drilldown report set in the field selected in Select. Clicking this button releases the binding between field and report and displays (No report is selected.) in Report.
Edit Expression button: Sets a filtering condition for the drilldown report that is bound to the field selected in Select. Clicking this button displays the New Report > Drilldown > Select Report > Edit Conditional Expression for Drilldown window or the Edit > Drilldown > Select Report > Edit Conditional Expression for Drilldown window.
Select: Selects a field for which a drilldown report is to be set or released.
Field: Displays the field in the report being defined that has been selected as the target for a drilldown report.
Report: Displays the name of the drilldown report set for the field. If no drilldown report is set, (No report is selected.) is displayed.

To Page Top

(9) New Report > Drilldown > Select Report window or Edit > Drilldown > Select Report window

The New Report > Drilldown > Select Report window and the Edit > Drilldown > Select Report window are used to select a report that is to be bound as a drilldown report to the field selected in the New Report > Drilldown window or the Edit > Drilldown window.

The display of the New Report > Drilldown > Select Report window or the Edit > Drilldown > Select Report window differs depending on the operation you perform in the New Report > Drilldown window or the Edit > Drilldown window:

When you click the Bind button in Field drilldown:

The following figure shows the New Report > Drilldown > Select Report window.

Figure 1‒91: New Report > Drilldown > Select Report window (when you click the Bind button in Field drilldown)

When you click the Add or Change button in Report drilldown:

The following figure shows the New Report > Drilldown > Select Report window.

Figure 1‒92: New Report > Drilldown > Select Report window (when you click the Add or Change button in Report drilldown)

The following describes the items displayed in these windows:

Refresh

Updates the information displayed in the contents area to the latest status. The selection in the contents area remains the same even though the display is updated.

OK button

Applies the specified settings and returns to the New Report > Drilldown window or the Edit > Drilldown window.

Cancel button

Discards the specified settings and returns to the New Report > Drilldown window or the Edit > Drilldown window.

Tree type

This item is displayed only when the Add or Change button in Report drilldown is clicked.

You can select the information to be displayed in the contents area from the pull-down menu. The information that is displayed differs according to whether you select Reports or Bookmarks. By default, Reports is set.

Text box

Use this text box to filter reports or bookmarks by keywords. Specify a character string of 1 to 1,024 characters to filter the reports or bookmarks that will be displayed. To perform a multi-keyword search by using AND, delimit keywords by using a single-byte space, a two-byte space, or a tab. A delimiter is counted as one word. The maximum number of words that can be entered as filtering keywords is 100.

Filter button

Filters reports or bookmarks by using the string specified in the text box.

Clear button

Clears the filtering status and the filtering condition.

Contents area

When you click the Bind button in Field drilldown, the window displays the reports tree.

If you click the Add or Change button in Report drilldown when Reports is displayed for Tree Type, the window displays the reports tree.

When Bookmarks is selected, the bookmarks tree appears.

In the contents area, from the reports tree or the bookmarks tree, select a report or a bookmark you want to bind as a drilldown report. You can select only one report or bookmark.

To Page Top

(10) New Report > Drilldown > Edit Conditional Expression for Drilldown window or Edit > Drilldown > Select Report > Edit Conditional Expression for Drilldown window

This window sets the filtering conditions for a drilldown report.

The following figure shows the New Report > Drilldown > Edit Conditional Expression for Drilldown window.

Figure 1‒93: New Report > Drilldown > Edit Conditional Expression for Drilldown window

The following describes the items displayed in these windows:

Description

Displays the Description of Record and Fields window, which describes the record selected in Record in the New Report > Field or Edit > Field window and its fields, as a separate window.

OK button

Applies the specified settings and returns to the New Report > Drilldown window or the Edit > Drilldown window.

Cancel button

Discards the specified settings and returns to the New Report > Drilldown window or the Edit > Drilldown window.

Field

From the pull-down menu, select a field to be filtered in the drill down report.

Description button

Displays the Description of Record and Fields window, which describes the field selected in Field and its records, as a separate window.

Condition

From the pull-down menu, select an operator to be used for setting the conditional expression for the selected field. This item is enabled when a field is selected in Field.

For details about the available operators, see 1.5.3(4) New Report > Filter window or Edit > Filter window.

Either a value or a field can be specified as the target of the comparison in the condition.

Value (radio button)

Specifies that a value is to be specified as the target of the comparison.

Value (text box)

By selecting Specify when displayed, you can omit this value specification.

Specify when displayed

Specifies that a conditional expression value will be specified when a report is displayed.

This item is enabled only when Value is selected as the target of the comparison with the conditional expression.

Field (radio button)

Specifies that a field is to be selected as the target of the comparison.

Field (pull-down menu)

From the pull-down menu, select a field as the target of the comparison.

The fields displayed in the pull-down menu vary depending on the report type.

For Realtime (Single Agent)

The Record Time field is displayed. If a multi-row record (multi-instance record) is selected, the Instance field is also displayed.
For Historical (Single Agent)

The Date and Time field is displayed. If a multi-row record (multi-instance record) is selected, the Instance field is also displayed.
For Historical (Multiple Agents)

The Date and Time, Agent Host, and Agent Instance fields are displayed.

AND

OR

Add button

Adds to Conditional expression the conditional expression set in Field, Condition, and the target of comparison (Value or Field). This button is enabled only when the Value text box or the Field pull-down menu is set.

Update button

Replaces the conditional expression selected in Conditional expression with the new conditional expression set in Field, Condition, and the target of comparison (Value or Field). This option is enabled only when at least one conditional expression is set in Conditional expression.

Conditional expression

Displays a list of conditional expressions that have been created. The value in a conditional expression for which Specify when displayed was selected is displayed in the format prompt ("value").

Simple

Complex

Handles the conditional expressions selected in Conditional expression as a complex expression. However, if it is not possible to handle them as a complex expression, they are handled as simple expressions. This option is enabled only when at least two conditional expressions are set in Conditional expression.

AND <--> OR button

Edit button

Displays the conditional expression selected in Conditional expression in Field, Condition, and Value, and selects the Specify when displayed check box clicking this button also enables you to edit the conditional expression. This button is activated when one or more conditional expressions are set in Conditional expression.

Delete button

Delete All button

Deletes all conditional expressions set in Conditional expression. This option is enabled only when at least one conditional expression is set in Conditional expression.

To Page Top