Reports

Available Reports

Essembi includes a set of built-in manufacturing reports available in the main module. Each report is powered by a dedicated data engine that queries production data across work orders, routings, lines, formulas, and related tables. Reports support schema table filters for narrowing results and report options for controlling time windows, dimensions, and calculation behavior.

How Filters Work

Two layers of filtering apply to most reports:

• Report options: Fields shown in the report UI such as time window, dimension, and toggles like "Subtract Incident Time."
• Schema table filters: Tables available to narrow results in the reporting UI, such as Work Order, Line, Routing, and Formula.

Shared Production Concepts

The following concepts apply across all routing-based reports and are referenced throughout the individual report definitions below.

Effective Schedule (Run Time Window)

Run time for a routing is derived from the work order routing's effective schedule:

• If Actual Start is null: the span uses Planned Start -> Planned Finish.
• If Actual Start is set and Actual Finish is set: span = Actual Start -> Actual Finish.
• If Actual Start is set and Actual Finish is null (in-process): span = Actual Start -> now.

Elapsed hours for a routing are the finish minus start, optionally adjusted for incident time depending on the report.

Effective Run Time and Quantity (Standard / Planned Side)

The effective run time and quantity use the linked Routing values, plus any active overrides from a Run Rate Rule. For a fixed time type, run time for a batch does not scale with quantity. For a per-unit time type, yield equals quantity times expected yield percent, and ideal minutes per unit scales to the requested quantity or run minutes.

Subtract Incident Time

When the "Subtract Incident Time" option is enabled, incident duration is removed from elapsed routing hours before calculations. Behavior differs by report: Run Rates - By Work Order and Labor reports subtract all active incident durations regardless of type, while Run Rates - Hourly Buckets only subtracts incidents flagged as Downtime type, limited to their overlap with each hour bucket.

Routing Override Rules

Before many calculations, the routing override engine may override the effective time type, run time, quantity, and expected yield for a work order routing. Standard and expected units respect active Run Rate Rules when configured.

Active Work Orders

A real-time status and forecast view for currently active work orders. Shows actual hours, run rate performance, projected quantities, and incident status across all started production routings.

Labor Costs - By Work Order

Labor efficiency analysis grouped by individual work order, line, and formula. Compares actual labor cost per unit to the target labor cost per unit and calculates the delta.

Labor Costs - By Formula

Labor efficiency rolled up by formula and line across multiple work orders. Useful for identifying which formulas are over or under target labor cost across production runs.

OEE - Daily Buckets

Daily OEE trend for a selected dimension over a configurable number of days. Results are aligned to local calendar days using the organization's timezone offset.

OEE - Hourly Buckets

Intraday OEE trend broken into one-hour buckets for a selected dimension. Useful for identifying hour-by-hour performance shifts within a production run.

OEE - Time Span

A single OEE aggregate for an arbitrary start-to-end window. Returns one result row per selected dimension value rather than bucketed intervals.

OEE Calculations (Shared Across All Three OEE Reports)

OEE = Availability x Performance x Quality, stored and displayed as percentages. All three components are calculated per routing span and then aggregated with weighted averages based on overlap duration within each bucket or time span.

Production Events

A timeline and event feed combining work order routing windows and incident windows into a single chronological view. Useful for reviewing what was running and when incidents occurred across lines during any time period.

Run Rates - By Work Order

Actual versus standard run-rate performance grouped by work order, line, and formula. Shows whether each work order ran at, above, or below standard and by how many units.

Run Rates - Hourly Buckets

Hourly run-rate performance trend over a configurable time window. Breaks production output and efficiency into one-hour buckets to identify where performance improved or declined within a shift or day.

Throughput Summary

Summarized throughput from sensor captures, including quantity totals, difference between successive sensor readings, and run rate metrics. Only sensors with Record Throughput enabled contribute to this report.

Shared Calculation Reference

Run rate and OEE calculations use the shared production concepts above (effective schedule, effective run time and quantity, subtract incident time, and routing override rules) applied consistently across every report on this page.