Revision as of 16:31, 14 May 2024

Reporting MESWeb Execution / Reports Version MES 15.80 Revision R1

Introduction

MESWeb is a powerful business intelligence application designed from the ground up to enable and simplify reporting from 42Q’s manufacturing execution systems and empower end-users with a streamlined and full-featured web interface. The application includes an ad hoc report design tool that allows users to create customized reports from heterogeneous data sources.

MESWeb provides access to information through a real-time replication reporting database to avoid negatively impacting the production system performance. In its standard configuration, here are some of the reports based on data tracked via MES101:

Work in Progress (WIP Distribution)
Yield, Defect, and Repair Analysis
Serial Number historical details (Unit History)
Evolution Reports (including moving averages) – Top Defect Evolution and Yield Evolution
Throughput information

These reports can filter and search the data per common attribute, such as Customer, Part Number, Process, Date and Time range, Shifts, Evolution Intervals, etc. These default reports provide a significant level of visibility to manufacturing processes.

MESWeb can be used along with several RDBMS (relational database management systems) and drivers:

ERP
PostgreSQL
MySQL
MSSQL Server
ODBC

Access Level

MESWeb has five distinct access levels:

Administrator (System Administrator)

The System Administrator has full access to MESWeb Central and Execution – all plants, all reports, and all customers. Basically, Administrator access includes the capabilities of all of the levels (Security Manager, Report Manager, and Data Source Manager). This access will be given to BSAs and global support personnel.

An administrator can perform the following functions:

Access the "Access Control" module
Create, Edit, and Delete Locations
Create, Edit, and Delete Data Sources
Create, Edit, and Delete Data Source types
Create new custom reports globally
Copy, Edit, and Delete existing custom reports globally
Publish custom reports globally
Manage permissions for all MESWeb locations

Security Manager (Local Administrator)

The Security Manager has full access to the plant(s) where he/she has been designated as the local Administrator for the MESWeb tool. The main responsibilities of this role are to organize permissions and manage customers. A Security Manager is able to:

Visualize the Central MESWeb module in the MES Portal
Access the "Access Control" module
Grant permissions to his/herself and others from the Security Manager level to all lower levels
Manage customers (add customers and map part numbers to them)

Report Manager

The Report Manager has access to "Reports" and "Report Groups" modules in the specific location(s) where he/she was designared as Report Manager. Inside those modules, a Report Manager is able to:

Create custom reports and publish them only in his/her location
Edit or Delete existing customer reports in his/her location

Note: Deleting is not possible if the report is published elsewhere

Create Report Groups
Add Reports to Report Groups

Data Source Manager

The Data Source Manager is responsible for creating and updating Data Sources and Data Source types.

A Data Source Manager is able to:

Create, Edit, and Delete Data Sources
Create, Edit, and Delete Data Source types

User (Execution Module only) Section Name

The User role is able to execute only those reports specifically granted access to him/her, and may not create new reports or modify existing reports. Administrators may restrict user access only to data belonging to specific customers and data sources.

MESWeb Parameters

As already has been said before, steps mainly work as filters to be used to execute the report. A step can contain a quantity of parameters, also, a step may or may not be the parent of another subsequent step. Take Customer and Part numbers as examples. In a previous step, the user selects the customer and the part numbers related to the selected customers will be shown.

MESWeb has a collection of parameters highly configurable by the user to help to filter the information, such as;

Dropdown List - This manages a list where only one single option is selected.
Checkbox - A checkbox is used for true/false parameters.
Radio Buttons - Radio buttons allow the user to select one option from the list. Every option selectable is mutually exclusive. This also can be used to show different parameters.
Date - A date parameter is used to select a specific date. This is a variant that also allows the user to select the time.
Date Range - The date range is a parameter that allows selecting a range between two dates. (A variant that also allows the to user selects the time).
Listbox - In a list box, multiple options can be selected. All checkbox allows to user to select every option available on the list. Users can filter options using the checkboxes Starts With, Contains, and Ends With after the user has selected the option and written some text in the text box has to click on the icon to refresh the list.

The (highlighted down-arrow) icon moves all of the options in the "Available" list to the "Selected" list.

The (down-arrow) icon moves only the selected option in the "Available" list to the "Selected" list.

The (up-arrow) icon moves only the selected option in the "Selected" list back into the "Available" list, thus removing it from the "Selected" list.

The (highlighted up-arrow) icon moves all of the options in the "Selected" list back to the "Available" list, thus removing all options from the "Selected" list.

Multi-Line Text Box - It allows adding lines as necessary.

Results

Grids: Once a report is executed, a grid with the results will appear on the right side.
Selected Parameters: The selected parameters will appear on the downside. This contains all the parameters that the user has selected and other useful information such as how many times the report took the application and the execution day.

Actions

There are three principal actions that can be done with the report's results: Print, Export, and Share.

Print: This option allows the user to print the report. After selecting the Print, a dialog box appears. Select Print to display the report’s results.
Export: The Export button downloads a file to the user's PC. The report can be saved in several formats, according to the user's needs Google Sheets, Excel, XML, CSV, and Text.

Follow the steps below to export to Google sheet:

Step 1: Select the Google Sheet option in the drop-down menu:

Step 2: Configure the Google permissions by selecting the correct option:

Step 3: A message will be displayed when the configuration is done:

Step 4: See the report exported in the selected format:

Share: This option is used to share the report's results. The user can share the report via Email or as a Link.

Drilldowns

Drilldowns occur when a link is selected by the user in order to drill down or further expand the data. To access Drilldown reports, select the parent link. This report will generate another report using a parameter passed by the selected link from the first report. This second report will use the default configuration (i.e., WEB format and pagination) to generate the data. WIP serials, a default report that shows the serial numbers and other information, have a Drilldown to Unit History. Drilldowns can be identified by their format; they are all underscored.

MESWeb Reports

MESWeb is designed for user-friendliness, and executing reports is no exception. This guide will walk users through the simple process in just a few steps.

To access the MESWeb Reports page users must have access to the 42Q Portal. Once logged in, users must navigate to: Reporting>MESWeb.

Figure 1: Accessing to MESWeb Reports

Users can access MESWeb Reports from this page by navigating and selecting from the two options available:

Administration
Reports

Reports

Snap Shots

This tool allows users to schedule a report with selected parameters saved at a certain time and sent to certain users.

Follow the steps below to create a Schedule':'

1. Select the configuration icon in the top right corner of the page

2. Select Snap Shots within the list menu to open the Snap Shots window

Figure 2: SnapShot Schedule

3. Select the plus-sign icon to the left of the SnapShot to expand.

4. Select the plus-sign icon to the far right on the schedule bar to open the Schedule Configuration form.

Figure 3: SnapShot Additional Information

''

The Schedule Configuration form appears where the user can enter specific information, such as Name, Time Zone, and Frequency, about the schedule.

The Frequency section allows the user to establish the timing settings for running a report.

Figure 4: Schedule Configuration

In Schedule Information, Name, enabled and Time zone can be modified. In Repeat Every, the user can set all settings on when the report is going to run.

The Period section allows the user to set a date range for execution or repetition. Users can also select how would they like the report to be delivered by choosing from the available options in the Delivery Options section.

Figure 5: Duration and Delivery Options

''

In the example above, the report will be delivered via email in Excel format.

Figure 6: Sending

While sending an email, users have the option to input the date/time stamp as needed within the email and file subject lines.

By clicking on the blue calendar icon, wildcard options will be displayed including:

<%datetime%> → will add “11/25/2020 18:05:50”

<%date%> → will add “11/25/2020”

<%time%> → will add “18:05:50”

<%YYYY%> → will add “2020”

<%MM%> → will add “11”

<%DD%> → will add “25”

<%hh%> → will add “18”

<%mm%> → will add “05”

<%ss%> → will add “50”

Users can also select or combine the wildcards as they choose, for example, if the subject contains: “Test Example <%DD%>_<%MM%>”, then the user will receive mail with the title showing as: “Test Example 25_11”.

This form is shown when users select Email on Delivery Options.

Figure 7: Sending via FTP Server

Once the FTP information has been entered and set up, the user can Save, Cancel, or Delete the scheduled report

Favorites and Most Viewed

MESWeb will automatically save the most viewed reports. This will be shown within the Most Viewedgroup as well as every report has a star on the header that allows the user to save reports on the Favorites group.

CMMS Reports

The CMMS Reports provide users with a list of reports for CMMS activity recorded.

To access this report navigate: to Reporting > MESWeb > CMMS Reports.

Asset Downtime

