The Application And Research Of Data Warehouse Building And Multi-hierarchical Dimension’s OLAP Database In HTS

Data warehouse (DW) and online analytical processing (OLAP) systems are widely applied during the decision-support process. A data warehouse provides users with high quality data organized in a way that facilitates expression of complex queries, ensuring at the same time efficient and accurate responses to such queries. OLAP systems can be used to access and analyze the data contained in DWs, whose multi-dimension dataset and data aggregation technology can process the huge amount of information complicatedly, fast and neatly according to data analyst’s demand and it also can supply the query result for different decision maker with obvious and intelligible way which can meet the demand of the system complex data.First of all, the thesis introduces the basic concept of DW and OLAP, which use the chart and data to expatiate the idea, methods and the problems in the process of implement. The author combines the DW and OLAP technology to design the whole process of information processing which from account data to analysis report, including the designing and building of DW and multi-dimension dataset, data display and analysis by studying the HTS Company’s financial reporting analysis’s issue. The application of the multi-dimensional and hierarchical data form can solve the problems of multi-perspective analysis and data detail requirement. In accordance with complex account chart, the author put forward the theory which is adopted with the parent-child dimension to realize the multi-hierarchical data structure of the object dimension. In the meanwhile, the author expatiates on the process which implements the OLAP system of HTS with Microsoft BI tools and MDX. Basing on the design above, the author develops a software platform of the system which proves the platform’s practicability and validation.