The Insights Hub OEE data source for Dashboard Designer¶

The OEE data source in Dashboard Designer enables the user to display their OEE related KPIs in customized dashboards. It includes a set of queries to build visualizations derived from the Insights Hub OEE application including data for Availability, Performance, Quality, Mean-Time-Between-Failure (MTBF), production quantities, machine status, downtime reasons and more. The data source also provides the list of OEE Assets and OEE KPIs as a dashboard variable so that the user can build templates that can be deployed to multiple assets with different metrics. In addition to the built-in visualization panels listed in Visualizations, there are the Downtime Reasons and Status panels that are designed specifically for the OEE data source. For more information, refer to OEE Visualizations. The Downtime Reasons panel is also interactive so that, if the user has the Operator role, they are able to edit the downtime data directly from Dashboard Designer. In this section, we describe how to configure an Insights Hub OEE data source query and how to define OEE dashboard variables.

Prerequisites¶

• The user must have a subscription to Insights Hub OEE and have the suitable roles enabled in Settings. For more information on user roles, refer the OEE documentation.
• The user must have access to fully configured OEE assets on the tenant. For more information, refer OEE configuration.

Procedure to create an OEE data source query¶

1. Click "Dashboards" in the left navigation.
2. Click "New" and select "New dashboard" from the drop-down list.
3. Click "+ Add visualization".
   
4. Select "Insights Hub OEE" from the data source list.
5. Click in the "Asset" dropdown box, and select an OEE asset from the list.
6. Select the "Category" dropdown box. The list of OEE KPI categories is displayed:
   • Common KPI: This includes the full list of KPIs for Insights Hub OEE as defined in the OEE KPI Configuration.
   • Distribution (Table): This returns distribution data structured as rows for display in a table. It is useful for showing the duration and occurence of OEE asset status and downtimes. It includes data for:
     • Downtime distribution
     • Status distribution
     • Top downtime reasons
     • Top reject reasons
   • Distribution (Chart): This returns distribution data structured as columns suitable for display in a chart. It includes the same list of data as the Distribution (Table) category. A Pie chart works well for many use cases. See the example below.
   • Downtime Reason: This category is designed for use with the interactive OEE Downtime Panel. For details, refer to OEE Visualizations.
   • Production Target: This category returns time series for Total, Good, Rejected and Target numbers of parts. It is designed to show your production progress compared with target. It works well with either Table or Time Series chart.
   • Status Trend: This category returns the status of the OEE asset against time. It is designed for use with the OEE Status Panel. For more information, refer to OEE Visualizations.
7. For Common KPI, Distribution (Table) and Distribution (Chart) categories, select the specific variable of interest from the KPI dropdown.
8. If applicable, select the "Type".
   • For Common KPI category, you can select "Type" as either "Trend" or "Single". "Trend" returns the variable against time, whereas "Single" returns one value for the time period. The former is useful for Time Series or tables, whereas the latter works well as a Stat Value or Gauge.
   • Fpr Distribution (Chart), the Type is either the "Duration" or the "Occurence". "Duration" refers to the total duration for each value in the distribution and "Occurence" refers to the number of occurences of that value.
9. You can choose to add additional queries on the data source. After configuring any additional queries, select an appropriate visualization, either a general purpose or OEE specific visualization (see OEE Visualizations).
10. Click "Apply" and continue adding widgets to the dashboard. Note that you can include other data sources alongside Insights Hub OEE to view other types of data with your OEE KPIs together in one dashboard.

Dashboard Variables¶

Using the Insights Hub OEE data source, you can set the Asset and the KPI as dashboard variables. This enables the user to easily change the asset or KPI in their queries and update the dashboard. It is possible to create a reusable dashboard template for all assets and KPIs of interest.

Procedure to create an OEE dashboard variable¶

1. Select "Dashboard Settings".
2. Choose "Variables" tab and click "Add Variable".
   
   
3. Set the parameters to configure the variable as shown below:
   • select "Query" the variable type
   • enter the suitable name for the variable
   • select "Insights Hub OEE" as data source
   • select the "Assets" wildcard if you want to use the OEE asset list in your variable or "KPIs" if it is a KPI variable.
     
     
4. Review the options to filter and sort the list of assets or KPIs. Choose whether to reload the list at the time the dashboard loads or when the time range changes. Check the check box "Multi-value" to enable multiple values for the variable.
5. Preview the values and click "Apply".

Procedure to use an OEE dashboard variable¶

1. The variable can now be used in queries by entering \$\{MyAssetVariable\} in the Asset selection box, or \$\{MyKPIVariable\} for the KPI selection. It can also be used in the "Repeat By Variable" option, so that the visualization can be repeated for each asset. The variable can also be used to set the title of the visualization.
2. The Asset and KPI variables appear at the top of your dashboard and can be used to select different combinations of Asset and KPI to display in your visualizations. In the example below three visualizations are repeated using the asset variable. The assets can be changed using the "MyAssetVariable" dropdown. The KPIs shown in the Stat and Gauges can be updated using the "MyKPIVariable" box.