Report generation method and system, computer equipment and storage medium

Abstract

The invention relates to the technical field of data analysis, and provides a report generation method and system, computer equipment and a storage medium. The report generation method comprises the following steps: obtaining an initial header with an index region and a dimension region; in response to a configuration operation of the index region, merging category cells of a target index according to a configured index classification structure, and generating a composite index; performing overlapping verification on the dimensions associated with the target indexes to generate a dimension set commonly associated with the composite indexes; generating a target dimension in response to a configuration operation of the dimension region based on the dimension set; and generating an initial report with a composite header according to the composite index and the target dimension. According to the method and the device, flexible configuration of indexes / dimensions is supported, the composite header can be automatically generated according to user requirements, the data export requirements of a user on multi-index / multi-dimension combinations are met, meanwhile, data validity verification can be carried out based on the index and dimension combinations, and the report generation efficiency is improved.

Description

technical field [0001] The present disclosure relates to the technical field of data analysis, and in particular, relates to a report generation method, system, computer equipment and storage medium. Background technique [0002] In the field of data analysis, it is often necessary to export the data content of certain indicators based on certain dimensions and generate reports for subsequent further analysis and processing. Dimensions represent the classification of data, and indicators represent the value of data under a specific dimension. [0003] The current common report export method is usually based on fixed indicators and fixed dimensions in a fixed form to export data, and there are the following problems: [0004] First, the header of the fixed form cannot be flexibly configured, and cannot meet the user's data export requirements based on multi-indicator / multi-dimensional combinations; if the user needs a composite header report with different indicator and dime...

AI Technical Summary

Problems solved by technology

[0004] First, the header of the fixed form cannot be flexibly configured, and cannot meet the user's data export requirements based on multi-indicator / multi-dimensional combinations; if the user needs a composite header report with different indicator and dimension combinations, it needs to be customized by writing SQL statements , wasting labor costs;

[0005] Second, it is impossible to achieve an effective combination of indicators and dimensions. During the customized development process, users cannot verify the validity of the data combined with different indicators and dimensions. It often happens that after complicated writing, a lot of redundant data or a lot of Invalid report with missing data

Images