Design And Implementation Of A Comprehensive Budget Management System Based On Multidimensional Data Model

With the deepening of China’s economic reform, corporate ownership structure has changed, there have been scattered diversified investor base, there have been two companies the right to separation of ownership and management. Corporate investors not only concerned about the current implementation of corporate profits, but also concerned about the future profitability and business development capacity. In this case, in order to meet the needs of investors and enhance the competitiveness of enterprises, implementation of a comprehensive budget management is the inevitable choice for corporate investors and operators in the property rights system reform under the new situation.Thesis, comprehensive budget management system development group enterprise background, business requirements for enterprise comprehensive budget management, design and development of a comprehensive budget management system based on multi-dimensional data model. The system according to an annual period dimension, monthly, etc., from top to bottom to complete the provincial, city, county, department or marketing service centers in four levels of cost budgeting and management, project budgeting and management, and budget data for approval and multidimensional online analytical budget processing and other business functions.This paper is the design and implementation of a comprehensive budget management system based on multidimensional model, the main research contents include multidimensional budget data model establishment, multidimensional budgeting model, multidimensional OLAP three most budget. The use of multidimensional data model based on the system requirement analysis analysis techniques, to compare and analyze the characteristics and difference between the star type model and snowflake model, includes the establishment of the budget units, departments and subjects, projects such as the multi dimension business data model; provide budget data compiling multi dimension based on multidimensional data model, multidimensional the data model of the budget table is divided into sheet dimension, dimension, table table expert in dimension, metric based on the four part, through the combination of dimensions, dimension member mappings satisfy the various business needs of the budget; based on the multidimensional data model of data by means of drilling technology to take, slicing and rotation were multidimensional on line analysis and processing, the user can from the multi angle, multi lateral master budget application, such as the implementation of the situation.Paper first describes the overall budget management role and significance in the modern enterprise management, analysis of the current situation at home and abroad acomprehensive budget development, characteristics and problems; then introduces the key technologies used in the system development; then in systems business needs analysis carried out on the basis of the overall system design, detailed design and implementation; Finally, test cases from the system response time, server resources occupancy of two angles of a comprehensive budget management system for testing and evaluation of test results are given.