Report generation method and system based on data model asset directory

Abstract

The invention discloses a report generation method and system based on a data model asset catalog, and belongs to the technical field of report generation. The report generation method comprises the following steps: constructing the data model asset catalog, selecting a proper data model as a report data model, and selecting a corresponding report generation rule according to the report data model and a business demand. The report template is selected according to the report generation rule, parameters and authority of the report are configured based on the report template and the service authority, and associated information in the service data is imported into the report template according to a service matching mechanism obtained by the configured parameters and authority to obtain the target report, so that the technical threshold of report generation is reduced, and the report generation efficiency is improved. The report generation process is simpler, the data model asset directory is constructed, the appropriate data model can be automatically selected according to the service type, complex service data are classified and combined, the data processing difficulty is reduced, and the report generation efficiency is improved on the premise that the report content accuracy is guaranteed.

Description

Technical Field

[0001] The present invention relates to the technical field of report generation, and in particular to a report generation method and system based on a data model asset catalog. Background Art

[0002] With the rapid development of information technology, enterprises and organizations are facing more and more data. While the diversification of data sources provides comprehensive data, it also makes it difficult for traditional report production methods to efficiently manage these multi-source data. Traditional report production usually requires programming languages, database knowledge, and specific reporting software operation skills. This is a huge challenge for most non-technical personnel, limiting their ability to generate reports in a timely manner according to their own needs. From the proposal of requirements to the final generation of reports, it often requires multiple links such as demand analysis, design, development, and testing, which consumes a lot of time and manpower costs. Once the requirements change, modifying the report may require reprogramming or complex spreadsheet adjustments, which makes it difficult to respond quickly to business changes. In order to increase the speed of report generation, the traditional means is to choose a modular approach to quickly generate reports through the combination of various modules. However, the data accuracy of the report can only be met when the data volume is low. Once the data volume is too large and the source of the data obtained by the report is too broad, it will affect the accuracy and effectiveness of the data after the report is generated.

[0003] Chinese patent, publication number: CN111553133A, publication date: August 18, 2020, discloses a report generation method, which receives a report set, extracts all underlying data models in the report set and summarizes them to obtain an initial report data model set; screens out a public report data model from the initial report data model set; receives a field set of a report to be generated, calculates a matching value between the field set and a field in the public report data model, selects a public report data model whose matching value is greater than a preset threshold, and obtains a general report data model; obtains report data of the report to be generated, and imports the report data of the report to be generated into the general report data model to generate a report, but it is difficult to ensure the generation efficiency and report content accuracy when generating reports for a large amount of data. Summary of the invention

[0004] In view of the problems that the technical threshold for generating reports in the prior art is high and the efficiency and accuracy of generating reports are low when the data volume is large, the present invention provides a report generating method based on a data model asset catalog, by constructing a data model asset catalog and selecting a suitable data model as a report data model, then selecting a corresponding report generating rule according to the report data model and business requirements, selecting a report template according to the report generating rule, configuring the report parameters and permissions based on the report template and business permissions, and importing the related information in the business data into the report template to obtain the target report according to the business matching mechanism obtained according to the configured parameters and permissions, thereby reducing the technical threshold for report generating, and making the report generating process simpler, and constructing a data model asset catalog to automatically select a suitable data model according to the business type, classifying and combining complex business data, reducing the difficulty of data processing, and thus improving the report generating efficiency while ensuring the accuracy of the report content.

[0005] In a first aspect, a technical solution provided in an embodiment of the present invention is: a report generation method based on a data model asset catalog, comprising the following steps: S1. Build a data model asset catalog, and configure a corresponding report data model for business needs based on the data model asset catalog; S2. Configure report generation rules for the report data model based on business needs to obtain a report template; S3. Configure corresponding basic configuration parameters and report permissions for the report template according to business logic and business permissions; generate a business matching mechanism based on the basic configuration parameters and report permissions; S4. The business matching mechanism obtains associated information in response to the business data, and fills the associated information into the corresponding report template to obtain a target report.

