Apparatus and method for workflow analytics and visualization of assimilated supply chain and production management (SCPM) for industrial process control and automation system

An apparatus for workflow analytics and visualization of assimilated supply chain and production management for an industrial process control and automation system, the apparatus comprising:

• at least one processing device configured to:
• obtain information identifying transactions from multiple sources including information from external source systems, the transactions related to multiple functional domains of a supply chain associated with at least one industrial process in the industrial process control and automation system, the step of obtaining includes configuring a unified model based on source system models for each of the external source systems and based on one or more equipment of the industrial process control and automation system, wherein the unified model is configured using a configuration tool by integrating the source system models of the external source systems and mapping of the one or more equipment with the unified model;
• store the information in a data store according to the unified model, the unified model representing all of the multiple sources, wherein the data store includes a common relational database that consolidates the information from the multiple sources;
• provide a common user interface for different functional users, the common user interface operated by a computing device and configured to display multiple views, reports and visualizations associated with the transactions;
• obtain, according to a user input at the common user interface, one or more metrics and one or more analytics from the data store, the one or more metrics and the one or more analytics associated with the obtained information, wherein the one or more analytics comprise a visualization of the one or more metrics over a period of time and at a requested interval using a time format associated with a time zone of a client machine;
• and
• configure using a customizable template operated by the computing device the common user interface to display, according to the user input, at least one visualization involving the one or more metrics and the one or more analytics in a requested unit of measure for a requested reporting interval, wherein configuring the common user interface to display the at least one visualization comprises:
• obtaining a subset of the information from the data store;
• calculating values for the one or more metrics using the obtained subset of the information;
• and
• configuring the common user interface to display the calculated values for the one or more metrics in a format defined by the one or more analytics using an equipment or material filter selected for the one or more metrics, and
• wherein the one or more metrics is used by an external system for monitoring key performance indicators (KPIs) or other information about the industrial process control and automation system.

A non-transitory computer readable medium for workflow analytics and visualization of assimilated supply chain and production management for an industrial process control and automation system containing instructions that when executed cause at least one processing device to:

• obtain information identifying transactions from multiple sources including information from external source systems, the transactions related to multiple functional domains of a supply chain associated with at least one industrial process in the industrial process control and automation system, the step of obtaining includes configuring a unified model based on source system models for each of the external source systems and based on one or more equipment of the industrial process control and automation system, wherein the unified model is configured using a configuration tool by integrating the source system models of the external source systems and mapping of the one or more equipment with the unified model;
• store the information in a data store according to the unified model, the unified model representing all of the multiple sources, wherein the data store includes a common relational database that consolidates the information from the multiple sources;
• provide a common user interface for different functional users, the common user interface operated by a computing device and configured to display multiple views, reports and visualizations associated with the transactions;
• obtain, according to a user input at the common user interface, one or more metrics and one or more analytics from the data store, the one or more metrics and the one or more analytics associated with the obtained information, wherein the one or more analytics comprise a visualization of the one or more metrics over a period of time and at a requested interval using a time format associated with a time zone of a client machine;
• and
• configure using a customizable template operated by the computing device the common user interface to display, according to the user input, at least one visualization involving the one or more metrics and the one or more analytics in a requested unit of measure for a requested reporting interval, wherein configuring the common user interface to display the at least one visualization comprises:
• obtaining a subset of the information from the data store;
• calculating values for the one or more metrics using the obtained subset of the information;
• and
• configuring the common user interface to display the calculated values for the one or more metrics in a format defined by the one or more analytics using an equipment or material filter selected for the one or more metrics, and
• wherein the one or more metrics is used by an external system for monitoring key performance indicators (KPIs) or other information about the industrial process control and automation system.