A query dimension-based dynamic report generation method

Abstract

The invention discloses a query dimension-based dynamic report generation method, which comprises the following steps: S1, constructing a data directory, and performing online display, sharing and dynamic updating in the form of a data asset directory and a shared directory; s2, providing a dynamic report tool, and forming a personalized report form according to different dimensions and index combination modes by means of a vector multiplication theory; s3, preprocessing the personalized report based on the J2EE technology, and obtaining a multi-dimensional dynamic report; and S4, dividing the report into a static report generated in a fixed format and a dynamic report which can be individually adjusted by the user as required according to the ability of the terminal user to change the presentation form of the report. The invention has the beneficial effects that a company-level index system is established, centralized storage and dynamic updating of index data are realized, index-based data processing and application of business personnel are effectively supported and promoted, and personalized report requirements on business are met.

Description

technical field [0001] The present invention relates to the technical field of computer networks, in particular to a method for generating dynamic reports based on query dimensions. Background technique [0002] The storm of global economic informatization is rapidly sweeping across all walks of life, and the need to build an enterprise information center with Internet technology and large databases is becoming more and more urgent; an important symbol of informatization is the wide application of new network technologies and database technology integration. The comprehensive application of modern high-tech can fundamentally solve the problem of high-quality information demanded by large enterprises, and provide reliable basis for decision-making to promote enterprise development and informatization process. [0003] Reports are the most common way to transmit information inside and outside the enterprise in an intuitive, generalized and highly condensed way to reflect the o...

AI Technical Summary

Problems solved by technology

The format of the report is not uniform, the industry has not formed a unified standard, the report template is not compatible, the industry is highly targeted, and improper selection will lead to repeated rework, wasting manpower and financial resources

[0006] 2. Poor maintainability of reports

The report format generated by the current popular report tool system is fixed, but with the change of application requirements, frequent additions and modifications are made to correspond to different requirements of the report, which makes it more and more difficult to maintain the report system software that lacks dynamic generation performance.

[0007] 3. Reports are poorly cross-platform

Although Windows is currently the most popular system platform, it is not the most secure system platform. Most of the current popular reporting systems only support the Windows platform.

[0008] 4. The operation of multiple data sources is difficult

The source data requires complex statistical calculations and format conversions, which are the bottlenecks of the current traditional report system processing

Images