Method and system for quickly generating report of custom template object and medium
Through custom template objects and support vector machine algorithms, rapid generation and data analysis of reports in the power system are realized, and the problem of low data collection efficiency in the existing technology is solved, and data processing efficiency and system friendliness are improved.
Patent Information
- Application Number
- CN202411084523.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-08
- Publication Date
- 2024-12-06
AI Technical Summary
The existing technology cannot quickly generate professional reports for data analysis, resulting in low efficiency in power grid regulation data processing and cannot meet the data collection and real-time data analysis needs of power system automation systems.
Through the rapid report generation method of custom template objects, the support vector machine algorithm is used to identify user behavior intentions and label data, realize multi-dimensional and multi-cycle data collection calculation, and generate business forms that meet user needs.
It realizes the rapid construction and data collection of report template objects, reduces the data collection time and report development cycle, and improves the system's friendly interactivity and rapid online capabilities.
Smart Images

Figure CN119089883A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of power system control, and in particular to a method, system and medium for quickly generating a report of a user-defined template object. Background Art
[0002] With the acceleration of the construction of new power systems, various business offices are facing the current situation of new elements access and the gradual expansion of the power grid scale. The power grid control data analysis and decision-making need to rely on more and more data. The current power system automation support research and development process is relatively slow, and the data has not yet been truly realized in the automation system. "Source maintenance, global sharing". At present, there is no mature solution and system to timely support the rapid data acquisition and real-time data analysis of various professions and businesses. When collecting basic data for various business scenarios, it is impossible to develop professional reports for data analysis and calculation in real time. Summary of the invention
[0003] Purpose of the invention: The present invention aims to provide a method for quickly generating reports by quickly constructing a custom template object for a business report to realize the rapid collection of basic data on the source side. Another purpose of the present invention is to provide a system, device and medium for quickly generating reports with a custom template object.
[0004] Technical solution: The method for quickly generating a report of a custom template object of the present invention comprises the following steps:
[0005] Automatically generate report template objects through offline import or online editing;
[0006] Use the support vector machine algorithm to identify the user's behavior intention, and use the key-value pair label set to represent the identification result concretely;
[0007] Gather basic data from multiple users;
[0008] Based on the concrete representation results, multi-dimensional and multi-period aggregation calculations are performed on multi-user basic data;
[0009] Generate one-time and periodic business forms to meet user needs.
[0010] Furthermore, report template objects are automatically generated through offline import or online editing, as follows:
[0011] Generate report template objects online by importing offline Excel files or editing the report header information, report cycle, reporting personnel and reporting validity period information by yourself.
[0012] Furthermore, the user behavior intention is identified based on the support vector machine algorithm, and the identification results are concretely represented by a label set of key-value pairs, as follows:
[0013] The support vector machine algorithm is used to analyze the reporting type, data source unit, data-related majors, data reporting person, data statistical cycle, data statistical logic and data verification logic information of the report header, and the<key,value> Form identifier, generate {<key1,value1> ,<key2,value2> ,<key3,value3> ...} tag combination.
[0014] Furthermore, the basic data of multiple users is collected, as follows:
[0015] Based on the report template object, the reporting task is issued to the reporter and basic data is reported.
[0016] Furthermore, based on the concrete representation results, the multi-dimensional and multi-period aggregation calculation of the basic data of multiple users is performed, as follows:
[0017] According to the combination of labels, the aggregated data is automatically calculated in the form of stacking, reorganization and statistics.
[0018] Furthermore, the one-time and periodic business forms that meet the needs of users are generated, that is, according to the periodic requirements of filling in data reports, filling tasks are automatically generated and business forms are generated based on data calculation results.
[0019] The system of the method for quickly generating a report based on the above-mentioned custom template object of the present invention comprises:
[0020] A report template object generation module is used to generate report template objects by offline template import or online editing;
[0021] The data collection module is used to send the report template objects to the corresponding reporting personnel and fill in the basic data;
[0022] The intent recognition module is used to recognize intent based on report template objects, historical forms and basic data collection content, and to visualize the recognition results using a tag set of key-value pairs;
[0023] The data automatic calculation module is used to calculate the basic data according to the intention recognition results;
[0024] The report generation module is used to visualize the calculation results based on the custom report components. It also automatically generates reporting tasks according to the periodic requirements of data reporting and generates the final business report in Excel format.
[0025] Furthermore, the intention recognition uses the support vector machine algorithm to analyze the reporting type, data source unit, data-related majors, data fillers, data statistical cycle, data statistical logic and data verification logic information of the report header, and adopts<key,value> Form identifier, generate {<key1,value1> ,<key2,value2> ,<key3,value3> ...} tag combination.
[0026] The computer device of the present invention comprises a memory, a processor and a computer program stored in the memory and executable on the processor, and is characterized in that the processor implements the steps of the above method when executing the computer program.
[0027] The computer-readable storage medium of the present invention stores a computer program thereon, and the computer program implements the steps of the above method when executed by a processor.
[0028] Beneficial effects: Compared with the prior art, the present invention has the following significant advantages: the present invention realizes rapid construction of business report template objects through offline import or online editing of report template objects, and at the same time, assists with strategies such as reporting time limit to realize rapid collection of basic data on the source side, thereby reducing data collection time; the present invention reduces the research and development work of basic data calculation for various scenarios through intent recognition, reduces the operating steps of report managers, improves the system's friendly interaction level for report managers, and further supports the rapid launch of various professional business applications; the present invention is based on report template objects, which can realize rapid collection of basic data for reports in various scenarios; business reports are quickly generated based on automated combined calculations, thereby reducing the report development cycle. BRIEF DESCRIPTION OF THE DRAWINGS
[0029] Figure 1 It is a structural schematic diagram of the system of the present invention;
[0030] Figure 2 Flow chart of the method of the present invention. DETAILED DESCRIPTION
[0031] The present invention will be further described below in conjunction with the accompanying drawings.
[0032] The method for quickly generating a report of a custom template object of the present invention comprises the following steps:
[0033] Automatically generate report template objects through offline import or online editing; import offline Excel files or generate report template objects online by editing the report header information, report cycle, reporting personnel and reporting validity period information by yourself.
[0034] Use the support vector machine algorithm to identify the user's behavior intention, and use the key-value pair label set to represent the identification result; use the support vector machine algorithm to analyze the report header filling type, data source unit, data involved major, data filler, data statistical cycle, data statistical logic and data verification logic information, and use<key,value> Form identifier, generate {<key1,value1> ,<key2,value2> ,<key3,value3> ...} tag combination.
[0035] Gather basic data from multiple users; issue reporting tasks to the reporter based on the report template object and report basic data.
[0036] Based on the concrete representation results, multi-dimensional and multi-period aggregation calculations are performed on multi-user basic data; according to the label combination, the aggregated data is automatically calculated in the form of stacking, reorganization, and statistics.
[0037] Generate one-time and periodic business forms that meet user needs, that is, according to the periodic requirements of data report filling, automatically generate filling tasks and generate business forms based on data calculation results.
[0038] like Figure 1 As shown, an embodiment of the present invention provides a report rapid generation system for a custom template object, including:
[0039] The report template object generation module is used to generate report template objects through offline template import or online editing. Among them, offline template import realizes template parsing and report template object generation by parsing offline Excel files; report template objects are generated through online editing, and the bottom layer relies on self-developed report components to generate online template editors, which supports various professionals to perform Excel-like editing operations to generate report template objects. This module is connected to the data collection module and the intention recognition module.
[0040] The data collection module is used to send the report template objects to the corresponding reporting personnel and fill in the basic data; by clicking on all the personnel in the organization, the personnel information that needs to be reported is obtained, and after confirming the reporting time limit, the report template objects are sent to each person in charge for basic data reporting; this module is connected to the report template object generation module and the data automatic calculation module.
[0041] The intent recognition module is used to recognize intent based on report template objects, historical forms and basic data collection content, and to visualize the recognition results using a tag set of key-value pairs. First, the new template and basic data collection content are analyzed, and the report header information such as the reporting type, data source unit, data-related majors, data fillers, data statistical cycles, data statistical logic and data verification logic are analyzed through the support vector machine algorithm, and this type of information is respectively used<key,value> Form identification, generate basic label set form such as {<report type, value>, <data source unit, {Nanjing, Wuxi, Suzhou, Hangzhou}>, <data involves major, Water Conservancy Department>, <data filler, {Zhang San, Li Si, Wang Wu, Zhao Liu}>}; then analyze the similarity between the historical form label set and the new template label set. If the new template is very similar to the historical template, extract the data statistical cycle, data statistical logic, data verification logic and other strategies of the historical template, and finally generate a label combination such as {<report type, value>, <data source unit, {Nanjing, Wuxi, Suzhou, Hangzhou}>, <data involves major, Water Conservancy Department>, <data filler, {Zhang San, Li Si, Wang Wu, Zhao Liu}>, <data statistical cycle, monthly>, <data statistical logic, statistics>, <data verification logic, value over-limit judgment>}. This module is connected to the report template object generation module and the data automatic calculation module.
[0042] The data automatic calculation module is used to calculate the basic data according to the intention recognition results. This process is based on the intention recognition tag set, and performs logical operations such as stacking, reorganization and statistics on the contents of each cell of the basic data to realize the automatic calculation of the basic data based on the report template object. This module is connected to the data collection module and the intention recognition module.
[0043] The report generation module is used to visualize the calculation results based on the custom report component, automatically generate reporting tasks according to the periodic requirements of data report filling, and generate the final version of the business report in Excel format. This module is connected to the data automatic calculation module.
[0044] The computer device of the present invention comprises a memory, a processor and a computer program stored in the memory and executable on the processor, and is characterized in that the processor implements the steps of the above method when executing the computer program.
[0045] The computer-readable storage medium of the present invention stores a computer program thereon, and the computer program implements the steps of the above method when executed by a processor.
[0046] Those skilled in the art will appreciate that the embodiments of the present application can be provided as methods, systems, or computer program products. Therefore, the present application can adopt the form of complete hardware embodiments, complete software embodiments, or embodiments in combination with software and hardware. Moreover, the present application can adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code. The scheme in the embodiments of the present application can be implemented in various computer languages, for example, object-oriented programming language Java and literal scripting language JavaScript, etc.
[0047] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0048] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.
[0049] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.
Claims
1. A method for quickly generating a report of a custom template object, characterized in that: The following steps are involved: Automatically generate report template objects through offline import or online editing; Use the support vector machine algorithm to identify the user's behavior intention, and use the key-value pair label set to represent the identification result concretely; Gather basic data from multiple users; Based on the concrete representation results, multi-dimensional and multi-period aggregation calculations are performed on multi-user basic data; Generate one-time and periodic business forms to meet user needs.
2. The method for quickly generating a report based on a custom template object according to claim 1, characterized in that: Automatically generate report template objects through offline import or online editing, as follows: Generate report template objects online by importing offline Excel files or editing the report header information, report cycle, reporting personnel and reporting validity period information by yourself.
3. The method for quickly generating a report based on a custom template object according to claim 1, characterized in that: Based on the support vector machine algorithm, the user behavior intention is recognized, and the recognition results are concretely represented by a label set of key-value pairs, as follows: The support vector machine algorithm is used to analyze the reporting type, data source unit, data-related majors, data reporting personnel, data statistical cycle, data statistical logic and data verification logic information of the report header, and the<key,value> Form identifier, generate {<key1,value1> ,<key2,value2> ,<key3,value3> ...} tag combination.
4. The method for quickly generating a report based on a custom template object according to claim 1, characterized in that: Gather multiple user basic data, as follows: Based on the report template object, the reporting task is issued to the reporter and basic data is reported.
5. The method for quickly generating a report based on a custom template object according to claim 1, characterized in that: Based on the concrete representation results, the multi-dimensional and multi-period aggregation calculation of multi-user basic data is performed as follows: According to the combination of labels, the aggregated data is automatically calculated in the form of stacking, reorganization and statistics.
6. The method for quickly generating a report of a custom template object according to claim 1, characterized in that: The one-time and periodic business forms that meet the needs of users are generated, that is, according to the periodic requirements of filling in data reports, filling tasks are automatically generated and business forms are generated based on data calculation results.
7. A system for quickly generating a report according to the method for quickly generating a report of a custom template object according to any one of claims 1 to 6, characterized in that: include: A report template object generation module is used to generate report template objects by offline template import or online editing; The data collection module is used to send the report template objects to the corresponding reporting personnel and fill in the basic data; The intent recognition module is used to recognize intent based on report template objects, historical forms and basic data collection content, and to visualize the recognition results using a tag set of key-value pairs; The data automatic calculation module is used to calculate the basic data according to the intention recognition results; The report generation module is used to visualize the calculation results based on the custom report components, automatically generate reporting tasks according to the periodic requirements of data reporting, and generate the final version of the business report in Excel format.
8. The system according to claim 7, characterized in that: Intent recognition uses the support vector machine algorithm to analyze the reporting type, data source unit, data-related majors, data fillers, data statistical cycle, data statistical logic and data verification logic information of the report header, and adopts<key,value> Form identifier, generate {<key1,value1> ,<key2,value2> ,<key3,value3> ...} tag combination.
9. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.
10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.