The Asset Downtime Report can show the downtime lists with the Asset ID, Asset Name, Asset Type, Work Order ID, Department, Location, Line Name, Reporter, and Fixed by.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Asset Type (Optional).
Work Order Status (Optional).
Department (Optional).
Location (Optional).
Line Name (Optional).
Downtime Date Range.
Up Time (Optional).
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 8: Asset Downtime - Data Source

Figure 9: Asset Downtime Report

Asset Event History

The Asset Event History Report can show the Asset Problem/Event lists with the Asset ID, Tag ID, Problem/Event Code, Creation Time and Process Time.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Creation Time in Step 2.
Select Parameters in Step 3.

Asset ID (Optional).
Tag ID (Optional).
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 10: Asset Event History - Data Source

Figure 11: Asset Event History Report

Asset List

The Asset List Report can show the PM Planned and PM Scheduled Assets records with the Asset ID, Asset Name, Asset Type, and other associated information.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

PM Plan Date (Optional)
PM Scheduled (Optional).

Select Parameters in Step 3.

Asset Type (Optional).
Asset ID (Asset Name) (Optional).
Asset Status (Optional).
Location (Optional).
Line Name (Optional).
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 12: Asset List - Data Source

Figure 13: Asset List Report

AVL Detail List

The AVL Detail List Report can show the AVL(Approved Vendor List) details for the spare parts.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Spare Parts Part Number (Optional)
Vendor (Optional)
Indicate if users would like to export just the file.
Select whether or not parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 14: AVL Detail List - Data Source

Figure 15: AVL Detail List Report

Calibration Master and Recall List

The Calibration Master and Recall List Report can show the Asset’s calibration records with the Asset ID, Asset Name, Asset Type, and other associated information. Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Site in Step 2.
Select Parameters in Step 3.

Calibration Date is due.
Planned Date.
Input Status.
Asset Status.
Owning Dept (Optional)
Location (Optional)
Owner (Optional)
Indicate if users would like to export just the file.
Select whether or not parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 16: Calibration Master and Recall List - Data Source

Figure 17: Calibration Master and Recall List Report

Labor History

The Labor History Report can show the Labor history records with the Asset ID, Asset Name, Work Order ID, Location, Line name, Start time, End Time, and Assigned User.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Start Time.
Location (Optional).
Line Name (Optional).
Asset ID (Asset Name) (Optional).
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 18: Labor History - Data Source

Figure 19: Labor History Report

PM Plan List with Work Order

The PM Plan List with Work Order Report can show the Asset’s PM plan work orders with the Asset ID, Asset Name, Asset Type, Work Order ID, Work Order Status, PM ID, PM Type, Plan Date, and other associated information.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

PM Plan Date.
PM Calendar Status (Optional).
Department (Optional).
Assigned Group (Optional).
Work Order Status (Optional).
Asset ID(Asset Name) (Optional).
Indicate if you users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 20: PM Plan List with Work Order - Data Source

Figure 21: PM Plan List with Work Order Report

Spare Parts Details

The Spare Parts Details Report can show the details of the spare parts with the Asset ID, Asset Name, Asset Type, Line Name, Location, Spare Parts’ Part number, Serial Number , WO ID, Load Time, Unload Time and other associated information.
Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Spare Part’s Part Category (Optional).
Spare Part’s Part Number (Optional).
Vendor (Optional).
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 22: Spare Parts Details - Data Source

Figure 23: Spare Parts Details Report

Spare Parts Usage by Asset

The Spare Parts Usage by Asset Report can show the spare parts usage by asset with the Asset ID, Asset Name, Asset Type, Line Name, Location, Spare Parts’ Part number, Serial Number, WO ID, Load Time, Unload Time and other associated information.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Load Time From Date.
Load Time To (Optional).
Spare Part’s Part Number (Optional).
Location Name (Optional).
Line Name (Optional).
Asset Type (Optional).
Asset ID (Optional).
Work Order ID (Optional).
Load User (Optional).
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 24: Spare Parts Usage by Asset - Data Source

Figure 25: Spare Parts Usage by Asset Report

Subinventory Detail List

The Subinventory Detail List Report can show the sub-inventory detail for the spare parts with the Spare parts’ part number, sub-inventory, locator, and QOH.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Spare Parts’ Part Number (Optional).
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 26: Subinventory Detail List Report - Data Source

Figure 27: Subinventory Detail List Report

Tooling Usage Report

The Tooling Usage Report can show the tooling usage records with the Asset ID, Asset Name, Asset Type, Location, Current Usage and Max Usage.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Asset Type (Optional).
Asset ID (Optional).
Start Date (Optional).
To Date (Optional).
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 28: Tooling Usage Report - Data Source

Figure 29: Tooling Usage Report

Tooling Where Used by Serial Number

The Tooling Where Used by Serial Number Report can show the tooling where used with the Serial Number, Part Number, Shop Order, Process, Location, and Date.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Location.
From Date.
To Date.
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 30: Tooling Where Used by Serial Number - Data Source

Figure 31: Tooling Where Used by Serial Number Report

Work Order List

The Work Order List Report can show the work orders with the Work Order ID, Work Order Type, PM ID, Location, Line Name, Asset ID, Asset Name and other associated information.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Date Range.
Assigned Group (Optional).
Requestor Group (Optional).
WO Status (Optional).
Asset ID (Asset Name) (Optional).
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 32: Work Order List Report - Data Source

Figure 33: Work Order List Report

Work Order Status

The Work Order Status Report can show the Work Order status with the Serial Number, Part Number, Shop Order, Process, Location, and Date.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Date Range.
Assigned Group (Optional).
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 34: Work Order Status Report - Data Source

Figure 35: Work Order Status Report

Custom Reports

Custom Reports is a categorization of report types that users can create. Custom reports perform the function of default reports and allow users to be more specific and narrow in their searches within the application.

See the steps below the steps to generate a Custom Report by Serial Number:

Select a data source.
Insert a serial number.
(Optional) Select a plant.
(Optional) Select a year.
(Optional) Select a month.
1. Select whether or not parameters should be hidden when the report is executed.
2. (Optional) Select the interval to refresh the report as needed.

Figure 36: Defautl Report 1

Figure 37: Default Report 1

Note: This report will be able to use the serial number for finding its use in all of the materials from PTSR and Fujitrax databases, and show its scan board data and material information.

These same steps can also help users generate a Custom Report by Date Period.

Note: This report can use a scanning date period to retrieve its serial number.

Customer Active User Report

The Customer Active User Report allows the extraction of active billable users who logged into the 42Q system. The report also provides users with the total billable user count. A billable user is one who is assigned to a billable profile or is assigned to a non-billable profile but has access to reports other than Unit History Reports.

To access this report navigate to Reporting > MESWeb > Activity Reports > Customer Active User Report,

Select a data source.
Select a Client-Server.
Select an IPortal Site.
Select a MESWeb Application.
Profile (Optional) allows users to filter reports by different profiles.
Set the date range to search for which the report should be generated. The date range limit is 31 days.
Click on the Go button. A list of all the active users in the selected date range will be displayed. The last row of the report shows the count of total billable users.

Figure 38: Customer Active User Report Generated

Location Activity Report

The Location Activity Report provides users a list of locations that had any activity recorded (e.g. when a unit is scanned and passed to another location).

To access this report navigate to Reporting > MESWeb > Activity Reports > Location Activity Report

Select a data source.
Select the Mfg Line.
Set the date range to search for location activities within that date range The date range limit is 90 days.
Click on the 'Go' button. A list of locations containing assigned processes, counters of the pass to, and counters of activity.

Note: Pass to count is how many units passed from that location and the Activity counts how many activities were recorded at that location (quantity of attributes or commands that are entered). The report only provides the list of locations that have Passed to count or Activity count values greater than 0.

Figure 39: Location Activity Report Generated

Default Reports

Crew Activity Reports

The Crew Activity Report is a functionality that allows the MESWeb users (Regular and Crew Users) to view the information and activities related to a specific Crew or Crew member.

To enter the Crew Activity Report the user must go to MESWeb> Reports> Default Reports> Crew Activity.

Note: The user can access Crew Activity Reports by selecting them and inserting information for each step provided.

Figure 40: Crew Activity - Data Source

''

Choose the Data Source provided with the drop-down menu of Data Source.
In order to choose a Data Source, users must select the customer. Users can search for a specific member report that may be available by “Crew” or by “Employee Number”.

Users can conduct searches by inserting information in the optional boxes. Users can search by using three options to find searches:

Starts With option: Allows users to search using the first few letter(s) of the name.
Contains option: This allows users to search with letters that are contained within the name.
Ends With option: Allows users to search using the last few letter(s) of the name.

