How to use 42Q MES OEE module

Problem Statements

 

1) A plant with quality and OTD (on time delivery) problems looking for help.

At an important manufacturing site, the program manager contacts the manufacturing operations manager and informs him that the company is facing delivery issues throughout a particular customer’s orders. After some painful further analysis, the operations team figured out that those orders have been processed across multiple different production lines making it really difficult to figure out what and where the problem is. According to manually acquired data from previous quarters, the production lines should be able to handle the demand and produce enough parts to meet the committed orders within the promised delivery dates, but it turns out that this is not the case.
Time is ticking, the team has no answer and there is no certainty they are asking the right questions. No data, no information. Lack of on-time delivery can be caused by several different factors in various areas throughout the shop floor and the team is struggling to get insights quickly.
After some brainstorming, the company decides to adopt 42Q MES as a solution. They have heard the system is full-fledged MES with integrated OEE and IIoT solutions that would allow them to not only leverage traceability data collected by operators, but also machine generated payloads that can bring valuable insights on availability performance and quality metrics. Utilizing 42Q MES track and trace data that is collected in real time from machinery and operators will enable the team to not only make sure their efficiency calculations are accurate but have them available anywhere, real-time. 
Once the team implemented 42Q Cloud-based MES, they were able to identify opportunities to improve the three main factors that affect overall equipment efficiency:

- Availability: With better maintenance plans, asset health and performance tracking through 42Q’s CMMS Preventive Maintenance Management.

- Performance: Making sure staff is trained and equipment is calibrated by managing these with 42Q MES101’s Employee Validation and CMMS Calibration modules. 

- Quality: Measured and confirmed by 42Q’s MES extensive quality reports and dashboards, which help lead to better overall equipment efficiency. 

A few months later, real-time OEE dashboards and weekly automatically delivered reports were making a difference in that company’s life (and in their customers’ confidence that their orders are now delivered as planned).

2) Comparing apples to apples (are those really apples)?

A Corporate manufacturing technology group that is responsible for enterprise wide performance and quality metrics is asked to support and approve an expensive equipment purchase for one of its plants. That’s a difficult decision. The plant has struggled to comply with corporate policies before, but the team has made significant strides over the past few years. The operations team has been sending spreadsheets via emails with data coming from disparate sources and collected at different points in time. It’s properly formatted but… still just data. The corporate team is looking for information, but not just any information. They are looking for trustworthy, auditable data, collected in real-time, as automatically as possible and protected against any sort of tampering or modifications.

Presently, the data collection happens inconsistently and the aggregations are manually done, which presents opportunities for human error. A corporate technology analyst who is familiar with 42Q MES and its features decides to drive continuous improvement programs using OEE. He/She suggested that more plants should start using it to consolidate overall efficiency and utilization information that is often available but in silos, which makes it really hard to collect, aggregate and report against in a global fashion. 
The plant that is requesting the purchase approval decides to take on the opportunity and give 42Q OEE a shot. The solution should support them with the goal to consistently prove that they are operating at their peak capacity with high availability, performance, quality and utilization levels, but still not able to meet the customers demands. 
They should be able to leverage the solution to make improvements on a shift to shift or week to week basis while corporate groups would also benefit from a larger adoption of 42Q’s OEE as they will be able to globally compare apples to apples when analyzing global efficiency trends, say month to month or quarter to quarter.

As a result of feeding accurate data into 42Q, the manufacturing technology group was able to confirm that the plant could reduce performance losses due to slow cycles and small stops. But the company decided to go ahead with the purchase since even with those improvements, more capacity was needed.
 

 

 

Configuration and Prerequisites

42Q is here to support customers in their journey to find answers to both of the problem statements discussed earlier. The first action is to get familiar with and complete the basic configurations and prerequisites described in this section. We will walk you through the steps that will later allow users to quickly identify production lines and machinery problems, analyze root causes and detect yield and throughput issues. These are the cornerstones to equip teams with the tools they will use to lay down the appropriate actions to fix short term problems and draw continuous improvement plans to tackle long term strategic goals around greater efficiency.