[0006] In this solution, by constructing a data model asset catalog, the appropriate report data model is automatically selected from the data model asset catalog based on business needs, and complex business data is classified according to data sources and uses, etc., which reduces the difficulty of data processing when generating reports, improves the speed of generating reports, and also improves the ability to process complex data when generating reports; by selecting corresponding report generation rules according to the report data model and business needs, an adaptive report template can be selected according to the needs and complexity of report generation, and there is no need to manually combine and arrange several report data models when generating more complex reports, which reduces the report generation steps and improves the report generation speed; by setting the basic report configuration through the report template, and then setting the report permissions according to the permissions of the report data model, different levels of report content can be displayed for users of different levels, which can ensure the security and privacy of data; by querying the information associated with the report data model from the database and importing the information into the report, the problem of obtaining data from multiple data sources can be solved from the root, thereby ensuring the consistency and accuracy of the report data.

[0007] Preferably, in S1, building a data model asset catalog includes the following steps: Obtain the subject, required data fields and data dimensions of the report to be generated, and define a corresponding report data model based on the subject, required data fields and data dimensions of the report to be generated; Obtain business data, build a mapping relationship between the report data model and the business data based on the source and type of the business data, and correspond the report data model to the business data one by one based on the mapping relationship; Based on the business type of the business data, the corresponding report data models are grouped to obtain the report data model group, and the data model asset directory is constructed based on the business sequence of the report data model group.

[0008] In this solution, by defining the corresponding report data model according to the subject of the report to be generated, the required data fields and the data dimensions, a rough sorting out of the complex business data can be done, so as to facilitate the subsequent import of the corresponding data from the database into the report according to the type of data model, so as to ensure the consistency and accuracy of the report data; by building a mapping relationship between the report data model and the business data based on the source and type of the business data, the report data model and the business data are matched one by one based on the mapping relationship, and the business data is associated with the corresponding data model. In the subsequent data transmission, there is no need to conduct a comprehensive search for all data, only the related data needs to be searched, which significantly reduces the difficulty of data processing and improves the efficiency of report generation; the corresponding report data models are grouped according to the business type of the business data to obtain the report data model group, and the data model asset directory is built based on the business order of the report data model group, so that the staff can quickly generate reports through simple dragging, clicking and other operations when generating reports, which greatly reduces the operational threshold for report generation and improves the efficiency of report generation.

[0009] Preferably, in S2, configuring report generation rules for the report data model based on business requirements to obtain a report template includes the following steps: Obtain the business types in the business requirements, and obtain the business complexity based on the number of business types. If the business complexity exceeds the set threshold, use the multi-report association generation mode and select the corresponding report template; If the business complexity is lower than the set threshold, the basic report generation mode is adopted and the corresponding report template is selected.

[0010] In this solution, when generating reports, it is sometimes necessary to associate reports according to the complexity of the generated reports. For example, if there are too many types of business data and it is very complex, when the report template is difficult to accurately import all the data, multiple report templates are required to be integrated to generate a report template suitable for such complex data. The corresponding report generation rules are selected according to the business type corresponding to the report data model, wherein the report generation rules include the first report generation rule and the second report generation rule. The first report rule is to select the header report template and the detail report template when the report generation requires multiple report associations, and is used to integrate multiple reports into a complete report. The second report rule is to select the basic row report template when the report generation does not require multiple tables to be associated. It only contains a single report type and only needs to import data of this type. In this way, when generating complex reports, the generated reports will not be too complicated in report layout due to complex data, affecting the user's observation experience.

[0011] Preferably, in S3, corresponding basic configuration parameters and report permissions are configured for the report template according to the business logic and business permissions, including the following steps: Enter the corresponding configuration page based on the business logic to set the basic configuration parameters of the report, the configuration page includes a multi-table association configuration page and a basic configuration page; The content of business permissions is extracted based on semantics and words to obtain permission fields, feature analysis is performed on permission fields to obtain field feature factors, the field feature factors are matched with configurable permissions to obtain permission enumeration values, and configurable permissions corresponding to permission fields higher than permission enumeration values ​​are configured in the report.

