This paper study the current information construction in domestic enterprises, for the lack of timeliness and effectiveness of existing systems in terms of decision making, this paper proposes a program of query analysis system with KPI as a core. Taking the data in business warehouse of ERP system as a data source, this program designs the logic architecture of the system, gives the model of KPI indicators, extracts the relevant KPI, and finally, realizes the program concretely. This system adapts the actual needs of enterprises, and can help them improve the ability of obtaining valuable information, thereby improving the quality and speed of management and decision-making and enhancing the competitiveness of enterprises.