Performing these steps will bring additional benefits. Note that although it is not required that customers utilize CMMS in its full extend, by configuring the basics described below (CMMS lite), customers will be well on their way to be able to adopt fully computerized machine maintenance by manage the assets themselves along with calibration, preventive checklists and repair maintenances. Using a full blown CMMS process can greatly help with prolonging the life of equipment, keep warranties from voiding, improve quality and performance as well as bringing better MTBF and MTTR. Customers that use CMMS will have a better picture of their factory’s shifts, production lines and machines operational calendars and know when there are scheduled downtimes. All that are certainly contributors to OTD as these are tightly integrated to the 42Q’s production scheduling system.

 

 

Configuration Order Diagram

 

Note: The Group configuration is optional and it is only required if the user is planning to use the CMMS Repair Work Order module.

 

 

Add a Department

Adding a department is important for Reporting purposes. It will allow users to filter reports by department later on when generating reports.

1. Navigate to: Shop Floor Control > Configuration > CMMS - Admin > Department.
2. To create a Department, left-click on the main ROOT level located at the top of the Department Name list.
3. To create a sub Department, left-click on a Department.

 

Figure 1: Department

 

4. Select Add.
5. Enter the Department Name.
6. Enter the Department Code.

Note: For more information on how to add a department, please refer to the document CMMS Admin - Add Department.

7. Select Save to save the information.

 

 

Add a Location

Locations represent physical locations within the plant.

1. Navigate to: Shop Floor Control > Configuration > CMMS - Asset > Location.
2. To create a Location, left-click on the main ROOT level located at the top of the Location Name list.
3. To create a sub Locationt, left-click on a Location.

 

Figure 2: Location

4. Select Add.
5. Enter the Location Name.

Note: For more information on how to add a location, please refer to the document CMMS Asset - Add Location.

6. Select Save to save the information.

 

Add a Production Line

1. Navigate to: Shop Floor Control > Configuration > CMMS - Asset > Production Line.
2. Select Add.
3. Enter the required information.

Figure 3: Add Production Line Form

 

Note: For more information on how to fill in the fields, please refer to the document CMMS Asset - Add Production Line.

4. Select Save to save the information.

 

Adding a Problem Category

The Problem Category module is used to organize problems into a categorical hierarchy, for that reason, users must first add a Problem Category to a pre-existing parent category before creating a Problem Type.
Problem Categories and Problem Type can be used with the OEE Reporting tools to equip users to perform availability analysis from different angles. Users can utilize these to filter, aggregate (group/break by) and plot/display Problems at different granularity levels depending on their needs.

Global Defects: Different types of assets/processes might require operators to report similar or the same exact issues using different jargon/verbiage/problem codes.
Assigning global problem codes to individual problems enables ‘apples-to-apples’ comparison when it’s required. 
This allows quality, production or maintenance teams to analyze plant or enterprise-wide trends while keeping the operation teams using codes and naming conventions that make sense to their areas throughout the factory.

Note: Global Problems are created by placing them into a specific Problem Category. They will become available to be linked to regular Problem Codes.

The following predefined Problem Categories that describe common manufacturing problems are available:

• Manufacture
• Production 
• Process 
• Quality 
• Energy

 

1. Navigate to: Shop Floor Control > Configuration > CMMS - Asset > Problem Category.
2. To create a main Problem Category, left-click on the main ROOT level located at the top of the Problem Category Name list.
3. To create a sub Problem Category, left-click on a main Problem Category.
4. Select Add.
5. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document OEE Add a Problem Category.

6. Select SAVE to save the information.

 

 

Adding a Problem Type

After adding a Problem Category to a pre-existing parent category, users may go ahead and use the Problem Type module to add new problem types or edit existing Problem Types to meet the changing needs of the plants. Users can also enable/disable Problem Types as needed.

1. Navigate to: Shop Floor Control > Configuration > CMMS - Asset > Problem Type.
2. Select Add. The Add Problem Type form will display.

 

Figure 8: Add Problem Type Form

 

3. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document CMMS Problem Type.

 

4. Select Add & Exit to save the information.

 

 

 

Adding a Root Cause Category

Root Cause Categories are detailed descriptions of machine downtime problems.