Figure 41: Crew Activity - Crew

''

Once the user types in the first few or last few letters to search, click the Refresh button. Add the desired choice from the Available list to the Selected list by clicking the downward arrow.

Note: A specific Crew name should be selected in order to display the Report Type.

The available options for crews are filtered for the crew name options.

Note: The down arrow will add the selected into the ‘Selected’ box below. The upward arrow will remove the selected from the selected box.

Figure 42: Crew Activity - Report Type

''

Next, select the Report Type desired. The options are as follows:

Crew Activity
Crew Status

Insert the desired time period using the From and To options and select the time for each.

Setting a time period will allow users to see all the activities for a specific crew name selected.

Note: Checking the box for the Hide on executing parameters option will hide the parameters once the report is executed.

Click Go. The reports will be displayed as follows based on the Report Type chosen:

Crew Activity

When the Crew Activity Report is selected, the final form will allow users to view a specific crew name and description concerning information about when the user logged in and logged out.

Figure 43: Report Type - Crew Activity

''

Crew Status

When the Crew Status Report is selected, the final form will allow users to view information concerning crew members' names, descriptions, employee ID, and names.

Figure 44: Report Type - Crew Status

''

Cycle Time Details Report

Cycle Time Details Report provides essential metrics including cycle time, hands-on time, unattended time, and wait time, segmented by each serial and operator activity.

Figure 45: Cycle Time Details Report: Step 1

Cycle Time Details report allows user to filter the report by:

Part Number: Users can optionally select one or multiple parts, for searching a part number use the product list box.
Process: Users can select one or multiple processes, but are not required, to search for a process users need to use the process list box.

If a part is selected for the report generation, the selection of the process in the parameter can be optional.

If a part is not selected then the selection of the process should be mandatory in the parameter.

Figure 46: Step 2

Cycle Time by Details report shows records of individual activity for all the serials and operators. It shows the record of:

Serial Number
Employee Number
Hands-on Time
Cycle Time
Unattended time
Wait Time

At the end of the report provide the total, minimum, maximum, average, and quantity of serials for all the times (hands-on time, unattended time, cycle time, and wait time) add all the Cycle Time reports and Labor by SO/Serial reports as default reports.

Provide the Unit of Measure(UOM) for each time-based data reported (like cycle time, and unattended time).

Cycle Time Report

Cycle Time report displays hands-on time, unattended time, cycle time, and wait time averaged by each process for each part number selected.

Figure 47: Cycle Time Report

For each process cycle time is the average of all the locations for that process.

Cycle Time report allows users to filter the report by:

Part Numbers: Users can optionally select one or multiple parts, this should include product families as well, if a product family is selected provide the cycle time, hands-on time, unattended time, and wait time product family.
Process: Users can optionally select one or multiple processes, for searching by process number use the process list box.

If a part(s) is selected for the report generation, the selection of process in the parameter can be optional. If a part(s) is not selected then the selection of process should be mandatory in the parameter. It has to be either selected by part(s) or by process(s).

Note: Date Range (99 days maximum) required field.

Cycle Time report shows the comparison with the baseline setup in SQC Configuration:

Baseline column: The baseline for a process is the standard time stored in the baseline table for that process by part number. If no baseline is defined in the SQC table display the value as ‘n.a’
Efficiency column: Efficiency is ((Cycle time/Baseline Column Value)*100). If the baseline value is ‘n.a.’ display the efficiency value as ‘n.a’

Note: The cycle time report provides a drill down from cycle time values to the Cycle Time Details report.

Labor Tracking Reports

MESWeb Labor Tracking Report allows administrators to track employee labor records over a 90-day span. Administrators can then Print, Export, Share via Email/Link, or create a Snapshot.

To access the Labor Tracking Report, the user must go to MESWeb > Reports > Default Reports > Labor Tracking.

Figure 48: Labor Tracking - Data Source

''

Choose the data source from the ‘Data Source’ drop-down menu.
Click Next.

Figure 49: Labor Tracking - Customers

''

A list of customers will be displayed once the data source is selected.
Select the customer desired. Once the customer is chosen, it will appear within the selected box.
Click “Next”.

Figure 50: Labor Tracking - Products

''

Within Step 3, users will have four optional parameters to conduct a search. Those options are as follows:

By selecting one or more optional Products.
By selecting one or more optional Shop Orders.
By selecting one or more optional Processes.
By selecting the optional Employee.

Figure 51: Labor Tracking - Shop Orders

''

Users can search by Shop Order by inserting the Shop Order number into the box provided and clicking the refresh button.

Figure 52: Labor Tracking - Processes

''

Users can search by Processes by inserting the processes title into the box provided and clicking the refresh button.

Figure 53: Labor Tracking - Employee

''

Users can search by Employee by inserting the Employee number into the box provided and clicking the refresh button.

Figure 54: Labor Tracking - Report Type

''

Report Types

For Labor Tracking, there are different Report Types such as Employee Efficiency, Labor Tracking, Shop Order Direct, and Indirect Details.

Each one of those reports supports different filters to consume the information of the activity tables.

Upon choosing the desired Report Type, click ‘Next’.

Figure 55: Labor Tracking - Report Time

''

Depending on the previous Report Type chosen, users will then be able to continue with Step 4 by selecting the options desired in each drop-down menu.
Select the Report Time. Options are as follows:

Hours
Minutes

Select the field to Group By, which has a given option based on the Report Type chosen.
Insert the desired time period using the From and To options and select the time for each.

Note: Checking the box for the Hide on execute parameters option will hide the parameters once the report is executed.

Click Go. The reports will be displayed as follows based on the Report Type chosen:

Employee Efficiency

When the Employee Efficiency report is 'Grouped By' Employee and/or Shift, the final form will allow users to view:'

The specific time that a member was working on a certain activity.
Good: quantity of units passed in the period of time selected by each employee.
Scrap: quantity of units scrapped in the period of time selected by each employee.
Standard Hours: the average time or number of hours that takes to manufacture a unit or assembly.
Actual Indirect Hours: total time of indirect activities recorded against specific department/work center throughout Labor Tracking.
Actual Direct Hours: elapsed time between the clock in and clock out of Labor activities.
Actual Total Hours: this comes from the calculation of total hours of indirect/direct activities recorded by employees against a department.
Run Earned Hours: comes from the calculation of actual good parts produced (passed units) * quoted parts per hour (standard run hours).
Run Efficiency Percentage: results from the calculation of Actual Total Hours/(Standard Hours * Throughput) *100.
Utilization Percentage: comes from the calculation of (Direct Hours/Actual Total Hours) * 100.

Figure 56: Report Type - Employee Efficiency Example (left side)

''

Figure 56a: Report Type - Employee Efficiency Example (right side)

''

When the Labor Tracking report is Group By Shop Order, Product, Employee, Shift, Process, and/or Location, the final form will allow users to view the Shop Order, Product, Employee, Shift, Process, or Location, and the direct hours associated with each.

Figure 57: Report Type - Labor Tracking Example

''

Shop Order Direct

When the Shop Order Direct report information is Group By Shop Order, Employee, Shift, and / or Process the final form will allow users to view the employees and the direct hours spent on specific activities.

Figure 58: Report Type - Shop Order Direct Example

''

Indirect Details

When the Indirect Detailed reports are 'Group By' Employee and/or Shift, the final form will allow users to view information regarding employees and direct hours spent on specific activities.

Figure 59: Report Type - Indirect Details Example

''

QCP Details

The QCP Checklist is a functionality that allows the MESWeb users to access a set of questions and answers done previously in Production Workbench.

To enter the QCP Checklist the user must go to MESWeb>Reports>Default Reports, there, three different reports are available: QCP History, QCP Details, and QCP Serials.

Note: The user can access QCP History, QCP Details, and QCP Serials by selecting them.

QCP Details allows the user to see and customize the information placed on the QCP checklist; Name, Status, Employee ID, etc. It also allows the user to see the questions and their respective answers.

The user can drill down from QCP History to QCP Details, by selecting the QCP Name in the list.

Note: The QCP Details have the same steps and the same parameters as QCP History (only the format is different).

Figure 60: QCP Details

'MESWebExecQCP52.png'

Note: The color on the sidebar, changes according to the status; Red= Expired, Green= Active

QCP History

QCP History is divided into four steps which allow the user to see the following parameters:

Step 1: Data Source

Step 2:QCP Name
Step 3: Part Number, Process, Location, Employee, Obsoletes
Step 4: Data range.

Note: These configurations are showing on the left side of the screen, as displayed in the following image:

