Production Monitoring for Snowflake
Previous
Next
Provides real-time and historical visibility into invoicing data, enabling monitoring and analysis of performance across plants, sales areas, and divisions.
TECHNICAL SPECIFICATIONS
| Streaming Method | Snowflake |
|---|---|
| Streaming Time | Real time |
| Script Language | Dynamic tables-SQL |
| Implementation Time | 15 hours |
| Tech Layers | Data Engineering / AI Data Foundation |
THIS SOLUTION CONTAINS
DESCRIPTION
Improves real-time tracking of production orders, planned, in-process, delayed, and completed; rejections, downtime, and lead-time deviations versus plan. Provides a clear view of shop floor control, enabling faster decision-making and facilitating production planning.
Dependencies:
- One Connect for SAP +
- One Connect Stream +
STREAMING SOLUTION ASSET DETAILS
SCRIPTS INCLUDED:
- onibex-dp-production-s4h-silversdproduction-snowflake.sql
- onibex-dp-production-s4h-goldsdproduction-snowflake.sql
- onibex-dp-production-s4h-goldsdproductiondata-snowflake.sql
STREAMING SOLUTION SOURCE DATA PRODUCTS
|
CATEGORY |
FOUNDATIONAL DATA PRODUCT |
|
PLANT TO PRODUCE |
PRODUCTION ORDER |
|
SALES AND DISTRIBUTION |
TRADING GOODS |
|
MATERIALS MANAGEMENT |
INVENTORY MOVEMENT STOCK |
|
MATERIALS MANAGEMENT |
RESERVATION DOCUMENT |
|
ORGANIZATIONAL STRUCTURE |
SHIPPING CONDITION |
|
ORGANIZATIONAL STRUCTURE |
SALES ORGANIZATION |
|
ORGANIZATIONAL STRUCTURE |
DISTRIBUTION CHANNEL |
|
ORGANIZATIONAL STRUCTURE |
CUSTOMER SALES DISTRICT |
|
ORGANIZATIONAL STRUCTURE |
PLANTS |
|
ORGANIZATIONAL STRUCTURE |
SALES OFFICE |
|
ORGANIZATIONAL STRUCTURE |
SALES DIVISION |
|
ORGANIZATIONAL STRUCTURE |
MATERIAL GROUP |
|
ORGANIZATIONAL STRUCTURE |
MATERIAL HIERARCHY |
