由ERP資料庫和DW系統自動化產生步驟導向之關鍵績效指標和多維度模型

以作者查詢圖書館館藏

、以作者查詢臺灣博碩士

、以作者查詢全國書目

、勘誤回報

、線上人數：36

、訪客IP：3.135.203.181

姓名

廖敏妏(Min-wen Liao) 查詢紙本館藏

畢業系所

工業管理研究所

論文名稱

由ERP資料庫和DW系統自動化產生步驟導向之關鍵績效指標和多維度模型
(Automatically Generating Step-oriented Key Performance Indices and Dimension Model Design from ERP Database and DW System)

相關論文

★ 以類神經網路探討晶圓測試良率預測與重測指標值之建立	★ 六標準突破性策略—企業管理議題
★ 限制驅導式在製罐產業生產管理之應用研究	★ 應用倒傳遞類神經網路於TFT-LCD G4.5代Cell廠不良問題與解決方法之研究
★ 限制驅導式生產排程在PCBA製程的運用	★ 平衡計分卡規劃與設計之研究-以海軍後勤支援指揮部修護工廠為例
★ 木製框式車身銷售數量之組合預測研究	★ 導入符合綠色產品RoHS之供應商管理-以光通訊產業L公司為例
★ 不同產品及供應商屬性對採購要求之相關性探討－以平面式觸控面板產業為例	★ 中長期產銷規劃之個案探討 -以抽絲產業為例
★ 消耗性部品存貨管理改善研究-以某邏輯測試公司之Socket Pin為例	★ 封裝廠之機台當機修復順序即時判別機制探討
★ 客戶危害限用物質規範研究-以TFT-LCD產業個案公司為例	★ PCB壓合代工業導入ISO/TS16949品質管理系統之研究-以K公司為例
★ 報價流程與價格議價之研究–以機殼產業為例	★ 產品量產前工程變更的分類機制與其可控制性探討-以某一手機產品家族為例

檔案

[Endnote RIS 格式]

[Bibtex 格式]

[相關文章]

[文章引用]

[完整記錄]

[館藏目錄]

至系統瀏覽論文 ( 永不開放)

摘要(中)

在先前的研究中，候選關鍵績效指標的數量不足以被分類至流程步驟之中，而分類的原因是因為關鍵績效指標可用來衡量企業流程的績效；除此之外，一個關鍵績效指標就產生一個多維度模型會使過多相似的維度模型被產生。在這次的研究裡，我們希望可以產生針對使用者需求數量的關鍵績效指標，並且藉由多維度表現指標的管理意義跟衡量流程的績效。最後，還希望能減少多維度模型的數量以簡化多維度模型的呈現。
此研究中，自動產生流程導向之關鍵績效指標的方法比較了企業資源規劃(ERP)資料庫之實體屬性和資料倉儲(DW)系統中既有之指標運算域的敘述相似度，並根據流程步驟來產生實體屬性跟運算域的連結，還透過預先定義好的公式結構去組合出候選關鍵績效指標。最後，我們建立候選關鍵績效指標之多維度模型並簡化多維度模型的結構，根據相同的流程步驟和相同的多維度模型，整合了候選關鍵績效指標的多維度模型。
我們的方法論提供了自動化的方法去產生更多的流程導向之候選關鍵績效指標和指標的多維度模型。首先，我們確切增加了候選關鍵績效指標的數量；接著還產生了以流程為導向之候選關鍵績效指標；最後，整合了候選關鍵績效指標的多維度模型根據相同的事實資料表、維度資料表、和流程步驟。

摘要(英)

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.

關鍵字(中)

★ 流程導向
★ 關鍵績效指標
★ 多維度模型設計

關鍵字(英)

★ Dimensional model design
★ Key performance index
★ Step-oriented

論文目次

Table of Content
摘要............................................................................................................. I
Abstract ...................................................................................................... II
Table of Content ........................................................................................ III
List of Figures ............................................................................................ V
List of Tables ............................................................................................ VI
Chapter 1 Introduction ................................................................................ 1
1.1 Background and motivation ..................................................................... 1
1.2 Research Problem .................................................................................... 4
1.3 Research Objective .................................................................................. 7
1.4 Research Methodology ............................................................................ 8
Chapter 2 Literature Review ..................................................................... 10
2.1 Step-oriented KPIs ................................................................................. 10
2.2 Threshold Setting ................................................................................... 11
2.3 Dimensional model design ..................................................................... 12
2.3.1 Dimensional model combination ................................................ 12
Chapter 3 Methodology ............................................................................ 14
3.1 Data Extraction ...................................................................................... 14
3.1.1 Extract Description of Entity-attribute from ERP System .......... 14
3.1.2 Extract Formula of KPI from DW System ................................. 17
3.2 Operand Set Classification ..................................................................... 17
3.3 Stemming ............................................................................................... 18
3.4 Entity-attribute Assignment ................................................................... 19
3.5 Generating step-oriented KPI Candidate ............................................... 21
3.6 Constructing Dimensional Model .......................................................... 23
IV
3.6.1 Finding out the shortest path of entities given by KPI candidate23
3.6.2 Fact entity definition ................................................................... 24
3.6.3 Dimension generating ................................................................. 26
3.6.4 Dimension model combination ................................................... 27
Chapter 4 Application ............................................................................... 29
4.1 Data Extraction ...................................................................................... 29
4.1.1 Extract Description of Entity-attribute from ERP System .......... 29
4.1.2 Extract Formula of KPI from DW System ................................. 32
4.2 Operand Set Classification ..................................................................... 35
4.3 Stemming ............................................................................................... 36
4.4 Entity-attribute Assignment and Generate KPI Candidate .................... 37
4.5 Construct Dimensional Model ............................................................... 38
4.5.1 Find out the shortest path of entities given by KPI candidate .... 39
4.5.2 Dimension generating ................................................................. 40
4.5.3 Dimension Model Combination .................................................. 43
Chapter 5 Conclusion ............................................................................... 46
5.1 Research contribution ............................................................................ 46
5.2 Research limitation ................................................................................ 47
5.3 Future research ....................................................................................... 47
Reference .................................................................................................. 48
Appendix ................................................................................................... 50
Appendix A: The SAP ECC6 database table used in data extracting stage. 50
Appendix B: The original formulas extracted from SAP BW ..................... 50
Appendix C: 44 operand sets of the production order process .................... 58
Appendix D: The generated KPI candidates and their shortest path with threshold 0.9 ......................................................................................................... 61