[0012] In this solution, by setting up a configuration page and performing basic configuration of the report on the configuration page, users do not need professional software development knowledge or use professional report generation software when making reports. They only need to search for their own configuration requirements on the configuration page to complete the configuration of the report, which reduces the difficulty and labor cost of report making. By querying the permissions of the report data model and then setting the report permissions according to the permissions of the report data model, different levels of report content can be displayed for users of different levels, which can ensure the security and privacy of data.

[0013] Preferably, the specific process of the business matching mechanism includes the following steps: Obtain the data volume of each basic configuration parameter, and sort the types of basic configuration parameters based on the data volume to obtain the matching priority; If the matching priorities are the same, business data matching is performed based on the ratio of the business permissions of the business data corresponding to the basic configuration parameters to the report permissions.

[0014] In this solution, in order to improve the speed and accuracy of data import during the report generation process, it is taken into consideration that some data in the report cannot be displayed to most users due to report permissions, and most of this data is important data. This type of data can only be displayed to a few users with high permissions. The data that most users can see is public data, which will be observed by a large number of users. In order to meet the needs of most users, this type of data needs to be imported into the report first, so that users can obtain the information they need at the first time. The data that only a few people can observe can have its import order postponed. Even if the import speed of some important data is slower than that of public data, it will not affect the user experience of the report for most users. In this way, the report generation speed can be greatly improved while meeting the needs of most users and the normal use of the report.

[0015] Preferably, the basic configuration parameters at least include a foreground description configuration parameter, a query condition type configuration parameter, and a watermark configuration parameter; The report permissions include at least query condition permissions, front-end display permissions, export permissions, and data display range permissions.

[0016] In this solution, by performing basic configuration of the report on the configuration page and setting the report description method, query method and watermark settings, the degree of report display content and the query relevance of the report content can be controlled, so that users can accurately understand the report content and query the data they need, thereby improving the user experience; by limiting the permissions of the report, whether the report can be queried, whether the model fields can be viewed, and whether the report can be exported can be determined according to the viewing permissions of different users, thereby preventing report data leakage and ensuring data security and privacy.

[0017] Preferably, the authority field includes at least an authority name field and an authority content field.

[0018] In this solution, since it is necessary to select report permissions, in order to reflect the business permission types corresponding to different business data, the words and semantics of the content of specific business permissions are analyzed to obtain the permission field. The permission name field is equivalent to the name of the business permission, which indicates a general type and purpose of the business permission. The permission content field is an extraction of the specific content of the business to prevent confusion with permissions with similar content. Users can select the required report permissions by querying the permission field, which is convenient for users to quickly search for the required report permissions through text queries according to their own needs. The query method is simple and the operation difficulty is low, which is convenient for users to configure report permissions.

[0019] In a second aspect, a technical solution provided in an embodiment of the present invention is: a report generation system based on a data model asset catalog, including a data storage module, a report configuration module, a report authority control module, and a report display module; The data storage module stores a data model asset catalog, and the data model asset catalog is a report data model corresponding to the business demand configuration; The report configuration module configures report generation rules for the report data model based on business requirements to obtain a report template and configures corresponding basic configuration parameters for the report template according to business logic; The report authority control module matches the corresponding report authority from the data storage module based on the business authority, and configures authority for the report based on the matching result; The report display module generates a business matching mechanism based on basic configuration parameters and report permissions, imports related information from the data storage module based on the business matching mechanism, fills it into the corresponding report template to obtain a target report, and displays the target report.

[0020] In this solution, the data model asset catalog classifies complex business data according to data sources and uses, which reduces the difficulty of data processing when generating reports, improves the speed of generating reports, and also improves the ability to process complex data when generating reports; the report configuration module and the report permission control module set the basic report configuration, and then set the report permissions according to the permissions of the report data model. It can not only display different levels of report content for users of different levels to ensure data security and privacy, but also simplify the report generation steps, reduce the operational threshold for report production, and thus improve the speed of report generation; the report display module can set different permissions for users of different levels according to the configured permissions to control access to the module and configuration permissions to ensure data security and privacy.