1. Navigate: Shop Floor Control > Configuration > OEE Configuration > Root Cause Category.
2. To create a main Root Cause Category, left-click on the main ROOT level located at the top of the Root Cause Category Name list.
3. To create a sub Root Cause Category, left-click on a main Root Cause Category.

 

Figure 9: Difference Between Main and Sub Categories (Root Cause Category)

 

4. Select Add.

 

Figure 10: Add a Root Cause Category Form

 

5. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document OEE Add a Root Cause Category.

 

6. Select the Add & Exit to save the information.

 

 

 

Adding a Root Cause

In order to create a Root Cause, users first need to create the Root Cause Category.

1. Navigate to: Shop Floor Control > Configuration > OEE Configuration > Root Cause. 
2. Select Add.

 

Figure 11: Add a Root Cause Form

 

3. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document OEE Add a Root Cause.

 

4. Select the Add & Exit to save the information.

 

 

 

Defining a Problem and Scheduling Regular Downtimes According To It

Before scheduling regular downtimes according to a problem, users will first need to create a Problem Category and Problem Type. After that, users using MES101 automatic data collection may use the Problem module to define a problem, and record regularly scheduled downtimes (such as lunch breaks) according to the problem defined.

 

1. Navigate to: Shop Floor Control > Configuration > CMMS - Asset > Problem.
2. Select Add.

Figure 12: Add Problem Form

 

3. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document OEE Schedule Regular Downtimes According to Problem in CMMS.

 

4. Select Add & Exit to save the information.

 

 

 

How to define mapping between Error Code and CMMS Problem Code/Event Codes

After defining a Problem, users may use the 42Q MES OEE module provides APIs/Interfaces to get Downtime Error Codes from PLCs and Up/Down data with Error Codes from the equipment automatically.

1. First of all, users have to map the relationship between Problem and Asset Type by navigating to: Shop Floor Control > Configuration > CMMS - Asset > Asset Type.
2. Select the Asset Type.
3. Select the Problem Event icon.

 

Figure 13: Problem/Event Icon

 

4. Select ADD.
5. Select one or more Code.
6. Select SAVE to save the information.
7. Then, go to the section: How to configure Tag Mappings (when using automatic data collection) to map the relationship between Error Code and CMMS Problem Code.

Note: Each Fuji Machine can be treated as one tag. To create a Tag ID for Fuji equipment use this naming convention: Tag ID = Fuji Machine Name. The Fuji Tag ID needs to be mapped with the CMMS Asset in the Tag Mapping. Similarly, users must also map Error Codes to Problem/Event Codes for the FUJI Error Code such as ‘SMT STOP’.

 

Event codes type spare affects planned production time rather than being an availability loss.
Whenever a machine sends a signal code that represents a planned downtime (a period of inactivity that is planned), an event code can be mapped to an asset spare status, nevertheless, that will affect the planned production time instead of being considered an availability loss.
If users are not using a ‘PLANNED’ SMT Line at the moment,  and users simply take it down with a Problem Code (unscheduled) it may bring discussions, since the OEE will be lower than it should due to availability loss, but the reality is that machine was planned not to run.
If these periods of inactivity are repeatable, they can be handled by the calendars and scheduled downtime modules, but things can not always follow a previously defined schedule, however, they are not necessarily problems.
Event codes have yet one advantage, they can bring machines back up (to running - essentially affecting the planned production time again).

We can use the figures to understand in a better way the Spare, Planned Downtime and Unscheduled Downtime affecting the OEE and Availability.
The descriptions below represent the rules and scenarios for the Spare, Planned Downtime and Unscheduled Downtime. It is possible that the Spare status is not used very often. It will only change the shift from working to not working. 

1. The same Spare and Planned Downtime minutes record have the same actual production time, planned production time, OEE and Availability result.
2. More Spare and Planned Downtime will increase the OEE value, but it will decrease the availability value a little.
3. More Unscheduled Downtime will decrease the both OEE & availability value.
4. The Spare, Planned Downtime and Unscheduled Downtime reduce the actual production downtime, however, both, Spare and Planned Downtime reduce the planned Production Time, while the Unscheduled Downtime will not reduce the planned production time. That is why the availability value is down.

 

