以作者查詢圖書館館藏

、以作者查詢臺灣博碩士

、以作者查詢全國書目

、勘誤回報

、線上人數：32

、訪客IP：18.220.226.147

姓名	許瑋倡(Wei-Chang Hsu)  查詢紙本館藏	畢業系所	企業管理學系
論文名稱	導入SAP BW/4HANA-教育訓練資料之研究 (The implementation of SAP BW/4HANA training data from SAP ERP)
檔案	[Endnote RIS 格式]    [Bibtex 格式]    [相關文章]   [文章引用]   [完整記錄]   [館藏目錄]   [檢視]  [下載] 本電子論文使用權限為同意立即開放。 已達開放權限電子全文僅授權使用者為學術研究之目的，進行個人非營利性質之檢索、閱讀、列印。 請遵守中華民國著作權法之相關規定，切勿任意重製、散佈、改作、轉貼、播送，以免觸法。
摘要(中)	由於SAP公司於2020年宣布2027年將不再維護SAP BW，鼓勵企業升級成SAP BW/4HANA，使系統可以運作的更加快速且存放更多資料量，同時SAP大學聯盟也宣布各個擁有SAP系統的學校將於2021年9月升級成HANA，與企業同步升級以提升學生競爭力並學習最新的技術。而對於學術界，相較於SAP BW，SAP公司提供IDES資料及能與此資料搭配使用的教材以供學術研究使用，使教學上能迅速上手，然而SAP公司並無針對SAP BW/4HANA提供任何資料及可搭配的教材，使得升級為SAP BW/4HANA後將無資料可使用且於教學上造成困擾。 對於系統升級成HANA，SAP針對SAP S/4HANA提供Global Bike資料以供教學，而本研究為了也使SAP BW/4HANA擁有資料供學術研究使用，將兩套SAP S/4HANA系統資料之Global Bike及Best Practice皆利用萃取轉換載入的方式匯入至SAP BW/4HANA中，使學術界擁有兩套資料可運用。 關鍵字：萃取轉換載入、SAP、HANA
摘要(英)	Since SAP announced in 2020 that it will no longer maintain SAP BW in 2027, it encourages companies to update the system to SAP BW/4HANA, so that it can operate faster and store more data. At the same time, the SAP University Alliance also announced that each college with SAP system will update the system to HANA in September 2021 as well, which will be simultaneous with enterprises to enhance students′ competitiveness and learn the latest technology. For academia, compared to SAP BW, SAP provides IDES data and textbooks that can be used with it for academic research, so that it can be used easily for teaching. However, SAP does not provide any data and related textbooks for SAP BW/4HANA. There are no resources that can be used after upgrading to SAP BW/4HANA which causes problems in teaching. For updating to HANA, SAP provides Global Bike data for SAP S/4HANA for teaching purposes. In order to enable SAP BW/4HANA to reside data for academic research purposes, two sets of SAP S/4HANA system data, Global Bike and Best Practice are imported into SAP BW/4HANA by using extraction transformation loading (ETL), and thus there are sufficient data for educational use. Keywords: ETL, SAP, HANA
關鍵字(中)	★ 萃取轉換載⼊	關鍵字(英)	★ SAP ★ HANA
論文目次	中文摘要 I ABSTRACT II 目錄 III 圖目錄 V 第一章 緒論 1 1-1 研究背景 1 1-2 研究動機 2 1-3 研究目的 3 第二章 文獻探討 4 2-1 商業智慧 4 2-2 萃取-轉換-載入 6 2-3 SAP系統名詞解釋 8 第三章 利用SAP BUSINESS CONTENT 導入 11 3-1 研究架構圖 11 3-1-1 BW/4HANA與S/4HANA雙向連接 15 3-1-2 激活Data Source 17 3-1-3 刪除setup table資料 18 3-1-4 維護Data Source結構 19 3-1-5 填寫setup table資料 20 3-1-6 Business Content 安裝 21 3-1-7 Replicate Data Source of Source System 22 3-1-8 激活Data Source 23 3-1-9 建立Transformation Rules 24 3-1-10 建立Data Transfer Process 25 3-1-11 利用Eclipse呈現報表 27 第四章 結論與未來研究及建議 31 4-1 結論 31 4-2 未來研究與建議 32 參考文獻 33 附錄 36
參考文獻	〔1〕薛如珊：台灣IDC(國際數據資訊)分析師觀點-商業智慧18年。2007 年 2 月2日。取自https://www.idc.com.tw/research/detail.jsp?id=MjI=。 〔2〕Fortune Business Insights : Business Intelligence Market to Reach USD 39.35 billion by 2027; Increasing Acceptance of Big Data Analytics to Intensify Market, states Fortune Business Insights. January 14, 2021. accessed https://www.globenewswire.com/news-release/2021/01/14/2158447/0/en/Business-Intelligence-Market-to-Reach-USD-39-35-billion-by-2027-Increasing-Acceptance-of-Big-Data-Analytics-to-Intensify-Market-states-Fortune-Business-Insights.html. 〔3〕Albert Pang , Misho Markovski and Marija Ristik : Top 10 Analytics and BI Software Vendors, Market Size and Market Forecast 2019-2024. November 4, 2020. accessed https://www.appsruntheworld.com/top-10-analytics-and-bi-software-vendors-and-market-forecast/. 〔4〕Albert Pang, Misho Markovski and Andrej Micik : Top 10 ERP Software Vendors, Market Size and Market Forecast 2019-2024. November 5, 2020. accessed https://www.appsruntheworld.com/top-10-erp-software-vendors-and-market-forecast/ 〔5〕Jörg Hofmann : Big news! SAP has extended ECC support until 2027. February 6, 2020. accessed https://www.pikon.com/en/sap-ecc-support-2027-s4hana-2040/. 〔6〕Richard Miller Devens, Cyclopaedia of Commercial and Business Anecdotes, 1864. 〔7〕Cebotarean Elena, “Business intelligence”, Journal of Knowledge Management, Economics and Information Technology, ScientificPapers.org, vol. 1(2), pp. 1-10, February 2011. 〔8〕Eckerson W, White C, “Evaluating ETL and data integration platforms”, Report of The Data Warehousing Institute 184, 2003. 〔9〕Nithin Vijayendra and M. Lu, “A Web-based ETL Tool for Data Integration Process”, IEEE Conference Publications, pp. 434-438, 2013. 〔10〕Nitin Anand and Manoj Kumar, “Modeling and Optimization of Extraction- Transformation-Loading (ETL) processes in Data Warehouse: An Overview”, IEEE, pp.1-5, 2013. 〔11〕Vassiliadis P, “A survey of extract—transform—load technology”, International Journal of Data Warehousing and Mining, pp. 1-27, 2009. 〔12〕Kimball R and Caserta J, The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, Wiley Publishing, Inc,., 2002. 〔13〕Kimball R and Ross M, The data warehouse toolkit: the complete guide to dimensional modeling, Second Edition, Wiley, 2003 〔14〕Wilson Kurian : SAP Business Content for SAP BW/4HANA Features, Value & Benefits, October 2020. accessed https://assets.cdn.sap.com/sapcom/docs/2020/06/3cbbd4de-9a7d-0010-87a3-c30de2ffd8ff.pdf. 〔15〕guru99 : SAP BI Content: Installation, Activation. accessed https://www.guru99.com/installing-bw-standard-content.html. 〔16〕hebergementwebs : SAP SCM - Integration Models. accessed https://www.hebergementwebs.com/sap-scm-tutorial/sap-scm-integration-models 〔17〕SAP, BW430_EN_Col17_SAP BW4HANA Data Modeling, 2020. 〔18〕SAP, TADM10_1_EN_Col18_Technical Impl. and Operation I for SAP S/4HANA and SAP Business Suite - Week 1, 2018.
指導教授	許秉瑜 沈國基	審核日期	2021-7-12
推文	facebook   plurk   twitter   funp   google   live   udn   HD   myshare   reddit   netvibes   friend   youpush   delicious   baidu
網路書籤	Google bookmarks   del.icio.us   hemidemi   myshare