Demand Planning Hierarchy Software System Based on OLAP Technology

• Main Authors: Chang Yi Chun, 張尹駿
• Other Authors: Argon Chen
• Format: Others
• Language: zh-TW
• Published: 2002
• Online Access: http://ndltd.ncl.edu.tw/handle/14780328150612707306

碩士 === 國立臺灣大學 === 工業工程學研究所 === 90 === Demand planning has to deal with a lot of complicated information. It is difficult for planners to make decisions efficiently from these data. In order to satisfy the requirement of quick response, the relational database and the spreadsheets are no longer sufficient. Therefore, this thesis applies the new information technology, namely, On-Line Analytical Processing (OLAP), and develops a software system to help users determine a Demand Planning Hierarchy quickly. The concept of Demand Planning Hierarchy (DPH) is first developed by Chen[3] to improve demand planning efficiency. OLAP and the Multidimensional database are utilized to design and implement a DPH software system. This system provides not only the greedy method but also the dynamic programming approach to search for the DPH. In addition, it can support planners to choose a specific product combination, and the system will provide middle out approach to get the DPH. Finally, a demand data set from a semiconductor manufacturing company is used to test the developed software system.