A method and system for generating irregular reports

By using a business language to organize the construction of data sources and display interfaces in irregular report generation, ordinary users can generate irregular reports by self-service, solving the problem of high operation difficulty in the existing technology, and improving the ease of use and generalization of reports Adaptability.

CN113157707BActive Publication Date: 2024-11-05STATE GRID INFORMATION & TELECOMM GRP CO LTD +1
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202110551012.3
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-05-20
Publication Date
2024-11-05
Estimated Expiration
2041-05-20

AI Technical Summary

Technical Problem

Existing report generation software is difficult to operate directly by ordinary users, resulting in low ease of use and universality of irregular reports, and cannot meet the self-service generation needs of business needs.

Method used

The report type is determined based on the layout structure and header fields of irregular reports, and the business language is used to organize the construction of business data sources and display interfaces to visually build the correspondence between the business data set and the report, and generate irregular reports based on the report type.

Benefits of technology

It reduces the difficulty of operation of irregular report generation, enables ordinary business users to generate irregular reports by themselves, improves their ease of use and universality, improves user experience and meets the needs of dynamic business changes.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN113157707B_ABST
    Figure CN113157707B_ABST
Patent Text Reader

Abstract

The present invention discloses a method and system for generating irregular reports, determining irregular report types based on known layout structures and header fields of irregular reports, determining various business data sources of irregular reports based on irregular report types, constructing business data sets of irregular reports based on various business data sources, visually constructing a correspondence between business data sets and irregular reports on an irregular report display interface corresponding to the irregular report type, and visually setting irregular report parameter information and generating irregular reports according to the irregular report type after the correspondence is constructed. The present invention adopts a business language to organize and construct business data sources and irregular report display interfaces, and by constructing a correspondence between business data sets corresponding to business data sources and irregular reports on the irregular report display interface, the operational difficulty of generating irregular reports is reduced, so that ordinary business users can also generate irregular reports, and the irregular reports are easy to use and universal.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of report generation, and more particularly to a method and system for generating irregular reports. Background Art

[0002] As a way of organizing and outputting business operating data, reports play an important role in the enterprise information platform. Reports are not only one of the effective means of sorting and analyzing data, but also an important source of data collection for departments at all levels and an important basis for enterprise leaders' decision-making.

[0003] Conventional reports used to present data are all "horizontally flat and vertically straight", that is, two-dimensional tables. Such reports can be collectively referred to as conventional reports, while special layout reports that are different from "horizontally flat and vertically straight" are collectively referred to as irregular reports. Existing report generation software products are mainly aimed at conventional reports. Irregular reports can only be customized, developed, upgraded, and launched by professionals, and can only be operated by professionals. Ordinary business users cannot directly operate them. Therefore, the usability and universality of existing irregular reports are low. Summary of the invention

[0004] In view of this, the present invention discloses a method and system for generating irregular reports, so as to reduce the operational difficulty when generating irregular reports, so that ordinary business users can also generate irregular reports by themselves according to business needs, thereby greatly improving the usability and universality of irregular reports and enhancing user experience.

[0005] A method for generating an irregular report, comprising:

[0006] Determine the irregular report type based on the known layout structure and header fields of the irregular report;

[0007] Determine each business data source of the irregular report based on the irregular report type, each of the business data sources is organized and constructed using a business language;

[0008] Constructing a business data set of the irregular report based on each of the business data sources, the business data set comprising: a plurality of metadata information and business data corresponding to each metadata information;

[0009] On an irregular report display interface corresponding to the irregular report type, a corresponding relationship between the business data set and the irregular report is visually constructed, and the irregular report display interface is organized and constructed using a business language;

[0010] After the corresponding relationship is constructed, irregular report parameter information is visually set according to the irregular report type to generate the irregular report.

[0011] Optionally, constructing the business data set of the irregular report based on each of the business data sources specifically includes:

[0012] According to the data source type corresponding to each of the business data sources, a corresponding connection relationship between the report system and each of the business data sources is established;

