Currently, many large corporations adopt secondary deployment pattern in their core business. However, when head office analyzes the company-wide data timely and fully in this model, it may cause problems of large amount of data, scattered data storage, not timely responding to the changes in requirements and handiwork statistics. In this paper, based on the above problems, a multidimensional data analysis technology and software tool which can support the end users on-demand self-service data analysis are proposed. The software can analyze data according to different requirements of users, form a data view quickly, and show data through report forms finally. Furthermore, this flexible, efficient, practical and real-time data analysis tool has been successfully applied to State Grid Corporation of China(SGCC), which shows that it has some value in theory and practical applications.