摘要(英) |
Business Intelligence including query, data mining and statistical analysis, ETL is the core of Business intelligence, the various sources of information exchange into the end system business intelligence systems analysis, but the ETL process is complex and time consuming. SAP system is the most popular in the Enterprise information system markets, so many systems are to be considered with the SAP system as ETL process. In order to save time and design of the cube, SAP provides Business Content, included a wealth of industry models, cubes and reports. If the successful start-Business Content to connect to other SAP information system will greatly save time BI import. The first purpose of this study is to clarify the use of SAP BI system with SAP Business Content in the system settings on other topics, in order to smooth ETL, to complete data import from other SAP systems to the BI system. The second purpose of this study is based on data freshness constraints to build the minimum hours of work based on priority scheduling algorithm to determine the timing and implementation of delta load order, in order to achieve the shortest average response time. This study presents the detailed SAP BI system in the connection setup and operation of SAP ERP systems to import data process to provide the required use of the SAP system for business intelligence analysis staff have a reference.
|
參考文獻 |
參考文獻─中文部份
[1] 薛如珊: 商業智慧18年,台灣IDC(國際數據資訊)分析師觀點,2007年2月2日。
[2] 國立中央大學管理學院ERP中心,商業智慧,第一版,滄海書局,2010。
參考文獻─英文部份
[3] Campbell, G.M. ,“Establishing saf Sheth, A.; Larson, J.:
“Federated Database Systems for Managing Distributed, Heterogeneous and Autonomous Databases”. ACM Computing Surveys, Vol. 22(3): 186-236, September 1990.
[4] Jarke, M.; Jeusfeld, M.; Quix, C.; Vassiliadis, P.: “Architecture and Quality in Data Warehouses: An Extended Repository Approach”. Info Systems, Vol. 24(3): 229-253, 1999.
[5] Verónika Peralta ,”Data Freshness and Data Accuracy: A State of the Art” Vol.12, NO.4,,2006
[6] Nechval,N.A. and Nechval,K.N. ,“Applications of invariance to estimation of safety stock levels in inventory model”,Computers & Industrial Engineering Vol.37, NO.1-2 , pp.247-250, 1999
[7] Wang, R.; Strong, D.: "Beyond accuracy: What data quality means to data consumers". Journal on Management of Information Systems, Vol. 12 (4):5-34, 1996.
[8] Kimball, R., & Ross, M. The Data Warehouse Toolkit: The
Complete Guide To Dimensional Modeling, 2nd Edition.
John Wiley, 2002.
[9] Harinarayan, V., Rajaraman, A., Ullman, J, 1996.
Implementing Data Cubes Efficiently. Proc. of ACM
SIGMOD Conference. Montreal.
[10] Michael V. Mannino”A framework for data warehouse refresh policies. 2006,Vol 42. pp121-pp143
[11] Inmon,W.H.”Building the Data Warehouse 4 ed,New York: John Wiley&
Sons,Inc.,2005.
|