[0013] Based on the connection relationship, obtain a business database object set corresponding to the irregular report from the business database;

[0014] Visually constructing the association relationship between each business database object in the business database object set;

[0015] The business data set of the irregular report is generated based on the association relationship.

[0016] Optionally, visually constructing a correspondence between the business data set and the irregular report on an irregular report display interface corresponding to the irregular report type specifically includes:

[0017] Drag metadata information selected from the business data set as target metadata information to a target cell of the irregular report display interface to establish a display relationship between each of the business data sources and the irregular report;

[0018] releasing the dragged target metadata information from the target cell;

[0019] Presenting target business data according to the layout structure of the irregular report, wherein the target business data is business data corresponding to the target metadata information in the business database;

[0020] The binding relationship between the target metadata information and the target cell is saved.

[0021] Optionally, after generating the irregular report, the method further includes:

[0022] Publish said irregular report.

[0023] Optionally, after publishing the irregular report, the following is further included:

[0024] Run the irregular report.

[0025] A system for generating irregular reports, comprising:

[0026] A report type determination unit, used for determining the type of the irregular report based on the known layout structure and header fields of the irregular report;

[0027] A data source determination unit, configured to determine each business data source of the irregular report based on the irregular report type, each of the business data sources being organized and constructed in a business language;

[0028] A data set construction unit, used to construct a business data set of the irregular report based on each of the business data sources, the business data set comprising: a plurality of metadata information and business data corresponding to each metadata information;

[0029] A corresponding relationship building unit, used for visually building a corresponding relationship between the business data set and the irregular report on an irregular report display interface corresponding to the irregular report type, wherein the irregular report display interface is organized and built using a business language;

[0030] A report generation unit is used to visually set irregular report parameter information according to the irregular report type after the corresponding relationship is constructed to generate the irregular report.

[0031] Optionally, the data set construction unit is specifically used for:

[0032] According to the data source type corresponding to each of the business data sources, a corresponding connection relationship between the report system and each of the business data sources is established;

[0033] Based on the connection relationship, obtain a business database object set corresponding to the irregular report from the business database;

[0034] Visually constructing the association relationship between each business database object in the business database object set;

[0035] The business data set of the irregular report is generated based on the association relationship.

[0036] Optionally, the corresponding relationship building unit is specifically used to:

[0037] Drag metadata information selected from the business data set as target metadata information to a target cell of the irregular report display interface to establish a display relationship between each of the business data sources and the irregular report;

[0038] releasing the dragged target metadata information from the target cell;

[0039] Presenting target business data according to the layout structure of the irregular report, wherein the target business data is business data corresponding to the target metadata information in the business database;

[0040] The binding relationship between the target metadata information and the target cell is saved.

[0041] Optionally, also include:

[0042] The report publishing unit is used to publish the irregular report after the report generating unit generates the irregular report.

[0043] Optionally, also include:

[0044] The report running unit is used to run the irregular report after the report publishing unit publishes the irregular report.

[0045] It can be seen from the above technical solutions that the present invention discloses a method and system for generating irregular reports, determining the type of irregular reports based on the known layout structure and header fields of irregular reports, determining each business data source of irregular reports based on the type of irregular reports, organizing and constructing the business data source using a business-oriented language, and constructing a business data set of irregular reports based on each business data source, visually constructing the correspondence between the business data set and the irregular report in the irregular report display interface corresponding to the irregular report type, and after the correspondence is constructed, visually setting the irregular report parameter information according to the irregular report type, and generating an irregular report. The present invention organizes and constructs the business data source and the irregular report display interface using a business-oriented language, and constructs the correspondence between the business data set corresponding to the business data source and the irregular report in the irregular report display interface, thereby greatly reducing the operational difficulty when generating irregular reports, so that ordinary business users can also generate irregular reports by themselves according to business needs, thereby greatly improving the ease of use and universality of irregular reports, and enhancing user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the disclosed drawings without paying creative work.

[0047] Figure 1 A flow chart of a method for generating an irregular report disclosed in an embodiment of the present invention;

