Utilization by Entity report

The Utilization by Entity report shows utilization data for entities. Data can be filtered by:

• Time period

• Shifts

• Lines

• Entities

• Items

• Event types

• Utilization states, reason groups, and reasons

• Category

Utilization data is displayed in tabular format and includes total counts and durations for events, and details about each event by line, entity, and shift.

The Utilization by Entity report uses the calendar day instead of the production day, since this report totals the event durations that occur in the time period. The current BI Gateway model does not include the hours and minutes for when a production day starts for each entity, so it uses the event time and midnight for the start and end of a day, respectively.

With millions of utilization records in the database, this report takes approximately 20 seconds for one entity for one day. Additional entities and longer time periods increase the response time with the number of entities having a greater impact than the number of days. Ten entities for one week displayed in approximately 30 seconds in a testing environment while one month displayed in 40 seconds.