Automatically Discoverying Key Performance Indices from the Descriptions of ERP Data Model

• Main Authors: Ji-ting Li, 李季庭
• Other Authors: Gwo-ji Sheen
• Format: Others
• Language: en_US
• Online Access: http://ndltd.ncl.edu.tw/handle/96824733817802569871

碩士 === 國立中央大學 === 工業管理研究所 === 97 === This paper tries to generate more business performance indices from transaction data in ERP (Enterprise Resource Planning) system. The data is designed in ERP system as an ER-Model (Entity Relationship Model) but the query system is used Star Schema to represents the results. How to reduce this gap? The first of all we use the TFIDF (Term Frequency Inverse Document Frequency) to count the number of Key Words for the purpose of classifying Entity in ER-Model. Then we can include the Key Figure from the Star Schema by the Key Word classes. Second, we take the formulas that have designed in query system for the basis to bring the Attribute into this formula structure. Third, we generate more KPIs (Key Performance Indices) from including Attribute and Key Figure. Final, we transfer the results into the Star Schema for performing our results and improving the query system.