SRC Project 879 Progress Report March 2003 Task 879.1: Intelligent Demand Aggregation and Forecasting Task Leader: Argon Chen Co-Investigators: Ruey-Shan Guo Shi-Chung Chang Students: Chris Hsu, Tony Huang 1
Outline � Most Significant Outcomes and Deliverables � System Architecture of DPH Planner � DPH Planner Documentations � UML System Design � Demand Data Source Schema � Product Info Database Schema � OLAP Demand Dimension Example � Product Hierarchy DB Schema Example � User Tutorial � Future Direction 2
879.001 Most Significant Outcomes and Deliverables � Defined and developed an optimum Demand Planning Hierarchy (DPH) to support different granularities of planning activities. � Provided guidelines to help practitioners determine the appropriate aggregated levels to make demand forecasts. � Developed optimum methodologies to estimate the product-mix and the methodologies to predict the disaggregated demands. � Designed and developed a DPH Planner software system that can be used to find the optimum DPH for hierarchical products and perform what-if analysis. 3
Outline � System Architecture of DPH Planner � DPH Planner Documentations � UML System Design � Demand Data Source Schema � Product Info Database Schema � OLAP Demand Dimension Example � Product Hierarchy DB Schema Example � User Tutorial � Future Direction 4
DPH Planner – System Architecture Demand P and Planni anning ng Data Mart Data Mart Hierarchy erarchy P Planner anner (OLTP) (OLTP) MDX Query Demand-info DPH Result Dataset (OLAP) Optimization Data Mart Dimension Information Data (OLTP) Warehouse DPH Analysis T-SQL Other Sources Pre-process of Product-info of Demand- product data (OLTP) Related Data Result Dataset 5
Outline � DPH Planner Documentations � UML System Design � Demand Data Source Schema � Product Info Database Schema � OLAP Demand Dimension Example � Product Hierarchy DB Schema Example � User Tutorial � Future Direction 6
DPH System Design UML (Unified Modeling Language) System Design (see the attached document) 7
Demand Data Source Schema 8
Product Info Database Schema 9
Example – OLAP Demand Dimension 10
Example – Product Hierarchy and Info Tables 11
DPH User Tutorial DPH User Tutorial (see the attached document) 12
Outline � Most Significant Outcomes and Deliverables � System Architecture of DPH Planner � DPH Planner Documentations � UML System Design � Demand Data Source Schema � Product Info Database Schema � OLAP Demand Dimension Example � Product Hierarchy DB Schema Example � User Tutorial � Future Direction 13
Future Direction � Investigating different DPH evaluation metrics � Incorporating business constraints and rules into the optimum DPH � Implementing DPH planners in actual business settings 14
Recommend
More recommend