Manufacturing Intelligence: Early Capacity Warning System
Capacity-Planning and What-if Analysis
The first step in the planning cycle is to prepare the initial data – In this example its a data set called parts-Honda.
Download the data and Upload it again through an Excel Spread-sheet. Here you just enter the data offline in the spreadsheet and upload it once finished again to the database.
This is done in the users-security context and in a save and controlled way, embedded in a workflow.
Another way is direct edit in the web browser by the data entry mask.
Once all the data is prepared, the slice of the data will be set to read-only by a workflow for further review.
Part 1 – Workflow Overview
Part 2 – Workflow Planner
Set the Current Cycle in order to specify in which period your planning should happen.
Set the Import Version to select on which version you want to store your initial data for the panning.
Process Plan Version:
After that you prepare the planning by move or copy the date from the initial version to the plan version.
Once the planning cycle is finished you have the possibility to create the final version or export the data set to a different system for further usage or analysis.
Part 3- File Import
The idea is to let the business user upload and download data in a controlled and secure way to the Data warehouse or the planning system.
On the landing page you can see for example the Audit log of the last file imports.
First, the user selects which kind of file type he wants to import.
Once the file is upload to the database, standard checks happen on the data:
This could be Column name, column count and so on
Every check which is in SQL possible can be applied her by user defined checks.
– for example a Check could be: Check row number 7 and column number 4, if the value is numeric or not.
The user gets also a preview of the file
The import mode is also complete configurable (add, replace,..)
Once the data is loaded you can see the success in the auditing log window