Oracle by Example brandingCreating KPIs in Oracle IoT Production Monitoring Application for Predictive Maintenance

section 0Before You Begin

This 15-minute tutorial shows you how to create metrics or Key Performance Indicators (KPIs) to help you track key production data for your factories and machines and predict the need for maintenance using the Oracle Internet of Things (IoT) Production Monitoring Cloud Service application.

Background

Oracle IoT Production Monitoring Cloud Service is a specialized Internet of Things application. This application lets you locate your factories and machines, and monitor their health and utilization.

Vision Corp., a manufacturer for tablets and smartphones, has implemented the Oracle IoT Production Monitoring Cloud Service application to improve yield, quality, and reliability of the products that are manufactured in the factory. The machines in the factory are a display picker, glue dispenser, and a display mount. The application is configured to detect anomalies, trigger incidents, display the historical and current values of the sensor data, and display the status of the incidents.

What Do You Need?

section 1Use the Visual Expression Builder to Create a KPI

In this section, you create a custom KPI (metric) using the Visual Expression Builder to define an expression to calculate the average of the glue temperature in the Glue Dispenser machine.

  1. Sign in to your instance of the Oracle IoT Production Monitoring Cloud Service application.
  2. Click Menu main menu icon and then click Configuration configuration button. Click Metrics metrics button. tab and then Create Metric create new icon.
  3. On the Create Metric page, enter Avg Glue Temperature, then click Entity Type field and select GlueDispenserMachineType.
  4. From the Metric Type drop-down list, select Query, and from the Calculate drop-down list, select On Demand for All Machines.
  5. On the Formula editor, click Click here to insert formula.
  6. On the popup, select the aggregation Average.
  7. veb KPI
    Description of the illustration veb_1.png
  8. Click the arrow between the parentheses to show the Formula Menu popup and select Property, then Sensor and then glue_temperature.
  9. veb KPI 2
    Description of the illustration formula_kpi.png

    You can build your operation using the elements in the Formula editor, or click Advanced to directly edit the SQL-like expression.

  10. To verify that the expression is valid, click Validate Formula.
  11. Click Save and then Republish. You need to wait a few minutes after clicking that button for the KPI to be available.
  12. Click Back.

section 2Add the KPI to the Map Dashboard

  1. Click Menu main menu icon and then click Map.
  2. In the Metrics toolbar, click the Edit Edit icon icon.
  3. On the Metrics page, click the Add New Gadget create new icon icon.
  4. On the Create Metric page enter or select the following values:
    • Type: Metrics
    • Metric: Avg Glue Temperature
    • Label: Avg Glue Temperature
    • Unit: °
    • Color: Light Blue
  5. On the metrics bar, notice the Avg Glue Temperature KPI. You can move the position of the KPI by clicking in the three dots icon.
    engine temp KPI
    Description of the illustration kpi_avg_glue_temp.png
  6. Click Save.

section 3Create an Anomaly Based Rule

In this section, you create an anomaly and then a rule for the Glue Dispenser Machine Type, so that a warning is generated when the anomaly occurs.

  1. Click Menu Menu icon, and then click Configuration.
  2. Click the Anomalies Anomalies icon tab, and then on the Anomalies page, click Add Add icon.
  3. On the Configure New Anomaly page, enter or select the following values for Details:
    • Name: Glue temp anomaly
    • Description: Glue temperature anomaly
  4. For Detection Target:
    • Machine Type: GlueDispenserMachineType
    • Attribute: glue_temperature
  5. For Training Data:
    • Analysis Method: Automatic
    • Specimen Machine: SF_Factory_GlueDispensingM1
    • Training Window: 1 hour
    • Deviation Threshold: 2
  6. Click Save, and then click Publish/Republish. The Publishing KPI metrics...Building message is displayed. Wait until the message changes to Activated.
  7. To return to the Anomalies page, click Back.
  8. Click Menu main menu icon, and then click Rules.
  9. On the Rules page, click Create New Rule create new icon.
  10. On the Create New Rule page, in the Details section, enter or select the following values:
    • Name: Glue Temperature Warning
    • Apply to: Machine Type and GlueDispenserMachineType
  11. In the Condition section, select Glue temp anomaly and Occurred.
  12. In the Fulfillment section, select the following values:
    • Fulfill when: All Conditions Apply
    • Generate: Warning
  13. In the Warning Details section, enter or select the following values, and then click Save:
    • Summary: Glue Temp Warning
    • Level: High
  14. Click Save.

section 4Customize Existing Metrics

In this section, you customize the metrics in the Map and Factory views to use an order and colors that are meaningful. You can also add new groups to organize your metrics.

  1. In the Map view, click the Edit Edit icon icon located in the Metrics toolbar.
  2. Customize the Metrics toolbar using these alternatives:
    • Click Add Add icon to add a new group.
    • Click ... (three dots) to drag and drop the metric to a different location in the same group, or to another group.
  3. customize existing  metrics page
    Description of the illustration customize_metrics.png
  4. You can delete a section or a metric by selecting the Delete Delete Icon icon.
  5. Click Save.

more informationWant to Learn More?

  • What Are Metrics? in Using Oracle Internet of Things Production Monitoring Cloud Service