(Availability = Actual Production Time / Planned Production Time).

 

 

5. The Spare (non-scheduled time) is used for the production planning, such as public holiday, or due to non-machine issues, the production predefined schedule will be canceled as the operator finished the work earlier than expected during the weekend overtime, then the operator can go home early.
6. The Scheduled Downtime will be used widely, such as production site training, weekly meetings, lunch, tea break, smoking break etc.
7. The Unscheduled Downtime will divide into machine failure or non-machine failure, that is important to identify the root cause and improve the uptime in order to improve the availability and OEE value. If there is more problem with the machine failure, then the plant management needs to check with the plant Repair team and Maintenance team. They need to find a way to make the machine more stable and increase the machine run time. If there is more problem with the non-machine failure, then plant management needs to check with the plant Training department and define a better training plant for their production operator. Most non-machine failure problems are related to human mistakes, such as short of material, waiting for the tool, wrong parts etc.

 

Availability = Actual Production Time / Planned Production Time

 

The Planned Downtimes and Assets in spare status both affect the planned production time (the denominator), while the Unscheduled Down will affect the shift's actual production time (the faction's numerator).
When the denominator decreases and the numerator stays the same, the fraction as a whole increases.
When the numerator decreases and the denominator stays the same, the fraction as a whole decreases.

Bottom line, if users incorrectly reduce the amount of planned Production Time by moving an asset to spare or recording a scheduled down rather than affecting the actual run time by properly recording unscheduled downs, the asset's availability will look better than it should (which will, in turn, drive the OEE index up incorrectly).
 

 

 

 

 

Adding an Asset

The first step into utilizing 42Q’s OEE to monitor Overall Equipment Effectiveness (OEE) is having asset records representing the equipment into the system. This is done in the CMMS Asset module.

1. Navigate to: Shop Floor Control > Configuration > CMMS - Asset > Asset.
2. Select ADD ASSET from the top right menu.
3. Enter the required information of the Basic Information section.

Note: For more information on how to fill in the fields, please refer to the document: CMMS Asset.

 

Figure 14: Add Asset Form (Basic Information)

 

 

4. Enter the required information of the Advanced information section.

Note: For more information on how to fill in the fields, please refer to the document: CMMS Add Asset.

 

Figure 15: Add Asset Form (Advance Information)

 

5. Select SAVE to save the information.

Note: There exists a bulk upload feature inside the Import Assets module; to use it, download the template, fill in the required information, and then import the file.

 

 

 

Mapping assets to acquire Performance and Quality from MES101

Assuming the company is using MES 101 track and trace to scan units and move them through a route (via Production Workbench, OEE Workbench, a custom application, Measurement parsers or any other 42Q Conduit based automation) users can leverage cycle time and yield information already collected and computed in 42Q to populate Performance and Quality variables automatically. 
This is done in the Asset Mapping module where users can link CMMS Assets to an MES101 Location or Device.

Note: If the user will not be pulling scanned information from MES101, they can skip this part of the process.

 

1. Navigate to: Shop Floor Control > Configuration > CMMS - Asset > Asset Mapping.
2. Select Add.
3. Enter the required information.

Note: For more information on how to fill each field, please refer to the CMMS Add Asset Mapping.

 

4. Select Save to save the information.

 

Figure 16: Add Asset Mapping Form

 

Note: There exists a bulk upload feature inside the Import Mapping module; to use it, download the template, fill in the required information, and then import the file.

 

 

 

Shift Configuration For The Entire Plant

Shifts define days and times of operation to the entire plant. This is going to help shape the planned production time which is one of the key factors to accurately measure OEE.

1. Navigate to: Shop Floor Control > Configuration > OEE Configuration > Shift.
2. Select Add.

 

Figure 17: Add Shift Form

 

3. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document OEE Add Shift.

 

4. Select Save to save the information.

 

 

 

Dynamic Work Schedule By Plant, Line Or Assets In The Plant Calendar Configuration

