KPI tables

The IBM® Predictive Maintenance and Quality key performance indicator (KPI) tables: resource_kpi and process_kpi hold aggregated values for each day.

In the resource_kpi table, the key for each row is determined by

  • The profile_variable that triggered the calculation of the KPI
  • The date
  • The resource that is associated with the event
  • The event code that is associated with the event observation
  • The location that is associated with the event
  • The process that is associated with the event
  • The production batch that is associated with the event
  • The tenant_id.

The fields in resource_kpi are described in the following table.

Table 1. Fields in the resource_kpi table
Field Type Description
kpi_date date The date for which the KPI is calculated. The time grain for KPI calculation is a single day.
profile_variable_id integer The profile variable that is the source of this KPI.
resource_id integer The resource that is associated with the event.
event_code_id integer The event code that is associated with the event observation. Event codes are codes for alarms, failures, issues, and so on. When an event arrives with a measurement_type value that has an event_code_indicator value of 1, the text from the event_observation_text field is assumed to contain an event_code value.
location_id integer The location that is associated with the event.
process_id integer The process that is associated with the event.
production_batch_id integer The production batch that is associated with the event.
actual_value float The actual value for this KPI. It is important to understand that for Business Intelligence reporting purposes, this value is typically divided by the measure count. Even if the value is meant to be an average, this value must be a sum of the values from the event and the measure_count must be the number of events. actual_value field supports the average calculation for dimensional reporting.
plan_value float The planned value for the KPI for this date.
forecast_value float The forecast value for the KPI for this date
measure_count integer The measure count for this date. Typically this value is used to divide the actual_value for reporting.
current_indicator integer Indicates that this row is the current row for a KPI. Typically the date of the current row is the current day.
tenant_id integer The tenant_id of the profile_variable that is the source of this KPI.

The fields in the process_kpi table are described in the following table.

Table 2. Fields in the process_kpi table
Field Type Description
process_id integer The process that is associated with the resource.
kpi_date date The date for which the KPI is calculated. The time grain for KPI calculation is a single day.
profile_variable_id integer The profile variable that is the source of this KPI.
material_id integer The material that is associated with the resource.
event_code_id integer The event code that is associated with the event observation. Event codes are codes for alarms, failures, issues, and so on. When an event arrives with a measurement_type value that has an event_code_indicator value of 1, the text from the event_observation_text field is assumed to contain an event_code value.
location_id integer The location that is associated with the resource.
production_batch_id integer The production batch that is associated with the event.
actual_value float The actual value for this KPI. It is important to understand that for Business Intelligence reporting purposes, this value is typically divided by the measure count. Even if the value is meant to be an average, this value must be a sum of the values from the resource and the measure_count must be the number of resources. actual_value field supports the average calculation for dimensional reporting.
plan_value float The planned value for the KPI for this date.
forecast_value float The forecast value for the KPI for this date.
measure_count integer The measure count for this date. Typically this value is used to divide the actual_value for reporting.
current_indicator integer Indicates that this row is the current row for a KPI. Typically the date of the current row is the current day.
tenant_id integer The tenant_id of the profile_variable that is the source of this KPI.