[0048] Figure 2 A flowchart of a method for constructing a business data set of an irregular report based on various business data sources disclosed in an embodiment of the present invention;

[0049] Figure 3 A schematic diagram of establishing a relationship in series between business database objects disclosed in an embodiment of the present invention;

[0050] Figure 4A schematic diagram of merging and building association relationships between business database objects disclosed in an embodiment of the present invention;

[0051] Figure 5 A flow chart of a method for constructing a corresponding relationship between a business data set and an irregular report disclosed in an embodiment of the present invention;

[0052] Figure 6 A schematic diagram of an irregular report display interface disclosed in an embodiment of the present invention;

[0053] Figure 7 A schematic diagram of the display effect of data on an irregular report display interface after releasing metadata information disclosed in an embodiment of the present invention;

[0054] Figure 8 A flow chart of another method for generating an irregular report disclosed in an embodiment of the present invention;

[0055] Fig. 9 The present invention is a schematic diagram of the structure of a system for generating irregular reports disclosed in an embodiment of the present invention. DETAILED DESCRIPTION

[0056] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0057] The embodiment of the present invention discloses a method and system for generating irregular reports. The irregular report type is determined based on the known layout structure and header fields of the irregular report. The various business data sources of the irregular report are determined based on the irregular report type. The business data source is organized and constructed using a business language. Based on the various business data sources, a business data set of the irregular report is constructed. In an irregular report display interface corresponding to the irregular report type, a corresponding relationship between the business data set and the irregular report is visually constructed. After the corresponding relationship is constructed, the irregular report parameter information is visually set according to the irregular report type, and the irregular report is generated. The present invention uses a business language to organize and construct a business data source and an irregular report display interface. By constructing a corresponding relationship between a business data set corresponding to the business data source and the irregular report in the irregular report display interface, the operational difficulty of generating irregular reports is greatly reduced, so that ordinary business users can also generate irregular reports by themselves according to business needs, thereby greatly improving the ease of use and universality of irregular reports and improving user experience.

[0058] See also Figure 1, an embodiment of the present invention discloses a flow chart of a method for generating an irregular report, the method comprising:

[0059] Step S101, determining the irregular report type based on the known layout structure and header fields of the irregular report;

[0060] In practical applications, the layout structure and header fields of irregular reports can be determined according to the requirements of irregular reports.

[0061] Among them, different types of irregular reports have different layout structures, and correspondingly, irregular report display interfaces have different layout structures. Therefore, after determining the irregular report type, the irregular report display interface is also determined accordingly.

[0062] The layout structure of an irregular report can include any one or more combinations of single-line report, column report, partition report, master-detail report, segment report and multi-source column report, and can also be irregular report trimming and other types.

[0063] Step S102: determining each business data source of the irregular report based on the irregular report type;

[0064] Each of the business data sources is organized and constructed using a business language.

[0065] In this embodiment, each business data source of the irregular report can be determined according to the header field of the irregular report type, and the business data set of the irregular report can be constructed based on each business data source.

[0066] In practical applications, the business data sources of irregular reports are determined based on the header fields of the irregular report types. Each header field is an indicator or attribute information, such as power generation, unit name, remarks, etc.

[0067] The purpose of determining the business data sources of irregular reports is to determine the correspondence between the header fields of irregular reports and the storage fields of business databases. Business data sources include but are not limited to ORACLE, MYSQL, POSTGRESQL, SQLITE, SAP-HANA, etc.

[0068] Step S103: constructing a business data set of the irregular report based on each of the business data sources;

[0069] It should be noted that each business data source may include multiple metadata information, and therefore, the business data set corresponds to each metadata information of each business data source and the business data corresponding to each metadata information in the business database.

[0070] Step S104: On the irregular report display interface corresponding to the irregular report type, visually construct the corresponding relationship between the business data set and the irregular report;

[0071] Among them, the irregular report display interface is organized and constructed using business language.

[0072] Step S105: After the corresponding relationship is constructed, the irregular report parameter information is visually set according to the irregular report type to generate the irregular report.

