Get started with 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.