Once assets are created, mapped to ME101 (if applicable) and shifts are set up, users can use the Plant Calendar module to define specific work schedules or breaks for the whole plant, individual lines or assets. This includes special periods of time such as holidays, unplanned weekend shifts or overtime. It also covers lines that will not be available during certain shifts or periods of time. This allows flexible allocation of resources by line or assets without modifying the entire shift calendar configuration that would affect all lines and equipment.

 

1. Navigate to: Shop Floor Control > Configuration > OEE Configuration > Plant Calendar.

 

Adding a new Plant Calendar

1. Select Add Plant Calendar. The Plant Calendar List form will display.
2. Select ADD. The Add Plant Calendar form will display.

 

Figure 18: Add Plant Calendar Form

 

3. Enter the required information.

Note: For more information on how to fill each field, please refer to the OEE Add Plant Calendar.

 

4. Select SAVE to save the information.

Note: There exists a bulk upload feature inside the Plant Calendar module; to use it, download the template, fill in the required information, and then import the file.

 

Predictable Scheduled downtimes

Once shifts are in place and any special plant, line or asset calendars are created, the next step is to record scheduled downtimes into the system. A reason (a problem code; we will talk more about that later in this document), an entity (production line or individual asset), as well as the duration, time dimension and the frequency of occurrence must be indicated.

 

1. Navigate to: Shop Floor Control > Configuration > OEE Configuration > Scheduled Down.
2. Select the ADD.

 

Figure 19: Add Scheduled Down Form

 

3. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document OEE Scheduled Down.

 

4. Select Save to save the information.

 

 

How To Configure Tag Mappings (When Using Automatic Data Collection)

Only after completing the configuration of Asset and Asset Mapping, users should carry on and start configuring Tag Mapping.
Tags are key/value pairs within JSON payloads that are sent by machinery, custom applications or commercial middleware systems to the MES APIs (usually via HTTPS or MQTT).
The Tag  Mapping module allows admins to map/link these tags to assets, defining who they belong to. This is how the 42Q OEE data acquisition system works when set up in automatic data collection mode. There are other types of data collection available (such as manual data entry via OEE data collection form or Fuji Host Interface via MES Agent).
This mapping process allows 42Q MES to automatically capture asset downtimes and problem codes from the equipment itself and eliminates the need to manually input downtime events.

 

1. Navigate to: Shop Floor Control > Configuration > OEE Configuration > Tag Mapping.
2. Select Add.

 

Figure 20: Tag Asset Mapping Form

 

3. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document OEE Tag Mapping.

 

4. Select Save to save the information.

Note: There exists a bulk upload feature inside the Import Tag Mapping module; to use it, download the template, fill in the required information, and then import the file.

 

 

Adding an Up Down Threshold

Only after completing the configuration of Asset and Asset Mapping, users should carry on and start configuring ‘Up Down Thresholds’. The Up Down Threshold module allows users to set a grace period (threshold time) before assets are officially flagged as down or up in the 42Q MES.

 

1. Navigate to: Shop Floor Control > Configuration > OEE Configuration > Up Down Threshold.
2. Select Add.

 

Figure 21: Add An Up Down Threshold Form

 

 

3. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document OEE Add Up/Down Threshold.

 

4. Select Save to save the information.

 

 

Data Gathering (Manual And Automatic)

Perform a proper and flawless data gathering process is crucial for measuring and improving the overall equipment efficiency from plants, 42Q OEE will help users not only to cover these needs, but also will help detecting different types of errors and their root causes resulting in the increase of productivity, decrease downtimes, obtaining real-time and accurate data. 42Q offers two ways of data gathering: Manual and Automatic.
Manual data gathering can be used for specific cases in which the operator must collect data manually.
On the other hand, Automatic data gathering saves a massive amount of time, since all data is collected in real-time from all machinery. Practical and efficient.

Manual Data Gathering

Quality (goods and total quantity processed) and Performance (throughput and expected HPU) are collected from MES101 scanning.

Adding Asset Events

The Report Asset Event module is used by the shop floor operators to manually add asset events running, setup, idle, spare, maintenance, calibration, schedule downtime and unschedule downtime due to asset malfunctions as well as routine stoppages (such as parts in transit or lunch breaks).
Widget Configuration Menu