[0073] It should be noted that the irregular report parameter information set each time will be automatically saved.

[0074] Among them, irregular report parameters will affect the display details of irregular reports, such as whether to display paging, columns, row numbers, whether to reserve spaces, the starting cell of the report, cell display style, etc. Irregular report parameter information may include: any one or more of generation parameters, update parameters and reset parameters.

[0075] In actual applications, the reporting system can automatically display the irregular report parameter information that needs to be maintained according to the irregular report type, and can display the corresponding information according to the irregular report type. For example, if the irregular report type is: column report, the information displayed in the column report may include: report name, report code, report period (year, month, day), report type (column report), number of report columns, whether spaces are reserved between columns, etc.

[0076] In summary, the present invention discloses a method for generating irregular reports, determining irregular report types based on known layout structures and header fields of irregular reports, determining various business data sources of irregular reports based on irregular report types, organizing and constructing business data sources using business-oriented languages, and constructing business data sets of irregular reports based on various business data sources, visually constructing the correspondence between business data sets and irregular reports on irregular report display interfaces corresponding to irregular report types, visually setting irregular report parameter information according to irregular report types after the correspondence is constructed, and generating irregular reports. The present invention organizes and constructs business data sources and irregular report display interfaces using business-oriented languages, and constructs the correspondence between business data sets and irregular reports corresponding to business data sources on irregular report display interfaces, thereby greatly reducing the operational difficulty of generating irregular reports, allowing ordinary business users to self-generate irregular reports according to business needs, thereby greatly improving the ease of use and universality of irregular reports and enhancing user experience.

[0077] In addition, the ease of use of irregular reports can also meet the needs of dynamic business changes.

[0078] See also Figure 2 , a flowchart of a method for constructing a business data set of an irregular report based on various business data sources disclosed in an embodiment of the present invention, that is, step S103 may specifically include:

[0079] Step S201: establishing a corresponding connection relationship between the report system and each of the business data sources according to the data source type corresponding to each of the business data sources;

[0080] It should be noted that when establishing a connection relationship between a report system and a business data source, different connection relationships are established for different data source types.

[0081] The connection information included in the connection relationship may include: data source type, data source address, database driver URL, port, user and password, and other connection information.

[0082] Step S202: acquiring a business database object set corresponding to the irregular report from a business database based on the connection relationship;

[0083] The business database object set is a collection of multiple business database objects.

[0084] Step S203: visually constructing the association relationship between each business database object in the business database object set;

[0085] This embodiment constructs association relationships between different business database objects, mainly by fusing different business database objects, thereby realizing integration of multiple business database objects. The integration mainly includes: column integration and row integration.

[0086] For an example, see Figure 3 The schematic diagram of the series construction of association relationships between business database objects is shown. Object 1 and Object 2 are both business database objects from the business database object set, and new business database objects are constructed through a series relationship (inner association). OR indicates that multiple inner association relationships are "or" relationships.

[0087] See also Figure 4 The schematic diagram of merging and building an association relationship between business database objects is shown. Object 1 and Object 2 are both business database objects from the business database object set. Object 1 and Object 2 are merged to build a new business database object. The merge content can include: consistent selection information length, consistent name (alias) and consistent field type.

[0088] Step S204: Generate a business data set of the irregular report based on the association relationship.

[0089] The present invention can meet different business demand scenarios by generating business data sets of irregular reports. In practical applications, business data sources can be displayed in a tree structure for users to intuitively drag and drop binding layouts.

[0090] In summary, the present invention adopts Excel-based data operation and presentation methods, which can quickly realize business data binding and presentation positioning, thereby improving business data presentation standards and layout efficiency.

[0091] See also Figure 5 , a flowchart of a method for constructing a corresponding relationship between a business data set and an irregular report disclosed in an embodiment of the present invention, that is, step S104 may specifically include:

[0092] Step S301: Drag metadata information selected from the business data set as target metadata information to a target cell of the irregular report display interface to establish a display relationship between each business data source and the irregular report;