[0021] Preferably, the data storage module stores a report permission library and a business permission library. The data storage module receives business data, classifies the business data based on the source of the business data, and stores it to obtain a business database; the data storage module, based on the permission size of each type of business data, organizes the business permissions corresponding to each type of business data based on the permission content to obtain report permissions, and stores them to obtain a report permission library.

[0022] In this solution, the data storage module stores the data model asset directory, business data, and business permissions, and organizes and classifies the above data to facilitate users to directly query based on keywords and other information. The data storage module serves as the data source for the entire report generation system, and is also used to connect several modules to each other so that they can cooperate with each other to achieve rapid generation of reports, reducing the difficulty of report production and improving report generation efficiency.

[0023] Preferably, the report display module forms an independent URL and generates an extended link after generating the report. The extended link interacts with the external system and the external platform to display the report on the external system and the external platform, and updates the content on the report in real time.

[0024] In this solution, the report display module is also used to exchange information with external modules, adopting standardized interface protocols and data exchange formats to ensure smooth communication and data transfer between modules, displaying reports on external modules, and supporting real-time updating and verification of data to ensure that the data in the report is always up-to-date and accurate, thereby improving the accuracy and real-time nature of the report content.

[0025] The beneficial effects of the present invention are as follows: (1) The present invention constructs a data model asset catalog, automatically selects a suitable report data model from the data model asset catalog based on business needs, and classifies complex business data according to data sources and uses, thereby reducing the difficulty of data processing when generating reports, improving the speed of generating reports, and also improving the ability to process complex data when generating reports; (2) The present invention selects corresponding report generation rules according to the report data model and business requirements, and can select an adaptive report template according to the requirements and complexity of report generation. It is not necessary to manually combine and arrange several report data models when generating more complex reports, thereby reducing the report generation steps and improving the report generation speed; (3) The present invention sets the basic report configuration through the report template, and then sets the report permissions according to the permissions of the report data model, so that different levels of report content can be displayed for users of different levels, thereby ensuring the security and privacy of data; (4) The present invention can fundamentally solve the problem of obtaining data from multiple data sources by querying information associated with the report data model from the database and importing the information into the report, thereby ensuring the consistency and accuracy of the report data.

[0026] The above invention content is only an overview of the technical solution of the present invention. In order to more clearly understand the technical means of the present invention, it can be implemented according to the contents of the specification. In order to make the above and other purposes, features and advantages of the present invention more obvious and easy to understand, the specific implementation methods of the present invention are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] Other features, objects and advantages of the present invention will become more apparent by reading the detailed description of non-limiting embodiments made with reference to the following drawings. The drawings are only for the purpose of illustrating preferred embodiments and are not to be considered as limiting the present invention. Also, the same reference symbols are used throughout the drawings to represent the same parts.

[0028] Figure 1 It is a flow chart of a report generation method based on a data model asset catalog of the present invention; Figure 2 It is a system block diagram of the report generation system based on the data model asset catalog of the present invention. DETAILED DESCRIPTION

[0029] In order to make the objectives, technical solutions and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific implementation method described herein is only an optimal embodiment of the present invention, which is only used to explain the present invention and does not limit the scope of protection of the present invention. All other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.

[0030] Before discussing the exemplary embodiments in more detail, it should be mentioned that some exemplary embodiments are described as processes or methods depicted as flow charts. Although the flow charts describe the operations (or steps) as sequential processes, many of the operations (or steps) therein can be implemented in parallel, concurrently, or simultaneously. In addition, the order of the operations can be rearranged. The process can be terminated when its operation is completed, but can also have additional steps not included in the drawings; the process can correspond to a method, function, procedure, subroutine, subprogram, etc.

[0031] Example 1: Figure 1 As shown, in order to solve the problem that the technical threshold for generating reports in the prior art is high and the efficiency and accuracy of generating reports are low when the amount of data is large, this embodiment provides a report generation method based on a data model asset catalog, including the following steps: S1: Build a data model asset catalog and configure the corresponding report data model for business needs based on the data model asset catalog.

[0032] In this embodiment, building a data model asset catalog includes the following steps: Obtain the subject, required data fields and data dimensions of the report to be generated, and define the corresponding report data model based on the subject, required data fields and data dimensions of the report to be generated; Obtain business data, build a mapping relationship between the report data model and the business data based on the source and type of the business data, and correspond the report data model to the business data one by one based on the mapping relationship; Based on the business type of the business data, the corresponding report data models are grouped to obtain the report data model group, and the data model asset directory is constructed based on the business sequence of the report data model group.

[0033] This embodiment can roughly sort out complex business data by defining the corresponding report data model according to the subject of the report to be generated, the required data fields and the data dimensions, so as to facilitate the subsequent import of corresponding data from the database into the report according to the type of data model to ensure the consistency and accuracy of the report data; by constructing a mapping relationship between the report data model and the business data based on the source and type of the business data, the report data model and the business data are matched one by one based on the mapping relationship to associate the business data with the corresponding data model, and there is no need to conduct a comprehensive search for all data during subsequent data transmission, only the associated data needs to be searched, which significantly reduces the difficulty of data processing and improves the efficiency of report generation; the corresponding report data models are grouped according to the business type of the business data to obtain a report data model group, and a data model asset directory is constructed based on the business order of the report data model group, so that the staff can quickly generate reports through simple dragging, clicking and other operations when generating reports, which greatly reduces the operational threshold for report generation and improves the efficiency of report generation.

[0034] S2: Based on business requirements, configure report generation rules for the report data model to obtain a report template.

[0035] In this embodiment, configuring report generation rules for a report data model based on business requirements to obtain a report template includes the following steps: Obtain the business types in the business requirements, and obtain the business complexity based on the number of business types. If the business complexity exceeds the set threshold, use the multi-report association generation mode and select the corresponding report template; If the business complexity is lower than the set threshold, the basic report generation mode is adopted and the corresponding report template is selected.

[0036] In this embodiment, when generating a report, it is sometimes necessary to associate the reports according to the complexity of the generated report. For example, if there are too many types of business data and it is very complex, when it is difficult for the report template to accurately import all the data, multiple report templates need to be integrated to generate a report template suitable for such complex data. The corresponding report generation rule is selected according to the business type corresponding to the report data model, wherein the report generation rule includes a first report generation rule and a second report generation rule. The first report rule is to select a header report template and a detail report template when the report generation requires the association of multiple reports, and is used to integrate multiple reports into a complete report. The second report rule is to select a basic row report template when the report generation does not require the association of multiple tables, and only includes a single report type, and only needs to import data of this type. In this way, when generating complex reports, the generated report will not be too complicated in report typesetting due to complex data, affecting the user's observation experience.

[0037] S3: Configure corresponding basic configuration parameters and report permissions for the report template according to business logic and business permissions; generate a business matching mechanism based on the basic configuration parameters and report permissions.

[0038] In this embodiment, the corresponding basic configuration parameters and report permissions are configured for the report template according to the business logic and business permissions, including the following steps: Enter the corresponding configuration page based on the business logic to set the basic configuration parameters of the report, the configuration page includes a multi-table association configuration page and a basic configuration page; The content of business permissions is extracted based on semantics and words to obtain permission fields, feature analysis is performed on permission fields to obtain field feature factors, the field feature factors are matched with configurable permissions to obtain permission enumeration values, and configurable permissions corresponding to permission fields higher than permission enumeration values ​​are configured in the report.

[0039] This embodiment sets up a configuration page, and performs basic configuration of the report in the configuration page, so that when making reports, users do not need professional software development knowledge and use professional report generation software. They only need to search for their own configuration requirements in the configuration page to complete the configuration of the report, thereby reducing the difficulty and labor cost of report making; by querying the permissions of the report data model and then setting the report permissions according to the permissions of the report data model, different levels of report content can be displayed for users of different levels, thereby ensuring the security and privacy of the data.

[0040] In this embodiment, the specific process of the business matching mechanism includes the following steps: Obtain the data volume of each basic configuration parameter, and sort the types of basic configuration parameters based on the data volume to obtain the matching priority; If the matching priorities are the same, business data matching is performed based on the ratio of the business permissions of the business data corresponding to the basic configuration parameters to the report permissions.