1. Navigate to: Production > OEE Data Collection.
2. Click the Plus (+) icon.

 

Figure 22: Asset Events Plus Icon

 

3. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document OEE Add Work Time.

 

 

4. Once data is entered, the NEXT button will become available. Select NEXT.
5. Select BACK to go to the previous window to double-check the information, or select the next status from the Status drop-down list, then select the tick button to save the information.

Note: There exists a bulk upload feature inside the OEE Data Collection module; to use it, download the template, fill in the required information, and then import the file.

 

 

Automatic Data Gathering

Q&P

The 42Q MES OEE module has a Q&P MES-API function which has the capacity to retrieve data that was previously collected and stored in MES101. When the ‘A’ parameters (provided outside of MES101) and the planned production time configured (plant/line/asset, calendar, shifts and planned downtimes) are combined, 42Q will be able to obtain the data needed to compute real-time TEEP and OEE metrics.

P&Q will be computed for the Asset based on the Asset Mapping (MES101 device or location used to scan units/serial numbers).
As operators scan serial numbers, pass and fail them over time, 42Q can compute both the cycle time (used to calculate the Performance variable) and the yield (used to calculate the Quality variable).

 

How to implement Fuji Host Interface and MESAgent Client

The 42Q MES OEE module can retrieve the machine Up Down/Reason through the Fuji Host Interface/MESAgent Client automatically. The ‘Fuji Host Interface Up/Down’ down reason is the same as the ‘PLC up/down’ down reason signal which comes from the machine automatically. When using this approach, the Fuji Host Interface can only be used along with the NXT & Aimex modules.

 

1. Install Fuji Host Interface at the production Fujitrax PC. The Host Interface application is included in the Fuji installation CD with installation instructions.
2. Install the MESAgent Client (42Q application) in the production Fujitrax PC. It will keep listening to the machine Up & Down/Reason signals from the Fuji Host Interface and will forward it to the 42Q MES OEE.

Note: The Fuji Host Interface and MESAgent are installed by the Administrator or Support team.

 

 

Setting up MESAgent Machine STOP Event Status

To enable the MESAgent Machine STOP Event Status option, users must first complete the following configurations:

 

1. Asset.
2. Asset Mapping.
3. Tag Mapping.
4. Defining a Problem (it is advisable to set up its corresponding Problem Code and Problem Name as ‘SMT STOP’ for easy identification).
5. Defining the mapping between the Error Code and the CMMS Problem Code.

Note: The SMT STOP Event Status change logic is described below:
When the machine starts up, the MESAgent sends out the ‘SMT RUNNING’ status to the CMMS/OEE API.
When one of the machine modules meets the problem and stops, the MESAgent sends out the ‘SMT STOP’ status to the CMMS/OEE API.
When all the machine modules are up and running without stop, then the MESAgent sends out the ‘SMT RUNNING’ status to the CMMS/OEE API.

 

 

6. Download the ‘fuji-command.xml’ file.

Note: The Service team must provide the link to download the Fuji Command file.

 

7. Open the XML file to edit the information.
8. Enter the OEE Web Service IP Address information.
9. Enter the MCSTATECHANGE option inside the command tag.

 

Figure 23: Fuji Command XML File Content

 

Note: Only after completing the previous steps, users may find out all the Fuji SMT Machine Stop Event records by navigating to: Reporting > CMMS - Report > Asset Event History.
To view all the downtime work orders associated with an asset, navigate to: Reporting > CMMS - Report > Work Order, enter the Asset Name, and then select the Search button.

How to integrate a PLC

The 42Q MES OEE application availability of Layer 2 drivers (Kepware) to perform data capture from Machines or PLCs and transfer to 42Q Via Rapid IIoT.

1. Install a third-party middleware (such as Kepware) software to communicate with the PLC and forward payloads to 42Q IIoT APIs.
2. Work with the 42Q automation engineering to test and set up the PLC connection.
3. Set up the machine downtime OEE Define Mapping between Reason Code/Error Code and CMMS Problem Code (to map Asset’s Problem Code) at the 42Q MES OEE module.
4. Once mapped, users may view Downtime Root Cause Analysis Reports, Downtime Problem Reports, Downtime Trend Analysis Reports, and others in MESWeb Reports.