[0093] The present invention independently develops an Excel-like operation interface as an irregular report display interface to facilitate users to quickly and accurately realize the binding between various business data sources and irregular reports, and efficiently improve the generation capability of irregular reports.

[0094] This embodiment establishes a display relationship between each business data source and an irregular report, and realizes dragging and dropping the data structure information corresponding to the business data source into the target cell of the irregular report display interface through a visual drag process, see Figure 6 The schematic diagram of the irregular report display interface shown in the figure, the business data source includes: metadata information 1, metadata information 2, metadata information 3, metadata information 4 and metadata information 5, select a certain information in the business data source on the right, such as metadata information 5, and drag metadata information 5 directly to the cell on the left where it needs to be placed by pressing the left button of the mouse, and release the left button of the mouse. The report system can query the target business data corresponding to metadata information 5 from the business database according to the attributes and indicators contained in the dragged metadata information 5, and can display the target business data, so as to achieve the query effect of what you see is what you get. After dragging information 5 to the cell on the left where it needs to be placed, the report data information can be displayed on the spot according to the irregular report category, style and setting information.

[0095] Step S302: releasing the dragged target metadata information from the target cell;

[0096] Step S303: Display the target business data corresponding to the target metadata information in the business database according to the layout structure of the irregular report;

[0097] After releasing the dragged target metadata information, this embodiment queries the corresponding target business data from the business database based on the target metadata information, and dynamically determines the scope of the acquired target business data based on the layout structure of the irregular report, and displays the target business data. The display effect depends on the irregular report type and the cell display style.

[0098] For example, Figure 7 The schematic diagram of the display effect of releasing metadata information on the irregular report display interface is shown, where ① indicates dragging metadata information to a cell in the display interface. One metadata information data corresponds to one cell in the display interface, which is mainly suitable for single-line reports;

[0099] ②Drag the metadata information to the display interface cell. One metadata information data corresponds to one column of data in the display interface, which is mainly used to display the detailed table data of the master-detail report;

[0100] ③Drag the metadata information to the display interface cell. One metadata information data corresponds to multiple columns of data in the display interface, which is mainly suitable for the multi-column display of column reports;

[0101] ④ Indicates dragging metadata information to the display interface cell. One metadata information data corresponds to one cell in the display interface, and multiple value selections are displayed in a selection box, which is mainly suitable for the display of master table business data in master-slave reports;

[0102] ⑤ Indicates dragging metadata information to the display interface cell. One metadata information data corresponds to one cell in the display interface, and multiple value selections are displayed with radio buttons, which is mainly suitable for the display of master table business data in master-slave reports.

[0103] It should be noted that after releasing the target metadata information, the data displayed in the irregular report display interface can be: single value display, vertical expansion, horizontal expansion and different types of display styles to dynamically meet business display needs.

[0104] This embodiment can realize impromptu interaction with users by presenting target business data, thereby improving user experience.

[0105] Step S304: Save the binding relationship between the target metadata information and the target cell.

[0106] To further optimize the above embodiment, see Figure 8 , a flow chart of a method for generating an irregular report disclosed in another embodiment of the present invention, Figure 1 Based on the embodiment shown, after step S104, the following may also be included:

[0107] Step S105: display the generated irregular report on the irregular report display interface.

[0108] After the irregular report parameter information is set, the generated irregular report can be displayed on the irregular report display interface.

[0109] In actual applications, the set irregular report parameter information can also be saved to provide a data source for subsequent irregular report running and other steps.

[0110] Therefore, before step S105, the following may also be included: saving the irregular report parameter information.

[0111] To further optimize the above embodiment, after step S105, the following may also be included:

[0112] Step S106: Publish the irregular report.

[0113] In order to shield the operability of users and share irregular reports with multiple people at the same time, irregular reports can be published. Before publishing irregular reports, it is necessary to determine the unit information, period information, indicator information and storage information of the report, as well as the sharing object and scope of the irregular report.

