Multi-dimensional analysis method for multi-level storage data

Abstract

The invention discloses a multi-dimensional analysis method for multi-level storage data. The multi-dimensional analysis method comprises the following steps: step 1, building a unified data model; step 2, building a multi-dimensional analysis model; step 3, performing multi-dimensional analytic calculation and demonstration: a calculation engine automatically generates an aggregate calculating sentence, corresponding to a next-level calculation node, of the multi-dimensional analysis model according to routing information, a calculation agent executes aggregation operation to generate a pre-aggregation result and uploads the pre-aggregation result onto a main-control server, and then secondary aggregation calculation is executed to generate a multi-dimensional calculation result set; the calculation engine forms a dimension member inquiry algorithm according to the multi-dimensional analysis model and the unified data model, inquires a dimension member, generates cell objects of a demonstration report and fills the multi-dimensional analysis result into the cell objects to realize multi-dimensional demonstration of the multi-dimensional analysis result. The multi-dimensional analysis method can realize real-time multi-dimensional analysis of hierarchical storage data without centralizing data in advance.

Description

technical field [0001] The invention relates to a multidimensional analysis method, in particular to a multidimensional analysis method for multilevel storage data. Background technique [0002] With the gradual deepening of the application of power enterprise business information systems, the amount of business data will gradually increase, and there is a strong demand for real-time multi-dimensional analysis of data. At present, foreign data analysis application research mainly focuses on the following five aspects: [0003] 1) Enterprise-level reports. The report generator is used to generate nicely formatted static reports that are widely distributed to most people. [0004] 2) Cube analysis. Cube-based BI tools provide business managers with simple slice-and-drill analysis capabilities. [0005] 3) Arbitrary query and analysis. For super users to access the database arbitrarily, slice and drill the entire database, so as to analyze the most fine-grained business in...

AI Technical Summary

Problems solved by technology

[0008] The current multi-dimensional analysis products do not support real-time data analysis of multi-level storage data, and all the hierarchically stored data need to be concentrated in the data center of the headquarters before the global multi-dimensional analysis can be performed, which greatly reduces the immediacy of multi-dimensional analysis , the use of data value is also greatly reduced

Images