Create Asset Metrics and Dashboards

Before You Begin

This tutorial shows you how to create asset metrics and dashboards for your organizational assets. System metrics such as assets connected, assets available, and assets utilization can be added to dashboards. You can also define and add your own dashboard metrics.

Background

Acme Corporation specializes in injection molding, assembly, and manufacturing services. They focus on custom molding of things like performance parts. Acme Corporation is project driven - their jobs run from a couple of days to a couple of weeks, from a hundred to a few thousand parts. Their customers range from large contractors to lone inventors.

Acme Corporation does not want to be a shoot-and-ship job shop. They are constantly moving towards automation. For the last one year, the company is using Robots. Robots cost only $3 to $5/hr, much less than the operator.

Acme needs to ensure optimum environmental conditions, such as temperature and humidity, for the proper functioning of their robots and plant. Too much humidity and the robots can rust. High temperature may lead to equipment burnout. On the other hand, too low a temperature can mean high air-conditioning power bills.

Acme also needs to ensure optimal performance of its robots and plant at all times with minimal downtimes. It needs automatic monitoring of any equipment problems and robot errors. Acme should ideally be able to predict, and proactively address potential problems in advance. The plant Operations Managers should not need to monitor dashboards 24x7. Automatic notifications should be triggered for potential issues and problems.

Oracle can help Acme Corporation using the Oracle Internet of Things Asset Monitoring Cloud Service. Oracle IoT Asset Monitoring Cloud Service creates a digital twin version of Acme Corporation's IOT-enabled organizational assets, and lets them monitor the location, condition, and utilization of their assets.

As an Acme Administrator, your responsibility is to set up the digital twin versions of Acme Corp's organization and assets. And as an Operations Manager, you will use Oracle IoT Asset Monitoring Cloud Service to monitor the location and health of Acme's IoT-enabled assets. To make sure you receive timely notification of issues, you'll create rules that generate alert and incident notifications when optimal environmental conditions are exceeded. To make sure the issues are addressed promptly, you'll create mobile notifications (SMS) for field technicians.

You will define anomalies to detect deviations from normal asset behavior, and to flag potential device issues in time.

What Do You Need?

Access to an instance of Oracle IoT Asset Monitoring Cloud Service

Create a Metric to Show Average Hourly Temperature Per Sensor

The average hourly temperature for each robot should stay under 20 degrees. The robots division creates a metric to calculate average hourly temperatures for each temperature detector, and adds it to the asset dashboard.

You can also use calculated metric values in your rules, such as the one you created for reporting high temperature.

Click Menu and then click Design Center.
Select Asset Types from the Design Center sub-menu.
Select the TemperatureDetector asset type from the Asset Types list.
Click Metrics.
On the Metrics page, click Create New Metric .
Under Name, enter Average Hourly Temperature.
Under Calculate, leave the default option set to Calculate on Schedule per Entity.
The average hourly temperature is calculated for each temperature sensor.
Under Calculation Schedule, select Hourly.
After the metric is created, you would need an hour's worth of data before you can see values. If you prefer, you can also select Live for the purposes of this exercise. Live averages the temperature every 5 minutes.
Under Formula, click Click here to insert formula.
Select Average under Aggregations.
Within the Average function parentheses, select Property, then select Sensor and Temperature.
Optionally click Validate Formula to check your formula.
You can also click Advanced to see the SQL query that is generated. Click Basic to return to the basic mode.
Click Save to save your metric.

As this is the first time you have created an analytics artifact, you are prompted to publish the same, which deploys and activates the analytics controls.
Click Publish.

The publishing of the analytics artifacts might take a few minutes. You can choose to click Back and continue to work on other pages while the publish operation completes.

After the publish operation completes, the Publish banner shows Publishing Metrics...Activated. At this point you can close the banner.

Add the Temperature Metric to an Asset Dashboard

Next, let us add the metric we created to an asset dashboard for temperature detector asset types.

Click Menu and then click Design Center.
Select Asset Types from the Design Center sub-menu.
Select the TemperatureDetector asset type from the Asset Types list.
Click Dashboards.
On the Dashboards page, click Create Create Dashboard .
Select the Empty template, and click Create.
Enter a Name for the Dashboard, say Monitor Temperature.
Select an Icon for your dashboard.
Once the dashboard is created, the chosen icon will appear on the asset view menu bar.
Click Add Group and then click Add New Gadget to add your gadget in the group of gadgets.
Select the Average Hourly Metric metric and select a label, unit, color, and icon for your gadget.
Click Create.
You can use the same process to add more gadgets and groups.
Click Save to save the dashboard.

Inspect Dashboard Gadget in Operations Center

Let us next inspect the dashboard, we just created, in the Operations Center.

In the Operations Center, click the navigation icon next to your organization name in the breadcrumbs.

If you are in one of the Design Configuration screens, then use the following steps to go back to the Operations Center:
1. Click Menu, and then click Previous next to Design Center.
2. Click Operations Center.
3. Click the navigation icon next to your organization name in the breadcrumbs.
Adjust the zoom settings as desired. You can also use the mouse scroll wheel for this.

Description of the illustration [filename]
Select the Robots Division group.

Description of the illustration [filename]
Use the breadcrumb Navigation icons to navigate to a temperature detector asset. Say: AcmeCorp > Robots Division > R1 > T1 : Digital Twin.
Click your dashboard icon on the left menu bar.
Inspect the gadget value for last hour's temperature.

Create and Inspect Organization and Group Level Dashboard Gadgets

When you create a dashboard at the organization level, you can add metrics from across your organizational assets to the dashboard. The dashboard appears in your Operations Center menu bar.

Click Menu and then click Design Center.
Select Organization from the Design Center sub-menu.
Click Dashboards.
On the Dashboards page, click Create Dashboard .
Select the template of your choice, and click Create.
Enter a Name for the Dashboard, say Robots Dashboard.
Select an Icon for your dashboard.
Once the dashboard is created, the chosen icon will appear on the Operations Center menu bar.
Click Add New Gadget to add a new gadget.

Add the following gadgets:

Each row represents a gadget to add.

Type	Metric/Sensor Attribute	Aggregation	Label, Color, Style	Description
Metrics	Open Maintenances	Percentile	Choose	Percentage of maintenance incidents open across all robots.
Metrics	Open Incidents	Percentile	Choose	Percentage of open incidents across your assets.
Metrics	Active Warnings	Average	Choose	Average number of active warnings across your assets.
Metrics	Average Hourly Temperature	Average	Choose	Average hourly temperature aggregated across your assets.
Sensor Attributes	Temperature	Average	Choose	Current temperature aggregated across your assets.

Click Save to save the dashboard. Click Back.
Go back to the Operations Center Organization page and click the Dashboard icon on the menu bar to see your live dashboard.