Logistics Company Financial System Design And Development Of Integrated Query Platform

With the vigorous development of IT software technology,major companies have gradually established a more mature IT computer environment,and even set up the IT department.IT departments will participate in the management of production processes within the enterprise through technical support,not only the computer hardware,but also different types of different production processes used in the management of software,such as MIS(Management Information System)management information system,Financial systems and production systems and other information systems.These different types of systems are aimed at different business units in the enterprise,so that enterprises through these tools in an orderly manner the production process.So a wide range of software systems generated by the data every day is very large,the major system is provided by the different software vendors,so the data between various software systems is relatively small.When the company's management wants to understand the company's overall business situation,you need across a number of systems,through a few relationships between the system to manually statistical analysis,in order to come to the company's production and operation.Such a statistical analysis by manual intervention,will bring some unavoidable problems.Such as: the authenticity of the data,the fault tolerance of artificial data processing,the cost of personnel input.How to integrate the data of each big system of the enterprise,through mature business intelligence idea,with the mature technology that SqlServer2012 offers,utilize SSIS(Microsoft SQL Server Integration Services),SSAS(Microsoft SQL Server Analysis Services),SSRS Services)to carry out major system data extraction conversion,the formation of DW data warehouse.The data warehouse is used as the data base to carry out multidimensional data set dimension and value design,and finally to form the analysis report or trend chart of the business condition needed by the enterprise.Through the relationship between the system to integrate all the key business systems integration to replace the manual statistical analysis,through a comprehensive automation for business decision-making or management to provide statistical basis for statistical data,and fully meet the financial aspects of theintegrated query platform,which will be The core issue of the paper.