Figure 61: QCP History Steps

'MESWebExecQCP49.png'

The parameters mentioned above allow the user to have a customized search of the QCP Checklists, all of them are optional, except for Step 1:Source and Step 4: Data Range; as shown in the image below.

The Data Range allows the user to search the previously filled/answered QCP checklists in the selected date ranges; once the user fills in the dates and times, they can click the Go button.

Figure 62: Data Range

'RTENOTITLE'

The QCP information will be displayed on the screen, with their respective configuration; name, version, part number, etc.

Figure 63: Data Range List

MESWebExecQCP51.png

This list shows the Effective Date and the Expiration Date, it also shows the State of the QCP; which can be either Active or Expired, and the Employee ID from the user who filled the QCP checklist.

Note: The Effective Date and the Expiration Date information is associated with every Serial Number, scanned between the active period of the checklist and before it expires.

QCP Serials

To access the QCP Serials, the user can select the option from the QCP Details page, as displayed in the following image:

Figure 64: QCP Serials

'

Once this option is selected, the screen will display the QCP Serials, allowing the users to see the list of serials and their respective information, Serial Number, Part Number, Process, Location QCP name, and the QCP version.

Figure 65: QCP Serials Detail Chart

By selecting the Serial Number, shown in the image above; the user is able to see the Unit History.

This allows the user to see detailed information about the Serial Numbers and all their activity throughout their lifecycle.

Figure 66: Unit History

'

Shop Order

The Shop Order Report presents details for one or more shop orders along with all serials associated with them. It is important for users to track shop orders, and in order to do so, a user needs to be able to see the details of the units that comprise the shop order.

Follow the steps below to generate a Shop Order Report:

1. Select a Data Source

2. Enter up to 1000 Shop Order Numbers

3. Select whether or not parameters should be hidden when the report is executed

4. (Optional) Select the interval to refresh the report as needed

Shop Order Summary

The Shop Order Summary Report displays information about the part numbers, the order status, and the number of units in each status of a shop order.

Follow the steps below to execute the Shop Order Summary Report:

1. Select a Data Source

2. Enter up to 100 Shop Orders (only one per line)

3. Select whether or not parameters should be hidden when the report is executed

4. (Optional) Select the interval to refresh the report as needed

The report result is:

Figure 67: Shop Order Summary Report

By entering one or several Shop orders this report will display information about, their part numbers, order status, and the quantity of units in each status.

Solder Paste Process Tracking

The Solder Paste Process Tracking Report details the Process of any items with the Solder Paste inventory, specified by part and serial numbers. It shows the process, with timestamp data. See the steps below the steps to generate the Solder Paste Process Tracking Report

Select a data source
(Optional) Select a Solder Paste P/N, users can select Starts with/Contains/Ends with the characters
(Optional) Select a Solder Paste S/N
(Optional) Select a Process
(Optional) Select a Step by
Select a date range
Select Display Data as users can select by Web View/Excel File/Google Sheet/XML File/CSV File/Text File
Select whether or not parameters should be hidden when the report is executed.
(Optional) Select the interval to refresh the report as needed.

The report result is:

Figure 68: Solder Paste Process Tracking Report Result

Solder Paste Status Report

The Solder Paste Status Report details the status of any items with the Solder Paste inventory, specified by part and serial numbers. It shows the current status, with timestamp data.

See the steps below the steps to generate a Solder Paste Status Report

Select a data source
(Optional) Select a Solder Paste P/N
(Optional) Select a Solder Paste S/N
(Optional) Select a Solder Paste Status
Select a date range
Select whether or not parameters should be hidden when the report is executed.
(Optional) Select the interval to refresh the report as needed.

The report result is:

Figure 69: Solder Paste Status Report Result

'

Unit History Report

The Unit History Report gives detailed information about a specific unit and all its activities throughout its lifecycle. This allows users to see information about a specific unit and its activity.

Follow the steps below to generate a Unit History Report:

1. Enter up to 150 Serials

2. Select whether or not parameters should be hidden when the report is executed

3. (Optional) Select the interval to refresh the report as needed

Figure 70: Unit History

Unit History Report now has the capability to query data from the MES Archive integrated into the report.

The Archive parameter was added to the report to query archive data or only be notified when searched serials have already been archived.

Figure 71: Unit History

When the report is executed with the Include Archive parameter selected, it will query Archive data for all searched serials that have been archived. Archived serials will be labeled as such, and data will be presented in the same format as regular serials. Both archived and regular serials can be searched at the same time.

When the report is executed with the Include Archive parameter unselected, serials that have been archived will be labeled as such, and the user will be given the option to click the link in order to get the data from Archive. This is to prevent a longer execution time in case the user is unaware serials have been already archived.

A Report executed with Include Archive selected

Figure 72: Unit History

Figure 73: Unit History

A report executed with Include Archive selected

A report executed with Include Archive unselected

Export UH

Allows the user to export the report with the selected format without the render on the screen and to improve the performance.

Figure 74: Export UH

''

Export UH contains two options to export the file; Exclude Measurement Information and Split by Serial and Export as a ZIP file.

Figure 75: Options for Export UH

''

Note: If the users choose to split by serial and export as a Zip if there are multiple serial numbers, the Zip file will create a folder with all the numbers in a file.

Display Data as would allow users to choose from several different kinds of files to download/ view; Web view, Excel File, Google Sheet, XML File CSV File, and Text File.

Unit History With Multimedia File

Production Workbench supports Multimedia Data Collection (PDF, Imagen, and Video) and users can take photos using their computer or tablet camera and upload any multimedia file.

This will be reflected in the Unit History report, where the user is able to see the image upload for the SN.

For more information about Multimedia files, refer to Production Workbench SOP.

Figure 76: Unit History with Multimedia File Attached

Clicking on the image icon, the attached file will be displayed:

Figure 77: Expanded Image

Select the expand icon to see just the image.

Figure 78: Uploaded Image Details

Part Order Summary Report

This report displays the following information about works orders: Part Number, Status, Quantity, and Serial Quantity. It also shows the due date, last activity, and how many days have passed before the due date.

Follow the steps below to generate a Part Order Report:

1. Select a Data Source

2. Enter up to 500 Part Numbers (one per line)

3. Select whether or not parameters should be hidden when the report is executed

4. (Optional) Select the interval to refresh the report as needed

Figure 79: Part Order Summary

''

RTY Report

RTY shows how many activities were created by a Global Process. The report can display the results by month, week, or day.

Follow the steps below to generate an RTY Report:

1. Select a Data Source

2. Select one or more Customers

3. Select the Data Range (Start and End Dates)

4. Select whether or not parameters should be hidden when the report is executed

5. (Optional) Select the interval to refresh the report as needed

Figure 80: RTY Report

'

WIP Distribution Report

The WIP Distribution Report is designed to take the parameters specified by the user and return the number of units that are currently in WIP based on those parameters. The WIP Distribution Report can group results in several ways, depending on the user's preferences. The top level of the results offers the ability to drill down to the unit details. The WIP Distribution Report aims to give users the ability to get a snapshot of where their plant s workload is distributed.

Follow the steps below to generate a WIP Distribution Report:

1. Select a Data Source

2. Select one or more Customers

3. Select one or more Products

4. (Optional) null

5. Select one or more Departments

6. Select one or more Unit Statuses

7. (Optional) Select one or more Processes

8. Select one or more Workstations

9. Select whether or not parameters should be hidden when the report is executed

10. (Optional) Select the interval to refresh the report as needed

Figure 81: WIP Distribution Report

WIP Serials Report

The WIP (Work in Process) Serials Report displays all the serial numbers that are in production.

Follow the steps below to generate a WIP Serial Report:

1. Select a Data Source

2. Select one or more Customers

3. Select one or more Products

4. Select the order that should be used to filter the results

5. Select one or more Departments

6. Select one or more Unit Status

7. Select one or more ways to group the information

8. (Optional) Select a field to group by

9. Indicate if you would like to display charts or not

10. Select whether or not parameters should be hidden when the report is executed

11. (Optional) Select the interval to refresh the report as needed

The report result is:

Figure 82: WIP Serials

Workstation Monitor Report

The Workstation Monitor Report shows how many units have been processed on a particular station.

Follow the steps below to generate a Workstation MonitorReport:

1. Select a Data Source

2. Select a Customer

3. Select a Product

4. Select a Workstation

5. Select the Date and Time Range for the Shift

6. Enter the start time for the first break (format: HH:mm)

7. Enter the end time for the first break (HH:mm)

8. (Optional) Enter the start time for the second break (HH:mm)

9. (Optional) Enter the end time for the second break (HH:mm)