[0114] After being published, irregular reports only need to dynamically refresh the report data of the corresponding information based on the unit and period information. The report data is based on the unit and the period, i.e. time, is used as the frequency for data storage. The frequency is generally year, quarter, month, week, etc. The corresponding report data can be selected based on the specific unit and period.

[0115] In order to facilitate the subsequent review of irregular reports, after the irregular reports are published, the relevant information of the irregular reports needs to be stored.

[0116] To further optimize the above embodiment, after step S106, the following may also be included:

[0117] Step S107: Run the irregular report.

[0118] In actual applications, when running irregular reports, the irregular report parsing engine can be called to read the basic information of the irregular report, and dynamically obtain, process, display and store the irregular report data.

[0119] After running an irregular report, storage report data is generated.

[0120] In practical applications, an irregular report component can be constructed to generate irregular reports. The irregular report component can support the user's processing process for business data, can quickly display and analyze business data by self-service, and meet the needs of quickly generating irregular reports. The present invention can create new highlights for the unified application development platform, expand the platform's business scope, enhance the platform's market competitiveness, ensure that the irregular report generation process can be seamlessly integrated into various business systems, speed up the project progress while ensuring the scalability and maintainability of the irregular report component, fundamentally solve the problems of ease of use and adaptability, and provide companies with a safe, unified, and efficient report development system to escort the development process of irregular reports.

[0121] Corresponding to the above method embodiment, the present invention also discloses a system for generating irregular reports.

[0122] See also Figure 8 , a schematic diagram of the structure of a system for generating irregular reports disclosed in an embodiment of the present invention, the system comprising:

[0123] A report type determination unit 401, configured to determine the type of the irregular report based on the known layout structure and header fields of the irregular report;

[0124] In practical applications, the layout structure and header fields of irregular reports can be determined according to the requirements of irregular reports.

[0125] Among them, different types of irregular reports have different layout structures, and correspondingly, irregular report display interfaces have different layout structures. Therefore, after determining the irregular report type, the irregular report display interface is also determined accordingly.

[0126] The layout structure of an irregular report can include any one or more combinations of single-line report, column report, partition report, master-detail report, segment report and multi-source column report, and can also be irregular report trimming and other types.

[0127] A data source determining unit 402 is used to determine each business data source of the irregular report based on the irregular report type, each of the business data sources is organized and constructed using a business language;

[0128] In this embodiment, each business data source of the irregular report can be determined according to the header field of the irregular report type, and the business data set of the irregular report can be constructed based on each business data source.

[0129] In practical applications, the business data sources of irregular reports are determined based on the header fields of the irregular report types. Each header field is an indicator or attribute information, such as power generation, unit name, remarks, etc.

[0130] The purpose of determining the business data sources of irregular reports is to determine the correspondence between the header fields of irregular reports and the storage fields of business databases. Business data sources include but are not limited to ORACLE, MYSQL, POSTGRESQL, SQLITE, SAP-HANA, etc.

[0131] A data set construction unit 403 is used to construct a business data set of the irregular report based on each of the business data sources, wherein the business data set includes: a plurality of metadata information and business data corresponding to each metadata information;

[0132] A corresponding relationship building unit 404 is used to visually build a corresponding relationship between the business data set and the irregular report on an irregular report display interface corresponding to the irregular report type, wherein the irregular report display interface is organized and built using a business language;

[0133] The report generating unit 405 is used to visually set irregular report parameter information according to the irregular report type to generate the irregular report after the corresponding relationship is constructed.

[0134] It should be noted that the irregular report parameter information set each time will be automatically saved.

[0135] Among them, irregular report parameters will affect the display details of irregular reports, such as whether to display paging, columns, row numbers, whether to reserve spaces, the starting cell of the report, cell display style, etc. Irregular report parameter information may include: any one or more of generation parameters, update parameters and reset parameters.

[0136] In actual applications, the reporting system can automatically display the irregular report parameter information that needs to be maintained according to the irregular report type, and can display the corresponding information according to the irregular report type. For example, if the irregular report type is: column report, the information displayed in the column report may include: report name, report code, report period (year, month, day), report type (column report), number of report columns, whether spaces are reserved between columns, etc.

