Research On Application Of Enterprise Performance Analysis Based On TM1

Uncertainty of financial environment and intense competition make the pressure of survival for enterprises become more and more. Finding out the gap between company's operating situation and strategic goals by analyzing performance in time should be useful for the management decisions. On-Line Analytical Processing (OLAP) is a kind of technology based on Multidimensional data model. It is characterized by multi-level and multi-angle analysis data. Applying OLAP to performance analysis and developing multidimensional analysis of enterprise performance data system with the aid of ripe OLAP software, managers and business personnel can analyze performance data from different levels and angles on the same platform according to their rights. It will help locate and solve problems accurately.ASIMCO Technologies Limited selected IBM Cognos TM1as the performance analysis system, and implemented analytical model and business logic in the platform. Analysis models in the system are designed from conceptual model to logic model, then to physical model. This designing idea transforms fuzzy requirements into analysis models in the computer gradually. Processing logic of data combines the characteristics of data sources and specific business needs. Based on the analysis of data sources, relevant data are maintained into the system with ETL(Extract-Transform-Load) tools Turbo Integrator integrated in TM1and tested the accuracy and rationality of the system with historical data and business logic. Managers and business personnel can analyze performance indicators through OLAP operations such as slice, dice, drill and pivot. In particular, the system can realize cross-thematic query and analysis from performance indicators analysis to financial statements analysis and sales information analysis according to drill-through rules defined. The system has come into being and is running stably. It provides great help to ASIMCO on grasping of enterprise performance in time.