10. (Optional) Enter the start time for the third break (HH:mm)

11. (Optional) Enter the end time for the third break (HH:mm)

12. Enter UPH target.

13. Select whether or not parameters should be hidden when the report is executed

14. (Optional) Select the interval to refresh the report as needed

Figure 83: Workstation Monitor

''

Yield & Defect Report

The purpose of the Yield & Defect Report is to give users a high-level overview of progress. It lists the total number of units with activity, pass/fail quantity, and the yield for each process that is selected (filtered by other parameters as well). From there users can see details about the most common defects for a given process as well as details about each unit.

Managers can use this information to pinpoint the areas on the floor that require their attention and discover why. To execute this report, the user must be in Execution Module, where he/she should select the Reports menu and navigate to Default Reports Yield & Defect Report.

Follow the steps below to generate a Yield & Defect Report:

1. Select a Data Source

2. Select one or more Customers

3. Select one or more Products

4. Select one or more Processes

5. Select one or more Lines

6. Select a Pass to view

7. Select one or more Shifts

8. Select one or more Workstations

9. Enter a Date Range or select one or more Orders

10. Select a field to group by

11. (Optional) Select a second field to group by

12. Choose whether to include moving units

13. Indicate if you would like to consider "No Fault Found" as passes

14. Indicate if you would like to view graphs

15. Select whether or not parameters should be hidden when the report is executed

16. (Optional) Select the interval to refresh the report as needed

The report result is:

Figure 84: Yield & Defect Report

Yield Evolution Report

This report displays the percentage of success of the product for a determined period (Hour/Day/Week/Month). Users can view charts of this data and have tabular data presenting the hour/date/unit/passed/yield of a product. This data is presented via "All Products".

A drilldown report, which offers more details about the product, is available for unit/passed/failed. To execute this report, the user must be in Execution Module, where he/she should select the Reports menu and navigate to Default Reports Yield Evolution Report.

Follow the steps below to generate a Yield Evolution Report:

1. Select a Data Source

2. Select one or more Customers

3. Select one or more Products

4. Select one or more Processes

5. Select one or more Lines

6. Select a pass to view

7. Select one or more Shifts

8. Set the values for the Evolution Parameter

9. Select Start Date

10. Select which field to group by first

11. (Optional) Select which field to group by the second

12. Choose whether to include moving units

13. Indicate if you would like to display charts

14. Select whether or not parameters should be hidden when the report is executed

15. (Optional) Select the interval to refresh the report as needed

The report result is:

Figure 85: Yield Evolution Report

''

Yield Serials Report

The Yield Serials Report displays the following information: Serial Number, Product, Workstation where the action occurred, Serial Quantity, Date of Action, and the Action.

Follow the steps below to generate a Yield Serials Report:

1. Select a Data Source

2. Select one or more Customers

3. Select one or more Products

4. Select one or more Processes

5. (Optional) Select one or more Lines

6. Select a pass to view

7. (Optional) Select one or more Shifts

8. (Optional) Select one or more Global Processes

9. (Optional) Select one or more Workstations

10. (Optional) Filter Data by a Date Range

11. (Optional) Select the number of Shop Orders

12. Select one or more Actions

13. Select whether or not parameters should be hidden when the report is executed

14. (Optional) Select the interval to refresh the report as needed

The report result is:

Figure 86: Yield Serials Report

''

Top Defect Evolution Report

The Top Defect Evolution Report allows users to have a better view of defects registered in MESR for one or more products. Those defects are classified by defect name, which produces a sum (number of defects and percent defect from total) of defects found in a given range for the specific defect. This report also lists the defect total based on a range of time.

Follow the steps below to generate a Top Defect Evolution Report:

1. Select a Data Source

2. Select one or more Customers

3. Select one or more Products

4. Select one or more Processes

5. Select one or more Lines

6. Select a Pass to view

7. Select one or more Shifts

8. Set the values for the Evolution Parameter

9. Select Start Date

10. Select which field to group by first

11. (Optional) Select which field to group by the second

12. Select the type of report you want to run

13. Indicate if you would like to view graphs, and, if so, select the type

14. Select whether or not parameters should be hidden when the report is executed

15. (Optional) Select the interval to refresh the report as needed

The report result is:

Figure: Top Defect Evolution Report

'

OEE Drill Down

To view each report in detail and its corresponding work orders :

Double-click on the desired section of the pie chart or data point on the Pareto chart. The system will prompt the user to select one of the following:

Downtime Trend and Frequency Report
Work Order Report by Problem

Figure 88: System Prompt: Select Report for Drilldown

Double-click on the desired report. The next two figures show each report in a close-up view.

Figure 89: Drill down Downtime Problem Trend and Frequency Report

Figure 90: Work Order Report Drilldown

To view the Work Order, copy the W/O # and search in Production > CMMS Work Order.

Downtime Trend Analysis Report

The Downtime Trend Analysis Report shows production line patterns over time.

Drill Down: Users can access the corresponding Downtime Trend and Frequency Report and the Work Order Report by Problem within this report.

Chart Type: Downtime Trend Analysis Report displays as a Pareto Chart.

Select Data Source
Select Next
Select Date Range: Select the time period (To/From) for the report using the drop-down calendar

Figure 91: Downtime Trend and Frequency Report

By: Select time frame: Month, Week, or Day. (Week is the default)
Display by: Select if users would like the chart to display the number of times the problem occurred (Occurrences) or the time period during which the problem persisted (Duration)
KPI By: Select the Key Performance Indicator the chart will show: Problem, Problem Type, Problem Category, Location, Line, Project, Asset Type, Asset ID, or Overall
Select the Parameters in Step 4
Production PN: (Optional) Select the PN to analyze

Note: PN reports will show data about the product being built.

Production WO: (Optional) Select the Production WO analysis

Note: Work Order refers to the work order assigned in Oracle, and will show data connected to the product build.

Non Stop: (Optional. Default is checked): Check the box to view data that pertains to machinery problems on lines that are still running (nonstop). Uncheck to view only lines which have been shut down due to machinery problems.
Location: (Optional) Select the building, floor, level, etc., etc. Department, Location, or Line.
Production Line: (Optional) Select the manufacturing line.
Asset Id: (Optional): Select the individual Asset to analyze downtime trends.
Asset Type: (Optional) Select the machine (Asset) type to analyze.
WO Project: (Optional) Select the Work Order Project from Oracle’s database to analyze.
Problem Category: (Optional): Select data to display according to a specific Asset Problem (e.g. Misalignment, Jammed). Asset Problems are configured in CMMS Asset.
Problem Type: (Optional): Select data to display according to a specific Asset Problem Type (e.g. Damaged Sensor). Asset Problems are configured in CMMS Asset.

Parameters for Downtime Trend Analysis

Set Parameters in Step 5:

Problem Id: (Optional): Select the Problem for display in the Downtime Trend Report

Parameters: (Checked by default) Uncheck to see parameters displayed next to the report
Refresh Rate: (Do not Refresh is the default) Users can change the refresh rate by minutes up to one hour

Figure 92: Downtime Trend Analysis Report

Drill Downs: Downtime Trend Analysis Reports

To view the detailed report for each downtime trend and its corresponding work orders, double-click on the desired data point on the Pareto chart. The system will prompt the user to select one of the following reports:

Downtime Problem Trend and Frequency

Work Order Report by Problem

Select the desired report. See Drill Downs: Root Cause Analysis Reports to see how the reports and prompts appear in the system.

MTBF And MTTR Report

