CN113095054A - Method and device for generating detailed summary report based on divide-and-conquer algorithm - Google Patents

Method and device for generating detailed summary report based on divide-and-conquer algorithm Download PDF

Info

Publication number
CN113095054A
CN113095054A CN202110499169.6A CN202110499169A CN113095054A CN 113095054 A CN113095054 A CN 113095054A CN 202110499169 A CN202110499169 A CN 202110499169A CN 113095054 A CN113095054 A CN 113095054A
Authority
CN
China
Prior art keywords
data
report
index
user
summarizing
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202110499169.6A
Other languages
Chinese (zh)
Other versions
CN113095054B (en
Inventor
张启伟
王佳新
刘迪
尹洪苓
刘海涛
刘泽三
隋志巍
王晋斌
付成花
苏宝昆
孙璐
胡美林
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Information and Telecommunication Co Ltd
Beijing Guodiantong Network Technology Co Ltd
Original Assignee
State Grid Information and Telecommunication Co Ltd
Beijing Guodiantong Network Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by State Grid Information and Telecommunication Co Ltd, Beijing Guodiantong Network Technology Co Ltd filed Critical State Grid Information and Telecommunication Co Ltd
Priority to CN202110499169.6A priority Critical patent/CN113095054B/en
Publication of CN113095054A publication Critical patent/CN113095054A/en
Application granted granted Critical
Publication of CN113095054B publication Critical patent/CN113095054B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/903—Querying
    • G06F16/9035—Filtering based on additional data, e.g. user or group profiles
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/903—Querying
    • G06F16/9038—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/186—Templates

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Data Mining & Analysis (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application provides a detailed summary report generation method and device based on a divide-and-conquer algorithm, which select a data filtering factor and a data summary mode through a displayed first window according to attribute information and index information selected by a user based on a displayed first interface, take the data filtering factor as a data filtering condition of a service index, and take the summary mode selected by the user as a data summary mode corresponding to the service index. And finally, automatically summarizing the index information meeting the data filtering condition according to a summarizing mode, and generating a summarizing result corresponding to the attribute information under the business index, so as to obtain a detailed summarizing report. The report template provided by the scheme is high in flexibility, and for different service types and different data processing conditions and modes, a user can select to obtain a corresponding report based on requirements under the condition that the template is not required to be re-formulated or modified, so that the report generation efficiency can be improved, and the operation is simple and convenient.

Description

Method and device for generating detailed summary report based on divide-and-conquer algorithm
Technical Field
The application relates to the field of data processing, in particular to a method and a device for generating a detail summary report based on a divide-and-conquer algorithm.
Background
The report form is an effective means for sorting and analyzing data and is an important basis for enterprise decision-making as a data display mode. The detail summary table is a form of a report and is a data report generated by summarizing the business detail data. Under normal conditions, enterprises or organizations generate a large amount of detail data every year, and how to quickly form summary reports based on the detail data is extremely important for management and decision of the enterprises.
At present, there are many implementation ways for generating a detail summary report, and a detail summary report meeting requirements is generally generated based on a report template, but the flexibility of the report template is poor at present, for example, only specific service types can be targeted, and data processing conditions and modes (e.g., summary conditions and modes) of the report template are relatively fixed. If the service type is changed or the data processing condition and mode are to be changed, a professional is required to modify the template or customize a new report template, which results in low report generation efficiency. Therefore, how to generate detailed summary reports quickly becomes an urgent problem to be solved.
Disclosure of Invention
In order to achieve the above object, the present application provides the following technical solutions:
a detail summary report generation method based on a divide-and-conquer algorithm comprises the following steps:
responding to a report generation instruction input by a user, and displaying a first interface, wherein the first interface comprises a preset report template; the report template comprises an index display area and a data display area; the index display area comprises a plurality of service indexes obtained by dividing based on a divide-and-conquer algorithm, and the service indexes are set according to service types; the data display area comprises a plurality of data columns;
responding to a data display instruction input by a user on the first interface, and loading a preset report data source to the first interface; the report data source comprises attribute information and index information; the attribute information is information of a report summarizing object, and the index information is data associated with the attribute information;
adding the attribute information selected by the user to a first data column of the data display area, and adding the index information selected by the user to a second data column of the data display area; the first data column and the second data column are the data columns of the data display area;
responding to an index parameter setting instruction which is input by a user based on the service index in the first interface and aims at the service index, and displaying a preset first window; the first window comprises a data filtering factor display area and a data summarizing mode display area;
generating a data filtering condition of the service index according to the data filtering factor selected by the user in the data filtering factor display area; generating a data summarizing mode corresponding to the service index according to the summarizing mode selected by the user in the data summarizing mode display area;
summarizing the index information of the second data column meeting the data filtering condition according to a summarizing mode in response to a data summarizing instruction input by a user, and generating a summarizing result corresponding to the attribute information under the service index;
and taking the report template of the data display area, including the attribute information, the index information and the summary result, as the generated detailed summary report.
Optionally, the adding the attribute information selected by the user to the first data column of the data display area includes:
in response to the fact that a user detects that the trigger object moves on the first interface based on the attribute information selected by the trigger object, track-tracking the trigger object, determining a data column corresponding to a final movement stop point of the trigger object, and adding the attribute information to the data column;
the adding the index information selected by the user to the second data column of the data display area comprises:
and in response to the fact that the index information is selected by a user based on a trigger object, under the condition that the trigger object is detected to move on the first interface, track tracking is carried out on the trigger object, a data column corresponding to a final movement stopping point of the trigger object is determined, and the index information is added to the data column.
Optionally, in the method, in response to a data summarization instruction input by a user, summarizing the index information of the second data column that meets the data filtering condition according to the summarization manner to generate a summarization result corresponding to the attribute information under the service index, where the summarizing method includes:
responding to a report issuing instruction input by a user, taking a report template comprising attribute information, index information, service indexes selected by the user and data filtering conditions and data summarizing modes corresponding to the service indexes as a first report, and converting the current report design state of the first report into a report running state;
storing the data content included in the first report, and distributing an ID code for the first report;
and responding to a data summarizing instruction input by a user, calling a preset report analysis engine, and summarizing the index information of the second data column meeting the data filtering condition by the report analysis engine according to the summarizing mode in the first report to obtain a summarizing result.
The above method, optionally, further includes:
after receiving a business instruction detail display instruction input by a user, acquiring an index parameter of the business index, and adding the index parameter into the report according to a data column form; the index parameters comprise data filtering conditions corresponding to the service indexes and/or data summarizing modes.
Optionally, the method for generating the data filtering condition of the service indicator according to the data filtering factor selected by the user in the data filtering factor display area includes:
and combining the data filtering factors selected by the user in the data filtering factor display area to obtain the data filtering condition.
A device for generating a detailed report based on a divide-and-conquer algorithm comprises:
the first display unit is used for responding to a report generation instruction input by a user and displaying a first interface, and the first interface comprises a preset report template; the report template comprises an index display area and a data display area; the index display area comprises a plurality of service indexes obtained by dividing based on a divide-and-conquer algorithm, and the service indexes are set according to service types; the data display area comprises a plurality of data columns;
the loading unit is used for responding to a data display instruction input by a user on the first interface and loading a preset report data source to the first interface; the report data source comprises attribute information and index information; the attribute information is information of a report summarizing object, and the index information is data associated with the attribute information;
the adding unit is used for adding the attribute information selected by the user to a first data column of the data display area and adding the index information selected by the user to a second data column of the data display area; the first data column and the second data column are the data columns of the data display area;
the second display unit is used for responding to an index parameter setting instruction which is input by a user based on the service index in the first interface and aims at the service index, and displaying a preset first window; the first window comprises a data filtering factor display area and a data summarizing mode display area;
the first generating unit is used for generating the data filtering condition of the service index according to the data filtering factor selected by the user in the data filtering factor display area; generating a data summarizing mode corresponding to the service index according to the summarizing mode selected by the user in the data summarizing mode display area;
the second generating unit is used for responding to a data summarizing instruction input by a user, summarizing the index information of the second data column meeting the data filtering condition according to the summarizing mode, and generating a summarizing result corresponding to the attribute information under the service index;
and the third generating unit is used for taking the report template of the data display area, which comprises the attribute information, the index information and the summary result, as a generated detailed summary report.
Optionally, in the apparatus described above, the adding unit is configured to add the attribute information selected by the user to the first data column of the data display area, and includes the adding unit specifically configured to:
responding to the attribute information selected by a user based on a trigger object, tracking the trigger object under the condition that the trigger object moves on the first interface, determining a data column corresponding to a final movement stop point of the trigger object, and adding the attribute information to the data column;
the adding unit is configured to add the index information selected by the user to a second data column of the data display area, and includes the adding unit specifically configured to:
and responding to the index information selected by a user based on a trigger object, tracking the trigger object under the condition that the index information moves on the first interface, determining a data column corresponding to a final movement stop point of the trigger object, and adding the index information to the data column.
Optionally, the above apparatus includes a second generating unit, configured to, in response to a data summarization instruction input by a user, summarize, according to the summarization manner, the index information of the second data column that meets the data filtering condition, and generate a summarization result corresponding to the attribute information under the service index, where the second generating unit is specifically configured to:
responding to a report issuing instruction input by a user, taking a report template comprising attribute information, index information, service indexes selected by the user and data filtering conditions and data summarizing modes corresponding to the service indexes as a first report, and converting the current report design state of the first report into a report running state;
storing the data content included in the first report, and distributing an ID code for the first report;
and responding to a data summarizing instruction input by a user, calling a preset report analysis engine, and summarizing the index information of the second data column meeting the data filtering condition by the report analysis engine according to the summarizing mode in the first report to obtain a summarizing result.
The above apparatus, optionally, the second display unit is further configured to:
after receiving a business instruction detail display instruction input by a user, acquiring an index parameter of the business index, and adding the index parameter into the report according to a data column form; the index parameters comprise data filtering conditions corresponding to the service indexes and/or data summarizing modes.
Optionally, in the apparatus described above, the first generating unit is configured to obtain the data filtering condition of the service indicator according to the data filtering factor selected by the user in the data filtering factor displaying area, and includes the first generating unit specifically configured to:
and combining the data filtering factors selected by the user in the data filtering factor display area to obtain the data filtering condition.
According to the scheme, the first interface is displayed in response to a report generation instruction input by a user, the first interface comprises a preset report template, the report template comprises an index display area and a data display area, and the index display area comprises a plurality of service indexes. And according to a data display instruction input by a user, displaying and loading a preset report data source to the first interface, wherein the user can select attribute information and index information based on the report data source. That is, in the present scheme, the attribute information and the index information may be dynamically selectable.
Furthermore, the index display area comprises a plurality of service indexes which are set according to service types, and displays a preset first window in response to an index parameter setting instruction which is input by a user service index and aims at the service indexes, the first window comprises a data filtering factor display area and a data summarizing mode display area, the data filtering factor selected by the user in the data filtering factor display area is used as a data filtering condition of the service indexes, and the summarizing mode selected by the user in the data summarizing mode display area is used as a data summarizing mode corresponding to the service indexes. Because the service index is set according to the service type, the user can select the corresponding service index according to different service types. And moreover, the data filtering condition and the data summarizing mode of the service index can be flexibly set for a service index user. That is to say, in the scheme, the service index, the data filtering condition of the service index and the data summarizing mode are dynamically selectable.
And finally, in response to a data summarizing instruction input by a user, summarizing the index information of the second data column meeting the data filtering condition according to a summarizing mode, and generating a summarizing result corresponding to the attribute information under the service index, so as to obtain a report.
In conclusion, the report template provided by the scheme has higher flexibility, and for different service types and different data processing conditions and modes, a user can select the report template based on requirements to obtain the corresponding report without re-formulating or modifying the template, so that the generation efficiency of the report can be improved, the operation is simple and convenient, and the requirement of the user on the specialty can be reduced.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of a method for generating a detail summary report based on a divide-and-conquer algorithm disclosed in an embodiment of the present application;
FIG. 2 is a schematic diagram of a framework structure of a report template disclosed in an embodiment of the present application;
FIG. 3 is a schematic diagram of a framework structure of a report data source disclosed in an embodiment of the present application;
FIG. 4 is a result diagram obtained by adding the attribute information and the index information to the report template disclosed in the embodiment of the present application;
fig. 5 is a schematic structural diagram of a device for generating a detailed summary report based on a divide-and-conquer algorithm disclosed in the embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
Fig. 1 is a method for generating a detail summary report based on a divide-and-conquer algorithm according to an embodiment of the present application, and the method includes the following steps:
s101, responding to a report generation instruction input by a user, and displaying a first interface.
The first interface comprises a preset report template, and the report template comprises an index display area and a data display area. The index display area comprises a plurality of service indexes obtained by division based on a divide-and-conquer algorithm, the service indexes are set according to service types, and the data display area comprises a plurality of data columns.
The basic idea of the divide and conquer algorithm is to decompose a problem of size N into K sub-problems of smaller size, which are independent of each other and have the same properties as the original problem. In this embodiment, the idea of the divide-and-conquer algorithm is adopted, and different service indexes are set for different service types. The business indexes can be understood as the summarizing dimensions of the report summarizing, and can be corresponding to the business indexes of different business types. A plurality of service indexes covering different service types are preset, and all preset service indexes are displayed in an index display area of the report template.
Referring to fig. 2, a frame structure of the report template displayed by the first interface is shown. As shown in fig. 2, the left side of the report template is an index display area including a plurality of service indexes, the right side is a data display area, and the data display area includes a plurality of data columns, such as column 1 and column 2 in the figure. The service index may be set in a tree structure, for example, in the graph, index 1 is a root index node, indexes 11, 12, and 13 are next-level index nodes of index 1, and the same indexes 141 and 142 are next-level index nodes of index 14.
S102, responding to a data display instruction input by a user on the first interface, and loading a preset report data source to the first interface.
In the first interface, a preset data display option is displayed, so that a user can input a data display instruction based on the data display option.
The report data source comprises attribute information and index information. The attribute information is information of a report summarizing object, and the index information is data associated with the attribute information.
For example, the attribute information may be the power condition of beijing, and the index information may be power data used in different seasons in each area of beijing, or may be the layout of power transport equipment in each area of beijing.
Referring to fig. 3, a frame structure of a report data source is shown, as shown in fig. 3, a specific name of the report data source is a detail summary report data source, attribute information includes multiple attributes (attribute 1, attribute 2, attribute 3, and the like in the figure), and index information includes multiple indexes (index 1, index 2, index 3, and the like in the figure).
It should be noted that, after the report data source is loaded to the first interface, the first interface still displays the report template including the index display area and the data display area, and the report data source can be understood as a part of the report template.
S103, adding the attribute information selected by the user to a first data column of the data display area, and adding the index information selected by the user to a second data column of the data display area.
It should be noted that the first data column and the second data column are data columns of the data display area. "first" and "second" are merely for convenience of description and to distinguish between different columns of data, and do not represent an order.
One implementation way of adding the attribute information selected by the user to the first data column of the data display area in this step is as follows: and in response to the fact that the user detects that the trigger object moves on the first interface based on the attribute information selected by the trigger object, tracking the trigger object, determining a data column corresponding to a final movement stop point of the trigger object, and adding the attribute information to the data column corresponding to the stop point. In this embodiment, adding the attribute information to the data column is equivalent to automatically acquiring specific data information of the attribute information and displaying the data information in the data column.
Similarly, the embodiment of adding the index information selected by the user to the second data column of the data display area in this step is as follows: and in response to the fact that the user selects the index information based on the trigger object, under the condition that the trigger object is detected to move on the first interface, track tracking is carried out on the trigger object, a data column corresponding to a final movement stop point of the trigger object is determined, and the index information is added to the data column. Similarly, adding the index information to the data column is equivalent to automatically acquiring specific data information of the index information and displaying the specific data information in the data column.
The trigger object may be a finger, a trigger pen, or the like. After the user selects the attribute information or the index information based on the trigger object, the user can add the selected attribute information and the selected index information to the data column of the data display area of the report template by moving the trigger object.
Referring to fig. 4, a result diagram of adding attribute information and index information to a data column of a data presentation area of a report template is shown, and a direction indicated by an arrow in the diagram is a trajectory of movement of a trigger object. The index node on the left side in the graph is an index display area of the report template, and can display all preset service indexes and also can display the service indexes selected by a user.
And S104, responding to an index parameter setting instruction which is input by a user based on the service index in the first interface and aims at the service index, and displaying a preset first window.
In this embodiment, the user may input an index parameter setting instruction for the service index based on the click service index.
The first window comprises a data filtering factor display area and a data summarizing mode display area. The data filtering factor is a filtering condition factor of the data information, and the data filtering factor can be preset by combining the requirements of the service type, the report summarizing object and the like. For example, the data regularity factor may be a factor in units of places, a time factor, or the like. The data summarizing mode can be summarizing, averaging, maximum, minimum, variance and the like.
And S105, generating a data filtering condition of the service index according to the data filtering factor selected by the user in the data filtering factor display area.
The embodiment mode of the step can be as follows: and combining the data filtering factors selected by the user in the data filtering factor display area to obtain data filtering conditions.
It should be noted that, in order to improve convenience of setting the index parameter, the data filtering condition of the service index may also be obtained by inheriting the data filtering condition of the higher-level service index, or the data filtering condition of the service index set by the user and the data filtering condition of the higher-level service index are combined to obtain the final data filtering condition of the service index. For example, in conjunction with fig. 2, after the user sets the data filtering condition of index 1, the data filtering condition of index 2 can be obtained by inheriting the data filtering condition of index 1.
And S106, generating a data summarizing mode corresponding to the service index according to the summarizing mode selected by the user in the data summarizing mode display area.
Specifically, the summary mode selected by the user may be used as the data summary mode corresponding to the service index.
And S107, in response to a data summarizing instruction input by a user, summarizing the index information of the second data column meeting the data filtering condition according to a summarizing mode, and generating a summarizing result corresponding to the attribute information under the service index.
One embodiment of this step includes steps a through D:
step A, responding to a report issuing instruction input by a user, and taking attribute information, index information, service indexes selected by the user and a report template of a data filtering condition and a data summarizing mode corresponding to the service indexes as a first report;
and step B, storing the data content included in the first report, and distributing the ID code to the first report.
The data content includes attribute information, index information, service index selected by the user, and data filtering condition and data summarizing mode corresponding to the service index.
And step C, converting the current report design state of the first report into a report running state.
And D, responding to a data summarizing instruction input by a user, calling a preset report analysis engine, and summarizing the index information of the second data column meeting the data filtering condition by the report analysis engine according to a summarizing mode in the first report to obtain a summarizing result.
After a data summarizing instruction input by a user is received, data content included in the first report is obtained according to the table ID of the first report, and a preset report analysis engine is called to perform data processing on the data content included in the first report, so that a summarizing result is obtained. The specific processing procedure of the report parsing engine may refer to the prior art, and is not described herein again.
And S108, taking the report template of the data display area, including the attribute information, the index information and the summary result, as the generated detailed summary report.
In this embodiment, the summary result may be placed at the column head of the data column where the index information is located, for example, the column heads of "column 1", "column 2", and "column 3" in fig. 4 are all summary results.
The method provided by the embodiment includes the steps that a report generation instruction input by a user is responded, a first interface is displayed, the first interface comprises a preset report template, and the report template comprises an index display area and a data display area; the index display area comprises a plurality of service indexes. And according to a data display instruction input by a user, displaying and loading a preset report data source to the first interface, wherein the user can select attribute information and index information based on the report data source. That is, in the present scheme, the attribute information and the index information may be dynamically selectable.
Furthermore, the index display area comprises a plurality of service indexes which are set according to service types, and displays a preset first window in response to an index parameter setting instruction which is input by a user service index and aims at the service indexes, the first window comprises a data filtering factor display area and a data summarizing mode display area, the data filtering factor selected by the user in the data filtering factor display area is used as a data filtering condition of the service indexes, and the summarizing mode selected by the user in the data summarizing mode display area is used as a data summarizing mode corresponding to the service indexes. Because the service index is set according to the service type, the user can select the corresponding service index according to different service types. And moreover, the data filtering condition and the data summarizing mode of the service index can be flexibly set for a service index user. That is to say, in the scheme, the service index, the data filtering condition of the service index and the data summarizing mode are dynamically selectable.
And finally, in response to a data summarizing instruction input by a user, summarizing the index information of the second data column meeting the data filtering condition according to a summarizing mode, and generating a summarizing result corresponding to the attribute information under the service index, so as to obtain a report.
In conclusion, the report template provided by the scheme has high flexibility, and for different service types and different data processing conditions and modes, a user can select the corresponding report based on requirements without re-formulating or modifying the template, so that the generation efficiency of the report can be improved, the operation is simple and convenient, and the requirement of the user on the specialty can be reduced. The method is equivalent to adopting a divide-and-conquer algorithm, splitting the generation problem of the complicated summary report of different service types into service indexes, and dynamically setting data filtering conditions and summarizing modes of the service indexes, corresponding summarized data and the like to obtain the summary result of the service indexes. Through zero code, self-service, quick definition and report form generation, the ease of use and adaptability of report forms are promoted.
The above embodiment, optionally, further includes:
and after receiving a business instruction detail display instruction input by a user, acquiring an index parameter of a business index, and adding the index parameter into a report according to a data column form. The index parameters comprise data filtering conditions corresponding to the service indexes and/or data summarizing modes.
The index parameter corresponds to the detail data. Specifically, the specific form of adding the index parameter to the report according to the form of the data column may be that the service index is displayed as a parent node of the detail data, and the detail data is displayed as a child node in a longitudinal arrangement manner.
Referring to fig. 5, a schematic structural diagram of an apparatus 500 for generating a detail summary report based on a divide-and-conquer algorithm according to an embodiment of the present application is shown, including:
the first display unit 501 is configured to display a first interface in response to a report generation instruction input by a user, where the first interface includes a preset report template; the report template comprises an index display area and a data display area; the index display area comprises a plurality of service indexes obtained by dividing based on a divide-and-conquer algorithm, and the service indexes are set according to service types; the data display area comprises a plurality of data columns;
a loading unit 502, configured to respond to a data display instruction input by a user on the first interface, and load a preset report data source to the first interface; the report data source comprises attribute information and index information; the attribute information is information of a report summarizing object, and the index information is data associated with the attribute information;
an adding unit 503, configured to add the attribute information selected by the user to a first data column of the data display area, and add the index information selected by the user to a second data column of the data display area; the first data column and the second data column are the data columns of the data display area;
a second display unit 504, configured to display a preset first window in response to an index parameter setting instruction for the service index, which is input by a user based on the service index in the first interface; the first window comprises a data filtering factor display area and a data summarizing mode display area;
a first generating unit 505, configured to generate a data filtering condition of the service indicator according to the data filtering factor selected by the user in the data filtering factor display area; generating a data summarizing mode corresponding to the service index according to the summarizing mode selected by the user in the data summarizing mode display area;
a second generating unit 506, configured to, in response to a data summarizing instruction input by a user, summarize the index information of the second data column that meets the data filtering condition according to the summarization manner, and generate a summarization result corresponding to the attribute information under the service index;
a third generating unit 507, configured to use the report template in which the data display area includes the attribute information, the index information, and the summary result as a generated detailed summary report.
In the foregoing apparatus, optionally, a specific implementation manner of the adding unit 503 for adding the attribute information selected by the user to the first data column of the data display area is as follows:
responding to the attribute information selected by a user based on a trigger object, tracking the trigger object under the condition that the trigger object moves on the first interface, determining a data column corresponding to a final movement stop point of the trigger object, and adding the attribute information to the data column;
the adding unit is configured to add the index information selected by the user to a second data column of the data display area, and includes the adding unit specifically configured to:
and responding to the index information selected by a user based on a trigger object, tracking the trigger object under the condition that the index information moves on the first interface, determining a data column corresponding to a final movement stop point of the trigger object, and adding the index information to the data column.
Optionally, in the apparatus described above, the second generating unit 506 is configured to, in response to a data summarizing instruction input by a user, summarize the index information of the second data column that meets the data filtering condition according to the summarizing manner, and a specific implementation manner of generating a summarizing result corresponding to the attribute information under the service index is as follows:
responding to a report issuing instruction input by a user, taking a report template comprising attribute information, index information, service indexes selected by the user and data filtering conditions and data summarizing modes corresponding to the service indexes as a first report, and converting the current report design state of the first report into a report running state;
storing the data content included in the first report, and distributing an ID code for the first report;
and responding to a data summarizing instruction input by a user, calling a preset report analysis engine, and summarizing the index information of the second data column meeting the data filtering condition by the report analysis engine according to the summarizing mode in the first report to obtain a summarizing result.
The above apparatus, optionally, the second display unit 504 is further configured to:
after receiving a business instruction detail display instruction input by a user, acquiring an index parameter of the business index, and adding the index parameter into the report according to a data column form; the index parameters comprise data filtering conditions corresponding to the service indexes and/or data summarizing modes.
Optionally, in the apparatus described above, a specific implementation manner of the first generating unit 505 for obtaining the data filtering condition of the service indicator according to the data filtering factor selected by the user in the data filtering factor displaying area is as follows:
and combining the data filtering factors selected by the user in the data filtering factor display area to obtain the data filtering condition.
The device provided by the embodiment is used for responding to a report generation instruction input by a user and displaying a first interface, wherein the first interface comprises a preset report template, and the report template comprises an index display area and a data display area; the index display area comprises a plurality of service indexes. And according to a data display instruction input by a user, displaying and loading a preset report data source to the first interface, wherein the user can select attribute information and index information based on the report data source. That is, in the present scheme, the attribute information and the index information may be dynamically selectable.
Furthermore, the index display area comprises a plurality of service indexes which are set according to service types, and displays a preset first window in response to an index parameter setting instruction which is input by a user service index and aims at the service indexes, the first window comprises a data filtering factor display area and a data summarizing mode display area, the data filtering factor selected by the user in the data filtering factor display area is used as a data filtering condition of the service indexes, and the summarizing mode selected by the user in the data summarizing mode display area is used as a data summarizing mode corresponding to the service indexes. Because the service index is set according to the service type, the user can select the corresponding service index according to different service types. And moreover, the data filtering condition and the data summarizing mode of the service index can be flexibly set for a service index user. That is to say, in the scheme, the service index, the data filtering condition of the service index and the data summarizing mode are dynamically selectable.
And finally, in response to a data summarizing instruction input by a user, summarizing the index information of the second data column meeting the data filtering condition according to a summarizing mode, and generating a summarizing result corresponding to the attribute information under the service index, so as to obtain a report.
In conclusion, the report template provided by the scheme has high flexibility, and for different service types and different data processing conditions and modes, a user can select the corresponding report based on requirements without re-formulating or modifying the template, so that the generation efficiency of the report can be improved, the operation is simple and convenient, and the requirement of the user on the specialty can be reduced.
The functions described in the method of the embodiment of the present application, if implemented in the form of software functional units and sold or used as independent products, may be stored in a storage medium readable by a computing device. Based on such understanding, part of the contribution to the prior art of the embodiments of the present application or part of the technical solution may be embodied in the form of a software product stored in a storage medium and including several instructions for causing a computing device (which may be a personal computer, a server, a mobile computing device or a network device) to execute all or part of the steps of the method described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
It should be noted that, in the present specification, the embodiments are all described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments may be referred to each other. For the device-like embodiment, since it is basically similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (10)

1. A detail summary report generation method based on a divide-and-conquer algorithm is characterized by comprising the following steps:
responding to a report generation instruction input by a user, and displaying a first interface, wherein the first interface comprises a preset report template; the report template comprises an index display area and a data display area; the index display area comprises a plurality of service indexes obtained by dividing based on a divide-and-conquer algorithm, and the service indexes are set according to service types; the data display area comprises a plurality of data columns;
responding to a data display instruction input by a user on the first interface, and loading a preset report data source to the first interface; the report data source comprises attribute information and index information; the attribute information is information of a report summarizing object, and the index information is data associated with the attribute information;
adding the attribute information selected by the user to a first data column of the data display area, and adding the index information selected by the user to a second data column of the data display area; the first data column and the second data column are the data columns of the data display area;
responding to an index parameter setting instruction which is input by a user based on the service index in the first interface and aims at the service index, and displaying a preset first window; the first window comprises a data filtering factor display area and a data summarizing mode display area;
generating a data filtering condition of the service index according to the data filtering factor selected by the user in the data filtering factor display area; generating a data summarizing mode corresponding to the service index according to the summarizing mode selected by the user in the data summarizing mode display area;
summarizing the index information of the second data column meeting the data filtering condition according to a summarizing mode in response to a data summarizing instruction input by a user, and generating a summarizing result corresponding to the attribute information under the service index;
and taking the report template of the data display area, including the attribute information, the index information and the summary result, as the generated detailed summary report.
2. The method of claim 1, wherein the adding the attribute information selected by the user to the first data column of the data presentation area comprises:
in response to the fact that a user detects that the trigger object moves on the first interface based on the attribute information selected by the trigger object, track-tracking the trigger object, determining a data column corresponding to a final movement stop point of the trigger object, and adding the attribute information to the data column;
the adding the index information selected by the user to the second data column of the data display area comprises:
and in response to the fact that the index information is selected by a user based on a trigger object, under the condition that the trigger object is detected to move on the first interface, track tracking is carried out on the trigger object, a data column corresponding to a final movement stopping point of the trigger object is determined, and the index information is added to the data column.
3. The method according to claim 1, wherein the aggregating the index information of the second data column that satisfies the data filtering condition in the aggregating manner in response to a data aggregating instruction input by a user to generate an aggregated result corresponding to the attribute information under the service index includes:
responding to a report issuing instruction input by a user, taking a report template comprising attribute information, index information, service indexes selected by the user and data filtering conditions and data summarizing modes corresponding to the service indexes as a first report, and converting the current report design state of the first report into a report running state;
storing the data content included in the first report, and distributing an ID code for the first report;
and responding to a data summarizing instruction input by a user, calling a preset report analysis engine, and summarizing the index information of the second data column meeting the data filtering condition by the report analysis engine according to the summarizing mode in the first report to obtain a summarizing result.
4. The method of claim 1, further comprising:
after receiving a business instruction detail display instruction input by a user, acquiring an index parameter of the business index, and adding the index parameter into the report according to a data column form; the index parameters comprise data filtering conditions corresponding to the service indexes and/or data summarizing modes.
5. The method according to claim 1, wherein the generating the data filtering condition of the service indicator according to the data filtering factor selected by the user in the data filtering factor presenting area comprises:
and combining the data filtering factors selected by the user in the data filtering factor display area to obtain the data filtering condition.
6. A device for generating a detail summary report based on a divide-and-conquer algorithm is characterized by comprising the following components:
the first display unit is used for responding to a report generation instruction input by a user and displaying a first interface, and the first interface comprises a preset report template; the report template comprises an index display area and a data display area; the index display area comprises a plurality of service indexes obtained by dividing based on a divide-and-conquer algorithm, and the service indexes are set according to service types; the data display area comprises a plurality of data columns;
the loading unit is used for responding to a data display instruction input by a user on the first interface and loading a preset report data source to the first interface; the report data source comprises attribute information and index information; the attribute information is information of a report summarizing object, and the index information is data associated with the attribute information;
the adding unit is used for adding the attribute information selected by the user to a first data column of the data display area and adding the index information selected by the user to a second data column of the data display area; the first data column and the second data column are the data columns of the data display area;
the second display unit is used for responding to an index parameter setting instruction which is input by a user based on the service index in the first interface and aims at the service index, and displaying a preset first window; the first window comprises a data filtering factor display area and a data summarizing mode display area;
the first generating unit is used for generating the data filtering condition of the service index according to the data filtering factor selected by the user in the data filtering factor display area; generating a data summarizing mode corresponding to the service index according to the summarizing mode selected by the user in the data summarizing mode display area;
the second generating unit is used for responding to a data summarizing instruction input by a user, summarizing the index information of the second data column meeting the data filtering condition according to the summarizing mode, and generating a summarizing result corresponding to the attribute information under the service index;
and the third generating unit is used for taking the report template of the data display area, which comprises the attribute information, the index information and the summary result, as a generated detailed summary report.
7. The apparatus according to claim 6, wherein the adding unit is configured to add the attribute information selected by the user to a first data column of the data presentation area, and includes the adding unit specifically configured to:
responding to the attribute information selected by a user based on a trigger object, tracking the trigger object under the condition that the trigger object moves on the first interface, determining a data column corresponding to a final movement stop point of the trigger object, and adding the attribute information to the data column;
the adding unit is configured to add the index information selected by the user to a second data column of the data display area, and includes the adding unit specifically configured to:
and responding to the index information selected by a user based on a trigger object, tracking the trigger object under the condition that the index information moves on the first interface, determining a data column corresponding to a final movement stop point of the trigger object, and adding the index information to the data column.
8. The apparatus according to claim 6, wherein the second generating unit is configured to, in response to a data summarization instruction input by a user, summarize the index information of the second data column that meets the data filtering condition in the summarization manner, and generate a summarized result corresponding to the attribute information under the service index, and the second generating unit is specifically configured to:
responding to a report issuing instruction input by a user, taking a report template comprising attribute information, index information, service indexes selected by the user and data filtering conditions and data summarizing modes corresponding to the service indexes as a first report, and converting the current report design state of the first report into a report running state;
storing the data content included in the first report, and distributing an ID code for the first report;
and responding to a data summarizing instruction input by a user, calling a preset report analysis engine, and summarizing the index information of the second data column meeting the data filtering condition by the report analysis engine according to the summarizing mode in the first report to obtain a summarizing result.
9. The apparatus of claim 6, wherein the second display unit is further configured to:
after receiving a business instruction detail display instruction input by a user, acquiring an index parameter of the business index, and adding the index parameter into the report according to a data column form; the index parameters comprise data filtering conditions corresponding to the service indexes and/or data summarizing modes.
10. The apparatus according to claim 6, wherein the first generating unit is configured to obtain the data filtering condition of the service indicator according to the data filtering factor selected by the user in the data filtering factor presenting area, and includes the first generating unit specifically configured to:
and combining the data filtering factors selected by the user in the data filtering factor display area to obtain the data filtering condition.
CN202110499169.6A 2021-05-08 2021-05-08 Method and device for generating detailed summary report based on divide-and-conquer algorithm Active CN113095054B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110499169.6A CN113095054B (en) 2021-05-08 2021-05-08 Method and device for generating detailed summary report based on divide-and-conquer algorithm

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110499169.6A CN113095054B (en) 2021-05-08 2021-05-08 Method and device for generating detailed summary report based on divide-and-conquer algorithm

Publications (2)

Publication Number Publication Date
CN113095054A true CN113095054A (en) 2021-07-09
CN113095054B CN113095054B (en) 2023-11-10

Family

ID=76664274

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110499169.6A Active CN113095054B (en) 2021-05-08 2021-05-08 Method and device for generating detailed summary report based on divide-and-conquer algorithm

Country Status (1)

Country Link
CN (1) CN113095054B (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1549182A (en) * 2003-05-15 2004-11-24 季永萍 Arrangement for realizing new technique
US20130085798A1 (en) * 2011-09-30 2013-04-04 Varian Medical Systems, Inc. Systems and methods for implementing medical workflow
CN103631969A (en) * 2013-12-20 2014-03-12 北京中电普华信息技术有限公司 Generation method and device of report data
CN103678401A (en) * 2012-09-21 2014-03-26 金蝶软件（中国）有限公司 Metadata based report group summarizing method and device

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1549182A (en) * 2003-05-15 2004-11-24 季永萍 Arrangement for realizing new technique
US20130085798A1 (en) * 2011-09-30 2013-04-04 Varian Medical Systems, Inc. Systems and methods for implementing medical workflow
CN103678401A (en) * 2012-09-21 2014-03-26 金蝶软件（中国）有限公司 Metadata based report group summarizing method and device
CN103631969A (en) * 2013-12-20 2014-03-12 北京中电普华信息技术有限公司 Generation method and device of report data

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
彭敏;官宸宇;朱佳晖;谢倩倩;黄佳佳;黄济民;杨绍雄;高望;应称;: "面向社交媒体文本的话题检测与追踪技术研究综述", 武汉大学学报(理学版) *

Also Published As

Publication number Publication date
CN113095054B (en) 2023-11-10

Similar Documents

Publication Publication Date Title
KR102537275B1 (en) Obfuscation of user content in structured user data files
US20140173501A1 (en) Device, Method and User Interface for Presenting Analytic Data
US10666593B2 (en) Systems and methods for messaging and collaboration
US20170192872A1 (en) Interactive detection of system anomalies
CN111125560B (en) Data visualization processing method, device and computer system
WO2014089460A2 (en) Device, method and user interface for presenting analytic data
KR20140074920A (en) Automatic relationship detection for reporting on spreadsheet data
US11496584B2 (en) Extraction and distribution of content packages in a digital services framework
US20130151547A1 (en) Method and system for generating document recommendations
US9015591B2 (en) Dynamic visualization generation and implementation
CN110806866A (en) Generation method and device of front-end management system
CN104424299A (en) Data statistical method and device
EP2307993A2 (en) System and method for visualizing a marketing strategy
US20200334298A1 (en) Managing information about document-related activities
CN113095054A (en) Method and device for generating detailed summary report based on divide-and-conquer algorithm
CN112379861A (en) Item manager and working method thereof
US20110231360A1 (en) Persistent flow method to define transformation of metrics packages into a data store suitable for analysis by visualization
KR102403276B1 (en) Method, system and non-transitory computer-readable recording medium for providing information related to advertising campaign
KR102436586B1 (en) Method, system and non-transitory computer-readable recording medium for assisting collaboration related to advertising campaign
EP3807780A1 (en) Binding query scope to directory attributes
US9785404B2 (en) Method and system for analyzing data in artifacts and creating a modifiable data network
CN115659045A (en) User operation identification method and device, storage medium and electronic equipment
CN111159435B (en) Multimedia resource processing method, system, terminal and computer readable storage medium
US11394626B2 (en) Digital services framework
CN107844563A (en) The creation method and device in a kind of electric business enterprise storehouse

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant