Smart Operations: Analyze Production Supervision Data Using Oracle Transactional Business Intelligence

Welcome to the demo of 25B smart operations feature Analyze production supervision data using OTBI in Oracle Fusion Cloud Manufacturing. This enhancement enables supervisors to analyze real time assignment of work order operations to workstations within a work center. It also provides visibility into operator assignments across shifts.

By leveraging common dimensions, supervisors can perform cross-subject area analysis with other manufacturing data for deeper insights. Supervisors require the ability to assess assignment activities within the production supervisor Workbench, while also analyzing production performance from other manufacturing subject areas. A unified view of these data points helps in improving operational efficiency.

With this enhancement, supervisors can leverage Oracle Transactional Business intelligence, OTBI, to monitor production performance and workstation assignments in real time. Additionally, they can create custom metrics and reports, embedding them directly into the production supervisor Workbench dashboard for streamlined decision making.

In this demo, we will begin by launching Oracle Transactional Business Intelligence, OTBI. Next, we will explore the dimensions within the new workstation supervision subject area and create a sample analysis.

I am logged in as the production supervisor. Select the Tools work area and then reports and analytics. Click Browse Catalog to launch OTBI. Click the Create menu. Select Analysis to create a new report. Search for the new subject area manufacturing workstation supervision real time and select it.

Here, you can see the dimensions available in this subject area. The newly introduced dimensions include assigned operations, workstation, assigned operators, and shift. All other dimensions are existing ones used across other manufacturing subject areas. The workstation supervision performance folder serves as the fact folder.

Expand the manufacturing organization dimension folder. Select the inventory organization name attribute and double click to add it as a column in the analysis. Switch to the Results tab to view the data in the analysis report as it is being built.

Expand the workstation dimension folder. Select the workstation name attribute and double click to add it as a column in the analysis. Expand the time of planned start date dimension folder. This dimension is anchored on the start date of the work order.

Select the date attribute and double click to add it as a column in the analysis. Expand the work order dimension folder. Select the work order attribute and double click to add it as a column in the analysis. Now you can see the work orders assigned to the workstation queue.

Expand the work order operations dimension folder. Select the operation name attribute and double click to add it as a column in the analysis. This will display the work order operations assigned to the workstation queue.

Expand the assigned operations dimension folder. Select the assigned quantity attribute and double click to add it as a column in the analysis. This will display the assigned quantity of work order operations in the workstation queue.

Expand the shift dimension folder. Select the shift name attribute and double click to add it as a column in the analysis. This will display the shift name to which operators were assigned in the workstation. Here, you see that the shift details are populated only for the first two records, as operators were assigned to only these two workstations.

Expand the assigned operators dimension folder. Select the operator name attribute and double click to add it as a column in the analysis. This will display the operator name if available. Select the check in date attribute and double click to add it as a column in the analysis. This will display the check in date and time of the assigned operator.

Select the check out date attribute and double click to add it as a column in the analysis. This will display the check out date and time of the assigned operator if available. Expand the workstation supervision performance fact folder to view the available facts in this subject area. This concludes our demo on creating an analysis using this new subject area.

To recap, we launched OTBI and explored the new workstation supervision real time subject area. We then demonstrated how to create a sample analysis using this subject area. To review the steps required to embed OTBI reports in production supervision dashboards, please review the 25 what's new and feature demo monitor workstation performance when supervising production. This is the end of the feature demo. Thank you.