[0137] In summary, the present invention discloses a system for generating irregular reports, which determines the type of irregular reports based on the known layout structure and header fields of irregular reports, determines each business data source of the irregular reports based on the type of irregular reports, organizes and constructs the business data source using a business-oriented language, and constructs a business data set of the irregular report based on each business data source, visually constructs the correspondence between the business data set and the irregular report in the irregular report display interface corresponding to the irregular report type, and after the correspondence is constructed, visually sets the irregular report parameter information according to the irregular report type, and generates the irregular report. The present invention organizes and constructs the business data source and the irregular report display interface using a business-oriented language, and constructs the correspondence between the business data set corresponding to the business data source and the irregular report in the irregular report display interface, which greatly reduces the operational difficulty when generating irregular reports, so that ordinary business users can also generate irregular reports by themselves according to business needs, thereby greatly improving the ease of use and universality of irregular reports and enhancing user experience.

[0138] In addition, the ease of use of irregular reports can also meet the needs of dynamic business changes.

[0139] To further optimize the above embodiment, the data set construction unit 403 may be specifically used for:

[0140] According to the data source type corresponding to each of the business data sources, a corresponding connection relationship between the report system and each of the business data sources is established;

[0141] Based on the connection relationship, obtain a business database object set corresponding to the irregular report from the business database;

[0142] Visually constructing the association relationship between each business database object in the business database object set;

[0143] The business data set of the irregular report is generated based on the association relationship.

[0144] Among them, this embodiment constructs the association relationship between different business database objects, mainly to merge different business database objects, so as to achieve the integration of multiple business database objects, and the integration mainly includes: column integration and row integration.

[0145] In summary, the present invention adopts Excel-based data operation and presentation methods, which can quickly realize business data binding and presentation positioning, thereby improving business data presentation standards and layout efficiency.

[0146] To further optimize the above embodiment, the corresponding relationship building unit 404 may be specifically used for:

[0147] Drag metadata information selected from the business data set as target metadata information to a target cell of the irregular report display interface to establish a display relationship between each of the business data sources and the irregular report;

[0148] releasing the dragged target metadata information from the target cell;

[0149] Presenting target business data according to the layout structure of the irregular report, wherein the target business data is business data corresponding to the target metadata information in the business database;

[0150] The binding relationship between the target metadata information and the target cell is saved.

[0151] The present invention independently develops an Excel-like operation interface as an irregular report display interface to facilitate users to quickly and accurately realize the binding between various business data sources and irregular reports, and efficiently improve the generation capability of irregular reports.

[0152] To further optimize the above embodiment, the generation system may further include:

[0153] The report publishing unit is used to publish the irregular report after the report generating unit 405 generates the irregular report.

[0154] In order to shield the operability of users and share irregular reports with multiple people at the same time, irregular reports can be published. Before publishing irregular reports, it is necessary to determine the unit information, period information, indicator information and storage information of the report, as well as the sharing object and scope of the irregular report.

[0155] After being published, irregular reports only need to dynamically refresh the report data of the corresponding information based on the unit and period information. The report data is based on the unit and the period, i.e. time, is used as the frequency for data storage. The frequency is generally year, quarter, month, week, etc. The corresponding report data can be selected based on the specific unit and period.

[0156] In order to facilitate the subsequent review of irregular reports, after the irregular reports are published, the relevant information of the irregular reports needs to be stored.

[0157] To further optimize the above embodiment, the generation system may further include:

[0158] The report running unit is used to run the irregular report after the report publishing unit publishes the irregular report.

[0159] In actual applications, when running irregular reports, the irregular report parsing engine can be called to read the basic information of the irregular report, and dynamically obtain, process, display and store the irregular report data.

[0160] After running an irregular report, storage report data is generated.

[0161] It should be noted that for the specific working principles of each component in the system embodiment, please refer to the corresponding part of the method embodiment, which will not be repeated here.

