發(fā)布時(shí)間：2018-06-06 04:11

  本文選題：數(shù)據(jù)倉(cāng)庫(kù)(DW) + 商務(wù)智能(BI)�。� 參考：《上海交通大學(xué)》2013年碩士論文

【摘要】：生產(chǎn)成本作為生產(chǎn)過(guò)程中的各種支出，是產(chǎn)品生產(chǎn)的“投入”，是產(chǎn)品定價(jià)的重要基礎(chǔ)。在競(jìng)爭(zhēng)日益激烈的市場(chǎng)環(huán)境下，對(duì)生產(chǎn)成本的管理重要性日益凸顯，甚至市場(chǎng)個(gè)體的核心競(jìng)爭(zhēng)力直接取決于對(duì)生產(chǎn)成本管理的成功與否。加強(qiáng)生產(chǎn)成本分析管理是擴(kuò)大生產(chǎn)經(jīng)營(yíng)的重要條件，有利于促使企業(yè)改善生產(chǎn)經(jīng)營(yíng)管理，提高經(jīng)濟(jì)效益，增強(qiáng)產(chǎn)品價(jià)格優(yōu)勢(shì)。 浙江某生產(chǎn)制造企業(yè)有限公司(簡(jiǎn)稱(chēng)某生產(chǎn)制造企業(yè))是位于浙江杭州的一家民營(yíng)企業(yè)，，該公司是集化工、金融、物流、房地產(chǎn)等為一體的多元化企業(yè)。該公司非常重視企業(yè)的信息化建設(shè)，在硬件、軟件、安全和網(wǎng)絡(luò)上都投入大量人力財(cái)力，一直走在行業(yè)前端。其企業(yè)信息化系統(tǒng)包括企業(yè)資源計(jì)劃系統(tǒng)(Enterprise Resource Planning，簡(jiǎn)稱(chēng)ERP)，辦公自動(dòng)化系統(tǒng)，人事管理系統(tǒng)，客戶(hù)關(guān)系管理等系統(tǒng)。后ERP時(shí)代，數(shù)據(jù)倉(cāng)庫(kù)(Data Warehouse，簡(jiǎn)稱(chēng)DW)和商務(wù)智能(Business Intelligence，簡(jiǎn)稱(chēng)BI)成為企業(yè)信息化的重點(diǎn)。為了保持和ERP系統(tǒng)的集成性，其數(shù)據(jù)倉(cāng)庫(kù)和商務(wù)智能工具都選擇了和ERP系統(tǒng)同廠家的產(chǎn)品，分別為SAP BusinessWarehouse(簡(jiǎn)稱(chēng)SAP BW)和SAPBusinessObject。本文是以該生產(chǎn)制造企業(yè)數(shù)據(jù)倉(cāng)庫(kù)平臺(tái)建設(shè)為研究背景，對(duì)生產(chǎn)企業(yè)的生產(chǎn)成本進(jìn)行分析研究。 該生產(chǎn)制造企業(yè)實(shí)施數(shù)據(jù)倉(cāng)庫(kù)以前，企業(yè)報(bào)表基于SAP ERP系統(tǒng)、關(guān)系型數(shù)據(jù)庫(kù)和手工數(shù)據(jù)，數(shù)據(jù)非常分散，涉及到多系統(tǒng)的數(shù)據(jù)時(shí)，則需要耗費(fèi)大量人力手工處理報(bào)表，效率低，而且非常容易出錯(cuò)。對(duì)于生產(chǎn)成本分析這么重要的分析，每個(gè)月月結(jié)以后由財(cái)務(wù)人員從ERP系統(tǒng)中導(dǎo)出部分報(bào)表進(jìn)行加工，依據(jù)不同的條件進(jìn)行復(fù)雜的計(jì)算手工合并預(yù)算數(shù)據(jù)和上年同期數(shù)據(jù)，每個(gè)月手工處理報(bào)表額外需要3天時(shí)間，且容易出錯(cuò)；一旦該財(cái)務(wù)人員請(qǐng)假，成本分析工作就會(huì)停滯。實(shí)現(xiàn)數(shù)據(jù)倉(cāng)庫(kù)建設(shè)以后，改善了上述的情況，財(cái)務(wù)每個(gè)月月結(jié)完成后，數(shù)據(jù)倉(cāng)庫(kù)平臺(tái)立即加載、整合數(shù)據(jù)，在后臺(tái)自動(dòng)進(jìn)行預(yù)定義的各種復(fù)雜計(jì)算，只需要2-3個(gè)小時(shí)，通過(guò)瀏覽器就可以查看生產(chǎn)成本報(bào)表，快速簡(jiǎn)單，數(shù)據(jù)準(zhǔn)確，和預(yù)算數(shù)據(jù)以及上年同期比較一目了然，任何有權(quán)限訪問(wèn)成本報(bào)表的人員都可以通過(guò)報(bào)表展現(xiàn)系統(tǒng)訪問(wèn)報(bào)表，財(cái)務(wù)人員可以將更多的精力投入到分析中。 論文詳細(xì)論述了數(shù)據(jù)倉(cāng)庫(kù)關(guān)鍵技術(shù)，以及該生產(chǎn)制造企業(yè)基于數(shù)據(jù)倉(cāng)庫(kù)的生產(chǎn)成本報(bào)表設(shè)計(jì)與實(shí)現(xiàn)。數(shù)據(jù)集成方面使用SAP BW的數(shù)據(jù)抽取轉(zhuǎn)換工具(ExtractTransformation Loading，簡(jiǎn)稱(chēng)ETL)抽取、轉(zhuǎn)換、加載各業(yè)務(wù)系統(tǒng)數(shù)據(jù)，經(jīng)過(guò)清洗、整合后儲(chǔ)存在數(shù)據(jù)倉(cāng)庫(kù)平臺(tái)，實(shí)現(xiàn)數(shù)據(jù)集成。利用數(shù)據(jù)倉(cāng)庫(kù)的多維模型技術(shù)進(jìn)行建模，從不同角度進(jìn)行分析。報(bào)表方面利用SAP BusinessObject基于數(shù)據(jù)倉(cāng)庫(kù)建立的數(shù)據(jù)集市展現(xiàn)報(bào)表，報(bào)表真實(shí)直觀，分析各指標(biāo)的意義，讓數(shù)據(jù)來(lái)說(shuō)話(huà)。最后將數(shù)據(jù)倉(cāng)庫(kù)平臺(tái)報(bào)表和業(yè)務(wù)系統(tǒng)、手工數(shù)據(jù)對(duì)比，從數(shù)據(jù)準(zhǔn)確性、報(bào)表邏輯正確性、數(shù)據(jù)集成性等各角度驗(yàn)證SAP BusinessObject報(bào)表準(zhǔn)確可靠。
[Abstract]:Production cost, as a kind of expenditure in the production process, is the "input" of product production. It is an important basis for product pricing. In the increasingly competitive market environment, the management importance of production cost is becoming more and more important. Even the core competitiveness of the individual in the market depends on the success of production cost management. Cost analysis and management is an important condition for expanding production and operation. It is beneficial for enterprises to improve production and operation management, improve economic efficiency and enhance product price advantage.
A production and manufacturing enterprise limited in Zhejiang (a manufacturing enterprise) is a private enterprise located in Hangzhou, Zhejiang. It is a diversified enterprise integrating chemical, financial, logistics and real estate. The company attaches great importance to the construction of enterprise information, and has invested a lot of manpower and financial resources in hard parts, software, safety and network. The enterprise information system includes enterprise resource planning system (Enterprise Resource Planning, ERP), office automation system, personnel management system and customer relationship management system. In the post ERP era, the data warehouse (Data Warehouse, DW) and business intelligence (Business Intelligence, BI) become enterprise letters. In order to maintain the integration of the ERP system, the data warehouse and the business intelligence tools have chosen the products of the same manufacturer as the ERP system, which are the SAP BusinessWarehouse (SAP BW) and the SAPBusinessObject., which are the research background of the flat platform construction of the data warehouse of the manufacturing enterprise, and the production of the production enterprises. This is an analysis and study.
Before implementing the data warehouse in the manufacturing enterprise, the enterprise report is based on the SAP ERP system, the relational database and the manual data, and the data are very scattered. When the data are involved in the multi system, it takes a lot of manpower to handle the report, and it is inefficient and is very easy to make mistakes. After the month of the month, the financial personnel from the ERP system export parts of the report processing, according to the different conditions to carry out complex calculation of manual combined budget data and the same period of the previous year data, manual processing of the report each month additional 3 days, and easy to make mistakes; once the financial person to ask for leave, cost analysis work will stagnate. After the building of the warehouse, the above situation is improved. After each month's completion, the data warehouse platform is immediately loaded, the data is integrated, and the various complex calculations are automatically predefined in the background. It takes only 2-3 hours to check the production cost report through the browser, fast and simple, the data is accurate, and the budget data and the previous year At the same time, it is clear that any person who has access to the cost report can access the report through the report, and the financial staff can put more energy into the analysis.
This paper expounds the key technology of data warehouse and the design and implementation of production cost report based on data warehouse in the manufacturing enterprise. Data extraction and conversion tool (ExtractTransformation Loading, ETL) using SAP BW is used to extract, convert and load the data of each business system in the aspect of data integration. Data warehouse platform to realize data integration. Using multidimensional model technology of data warehouse to model and analyze from different angles. The report forms a report using SAP BusinessObject data mart based on data warehouse. The report is real and intuitive, analyzes the meaning of each index, and lets the data speak. Finally, the data warehouse platform is reported. Tables and business systems, manual data comparison, from the data accuracy, report logic correctness, data integration and other angles verify SAP BusinessObject report is accurate and reliable.
【學(xué)位授予單位】：上海交通大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2013
【分類(lèi)號(hào)】：TP311.13

