MES BI Gateway Reports

Manufacturing Execution System (MES) BI Gateway Reports are SQL Server Reporting Service (SSRS) reports based on the BI Gateway software solution. The BI Gateway services extract data from the MES database, transform it, and populate the MES data in the BI Gateway database. This data is then available to the following MES BI Gateway Reports for viewing and analysis.

The reports are listed below.

Production by Entity Report

Summarizes good and reject production counts by line, entity, and shift.

Line Production Report

Summarizes production counts by line, entity, shift, work order, and item and displays production over time or item.

Genealogy by Work Order Report

Shows, by work order, which input or raw material items were consumed directly and indirectly to create production items.

Genealogy by Lot Report

Shows, by lot, which work orders and produced lots consumed specific raw materials.

Utilization Timeline Report

Displays a color time line of utilization states by entity.

Utilization by Entity Report

Summarizes event counts and durations by line, entity, and shift.

Utilization Analysis Report

Displays event counts and durations by reason, reason group or category, and by entity.

Utilization Waterfall Chart

Shows successive chart entries of time spent in utilization reasons and states to indicate how the effective production time for an entity is derived.

OEE Analysis Report

Shows Overall Equipment Effectiveness (OEE) and its components (Availability, Performance, and Quality) by entity over time.

Mean Time Between Failures (MTBF) Report

Calculates the failure counts and mean time between failures by entity.

Mean Time to Repair (MTTR) Report

Calculates the event counts and mean time to repair an entity.

Performance Dashboard

Shows several panels of at-a-glance performance summary data for an entity over a specified time period.

Quality Summary Report

Shows out-of-specification and out-of-control Pareto charts and summary statistics based on equipment, product (item), work order, operation, process, and item category.

Quality Characteristic Detail Report

Provides information on sample data and Statistical Process Control (SPC) charts based on characteristics and multiple filters.

For information on how to install and configure BI Gateway and the MES BI Gateway Reports, refer to the MES Installation Guide or online help.