Method for quickly generating dynamic cross two-dimensional table with hierarchical summarization

Abstract

The invention discloses a method for quickly generating a dynamic cross two-dimensional table with hierarchical summarization. The method comprises the following steps: S1, connecting a data source, and specifying analysis data; S2, maintaining and specifying analysis elements; S3, specifying a transverse title and a longitudinal title, and selecting a calculation field; S4, generating the transverse title and the longitudinal title; S5, performing multi-thread filtering, summarizing the calculation field, and outputting the table; and S6, exporting a multi-level summary cross two-dimensionaltable. According to the technical scheme, in step S1, data source names are input into a computer, data source connections are obtained, data needing to be analyzed is selected from data sources, andthe data needing to be analyzed is downloaded into a report system. The horizontal title and the longitudinal title are determined in sequence, the generation steps of the crossed two-dimensional table are clearer, the data filtering speed is increased by adopting a multi-thread technology, the report display speed is high, and finally the table is filled with the data, so that the generation of the table is accelerated.

Description

technical field [0001] The invention relates to the technical field of intersecting two-dimensional table generation, in particular to a method for quickly generating a dynamic intersecting two-dimensional table with hierarchical summary. Background technique [0002] As the system software is used longer and longer, more and more data is accumulated, and the user's demand for data analysis is becoming more and more urgent. Among them, the crosstab is a very commonly used form, and the crosstab is a A commonly used classification and summary table, using the cross-tab to query data is very intuitive and clear, and is widely used. The cross-tab query is also a feature of the database. The cross-two-dimensional table is a table in matrix format that displays the frequency distribution of variables. The cross-tab is used Widely used in survey research, business intelligence, engineering, and scientific research, they provide a basic picture of the interrelationships between two...

AI Technical Summary

Problems solved by technology

[0004] The present invention provides a method for quickly generating a dynamic intersecting two-dimensional table with hierarchical summary, which can effectively solve the problem that the current report software in the background technology can only meet the simple generation of cross two-dimensional tables. If the vertical title needs to be hierarchically summarized, Experienced technicians are often required to intervene. This kind of tabular data source is often difficult to write and has low performance and efficiency.

Images