[0041] In order to improve the speed and accuracy of data import during the report generation process, this embodiment takes into account that some data in the report cannot be displayed to most users due to report permissions, and most of this data is important data, which can only be displayed to a few users with high permissions. The data that most users can see is public data, which will be observed by a large number of users. In order to meet the needs of most users, this data needs to be imported into the report first, so that users can obtain the information they need at the first time. The data that only a few people can observe can have its import order postponed. Even if the import speed of some important data is slower than that of public data, it will not affect the report experience for most users. In this way, the report generation speed can be greatly improved while meeting the needs of most users and the normal use of the report.

[0042] In this embodiment, the basic configuration parameters at least include a foreground description configuration parameter, a query condition type configuration parameter, and a watermark configuration parameter; The report permissions include at least query condition permissions, front-end display permissions, export permissions, and data display range permissions.

[0043] This embodiment can control the extent of report display content and the query relevance of report content by performing basic configuration on the configuration page, setting the report description method, query method and watermark setting, so that users can accurately understand the report content and query the data they need, thereby improving the user experience; by limiting the permissions of the report, whether the report can be queried, whether the model fields can be viewed, and whether the report can be exported can be determined according to the viewing permissions of different users, thereby preventing report data leakage and ensuring data security and privacy.

[0044] In this embodiment, the authority field includes at least an authority name field and an authority content field.

[0045] In this embodiment, since it is necessary to select report permissions, in order to reflect the business permission types corresponding to different business data, the words and semantics of the content of specific business permissions are analyzed to obtain the permission field. The permission name field is equivalent to the name of the business permission, which indicates a general type and purpose of the business permission. The permission content field is an extraction of the specific content of the business to prevent confusion with permissions with similar content. Users can select the required report permissions by querying the permission field, which is convenient for users to quickly search for the required report permissions through text query according to their own needs. The query method is simple and the operation difficulty is low, which is convenient for users to configure report permissions.

[0046] S4: The business matching mechanism obtains associated information in response to the business data, and fills the associated information into the corresponding report template to obtain the target report.

[0047] This embodiment constructs a data model asset catalog, automatically selects a suitable report data model from the data model asset catalog based on business needs, and classifies complex business data according to data sources and uses, thereby reducing the difficulty of data processing when generating reports, improving the speed of generating reports, and improving the ability to process complex data when generating reports; by selecting corresponding report generation rules according to the report data model and business needs, an adaptive report template can be selected according to the needs and complexity of report generation, and there is no need to manually combine and arrange several report data models when generating more complex reports, thereby reducing the report generation steps and improving the report generation speed; by setting the basic report configuration through the report template, and then setting the report permissions according to the permissions of the report data model, different levels of report content can be displayed for users of different levels, and data security and privacy can be guaranteed; by querying information associated with the report data model from the database and importing the information into the report, the problem of obtaining data from multiple data sources can be solved from the root, thereby ensuring the consistency and accuracy of the report data.

[0048] Example 2: Figure 2 As shown, this embodiment provides a report generation system based on a data model asset catalog, including a data storage module, a report configuration module, a report authority control module, and a report display module; The data storage module stores a data model asset catalog, and the data model asset catalog is a report data model corresponding to the business demand configuration; The report configuration module configures report generation rules for the report data model based on business requirements to obtain a report template and configures corresponding basic configuration parameters for the report template according to business logic; The report authority control module matches the corresponding report authority from the data storage module based on the business authority, and configures authority for the report based on the matching result; The report display module generates a business matching mechanism based on basic configuration parameters and report permissions, imports related information from the data storage module based on the business matching mechanism, fills it into the corresponding report template to obtain a target report, and displays the target report.

[0049] The data model asset directory of this embodiment classifies complex business data according to data sources and uses, etc., which reduces the difficulty of data processing when generating reports, improves the speed of generating reports, and also improves the ability to process complex data when generating reports; the report configuration module and the report permission control module set the basic report configuration, and then set the report permissions according to the permissions of the report data model, which can not only display different levels of report content for users of different levels to ensure data security and privacy, but also simplify the report generation steps, reduce the operational threshold for report production, and thus improve the report generation speed; the report display module can set different permissions for users of different levels according to the configured permissions to control access to the module and configuration permissions to ensure data security and privacy.