[0162] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0163] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.

[0164] The above description of the disclosed embodiments enables one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to the embodiments shown herein, but rather to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for generating an irregular report, characterized in that: include: Determine the irregular report type based on the known layout structure and header fields of the irregular report; Based on the header fields of the irregular report type, determining each business data source of the irregular report, each of the business data sources is organized and constructed using a business language; Constructing a business data set of the irregular report based on each of the business data sources, the business data set comprising: a plurality of metadata information and business data corresponding to each metadata information; On an irregular report display interface corresponding to the irregular report type, a corresponding relationship between the business data set and the irregular report is visually constructed, and the irregular report display interface is organized and constructed using a business language; After the corresponding relationship is established, irregular report parameter information is visually set according to the irregular report type to generate the irregular report; The step of constructing the business data set of the irregular report based on each of the business data sources specifically includes: According to the data source type corresponding to each of the business data sources, a corresponding connection relationship between the report system and each of the business data sources is established; Based on the connection relationship, obtain a business database object set corresponding to the irregular report from the business database; Visually construct the association relationship between the various business database objects in the business database object set, merge different business database objects, and realize the integration of multiple business database objects, wherein the integration includes: column integration and row integration; The business data set of the irregular report is generated based on the association relationship.

2. The generation method according to claim 1, characterized in that: The visually constructing the corresponding relationship between the business data set and the irregular report on the irregular report display interface corresponding to the irregular report type specifically includes: Drag metadata information selected from the business data set as target metadata information to a target cell of the irregular report display interface to establish a display relationship between each of the business data sources and the irregular report; releasing the dragged target metadata information from the target cell; Presenting target business data according to the layout structure of the irregular report, wherein the target business data is business data corresponding to the target metadata information in the business database; The binding relationship between the target metadata information and the target cell is saved.

3. The generation method according to claim 1, characterized in that: After generating the irregular report, it also includes: Publish said irregular report.

4. The generation method according to claim 3, characterized in that: After the release of the said irregular report, it also includes: Run the irregular report.

5. A system for generating irregular reports, characterized in that: include: A report type determination unit, used for determining the type of the irregular report based on the known layout structure and header fields of the irregular report; A data source determination unit, configured to determine each business data source of the irregular report based on the header field of the irregular report type, wherein each business data source is organized and constructed in a business language; A data set construction unit, used to construct a business data set of the irregular report based on each of the business data sources, the business data set comprising: a plurality of metadata information and business data corresponding to each metadata information; A corresponding relationship building unit, used for visually building a corresponding relationship between the business data set and the irregular report on an irregular report display interface corresponding to the irregular report type, wherein the irregular report display interface is organized and built using a business language; A report generating unit, configured to visually set irregular report parameter information according to the irregular report type and generate the irregular report after the corresponding relationship is established; The data set construction unit is specifically used for: According to the data source type corresponding to each of the business data sources, a corresponding connection relationship between the report system and each of the business data sources is established; Based on the connection relationship, obtain a business database object set corresponding to the irregular report from the business database; Visually construct the association relationship between the various business database objects in the business database object set, merge different business database objects, and realize the integration of multiple business database objects, wherein the integration includes: column integration and row integration; The business data set of the irregular report is generated based on the association relationship.

6. The generation system according to claim 5, characterized in that The corresponding relationship building unit is specifically used for: Drag metadata information selected from the business data set as target metadata information to a target cell of the irregular report display interface to establish a display relationship between each of the business data sources and the irregular report; releasing the dragged target metadata information from the target cell; Presenting target business data according to the layout structure of the irregular report, wherein the target business data is business data corresponding to the target metadata information in the business database; The binding relationship between the target metadata information and the target cell is saved.

7. The generation system according to claim 5, characterized in that Also includes: The report publishing unit is used to publish the irregular report after the report generating unit generates the irregular report.

8. The generation system according to claim 7, characterized in that: Also includes: The report running unit is used to run the irregular report after the report publishing unit publishes the irregular report.