Research And Implementation Of Business Intelligence Reporting System Based On ERP

Information technology had appeared extraordinary impression in the applicationof business operation. Enterprise deal business information quickly and monitorinformation flow through MIS and ERP, in order to manage all aspects of businessoperation. While in the application of these systems have accumulated large amountsof data.These precipitates system data with the various data from the externalenvironment became the company’s most valuable asset. Management needs ofdecision-making, decision-making requires information. How to consolidate the datafrom system DB data, third-party assessment information, the various individual dataand manual reports into intuitive and effective information that we nee d. Businessintelligence system is committed to instant access to corporate information, andanalys many of the data of isolated islands, and find the corresponding links for thisdata. Thus business managers can translate information to decision-making, in orderto achieve business objectives.Since UF ERP system went live in Beverage company, standard reports are notintelligent, Most reports example sales report, aging analysis, customer statements,actual and plan data analysis need export from UF syste m and then manual processing,add a great deal to the report staff workload, and management can not get the data forthe first time and timely business decisions.In this papper, based on researching Business Intelligence concepts and datawarehouse technology, combined with the the demand of business report fro mBeverage company. Based on the existing back-end data in the current UF ERPsystem, used Microsoft SQL2005as the Business Intelligence tools, established datawarehousing, used online analytical processing technology to establish the dimensionand measure from different angles, levels, departments, duty to process data analysis.Develop the Pepsi business intelligence reporting system. First of all, on the basis of adetailed analysis of business needs, according to business data analysis for UFdatabase, established business reporting database and use SQL Sever the SSIS tools toextract the source database data, and converse and load the data, established datawarehouse. Second, used SQL Server SSAS tools establish dimensions, measurementsand data cube according with different view report that business needed, realize thecube multi-angle to browse and produce the report that compared with the same period of last year and on a month-on-month basis and KPI data. And setting accessby departments, positions and roles, in order to achieve separation of duties. Again,using SSRS deployment and show of the final report, allowing users to come intocontact with friendly, quickly, convenient, timely, compr ehensive business reports.At present, the entire system has been launched in Changsha, Pepsi-ColaBeverage Co., Ltd. successfully, full-featured, stable performance and achieve thepurpose of pre-designed. For enterprise management, power users to provide real-timebusiness analysis reports, and auxiliary help enterprise for business intelligence andintelligent collaborative decision-making and improve the competitiveness of thevalue of the supply chain.