[0050] In this embodiment, the data model asset directory is connected to the business database and the report configuration module respectively; the report authority control module is connected to the report authority library and the report display module respectively; the report display module is connected to the report configuration module and the business database respectively.

[0051] In this embodiment, the data model asset model directory and the database realize data interaction, and the report configuration module and the report permission control module both analyze the data in the data model in the data model asset model directory to configure the report. The report permission control module realizes data interaction with the report permission library, and selects corresponding permissions from the business permission library to configure the report, while the report display module selects the required data from the business database, imports it into the report from the business database, and displays the report. Several modules are interconnected and coordinated with each other to realize the rapid generation of reports, which reduces the difficulty of report production and improves the efficiency of report generation. For large data volumes and high concurrency scenarios, caching technology, asynchronous processing and other methods can be used to optimize system performance to ensure the smoothness and real-time nature of the data visualization process. In the report generation process, an appropriate error handling mechanism can also be added, and detailed log information can be recorded to facilitate troubleshooting and system maintenance, thereby reducing the probability of errors in the report generation process.

[0052] In this embodiment, the data storage module stores a report permission library and a business permission library. The data storage module receives business data, classifies the business data based on the source of the business data, and stores it to obtain a business database; the data storage module, based on the permission size of each type of business data, organizes the business permissions corresponding to each type of business data based on the permission content to obtain report permissions and stores them to obtain a report permission library.

[0053] The data storage module of this embodiment stores the data model asset directory, business data and business permissions, and organizes and classifies the above data to facilitate users to directly query based on keywords and other information. The data storage module serves as the data source for the entire report generation system, and is also used to connect several modules to each other so that they can cooperate with each other to achieve rapid generation of reports, reduce the difficulty of report production, and improve report generation efficiency.

[0054] In this embodiment, the report display module forms an independent URL and generates an extended link after generating the report. The extended link interacts with the external system and the external platform to display the report on the external system and the external platform, and updates the content on the report in real time.

[0055] The report display module of this embodiment is also used to exchange information with external modules, adopt standardized interface protocols and data exchange formats to ensure smooth communication and data transfer between modules, display reports on external modules, and support real-time updating and verification of data to ensure that the data in the report is always up-to-date and accurate, thereby improving the accuracy and real-time nature of the report content. Users can choose appropriate templates according to their needs and quickly generate beautiful and professional reports to improve user usage reminders.

[0056] It can be seen from the above embodiments that at least the following substantial effects are achieved: (1) The present invention constructs a data model asset catalog and automatically selects a suitable report data model from the data model asset catalog based on business needs, thereby classifying complex business data according to data sources and uses, etc., thereby reducing the difficulty of data processing when generating reports, improving the speed of generating reports, and improving the ability to process complex data when generating reports; (2) The present invention selects corresponding report generation rules based on report data models and business needs, and can select an adaptive report template based on the needs and complexity of report generation. There is no need to manually combine and arrange several report data models when generating more complex reports, thereby reducing the report generation steps and improving the report generation speed; (3) The present invention sets the basic report configuration through the report template, and then sets the report permissions according to the permissions of the report data model. It can display different levels of report content for users of different levels, and can ensure the security and privacy of data; (4) The present invention can solve the problem of obtaining data from multiple data sources from the root by querying the information associated with the report data model from the database and importing the information into the report, thereby ensuring the consistency and accuracy of the report data.

[0057] The specific implementation described above is a preferred implementation of the report generation method and system based on the data model asset catalog of the present invention, and is not intended to limit the specific implementation scope of the present invention. The scope of the present invention includes but is not limited to this specific implementation. All equivalent changes made in accordance with the shape and structure of the present invention are within the protection scope of the present invention.

Claims

1. A report generation method based on a data model asset catalog, characterized in that: The following steps are involved: S1. Build a data model asset catalog and configure the corresponding report data model for business needs based on the data model asset catalog; S2. Based on business requirements, configure report generation rules for the report data model to obtain a report template; S3. Configure corresponding basic configuration parameters and report permissions for the report template according to business logic and business permissions; generate a business matching mechanism based on the basic configuration parameters and report permissions; S4. The business matching mechanism obtains associated information in response to the business data, and fills the associated information into the corresponding report template to obtain a target report.

