以資料倉儲為基礎建置個人化彈性報表─以製造執行系統為例

為改善傳統的報表系統需耗費大量時間進行報表開發的問題，企業紛紛導入商業智慧系統，但商業智慧系統廠商為提高銷售量與市占率，不斷擴充各式功能，強調其產品功能的全面與強大，可符合企業各式各樣不同的需求，使得現今商業智慧系統的功能愈趨複雜，一般使用者學習使用商業智慧系統也愈趨困難，廠商原本導入商業智慧系統希望得到的彈性報表功能成效不如預期，報表開發者仍需花費大量時間，進行報表的開發，以符合各個使用者不同的需求。本研究嘗試建置一個人化商業智慧彈性報表雛形系統，以輔助原有商業智慧系統或報表系統，透過對使用者的操作和資訊人員的訪談，了解個人化彈性報表在封裝測試產業製造執行系統應用上的可行性。期望透過個人化彈性報表系統，提供使用者在需求格式簡單的基礎資料時，能夠快速的依自己的需求獲得所需報表，即時運用有效的資訊，進行分析資料，發掘生產製程中可能的問題，減少錯誤的發生，協助降低企業生產成本，提高生產品質，進而減少等待資訊人員開發報表程式所耗費的時間，並降低資訊人員重複開發報表程式的情形，避免人力資源的浪費。

關鍵字

個人化彈性報表；製造執行系統；資料倉儲

並列摘要

In order to improve traditional reporting system takes a lot of time to develop reports, enterprises implement business intelligence system. However, in order to meet a variety of business, business intelligence system enhance more complex functions, users learn how to use business intelligence systems become increasingly difficult,result in manufacturers did not get the expected effects. Report developers still spend a lot of time to develop reports to meet the different needs of each user. This study attempts to developing a personalization flexible reporting system to assist the existing reporting systems. Through prototype system implementation and case studies to understand the feasibility that personalization flexible report system apply to IC Assembly Testing industry manufacturing execution system. Expectations based on user requests to provide immediate and accurate information and explore possible problems, reduce errors, help reduce production costs, improve production quality. Further reduce the time users wait for report development and reduce duplication of report and avoid the waste of human resources.

並列關鍵字

Manufacturing execution system ； Data warehouse ； Personalization flexible report

參考文獻

3. 吳文維(2002)。產能需求規劃系統與製造執行系統於IC測試廠之整合應用。未出版碩士，中原大學工業工程研究所，桃園縣。

9. Chaudhuri, S., & Dayal, U. (1997). An overview of data warehousing and OLAP technology. ACM Sigmod Record, 26(1), 65-74.

10. Koc, M., Ni, J., Lee, J., & Bandyopadhyay, P. (2002). Introduction of e-manufacturing. Proceedings of the International Conference on Frontiers on Design and Manufacturing,

11. Han, J., & Kamber, M. (2006). Data mining: Concepts and techniques Morgan Kaufmann.

12. Berkhin, P. (2006). A survey of clustering data mining techniques. Grouping Multidimensional Data, , 25-71.

國際替代計量

以資料倉儲為基礎建置個人化彈性報表─以製造執行系統為例

未授權

主題瀏覽