The MTBF & MTTR are the KPIs for the asset (both CMMS & OEE Configuration system.

Use Case

The product manager views the MTBF & MTTR reports in the monthly machine downtime review meeting.
The product manager determines that all or some of the machine MTBF is out of the expected range.
The repair team needs to look at those lower MTFB hour machine OEE Configuration downtime records and drill down into the root cause of why those machines break quite often. This aims at increasing the production uptime. It might be caused by expired regular maintenance/service etc.
The product manager finds out the overall or MTTR value is longer than the expected recovery time.
The repair team needs to go through the longest MTTR value machine to figure out why the repair time is too long. The repair team needs to identify the root cause, then they will be able to repair the same issue in the shortest time to increase production uptime.

MTBF and MTTR Fields

The Mean Time Between Failures (MTBF) and Mean Time To Repair (MTTR) Reports provide a more detailed view of asset activity, specifically regarding asset failure and repair.

Drill Down: Users can access the corresponding Downtime Problem Chart, as well as corresponding individual problem, reports through this report.
Chart Type: MTBF and MTTR Report displays in Report format.

Select Data Source in Step 1
Select Parameters in Step 2

Site: Select the Plant’s Location
Location: (Optional) Select the building, floor, level, etc., etc. Department, Location, or Line
Asset Type: (Optional) Select the machine (Asset) type to analyze
Asset: (Optional) Select the machine to analyze its performance
Date Range: Select the time period for the report using the drop-down calendar
Parameters: (Checked by default) Uncheck to see parameters displayed next to the report
Refresh Rate: (Do not Refresh is the default) Users can change the refresh rate by minutes up to one hour

Figure 93: MTBF and MTTR Report

Drill Downs: MTBF and MTTR Reports

To see the detailed report for each MTBF And MTTR Report, double click on the Asset ID name.

The Downtime Problem Analysis Chart displays.

Figure 94: MTBF and MTTR Report Drill Down Downtime Problem Analysis Chart

Double click on the section of the pie to select reports specific to that problem.

Downtime Trend and Frequency Report
Work Order Report by Problem

Select the desired report. See Drill Downs: Root Cause Analysis Reports to see how the reports and prompts appear in the system.

MTBF And MTTR Trend Report

The MTBF and MTTR Trend Report show machine failure and repair averages over time.

Drill Down

Users can access the corresponding Downtime Problem and Downtime Root Cause Charts, as well as corresponding individual problem, reports through this report.

Chart Type: MTBF and MTTR Trend Report displays in a Pareto Chart format.

Select Data Source and Next
'Select 'Site: Select the Plant’s Location

Parameters for MTBF And MTTR Trend Report

Select Parameters in Step 3

Location: (Optional) Select the building, floor, level, etc., etc. Department, Location, or Line
Asset Type: (Optional) Select the machine (Asset) type to analyze
Asset: (Optional) Select the machine to analyze its performance
Date Range: Select the time period for the report using the drop-down calendar
Date Type: View by Day, Week, or Month (Week is Default)
Parameters: (Checked by default) Uncheck to see parameters displayed next to the report
Refresh Rate: (Do not Refresh is the default) Users can change the refresh rate by minutes up to one hour

Figure 95: MTBF and MTTR Trend Report

Drill Downs: MTBF and MTTR Trend Reports

To view each MTBF And MTTR Trend Report and their corresponding Work Orders, double click on the desired data point on the Pareto Chart.
The Downtime Problem Analysis and Downtime Root Cause Analysis Charts are displayed.

Figure 96: Drill down for MTBF and MTTR Trend Reports

Double click on the section of the pie to select reports specific to that problem and its corresponding Work Order:

Downtime Trend and Frequency Report
Work Order Report by Problem

Select the desired report. See Drill Downs: Root Cause Analysis Reports to see how the reports and prompts appear in the system.

History Status drill down report

Users can click the Asset Name column and drill down to the sub-report History Status to view the detailed information.

Figure 97: History Status

1.Double click on the desired Asset Name and a more detailed oriented chart will appear like the one shown above.

Report OEE by Product or Product Family

The Report OEE by Product or Product Family provides information concerning the view of Asset IDs, Asset names, Line Names, Product and Product Family, OEE, and more.

Select Data Source in section Step 1.
Select Site.
Select Parameters, for the given outcome :

Line Name
Asset ID
Product
Product Family
Data Range

Click “Go”.

Figure 98: Report OEE by Product or Product Family

''

Report OEE by Shop Order

Users have the ability to view the details of the report of OEE by Shop Order and the surrounding information for specific Asset IDs.

Select Data Source in section Step 1.
Select Site.
Select Parameters, for the given outcome:

Line Name
Asset ID
Shop Order
Date Range
Click “Go”.

Figure 99: Report OEE by Shop Order

''

OEE Reports

The OEE Reports are available in MESWeb to include all historical OEE and underlying metrics data available in 42Q.

The following section will go over each available OEE Report, their parameter options, and drill-down features that will help users to go from broader, higher-level information into the details that will help teams troubleshoot and find efficiency-related problems on assets and manufacturing lines.

Downtime Root Cause Analysis Report

The DowntimeRoot Cause Analysis report is the primary OEE Configuration 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.

Select Data Source
Select Site: Select the Plant’s Location.
Select Date Range in Step 3

Figure 47:Downtime Root Cause Analysis

Parameters for Downtime Root Cause Analysis

Date Range: Select the time span (From/To) for the report using the drop-down calendar.

Figure 48: Data Range

Location: (Optional) Select the building, floor, level, etc., etc. Department, Location, or Line
Production Line: (Optional) Select the manufacturing line
Asset: (Optional) Select the machine to analyze its performance
Asset Type: (Optional) Select the machine type to analyze
Project: (Optional) Select the project for analysis
Asset: (Optional) Select the machine to analyze its performance
Production PN: (Optional) Select the PN to analyze

Note: PN reports show data about the product being built according to the specified Part Number (PN).

Production WO: (Optional) Select the Production WO to analyze

Note: Work Order refers to the work order assigned in Oracle, and will show data connected to all activity for the specified Work Order.

Non Stop: (Optional. Default is checked): Check the box to view data that pertains to machinery problems on lines that are still running (non stop). Uncheck to view only lines which have been shut down due to machinery problems
Problem Category: (Optional): Select data to display according to a specific Asset Problem Category (e.g. Misalignment, Jammed). Asset Problem Categories are configured in CMMS Asset
Problem Type: (Optional): Select data to display according to a specific Asset Problem Type (e.g. Damaged Sensor). Asset Problems are configured in CMMS Asset
Display by: Select the type of Problems to display in the charts. Options include Problem, Problem Type, or Problem Category. Asset Problems are configured in CMMS Asset.
Root Cause By: Select if you would like the chart to display all Root Causes (Root Cause) or a broader set of data (Root Cause Category).
Calculate by: Select if you would like the chart to display the number of times the problem occurred (Occurrences) or the time period during which the problem persisted (Duration)
Chart Type: Select Pareto or Pie Chart
Top: (Optional) (Default is 5) Select the number of results to display in the chart. (5 - 20)
Charts to Display: Tell the system to create the type and number of charts to create: Both Problem/Root Cause (will display together), Downtime Problem, or Downtime Root Cause.
Display Data as: Select the kind of document you want, Web view, Excel, Google sheet, XML, CSV, or Text.
Parameters: (Checked by default) Uncheck to see parameters displayed next to the report.
Refresh Rate: (Do not Refresh is the default) Users can change the refresh rate by minutes up to one hour.

Figure 49: Downtime Root Cause and Downtime Problem Pie Chart

Figure 50: Downtime Root Cause and Downtime Problem Pareto Chart

Energy Consumption by Product

The Energy Consumption By Product Report allows users to display the data by product.

Chart Type: Data displays in Pareto Charts.

Select Data Source.
Select Site.
Select Next.
Select Parameters in Step 3

(Optional) Asset ID (Asset Name)
(Optional) Line Name
(Optional)Part Number
Sensor Type: Power, Gas, Water.
Start Time
End Time
Indicate if you would like to export just the file.
Select whether or not parameters should be hidden when the report is executed.
(Optional) Select the interval to refresh the report as needed.

Figure 51: Energy Consumption by Product- Data source

Figure 51a: Energy Consumption by Product Report

Energy Consumption by Shop Order

The Energy Consumption By Shop Order Report allows users to display the data by shop order.

Chart Type: Data displays in Pareto Charts.

Select Data Source.
Select Site.
Select Next.
Select Parameters in Step 3

(Optional) Asset ID (Asset Name)
(Optional) Line Name
(Optional) Shop Order
Sensor Type: Power, Gas, Water.
Start Time
End Time
Indicate if you would like to export just the file.
Select whether or not parameters should be hidden when the report is executed.
(Optional) Select the interval to refresh the report as needed.

Figure 52: Energy Consumption by Shop Order - Data source

Figure 52a: Energy Consumption by Shop Order Report

Historical Energy Consumption

The Historical Energy Consumption Report allows users to display historical data by product.

Chart Type: Data displays in Pareto Charts.

Select Data Source.
Select Site.
Select Next.
Select Parameters in Step 3

(Optional)Asset ID (Asset Name)
(Optional) Line Name
(Optional) Location Name
(Optional) Shop Order
(Optional) Part Number
Sensor Type: Power, Gas, Water.
Start Time
End Time
Indicate if you would like to export just the file.
Select whether or not parameters should be hidden when the report is executed.
(Optional) Select the interval to refresh the report as needed.

Figure 53: Historical Energy Consumption - Data source

Figure 53a: Historical Energy Consumption Report

OEE Dashboard

The OEE Dashboard Report allows users to display historical data in a similar fashion that the 42Q Operations Dashboard OEE Widget would.

Drill Down Reports: Users can access the corresponding Downtime Problem and Downtime Root Cause Charts, as well as corresponding individual reports through this report.
Chart Type: Data displays in Gauge meters with a target range of colors noted as critical (red), cautionary (yellow), or performing as expected (green). Gauge meters follow the same configuration rules set for 42Q Live in Target Maintenance. See Setting Target UPHsfor configuration steps.

Select Data Source
Select Next
Select Date Range
Select Parameters in Step 2

Figure 51: OEE Dashboard

Site: Select the Plant’s location

Group by: Select Department, Location, or Line

Time Range Type (Optional): Select Last hour, Last 24 hours, Current day, or Current shift

Date Range: Select the time period for the report using the drop-down calendar

Display By: (Optional) Select OEE, TEEP, or OEE & TEEP

Order By: (Optional) Select ASC, DESC

Parameters: (Checked by default) Uncheck to see parameters displayed next to the report

Refresh Rate: (Do not Refresh is the default) Users can change the refresh rate by minutes up to one hour:

Do not refresh(by default)
1 -5 minutes
10 minutes
15 minutes
30 minutes
60 minutes

Note:Users can view all production lines simultaneously on a single screen, or select a single production line or machine.

Figure 52: OEE Dashboard Report

Drill Downs: OEE Performance By Asset

To see the corresponding OEE Performance by asset Charts:

Select the OEE value in the center of the gauge.

Figure 53: First Drill Down

The OEE Performance by Asset chart will show

Figure 53a: OEE Performance by Asset

Calculation: Parallel/Serie.

Parallel: The Line OEE value will show the OEE average value of all the assets.
Serial: The Line OEE value will show the OEE asset with the less OEE belonging to the line selected.

Select the desired report. See Drill Downs: Root Cause Analysis Reports to see how the reports and prompts appear in the system.

Note: Please make sure to first configure: Location, department, and production line, before viewing the reports.

OEE Report

The OEE Report is a linear report that includes the OEE metric (A, P, Q) for each asset by production line over time, according to Asset.

Drill Down: Users can access the correspondingDowntime Problem and Downtime Root Cause Charts, as well as a corresponding individual problem, reports through this report.

Other Drill Down Reports available include:

OEE Availability Drill Down
OEE Performance Detail Drill Down
OEE Quality Detail Drill Down
Production Time
Scheduled Downtime
Unscheduled Downtime
Chart Type: The OEE Report displays in a linear Report style format.

'Select' Data Source

Figure 54: Select Data Source

Select Site: Select the Plant’s Location

Parameters for OEE Report

Select Parameters in Step 3

Line Name: (Optional) Select the manufacturing line
Asset Name: (Optional) Select the name of the Asset to analyze
Date Range:
- From: Selects the time period for the report using the drop-down calendar
- To: Select the time period for the report using the drop-down calendar
Group By: Select the option to group by Month, Week, Shift, or Day
Display Data as: Selects the view options of the file
Parameters: (Checked by default) Uncheck to see parameters displayed next to the report.
Refresh Rate: (Do not Refresh is the default) Users can change the refresh rate by minutes up to one hour.

Figure 55: OEE Report

To see the OEE Availability report for each OEE Configuration Report, click on the Availability name.

Figure 55a: OEE Availability

OEE Trend Chart Report

The OEE Configuration Trend Chart shows historical data to coincide with live time OEE Configuration reports defined in Operations Dashboard.

Drill Down: Users can access the corresponding Downtime Problem and Downtime Root Cause Charts, as well as corresponding individual reports through this report.

Chart Type: Data displays in Pareto Charts.

Select Data Source
Select Site
Select Next
Select Parameter in Step 3

Line: (Optional) Select the manufacturing line
Asset: (Optional) Select the machine to analyze its performance
Date Range: Select the time period for the report using the drop-down calendar
Display By: Select Day, Week, or Month (Month is Default)
Parameters: (Checked by default) Uncheck to see parameters displayed next to the report
Refresh Rate: (Do not Refresh is the default) Users can change the refresh rate by minutes up to one hour

Figure 56: OEE Trend Chart

Drill Downs: OEE Configuration Trend Chart

To see the corresponding Downtime Problem Analysis and Root Cause Analysis Charts:

Select the data point on the OEE Configuration Trend Chart. The charts will display.
Double click on the section of the pie to select reports specific to that problem and corresponding Work Orders.

Figure 57: First Drill Down for OEE Configuration Trend Chart

Downtime Trend and Frequency Report
Work Order Report by Problem

Figure 58: Second Drilldown: OEE Configuration Trend Chart

Select the desired report.

OEE Asset Status

The OEE Asset Status report can show the different asset statuses Running, Spare, In Maintenance, Unscheduled Down, Scheduled Down, Setup, Idle, and Calibration.

Drill Down: Users can access the corresponding Downtime Problem and Downtime Root Cause Charts, as well as corresponding individual reports through this report.

Chart Type: Data displays in Pareto Charts.

Select Data Source
Select Site
Select Next
Select Parameters in Step 3

Location: (Optional) Select the location
Or Line: (Optional) Select the manufacturing line
Or Asset: (Optional) Select the machine to analyze its performance.
Date Range: Select the time period for the report using the drop-down calendar.
Parameters: (Checked by default) Uncheck to see parameters displayed next to the report.
Refresh Rate: (Do not Refresh is the default) Users can change the refresh rate by minutes up to one hour.

Figure 59: OEE Asset Status

Drill Downs: OEE Asset Status Problem and Trend Chart

To see the corresponding Asset Status Problem Analysis:

Select the data point on the OEE Asset Status Problem Chart. The charts will display.

Figure 59a: OEE Asset Status trill down

Figure 60: First Drill Down for OEE Asset Status Problem Chart

Select the data point on the OEE Asset Status Trend Chart. The charts will display.

Figure 61: Second Drilldown: OEE Asset Status Trend Chart

System Connectivity Chart

Figure 62: Connectivity Chart

Drill Downs OEE Configuration Dashboard

To see the corresponding Downtime Problem Analysis and Root Cause Analysis Charts:

Select the OEE Configuration value in the center of the gauge.
The Charts will display:

Figure 63: Drilldown for OEE Configuration Reports

Double-click on the section of the pie to select reports specific to that problem and to view corresponding Work Orders.

Downtime Trend and Frequency Report
Work Order Report by Problem

Select the desired report. See Drill Downs: Root Cause Analysis Reports to see how the reports and prompts appear in the system.

Note: Please make sure to first configure the location, department, and production line, before viewing the reports.

PTSR Reports

The PTSR Reports provides users a list of reports for the part traceability system .

To access this report navigate to Reporting > MESWeb > PTSR Reports.

Figure 134: PTSR Reports

Barcode Information

The Barcode Information Report can show the barcode in detail with the Barcode, Part number, date code, create date, total qty, current qty, incoming number, manufacturer name, MSD lever, Orientation, thickness, and other associated information. Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Enter Date Code in Step 2.
Select Next.
Select Parameters in Step 3.

Component Barcode (Optional)
Incoming Number (Optional)
Part Number (Optional)
Indicate if users would like to export just the file.
Select whether or not parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure:135 Barcode Information Report

Boards In Model

The Board in Model report can be used to display information about serials that have been scanned with a selected BOM P/N, Boards S/N barcode, first scan time, and last scan time. The date range to display scan time should be maximum of 90 days. If the date range selected exceeds 90 days, the user receives an error prompt.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

BOM P/N
Scan Time (Maximum 90 days)
Indicate if users would like to export just the file.
Select whether or not parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional).

