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

section 0Before You Begin

This 15-minute tutorial shows you how to create key performance indicators (KPIs) in the Oracle Internet of Things (IoT) Fleet Monitoring Cloud Service application that'll help you track and monitor vehicles. In this tutorial, you use a simulator application that creates a simulated vehicle and generates its data.

Background

Oracle IoT Fleet Monitoring Cloud Service is a cloud-based service that lets you gain real-time visibility into vehicle location, operational costs, vehicle use, and driving behavior.

Vision Corporation, a manufacturer for tablets and smartphones, wants to optimize the supply chain management of its display pickers, glue dispensers, and display mounters. The company is using a new type of glue that will avoid temperature fluctuations and improve the reliability of displays.

To avoid production delays, the company implemented an Oracle IoT Fleet Monitoring Cloud Service application to track glue shipments from the warehouse to the factory. The application is configured to generate alerts (vehicle departure and speed), trigger incidents (vehicle breakdown), and display vehicle status.

What Do You Need?

section 1Create a Simulation Model in the Oracle IoT Digital Twin Simulator Application

In this section, create a simulation model in the Oracle IoT Digital Twin Simulator application. The application simulates a vehicle that generates on-board device data, and then sends the data to the Oracle IoT Fleet Monitoring Cloud Service application.

  1. Sign in to the Oracle IoT Digital Twin Simulator application at https://your Oracle IoT Cloud Service instance name/ds.
  2. On the Simulations Dashboard page, click Create a Simulation Model create new icon.
  3. On the Select an option page, click Truck.
  4. On the Truck page, click Create New Device Create New icon.
  5. On the popup, click Create.
  6. On the Truck page, click the Running icon to start the device. Note the ID of the new device.

section 2Create a Vehicle Type

In this section, you create a vehicle type to group vehicles with similar attributes. Grouping vehicles with similar attributes can simplify performance management.

  1. Sign in to your instance of Oracle IoT Cloud Service at https://your Oracle IoT Cloud Service instance name/ui.
  2. Click Menu main menu icon and then click Applications.
  3. Select the Oracle IoT Fleet Monitoring Cloud Service application.
  4. Click Device Model.
  5. Click Choose Device Model choose device model icon.
  6. Select the ora_obd2_device_model device model and click Done.
  7. Sign in to your instance of Oracle IoT Fleet Monitoring Cloud Service at https://your Oracle IoT Cloud Service instance name/fm.
  8. Click Menu Menu icon, and then click Configuration.
  9. Click Vehicle Type Vehicle Type icon.
  10. Click Create New Vehicle Type Create Vehicle Type icon.
  11. On the Create New Vehicle Type page, in the Details section, enter or select the following values:
    Name: KenworthVehicleType
    Make: Kenworth
    Model: T680
    Year: 2017.
  12. In the Sensor Attributes section, select all the pre-defined sensor attributes, click Select Device Model, select ora-obd2-device_model, and then click Select.
  13. Click Save and then Back.

section 3Register a Vehicle

In this section, you register a simulated vehicle that you created in the Oracle IoT Digital Twin Simulator application.

  1. Click Menu Menu icon, and then click Configuration.
  2. Click the Uploads Uploads icon tab, and then click the Vehicle Upload button.
  3. In the Upload: Vehicle CSV DATA page, click Choose File, browse to the folder where you saved vehiclet680.csv, select it, click Open, and then click Upload.
    4. vehicle created by uploading a csv file
    Description of the illustration vehicle_created.png
  4. Click Go to Vehicle Listing and verify that your vehicle is listed.
  5. Click Menu Menu icon, and then click the Vehicles Vehicles icon tab on Fleet page.
  6. Click the Vehicles Vehicles icon tab.
  7. From the Vehicles list, select Kenworth-T680.
  8. Click the Edit Edit icon icon.
  9. In the Sensor attributes section, click on select all the attributes checkbox.
  10. Click Link Device.
  11. On the Select Device popup, click your simulated device and click Select.
  12. Notice that in the Sensor attributes section, in the table, the device ID column is populated with the information of the device you selected.
  13. Click Save and then Back.

section 4View Vehicle Data

  1. On the Vehicles page, locate the vehicle Kenworth-T680 and then click View View icon.

    2. The Vehicle: Kenworth-T680 page displays the speed, engine RPM, and engine temperature from the simulated vehicle.

    vehicle data
    Description of the illustration vehicle_data.png
  2. Click Back.

section 5Use 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 engine temperature of a vehicle.

  1. Click Menu main menu icon and then click Configuration configuration button.
  2. On the Configuration page, click Metric metrics button., and then Create Metric create new metric icon.
  3. On the Create Metric Type page, in the Details section, enter or select the following values:
    Name: Avg Engine Temperature
    Entity Type: KenworthVehicleType
    Calculate: Calculate on Demand for All Vehicles
  4. In the Formula editor, click Click here to insert formula.
    veb KPI
    Description of the illustration veb_1.png
  5. On the popup, select the aggregation Average.
  6. Click the arrow between the parentheses to show the Formula menu popup and select Property, then Sensor and then enginecoolanttemp.
    7. 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.

  7. To verify that the expression is valid, click Validate Formula.
  8. Click Save and then Publish. Wait a few minutes after clicking that button for the KPI to be available.
  9. Click Back.

section 6Add the KPI to the Dashboard

  1. Click Menu main menu icon and then click Fleet.
  2. On the Fleet page, click the Fleet KPI Dashboard fleet kpi dashboard icon icon located in the toolbar.
  3. On the Fleet Metrics page, click the editMetricGroup Edit icon icon.
  4. Click Add New Metric create new icon icon.
  5. On the popup select the following values:
    • Type: KPI
    • Entity: KenworthVehicleType
    • Metrics: Avg Engine Temperature
    • Color: Ocean Blue
  6. Click Save.
  7. On the metrics bar, notice the Avg Engine Temperature KPI, you can move the position of the KPI by clicking the Ellipsis ellipsis icon icon.
    engine temp KPI
    Description of the illustration kpi_avg_engine_temp.png
  8. Click Save.

more informationWant to Learn More?