2. The report generation method based on the data model asset catalog according to claim 1 is characterized in that: In S1, building a data model asset catalog includes the following steps: Obtain the subject, required data fields and data dimensions of the report to be generated, and define the corresponding report data model based on the subject, required data fields and data dimensions of the report to be generated; Obtain business data, build a mapping relationship between the report data model and the business data based on the source and type of the business data, and correspond the report data model to the business data one by one based on the mapping relationship; Based on the business type of the business data, the corresponding report data models are grouped to obtain the report data model group, and the data model asset directory is constructed based on the business sequence of the report data model group.

3. The report generation method based on the data model asset catalog according to claim 1 is characterized in that: In S2, based on business requirements, report generation rules are configured for the report data model to obtain a report template, including the following steps: Obtain the business types in the business requirements, and obtain the business complexity based on the number of business types. If the business complexity exceeds the set threshold, use the multi-report association generation mode and select the corresponding report template; If the business complexity is lower than the set threshold, the basic report generation mode is adopted and the corresponding report template is selected.

4. The report generation method based on the data model asset catalog according to claim 1 is characterized in that: In S3, the corresponding basic configuration parameters and report permissions are configured for the report template according to the business logic and business permissions, including the following steps: Enter the corresponding configuration page based on the business logic to set the basic configuration parameters of the report, the configuration page includes a multi-table association configuration page and a basic configuration page; The content of business permissions is extracted based on semantics and words to obtain permission fields, feature analysis is performed on permission fields to obtain field feature factors, the field feature factors are matched with configurable permissions to obtain permission enumeration values, and configurable permissions corresponding to permission fields higher than permission enumeration values ​​are configured in the report.

5. The report generation method based on the data model asset catalog according to claim 1 is characterized in that: The specific process of the business matching mechanism includes the following steps: Obtain the data volume of each basic configuration parameter, and sort the types of basic configuration parameters based on the data volume to obtain the matching priority; If the matching priorities are the same, business data matching is performed based on the ratio of the business permissions of the business data corresponding to the basic configuration parameters to the report permissions.

6. The method for generating a report based on a data model asset catalog according to claim 4, characterized in that: The basic configuration parameters at least include foreground description configuration parameters, query condition type configuration parameters and watermark configuration parameters; The report permissions include at least query condition permissions, front-end display permissions, export permissions, and data display range permissions.

7. The method for generating a report based on a data model asset catalog according to claim 5, characterized in that: The authority field at least includes an authority name field and an authority content field.

8. A report generation system based on a data model asset catalog, applicable to the report generation method based on a data model asset catalog as claimed in any one of claims 1 to 7, characterized in that: Including data storage module, report configuration module, report authority control module, and report display module; The data storage module stores a data model asset catalog, and the data model asset catalog is a report data model corresponding to the business demand configuration; The report configuration module configures report generation rules for the report data model based on business requirements to obtain a report template and configures corresponding basic configuration parameters for the report template according to business logic; The report authority control module matches the corresponding report authority from the data storage module based on the business authority, and configures authority for the report based on the matching result; The report display module generates a business matching mechanism based on basic configuration parameters and report permissions, imports related information from the data storage module based on the business matching mechanism, fills it into the corresponding report template to obtain a target report, and displays the target report.

9. The report generation system based on the data model asset catalog according to claim 8, characterized in that: The data storage module stores a report permission library and a business permission library. The data storage module receives business data, classifies the business data based on the source of the business data, and stores it to obtain a business database; the data storage module organizes the business permissions corresponding to each type of business data based on the permission content based on the permission size of each type of business data to obtain report permissions and stores them to obtain a report permission library.

10. The report generation system based on the data model asset catalog according to claim 8, characterized in that: The report display module forms an independent URL and generates an extended link after generating the report. The extended link interacts with the external system and the external platform to display the report on the external system and the external platform, and updates the content on the report in real time.

Images