Note: Steps 1 and 2 are completed by the Administration or Support team. 

Note: OEE value will be recalculated with the new downtime or performance/quality data.
If users fill in the missing new downtime, then the system will recalculate the OEE value based on the new downtime. If the MES101 API is down, the system will try to get the previous OEE Performance & Quality data automatically. If the Target UPH value is missing, the system will recalculate the OEE value again after users correct the value. The backend recalculation job will run automatically.

 

Reporting and Business Intelligence

The OEE Reports module solves the problem statements mentioned at the beginning of this document due to its capability to show the collected machinery information in a more organized and digestible way for the user, coupled with the possibility of filtering the information based on different parameters. Since these reports are based on real-time trustworthy data, the outcome will accurately detect the problems as well as their root causes that affect the availability, performance, and quality, solving issues similar as in the problem statement 2, where the plant could reduce performance losses that was found out that were caused by slow cycles and small stops.

 

How To Generate MESWeb Reports

The 42Q MES OEE module automatically pushes OEE data to MESWeb Reports where information is displayed in a number of dynamic reports, charts, and graphs. Reports are created based on parameters selected in MESWeb Reports.

OEE Reports are classified into three categories:

• Overview: The Downtime Root Cause Analysis report is the primary OEE MESWeb Report. 
• Drill Down: Users can access the corresponding Downtime Problem and Downtime Root Cause Charts through this report.
• Chart Type: Downtime Root Cause Analysis displays as a Pie Chart (by default) or Pareto Chart.

 

1. Navigate to: Reporting > MESWeb.
2. Select a Report.
3. Select Data Source.
4. Select Site.
5. Select the Parameters.
6. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document OEE Reports.

 

7. Select Go to generate the report.

 

To solve the issues mentioned  in the problem statement 1, the plant could run the next reports in order to detect the actual delivery issues:

• Downtime Root Cause Analysis
• Downtime Trend Analysis Report
• MTBF And MTTR Report
• MTBF And MTTR Trend Report
• OEE Report

 

To solve the issues mentioned  in the problem statement 2, the plant could run the next reports in order to detect the current machinery performance:

• Downtime Root Cause Analysis
• Downtime Trend Analysis Report
• MTBF And MTTR Report
• OEE Dashboard
• OEE Report
• Products Without Throughput Per Hour Targets

 

 

OEE Serial And Parallel

The OEE Reports’ logic is focused on obtaining the average between the assets belonging to the line; this is known as the Average OEE.

The next list are the requirements to obtain the Average OEE:

• Add a new option with Parallel or Serial OEE Calculation.
• If the option added is Parallel, it means that the OEE Calculation will be an ‘Average’.
• If the option added is Serial, it means that the OEE will calculate the asset with the least OEE belonging to the line selected.

 

How To Configure Operation Dashboard

The Operation Dashboard module provides a view of production line status, allowing plant managers to quickly troubleshoot critical problems. Presently, factories can monitor the throughput and yield of any given production line as compared to expected target results.

 

1. Navigate to: Reporting > Operation Dashboard.
2. Choose one of the default Snapshots or a new one, and select View.
3. Select the Configuration Menu icon. 

A new screen will display. The configuration page consists of two parts: Widget and Global configuration.

 

 

Widget Configuration

The Widget Configuration page (top section) allows users to configure data for all individual widgets.

 

Figure 24: Widget Configuration Menu

 

 

Each widget may contain multiple reports. Filtered data is applied to each report. To select data for the widget:

1. Expand the Widget options by clicking on the arrow icon.
2. Select the Report. A list of parameters will display.

 

Figure 25: Expanding Widgets

 

Note: Users may clone a widget by selecting the clone icon adjacent to the selected widget. 
The Clone option allows users to create multiple widgets with different filters applied. For example, a user might clone the Top 5 Problems widget and configure one to display problems for Line 1 and the second to display problems for Line 2, thereby allowing plants to view the activity from both lines side by side.

 

