Automatically Generating Step-oriented Key Performance Indices and Dimension Model Design from ERP Database and DW System

• Main Authors: Min-wen Liao, 廖敏妏
• Other Authors: Gwo-Ji Sheen
• Format: Others
• Language: en_US
• Published: 2011
• Online Access: http://ndltd.ncl.edu.tw/handle/41343570955628933890

碩士 === 國立中央大學 === 工業管理研究所 === 99 === In previous research, the number of generated KPI candidates is not enough for classifying KPI candidates to step of the process because the KPI should be used for measuring the business processes. Otherwise, one KPI candidate has one dimensional model causes many similar dimensional model generated. In this research, we hope we can generate the user-specified number of KPI candidates which have dimensions to show the management meaning and measure the process. Finally, we decrease the number of the dimensional models to show the simplified dimensional model. In this research, the automatic step-oriented KPIs generating method compares the description similarity of Entity-attribute in ERP database with the operand of existing KPI in Data Warehouse (DW) system by text mining technique to make the linking of Entity-attribute and operand depend on the steps of the process. And it uses the defined formula structure to compose the KPI candidates. Finally, we construct the dimensional model of KPI candidates and simplify the dimensional model structure. We combine the dimensional models together depend on the same step of process and the same the dimensional model of KPI candidates. Our method provides an automatic approach to generate more step-oriented KPI candidates and its dimensional model. First, we increase the number of the KPI candidates. Second, we generate the step-oriented KPI candidates. Finally, combine the dimensional model of KPI candidate with the same fact table, the same dimension tables, and the same step of process.