Multi-dimensional data analysis method, device and equipment and readable storage medium

Abstract

The invention discloses a multidimensional data analysis method, which is characterized in that a query page used for interacting with a user is pre-configured, a plurality of condition components are arranged in the query page, and the user can form a self-defined data query condition by configuring the condition components. After condition information is obtained through configuration, a query statement is automatically generated through an SQL framework and executed, a matched data table is obtained and output, multi-dimensional analysis of data is achieved, and therefore the method can meet the requirement for multi-dimensional analysis under the condition that 2n arbitrary combinations are rapidly supported under any specified query condition; meanwhile, when a certain or some screening dimensions need to be newly added or deleted, only the corresponding condition components need to be added, deleted or modified, rapid modification, upgrading and online of the components can be supported, the dimension difficulty is low, and therefore flexible multi-dimensional analysis can be achieved through the method. The invention further discloses a multi-dimensional data analysis device and equipment and a readable storage medium, which have corresponding technical effects.

Description

Technical field [0001] The present invention relates to the field of information processing technology, in particular to a multidimensional data analysis method, apparatus, apparatus and readable storage medium. Background [0002] Multidimensional analysis refers to conditional filtering, specifying the dimensions of the analysis to see whether the changes in the indicators are as expected. Multi-dimensional analysis is a very important means in BI (business Intelligence, business intelligence), commonly used in indicator viewing, problem analysis, abnormal diagnosis, result prediction and other scenarios, with strong practical application value. [0003] The main means of multidimensional analysis of current data is multidimensional analysis based on pre-aggregation. This scheme is from the perspective of the report, the developer will specify the dimensions that need to be aggregated and analyzed in advance by the user, aggregate the intermediate detail model table according t...

AI Technical Summary

Problems solved by technology

This method needs to be based on customized development, the upgrade efficiency of new dimensions and indicators is low, and the flexibility is not enough; and it is only suitable for scenarios with a small number of dimensions. Once the number of dimensions is large, the time-consuming data processing and the size of the result set The amount of data increases exponentially, which is not suitable for high-dimensional scenarios; at the same time, adding new indicators or dimensions will involve the problem of historical data backtracking, and the maintenance cost is high

Images