Design and Application of KPI Query and Analysis System Based on Warehouse

Abstract:

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.

• Periodical: Advanced Materials Research (Volumes 479-481)
• Pages: 2616-2619
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.479-481.2616
• Online since: February 2012
• Authors: Xue Wen, Meng Jia Li, Rong Luo
• Keywords: Analysis, KPI, Query, Warehouse

References

[1] Binli Sun. (In Chinese) ERP principle and application [M]. Beijing: Electronic Industry Press, 2008.

[2] Hongli Jiang. (In Chinese) Strategic logic of KPI system [J]. Enterprise Reform and Management, 2005 (4).

[3] Zheng Rao, Bo Sun. (In Chinese) Performance management taking KPI as the core [M]. Beijing: China Renmin University Press, 2004.

[4] Xinning Su, Jian-lin Yang, etc. (In Chinese) Data warehousing and data mining [M]. Beijing: Tsinghua University Press, 2006.4.

[5] J. Cabot, E. Teniente, Incremental integrity checking of UML / OCL conceptual schemas, J. Software, 82 (9) (2009) 1459-1478.

DOI: 10.1016/j.jss.2009.03.009