Task 879.1: Intelligent Demand Aggregation and Forecasting Task - PowerPoint PPT Presentation

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