Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and terminal for hierarchically summarizing reports

A report and terminal technology, applied in the field of reports, can solve the problems of complex algorithms, inability to define hierarchical summary reports, and difficulty in abstraction, so as to improve query efficiency, improve readability and maintainability, and reduce database load.

Active Publication Date: 2021-10-08
FUJIAN BOSS SOFTWARE
View PDF10 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] But in this scheme, memory aggregation is required. The algorithm of memory aggregation is relatively complicated and it is difficult to abstract a general business model. It may be necessary to target different business data Dimensions are processed separately; currently, the custom report designer defines a report according to SQL semantics, and cannot use the memory aggregation algorithm to define a hierarchical summary report according to the conventional process

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and terminal for hierarchically summarizing reports
  • Method and terminal for hierarchically summarizing reports
  • Method and terminal for hierarchically summarizing reports

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0078] Please refer to figure 1 , Figure 3 to Figure 9 , a method for grading and summarizing reports, comprising the steps of:

[0079] S1. Set the SQL expression and various dimension combinations of the report.

[0080] Wherein, the SQL expression for setting the report includes:

[0081] Set the SQL expression of the report, and add condition variables in the SQL expression.

[0082] Specifically, please refer to Figure 3 to Figure 5 , use the custom report designer to define a multi-dimensional free combination report, you need to define the SQL expression, report display layout and report data set, among them, set the data model and SQL expression of the summary table, add condition variables in the expression, and In this example, the condition variables are ${BEGINDATE} and ${ENDDATE};

[0083] Please refer to Image 6 with Figure 7 , set the basic attributes of the report, and associate the report with the data model of the summary table, and set the hierarc...

Embodiment 2

[0109] Please refer to figure 2 , a terminal for grading and summarizing reports, including a memory, a processor, and a computer program stored in the memory and operable on the processor, when the processor executes the computer program, the report of Embodiment 1 is realized Steps in the method of hierarchical summarization.

[0110] To sum up, the method and terminal for hierarchical summarization of reports provided by the present invention pre-set the SQL expression of the hierarchical summary report and the combination of various dimensions that need to be displayed; receive a report query request, and substitute the query conditions of the query request into Get the first-level summary statement after the expression, and calculate the hash value of the first-level summary statement, which can correspond the first-level summary statement with the hash value one by one. When setting the SQL expression, add a condition variable to the expression , substituting the query...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method and a terminal for hierarchically summarizing reports. The method comprises the following steps of: presetting an SQL (Structured Query Language) expression of the hierarchically summarized reports and a plurality of dimension combinations needing to be displayed; receiving a report query request, substituting query conditions of the query request into the expression to obtain first-level summarized statements, and calculating hash values of the first-level summarized statements, so that the first-level summarized statements can be in one-to-one correspondence with the hash values; and enabling the hash value to exist in the memory temporary table corresponding to the hash value, selecting the summarizing dimension combination required by secondary summarizing from multiple dimension combinations, and performing secondary summarizing according to the memory temporary table and the summarizing dimension combination. Compared with a hierarchical summarizing method needing memory summarizing in the prior art, the subsequent secondary summarization can be directly inquired from the memory temporary table according to the SQL semantics, one-time analysis and repeated use can be realized, the database load is reduced, the query efficiency is improved, the memory temporary table can be used for multiple times, and the readability and maintainability during hierarchical summarization of reports are improved.

Description

technical field [0001] The invention relates to the technical field of reports, in particular to a method and terminal for hierarchically summarizing reports. Background technique [0002] When designing a custom report, when it is necessary to simultaneously query the same data set in a report menu and to freely combine and summarize data according to multiple different dimensions, the traditional solution is to count the source table multiple times. For example, the source data set includes multiple dimensions such as unit, account, item, bank, amount, etc. If the amount is calculated according to (unit|subject), (unit|item), and (unit|bank), the source table needs to be scanned three times. For different sub-tables, the background needs to submit query requests to the database separately, and then automatically merge the result sets and return them to the front-end. [0003] However, if the source table is queried many times, if the database table has a large amount of d...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/2455G06F16/21G06F16/22
CPCG06F16/24553G06F16/21G06F16/2282
Inventor 陈庸凯黄荣明汪彦朱国华
Owner FUJIAN BOSS SOFTWARE