Figure 136: Boards In Model

Boards In Work Order

The Boards In Work Order Report can show the boards information for one Work Order with the WO Number, Board barcode, First scan time, Last scan time. Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Work Order
Scan Time (Optional)
Indicate if users would like to export just the file.
Select whether or not parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 137: Board In Work Order

Fujitrax - Operator Trace Log

The Fujitrax Operator Trace Log can show the logs of the Fujitrax operation with the Time, System, Operator, Operator action, Result, and other associated information. Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Log Time period (Optional)
Component Barcode (Optional)
Previous Component Barcode (Optional)
Date Code (Optional)
Machine (Optional)
Part Number (Optional)
Indicate if users would like to export just the file.
Select whether or not parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 138: Fujitrax - Operator Trace Log

Load Material Initial Quantity Report

The Load Material Initial Quantity Report can show the initial quantity of the material when it was loaded to the workstation.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Barcode
Indicate if users would like to export just the file.
Select whether or not parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 139: Load Material Initial Quantity Report

Material on Board

The Material on Board can show all the materials information that was loaded to the board.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Source (Optional).
Board barcode.
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 140: Material on Board

Material on Board by Batch

The Material on Board by Batch can show all the materials information that was loaded to the boards, users can input more than one board barcode.

Chart Type: Data displays in Pareto Charts.

