The Research And Implementation Of Ad-Hoc Report Components Based On Multidimensional Data Analysis

Business intelligence(BI) transforms existing data of enterprise into knowledge using da ta warehouse, on-line analytical processing(OLAP) and data mining technology. In this w ay, it is a tool that can help a enterprise to make informed business decisions. After mo re than ten years of development history, business intelligence has applied to broad field s,such as Communication, Insurance, Financial, Business and otherindustries. Ad hoc reports(Ad-Hoc) is the core function of BI, it can help the user obtain the concerned data from thedata warehouse as needed, making an easier way to analyse and process these data.Based upon the full understanding of the demands of Ad-Hoc, this paper study the mu ltidimensional Ad-Hoc depthly.This paper introduces the main theories of data warehouse and the other related theori es, including the definition and characteristics of data warehouse, the main differences be tween database and data warehouse, the architec-ture of data warehouse and the model o f data.This paper also introduces the basic con-cepts and characteristics of OLAP, the co mparison and classification of OLTP and OLAP. These contents laid theoretical foundatio n on studying and realizing Ad-Hoc components.From the different groups of using Ad-Hoc components, this study bring in the show module of cube views which supports drag-and-drop for report generation; In order to i mprove the simplicity of generating Cube View, this study introduced the management m odule of Cube View to support graphical generation of Cube View; Forthe sake of suppo rting different designs of OLAP engine, this study developed the management module of OLAP engine, the user can conveniently to add, modify, delete the OLAP engine throug h the graphical way.On account of the architecture of SOA, the realization of components obey the methodology of the development of the unified software process.This paper firstly introduces the functions of components. And then designs a architecture,detailed plans and concrete realization of components. Finally summarizes the whole article and puts forward prospect of this component.