Data Model Study for Advancement of Japanese PSI Management Introducing the Concepts of S&OP

Under the impact of COVID-19, the global economy exhibits obvious slowdown. In such situation, the issues on how to keep balance between supply and demand in SCM (Supply Chain Management) operation have been more apparent than before. For SCM rebuilding, S&OP received extensive attention worldwide. However, there are few examples of successful implementation of S&OP in Japan because Japanese have not been growing accustomed to the phrase S&OP, although the challenges in SCM operations and PSI (Product, Sales, Inventory) management are recognized. Thus, no clear and exact solution is found to guide the operation. In order to further improve the current management level, a new design proposal of data model is rendered to advance the current PSI management that introduces the concepts of S&OP. Especially, we will address the motivation why we need use multidimensional database architecture to design the S&OP process instead of using RDB (Relational Database) which is often used in ERP (Enterprise Resource Planning).