Summarization rules
For records of the PI record type, the data that is collected is stored in the Store database. This includes data collected at the interval set in Collection Interval, as well as data that is collected on a specific interval basis derived from defined rules (such as minute, hour, day, week, month, or year). The type of summarization is defined for each field; this definition is referred to as the summary rules.
Some summary rules require intermediate data to be retained during the summarization period. In such a case, a field for retaining the intermediate data is added to the record in the Store database; this is called an added field. Some added fields are displayed as record fields in PFM - Web Console. These added fields that are displayed in PFM - Web Console can be used as fields for display in historical reports.
As distinguished from the added fields that are created by summarization, the fields described in each record explanation are called fixed fields.
The name of an added field is as follows:
-
Name of an added field that is stored in the Store database
PFM - Manager name of the fixed field with a suffix
-
Name of an added field that is displayed in PFM - Web Console
PFM - View name of the fixed field with a suffix
The following table lists the suffixes for the PFM - Manager name, the suffixes for the corresponding PFM - View name, and the data that is stored in each field.
Suffix for PFM - Manager name |
Suffix for PFM - View name |
Stored data |
---|---|---|
_TOTAL |
(Total) |
Sum of the field's value in the records over the summary period |
_COUNT |
-- |
Number of records collected during the summary period |
_HI |
(Max) |
Maximum field value in the records over the summary period |
_LO |
(Min) |
Minimum field value in the records over the summary period |
- Legend:
-
--: There is no added field.
The following table lists and describes the summary rules.
Summary rule name |
Description of summary rule |
---|---|
COPY |
Stores the field value in the most recent record in the summary period. |
AVG |
Stores the average field value in the summary period. The formula is as follows: (Sum-of-field-values)/(number-of-collected-records) Added fields (Store database):
Added field (PFM - Web Console):
|
HILO |
Stores the maximum, minimum, and average field values in the summary period. In the fixed field, the average value is stored. The formula is as follows: (Sum-of-field-values)/(number-of-collected-records) Added fields (Store database):
Added fields (PFM - Web Console):
|
-- |
Indicates that data is not summarized. |