參考文獻

1. Adamson C., Venerable M. (1998). Data warehouse design solutions. Wiley & Sons, Inc.
2. Boehnlein, M., and Ulbrich-vom E. A. (1999). Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems. Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, 15-21.
3. Chen, Y. T., and Hsu, P. Y. (2007). A grain preservation translation algorithm: From ER diagram to multidimensional model. Information Sciences, 177(18), 3679-3695.
4. Dori, D., Feldman, R., and Sturm, A. (2005). Transforming an operational system model to a data warehouse model: A survey of techniques. Proceedings of the IEEE International Conference on Software-Science, Technology & Engineering, 47-56.
5. Golfarelli, M., Maio, D., and Rizzi, S. (1998). Conceptual design of data warehouses from E/R schemes. Proceedings of the Hawaii International Conference on System Sciences, 31, 334-343.
6. Hotho A., Nürnberger A., and Paaß G. (2005). A brief survey of text mining. LDV Forum – GLDV. Journal for Computational Linguistics and Language Technology, 20(1) 19-62.
7. Kimball, R., and Ross, M. (2002). The data warehouse toolkit (2nd Ed.) Wiley & Sons, Inc.
8. Fernandes K. J., Raja V., and Whalley A. (2006). Lessons from implementing the balanced scorecard in a small and medium size manufacturing organization. Technovation, 26, Issues 5-6, May-June 2006, 623-634.
9. Masayna, V., Koronios, A., Gao, J., and Gendron, M. (2007). DATA QUALITY AND KPIs: A LINK TO BE ESTABLISHED. The 2nd World Congress on Engineering Asset Management (EAM) and The 4th International Conference on Condition Monitoring.
10. Moody, D. L., and Kortink, M. A. R. (2000). From enterprise models to dimensional models: A methodology for data warehouse and data mart design. DMDW’00, Sweden, 5.
11. Porter, M. F. (1997). An algorithm for suffix stripping. Program, 14(3).
12. Pourshahid, A., Amyot, D., Chen, P., and Weiss M. (2007). Business Process Monitoring and Alignment: An Approach Based on the User Requirements
49
Notation and Business Intelligence Tools. Computer and Information Science. Citeseer,149-159.
13. Salton, G., and Buckley, C. (1988). Term-weighting approaches in automatic text retrieval. Information Processing & Management, 24(5), 513-523.
14. Salton, G., and Lesk, M. (1968). Computer evaluation of indexing and text processing. Journal of the ACM, 15(1), 8-36.
15. Shang, F., Wang, J., and Shi, J. (2010). An approach of web text information filtering based on domain ontology to expand users' requirements. 201O 3rd International Conference on Advanced Computer Theory and Engineering(ICACTE). 20-22 Aug.
16. Sinz, E. J. (1988). The structures entity-relationship model (SERM). Angewandte Informatik, 30(5), 191-202.
17. Spremic, M., Zmirak, Z., Kraljevic, K. (2008). IT and business process performance management: Case study of ITIL implementation in finance service industry. Information Technology Interfaces, 2008. ITI 2008. 30th International Conference on. 243 – 250.
18. 吳佩蓉，「從 ERP交易資料發掘供應商績效評估指標並考慮查詢構面」，國立中央大學，碩士論文，民國95年。
19. 李季庭，「由 ERP 系統中資料模型之敘述自動挖掘關鍵績效指標」，國立中央大學，碩士論文，民國98年。
20. 鐘國華，「利用企業資源規劃以及商業智慧資料產生銷售面績效評估指標」，國立中央大學，碩士論文，民國97年。
21. 黃聖賢，「由ERP資料庫之實體-關係模型自動化產生關鍵績效指標的多維度模型」，國立中央大學，碩士論文，民國99年。

指導教授

沈國基(Gwo-Ji Sheen)

審核日期

2011-7-19

推文