3. Select the required filters and use the arrows to add them.

 

Figure 26: Adding Parameters to the Widget

 

 

4. Enter the Refresh Rate (min), this option defines how often data is refreshed from the database.

• Days option applies only for those widgets that have an option to display data for the number of days passed. 
• The top option applies to the number of items the users want to be displayed in the chart, users can select from the top 5 or top 10.
• The Start Time option applies only for those widgets that have an option to display data for the number of hours passed. 

 

 

Global Configuration

The Global configuration page (bottom section) applies data to an entire dashboard. The global configuration applies to any/all individual widget(s) with no data assigned in the Widget Configuration. 

 

Figure 27: Global Configuration

 

1. Enter the required information.

Note: For more information on how to fill in the fields, please refer to the document Operation Dashboard Global Configuration.

 

2. Select the required filters and use the arrows to add them.

 

Figure 28: Adding Filters

 

3. Select Apply to save changes locally in the user’s current window.
4. Select Apply & Save to save changes as a Snapshot and list them on the main Operation Dashboard page.

 

 

Figure 29: Operation Dashboard (Problem Statement 1)

 

Note: A possible dashboard configuration for problem statement 1 would include the following widgets: Availability, Performance, Quality, Availability, Performance & Quality, OEE/TEEP, A, P, Q Status, Shop Order, and Yield by Product.

 

Figure 30: Operation Dashboard (Problem Statement 2)

 

Note: A possible dashboard configuration for problem statement 1 would include the following widgets: Availability, Performance, Quality, Availability, Performance & Quality, OEE/TEEP, A, P, Q Status, Top 5 Problems/Repairs, and Top Defects.

 

How To Create a 42Q Live Monitor

42Q Live provides users the capability to visualize data reports and monitor lines on the shop floor. This module gathers yield percentage data to determine the line’s status based on the previously configured target yield. If the line’s current yield is lower than its target yield, the line’s status will change to critical. The benefits of using this module is getting a view of this essential information in an intuitive monitor layout that by consequence increases the plant visibility and ensures that issues can be addressed quickly as they arise.
 

To create a 42Q Live Monitor, follow the steps below:

1. Navigate to: Reporting > 42Q Live.
2. Go to the Admin tab.
3. Enter the required information.

Note: For more information on how to fill in the fields, please refer to 42Q Live Admin Tab.

 

4. Once data is entered, select Save to save the information. 

 

Figure 31: 42Q Live Admin Tab

 

Monitor Configuration

In the Home tab, users may view the list of levels. To open the fullscreen layout monitor, select the desired level.

 

Figure 32: Levels List

 

Note: In case the status of the levels has changed, select the Refresh button to update.

 

Select the Configuration Menu icon to open the Local Configuration screen.

 

Figure 33: Local Configuration Menu Icon

 

 

Inside the Local Configuration users are able to: Download Saved Configuration, Enable/Disable Layers, Choose the size of the icons (small, medium, or large), Update Refresh Rate, Change Card scroll to left/right, Enable/Disable Loop Mode; by default, this option is turned on, which means that it will continue scrolling consistently right to left, and just starting over with the first card placed behind the last card.
To learn more about the Loop Mode behavior and the Local Configuration, please refer to the document 42Q Local Configuration.

 

 

OEE Layer

The levels that contain an OEE layer can be configured following the steps below:

1. Select the double arrow icon to display the OEE layer configuration menu.

 

 

Figure 34: Double Arrow Icon

 

2. Select the Chart Type.
3. Select the number of columns (Distribution).
4. Select the icons to display.
5. Select the period time (OEE Period).
6. Mark the Display details checkbox to display additional details in the monitor or leave it unmarked.

 

Figure 35: OEE Layer Configuration

 

Note: For more information about the OEE Layers, please refer to 42Q Live OEE Layers.

 

For cases like the problem statement 1, plants could use the next 42Q Live layers in order to detect the actual delivery issues::

• TP/YIELD
• OEE

 

For cases like the problem statement 2, plants could use the next 42Q Live layers in order to detect the current machinery performance:

• TP/YIELD
• IIOT
• OEE