SelectData Source in Step 1.
Select Next.
Select Parameters in Step 2.

Source (Optional).
Board Serial No.
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 141: Material on Board by Batch

Material Report

The Material Report can show the material information in detail with Create date, barcode, RT No., MSD level, Manufacturer, current quantity, Date code, expiration date, when used.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Material barcode(Optional) .
Material Part Number(Optional) .
Lot Code(Optional) .
Date Code(Optional) .
Incoming Number(Optional) .
Manufacturer Part Number(Optional) .
Manufacturer Name(Optional) .
Created Date(Optional)
Expire Date(Optional) .
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 142: Material Report

Material Where Used

The Material Where Used Report can show the scanned board number, production line, and other information where the material used.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Component barcode.
Date Range
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 143: Material Where Used

Receipt Traveler Report

The Receipt Traveler Report can show the receipt traveler information in detail with receiving date, receiving number, Lot code, Date code, Part number, Quantity, company name, Manufacturer.

Chart Type: Data displays in Pareto Charts.

Select Data Source in Step 1.
Select Next.
Select Parameters in Step 2.

Incoming Number(Optional) .
Created Date
Indicate if users would like to export just the file.
Select whether or not the parameters should be hidden when the report is executed.
Select the interval to refresh the report as needed (Optional) .

Figure 144: Receipt Traveler Report

SOMS Reports

The SOMS Global Status Report is designed to start with a high-level overview of a plant's current operating status. The user can see the current number of units that are in the WIP, the yield for the current and previous days, and the throughput for the current and previous days for each of the plant's levels. Users also have the ability to drill down into a single level to see the same information broken out by line and process. The report is designed to give a quick snapshot of the health of a plant operation.

Follow the steps below to generate a SOMS Report:

1. Select a Data Source

2. (Optional) Enter the Mfg Line Name

3. (Optional) Enter the Scanner ID

4. (Optional) Enter the Multi-Pass Location Name

5. Select whether or not parameters should be hidden when the report is executed

6. (Optional) Select the interval to refresh the report as needed

Figure: SOMS Setup

''

Glossary

Availability: An OEE Configuration variable that depicts an asset’s uptime/downtime. Any stoppage (breaks, lunches, waiting for parts, malfunction, setup, emergencies) is part of this calculation; plants must account for all stoppages, even if they are planned.
Level: The building, floor, or plant on which the dashboard is displayed.
Layers: The data that is displayed on the 42Q Live Monocle Dashboard. 42Q offers 3 layers:

The Machine layer displays cycle time status (green - asset is performing at expected levels; yellow - asset is performing below optimal levels and requires attention; red - asset is performing severely below level, and may be stopped.) Machine status is determined by comparing scanning activity (throughput and cycle time) during a set period of time to target yield values predefined in target maintenance.
TP/Yield layer (also referred to throughout this document as the MES 101 layer) shows throughput and yield values for the selected level, and the current status of each production line (ok, acknowledged, on hold, critical, and idle).

Note: The MES 101 and Machine target values are defined in the Target Maintenance portal, using the soms_target table.

The OEE Configuration layer shows OEE Configuration statistics for the specific asset; OEE Configuration layers are color-coded according to predefined target ranges (red = levels are below defined OEE Configuration target values; yellow = approaching cautionary values; green = within acceptable OEE Configuration values).

Note: OEE Configuration target values are defined in the Target Maintenance portal, using the OEE Configuration_target_ table.

MTBF: Mean time between failures (MTBF) is the predicted elapsed time between inherent failures of a system during operation.
MTTR: Mean time to failure (MTTF), measures the average time between failures.
OEE Configuration: Overall Equipment Effectiveness. OEE Configuration factors together three variables (A, P, and Q (see below), to calculate a value that depicts an asset’s speed (how fast the asset produces), quality (good vs. bad products), and consistency (downtimes).
Performance: An OEE Configuration variable that depicts how fast an asset is produced.
Quality: An OEE Configuration variable that depicts the number of good products divided by the number of bad products. Good Units produced as a percentage of the Total Units Started. It is commonly referred to as the first pass yield (FPY).
Snapshots: Dashboard “pictures” that capture a common scenario on an individual factory floor. Users create snapshots to show asset status for information pertinent to their plants. For example, a user might want to compare Availability values for three different customers that use Fuji machinery. This user would create a snapshot showing downtimes for each line with Fuji equipment running per customer. This user could create another set of snapshots to show the target yield for their Fuji production lines and can configure each snapshot to run daily, weekly, etc. When customers visit, plant admins can quickly share Fuji line status, by accessing the configured snapshots.
Target Maintenance: 42Q Portal where users configure target parameters for their unique plant requirements, upon which 42Q Live reports display.
Target Yield: The ideal yield for a given asset, against which the actual yields are measured; critical status is displayed based on the comparison of target yield and actual yield.
TEEP: A calculation that measures OEE Configuration against total available production time.
Widgets: Individual Graphic User Interfaces for 42Q Live. Widgets allow users to quickly set up dashboards and bypass complicated coding, to view live-time productivity on their shop floors.

@@ Line 1,789: / Line 1,789: @@
 &nbsp;
-=== <span class="mw-headline" id="Yield_Serials_Report">Yield Serials Report</span> ===
+=== <span class="mw-headline" id="Yield_Serials_Report"><span class="mw-headline" id="Yield_Serials_Report">Yield Serials Report</span></span> ===
 The Yield Serials Report displays the following information: Serial Number, Product, Workstation where the action occurred, Serial Quantity, Date of Action, and the Action.
@@ Line 1,813: / Line 1,814: @@
 . (Optional) '''Select''' one or more Workstations
-. (Optional) '''Filter''' data by a Date Range
+. (Optional) '''Filter''' Data by a Date Range
-. (Optional) '''Select '''number of Shop Orders
+. (Optional) '''Select the&nbsp;'''number of Shop Orders
-.'''Select''' one or more Actions
+.&nbsp;'''Select''' one or more Actions
 . '''Select '''whether or not parameters should be hidden when the report is executed
@@ Line 1,827: / Line 1,828: @@
 &nbsp;
-'''Figure 138: Yield Serials Report'''
+'''Figure 86: Yield Serials Report'''
 ''''''[[File:MW-Yield Serials Report.png|900px|RTENOTITLE]]''''''

Difference between revisions of "SOP-42Q-MES0055 MESWeb Reports"

Revision as of 16:31, 14 May 2024

Contents

Introduction

Access Level

Administrator (System Administrator)

Security Manager (Local Administrator)

Report Manager

Data Source Manager

User (Execution Module only) Section Name

MESWeb Parameters

Results

Actions

Drilldowns

MESWeb Reports

Reports

Snap Shots

Favorites and Most Viewed

CMMS Reports

Asset Downtime

Asset Event History

Asset List

AVL Detail List

Calibration Master and Recall List

Labor History

PM Plan List with Work Order

Spare Parts Details

Spare Parts Usage by Asset

Subinventory Detail List

Tooling Usage Report

Tooling Where Used by Serial Number

Work Order List

Work Order Status

Custom Reports

Customer Active User Report

Location Activity Report

Default Reports

Crew Activity Reports

Crew Activity

Crew Status

Cycle Time Details Report

Cycle Time Report

Labor Tracking Reports

Report Types

Employee Efficiency

Shop Order Direct

Indirect Details

QCP Details

QCP History

QCP Serials

Shop Order

Shop Order Summary

Solder Paste Process Tracking

Solder Paste Status Report

Unit History Report

Export UH

Unit History With Multimedia File

Part Order Summary Report

RTY Report

WIP Distribution Report

WIP Serials Report

Workstation Monitor Report

Yield & Defect Report

Yield Evolution Report

Yield Serials Report

Top Defect Evolution Report

OEE Drill Down

Downtime Trend Analysis Report

Parameters for Downtime Trend Analysis

Drill Downs: Downtime Trend Analysis Reports

MTBF And MTTR Report

MTBF and MTTR Fields

Drill Downs: MTBF and MTTR Reports

MTBF And MTTR Trend Report

Drill Down

Parameters for MTBF And MTTR Trend Report

Drill Downs: MTBF and MTTR Trend Reports

History Status drill down report

Report OEE by Product or Product Family

Report OEE by Shop Order