【參考文獻(xiàn)】

相關(guān)期刊論文 前7條

1 王艷華;數(shù)據(jù)倉(cāng)庫(kù)的體系結(jié)構(gòu)及其技術(shù)的探討[J];電腦開(kāi)發(fā)與應(yīng)用;2001年06期

2 方幼林 ,楊冬青 ,唐世渭 ,張衛(wèi)華 ,余利波 ,付強(qiáng);數(shù)據(jù)倉(cāng)庫(kù)中數(shù)據(jù)質(zhì)量控制研究[J];計(jì)算機(jī)工程與應(yīng)用;2003年13期

3 商琳,駱斌;一種基于數(shù)據(jù)倉(cāng)庫(kù)的數(shù)據(jù)挖掘系統(tǒng)的結(jié)構(gòu)框架[J];計(jì)算機(jī)應(yīng)用研究;2000年09期

4 鮑玉斌,史捷,王大玲,嵇曉,于戈;企業(yè)級(jí)數(shù)據(jù)倉(cāng)庫(kù)設(shè)計(jì)方法及其實(shí)施的關(guān)鍵因素研究[J];控制與決策;2004年12期

5 陳尚勤;數(shù)據(jù)倉(cāng)庫(kù)的創(chuàng)意、內(nèi)涵與建立信息網(wǎng)絡(luò)提高應(yīng)用效率的新途徑[J];四川通信技術(shù);1999年01期

6 于劍軍,李鵬海;高�？蒲泄芾硐到y(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)[J];天津理工大學(xué)學(xué)報(bào);2005年05期

7 尤毅,方云安;多維數(shù)據(jù)倉(cāng)庫(kù)設(shè)計(jì)[J];系統(tǒng)工程理論方法應(yīng)用;1999年02期

相關(guān)碩士學(xué)位論文 前1條

1 薛晶;基于數(shù)據(jù)倉(cāng)庫(kù)的統(tǒng)計(jì)庫(kù)的設(shè)計(jì)和實(shí)現(xiàn)[D];中國(guó)科學(xué)院研究生院（計(jì)算技術(shù)研究所）;2000年

本文編號(hào)：1985013