A report management method and device, a report management system and a storage medium

Abstract

The application provides a report management method and device, a report management system and a storage medium, and belongs to the technical field of data processing. The method comprises the following steps: in response to a selection operation, determining a plurality of indexes corresponding to a target report and a data table model of the target report, each index corresponding to an SQL script representing a business process logical relationship, and the SQL script corresponding to an instance table; obtaining the SQL script corresponding to each of the plurality of indexes, parsing the SQL script corresponding to each of the plurality of indexes, and determining the business process logical relationship between the plurality of indexes; and according to the business process logical relationship, generating and displaying the target report in the form of the data table model after the instance table corresponding to each of the plurality of indexes is arranged through data, wherein the plurality of indexes in the target report correspond to a reverse lookup data list SQL script. The application aims to improve the generation efficiency of the report.

Description

Technical Field

[0001] This application relates to the technical field of data processing, and more specifically, to a report management method, apparatus, report management system, and storage medium. Background Technology

[0002] As enterprises deepen their digital transformation, they need data to support rapidly iterating business needs and respond to market changes in a timely manner. However, the development of digitalization has generated a large amount of rich data, and the accumulated data cannot generate value if it is not analyzed and processed.

[0003] Building enterprise operation and management reports and business development reports is an important way of data application. The support for these reports increasingly needs to be efficient, fast and flexible in order to quickly meet the reporting needs of business departments. That is, the requirements for full-process management from the generation and management of indicators to the further generation of reports are becoming increasingly higher.

[0004] In the development and management of existing indicators and reports, custom development is commonly adopted. Each indicator requires independent coding, which makes the development process extremely time-consuming. The same or similar data is driven by different developers and different applications, resulting in serious waste of resources and low overall development efficiency of reports. Summary of the Invention

[0005] This application provides a report management method, apparatus, report management system, and storage medium, aiming to improve the efficiency of report generation.

[0006] In a first aspect, embodiments of this application provide a report generation method, the method comprising:

[0007] In response to the selection operation, multiple indicators corresponding to the target report and the data table model of the target report are determined. Each indicator corresponds to an SQL script that represents the logical relationship of the business process, and the SQL script corresponds to an instance table.

[0008] Obtain the SQL scripts corresponding to each of the multiple metrics, parse the SQL scripts corresponding to each of the multiple metrics, and determine the business process logic relationship between the multiple metrics;

[0009] Based on the business process logic, the instance tables corresponding to the multiple indicators are arranged through data to generate a target report in the form of the data table model for display. The multiple indicators in the target report correspond to SQL scripts for reverse lookup of data lists.

[0010] Optionally, the method further includes:

[0011] In response to the indicator addition operation, obtain the data retrieval rules corresponding to the indicator to be added and the business rules of the target business corresponding to the indicator to be added;

[0012] Based on the business rules corresponding to the indicators to be added, obtain the business process logic relationship corresponding to the business rules in the business dimension tree of the target business;

[0013] Based on the data retrieval rules of the indicator to be added and the business process logic relationship corresponding to the indicator to be added, determine and store the SQL script of the indicator to be added;

[0014] The SQL script of the metric to be added is parsed by the SQL parser, and the data is read to generate the instance table corresponding to the metric to be added.

[0015] Optionally, the method further includes:

[0016] By analyzing the business dimensions of the target business, multiple distinct basic business rules for the target business are obtained;

[0017] Based on the aforementioned multiple distinct basic business rules, multiple distinct combined business rules are formed;

[0018] Based on the business process logic relationship between the basic business rules and the combined business rules, a business dimension tree is constructed.

[0019] Optionally, based on the business process logic, the instance tables corresponding to the multiple indicators are processed through data orchestration to generate a target report in the form of the data table model for display, including:

[0020] According to the business process logic, the instance tables corresponding to each of the multiple indicators are categorized, and view application tables are created through data orchestration.

[0021] By calling the report configuration, and based on the configuration conversion of the SQL scripts corresponding to the multiple indicators, the target report in the form of the data table model is generated and displayed.

[0022] Optionally, after generating and displaying the target report in the form of the data table model, the method further includes:

[0023] In response to a triggered operation on any metric displayed on the target report, the metric to be retrieved is determined, a SQL script for retrieving the data list corresponding to the metric to be retrieved is generated, and the SQL script for retrieving the data list is displayed in a pop-up window.

[0024] Optionally, a SQL script is generated to retrieve the reverse lookup data list corresponding to the indicator to be retrieved, including:

[0025] Obtain the business logic relationship of the indicator to be retrieved;

[0026] The SQL script of the indicator to be queried is reverse-analyzed, and combined with the business logic relationship of the indicator to be queried, the SQL script of the reverse data list corresponding to the data list of the indicator to be queried is determined.

[0027] Optionally, the method further includes:

[0028] In response to the triggered operation of the SQL script for the reverse lookup data list corresponding to the indicator to be reverse looked up, the data list corresponding to the indicator to be reverse looked up is read and displayed according to the SQL script for the reverse lookup data list.

[0029] Secondly, embodiments of this application provide a report generation apparatus, the apparatus comprising:

[0030] The selection module is used to respond to the selection operation, determine multiple indicators corresponding to the target report and the data table model of the target report. Each indicator corresponds to an SQL script that represents the logical relationship of the business process, and the SQL script corresponds to an instance table.

[0031] The parsing module is used to obtain the SQL scripts corresponding to each of the multiple indicators, parse the SQL scripts corresponding to each of the multiple indicators, and determine the business process logic relationship between the multiple indicators.

[0032] The report generation module is used to generate a target report in the form of the data table model by arranging the instance tables corresponding to the multiple indicators according to the business process logic relationship. The multiple indicators in the target report correspond to SQL scripts for reverse lookup of data lists.

[0033] Thirdly, embodiments of this application provide a report management system, the system comprising:

[0034] The metrics management module is used to create metrics and determine the SQL script that represents the logical relationship of each business process for each metric.

[0035] The indicator application module is used to respond to a selection operation, determine multiple indicators corresponding to a target report and the data table model of the target report, parse the SQL scripts corresponding to each of the multiple indicators, and generate a target report in the form of the data table model based on the parsed business process logic relationship, through data orchestration of the instance tables corresponding to each of the multiple indicators; and to respond to a trigger operation for any indicator displayed on the target report, determine the indicator to be retrieved, generate the SQL script for the retrieval data list corresponding to the indicator to be retrieved, and read and display the data list corresponding to the indicator to be retrieved based on the SQL script for the retrieval data list.

[0036] Fourthly, embodiments of this application provide a computer-readable storage medium storing a computer program, which, when executed by a processor, implements the report generation method as described in the first aspect of the embodiments.

[0037] Beneficial effects:

[0038] In response to a selection operation, multiple indicators corresponding to the target report and the data table model of the target report are determined. Each indicator corresponds to an SQL script representing the logical relationship of the business process, and the SQL script corresponds to an instance table. The SQL scripts corresponding to each of the multiple indicators are obtained, and the SQL scripts corresponding to each of the multiple indicators are parsed to determine the logical relationship of the business process between the multiple indicators. Based on the logical relationship of the business process, the instance tables corresponding to each of the multiple indicators are arranged through data to generate the target report in the form of the data table model for display. The multiple indicators in the target report correspond to SQL scripts for reverse lookup of data lists.

[0039] In this method, the indicators have pre-set corresponding SQL scripts and instance tables. The SQL scripts represent the logical relationships of the business process. By parsing the SQL scripts corresponding to multiple indicators, the business logical relationships between multiple indicators can be determined. Then, through data orchestration, a target report with a data table model can be generated. Compared with the existing development process of writing the code for each indicator one by one when generating reports, the efficiency of report generation is improved. Attached Figure Description

[0040] To more clearly illustrate the technical solutions of the embodiments of this application, the drawings used in the description of the embodiments of this application will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0041] Figure 1 This is a flowchart of the report generation method proposed in one embodiment of this application;

[0042] Figure 2 This is a functional block diagram of a report generation device proposed in an embodiment of this application;

[0043] Figure 3 This is an architecture diagram of a report management system provided in one embodiment of this application. Detailed Implementation

[0044] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0045] Reference Figure 1 The diagram illustrates a flowchart of a report generation method according to an embodiment of this application. The method may specifically include the following steps:

[0046] S101: In response to the selection operation, determine multiple indicators corresponding to the target report and the data table model of the target report. Each indicator corresponds to an SQL script that represents the logical relationship of the business process, and the SQL script corresponds to an instance table.

[0047] For a target business, the corresponding metrics can be predefined. In one feasible implementation, in response to the metric addition operation, the metric to be added is determined and then added to the metric table. When creating the metric to be added, the data retrieval rules corresponding to the metric to be added are also obtained and added to the metric data retrieval rule table.

[0048] When creating a new metric, users can customize the metric's name. Then, it is necessary to determine the business rule corresponding to the metric in the target business. Each metric corresponds to one business rule, meaning that there is a unique relationship between the metric and the business rule of the target business.

[0049] In practice, marketing analysis of the target business's business dimensions yields multiple distinct basic business rules for that target business. These basic business rules typically do not include business relationships. For example, basic business rules represent abstract dimensions such as products, urban / rural identification, user characteristics, and statistical periods. Each business rule corresponds to multiple business interpretations. For instance, user characteristics include at least two business interpretations: residential and commercial. In the product business rules, the business interpretation for a fixed-line telephone product could be: 1.01.0.0, where 1 identifies the product type and 01 identifies the highest level of fixed-line telephone within the product type. Thus, 1.01.0.0 can uniquely identify a fixed-line telephone.

[0050] The scope of basic business rules is limited. Therefore, it is necessary to combine these multiple different basic business rules into multiple different combined business rules. Each combined business rule is also unique. In actual implementation, all generated combined business rules can be stored in a business combination table.

[0051] For example, the combined business rule is: Urban residential ordinary telephone. Through the combination of product, city, and residence in the basic business rule, the product is ordinary telephone + the urban-rural identifier is city + the user type is residential. Therefore, there are multiple business interpretations in one combined business rule.

[0052] Then, based on the business process logic relationship between the basic business rules and the combined business rules, a business dimension tree is constructed, for example, selecting all products - landline telephones - city government and enterprise ordinary telephones and city residential ordinary telephones.

[0053] After adding a new indicator and determining the business rule corresponding to the indicator to be added, the business process logic relationship corresponding to the business rule can be obtained in the business dimension tree of the target business, thereby realizing the serialization of an indicator. For example, if the business rule corresponding to indicator A is: number of fixed-line phone calls received, then indicator A can be used to determine the number of fixed-line phone calls received in the city, rather than the number of mobile phone calls received in the countryside. Then, the relationship between the indicator and the business rule is stored in the indicator dimension relationship table.

[0054] Then, based on the data retrieval rules of the indicator to be added and the business process logic relationship corresponding to the indicator to be added, the SQL script of the indicator to be added is determined and stored. That is, the SQL script of an indicator can be regarded as a combination of data retrieval rules and business process logic relationships that can reflect business scope information.

[0055] Taking the number of landline phone calls received as an example:

[0056] The SQL for retrieving the arrival count of the indicator is as follows:

[0057] SQL="SELECT MONTH_NO,LOCAL_CODE,SUM(SERV_NUM)FROM D_SERV_NUM_MONTHLY

[0058] The business logic relationship for the number of landline calls is: number of calls - landline calls. In the business rules, the business interpretation of landline calls is 1.01.0.0. The generation condition for this business interpretation is: 1 indicates the product and can be written as D_TERM_TYPE, 01 indicates the third layer is 01, so it can be written as D_TERM_TYPE WHERE LEVEL3_CODE='01'.

[0059] The SQL scripts for calculating the number of landline calls received can then be combined as follows:

[0060] SELECT MONTH_NO, LOCAL_CODE, SUM(SERV_NUM) FROM D_SERV_NUM_MONTHLY a, D_TERM_TYPE b WHERE LEVEL3_CODE = '01' AND a.TERM_TYPE_id = b.term_type_id AND LOCAL_CODE = parameter passed in during program execution AND month_no = parameter passed in during program execution.

[0061] Finally, the SQL script of the indicator to be added is parsed by the SQL parser, and the data is read to generate the instance table corresponding to the indicator to be added.

[0062] In actual implementation, when a report needs to be generated, the user only needs to select the multiple indicators required for the target report and the corresponding data table type. The data table type can include single-table report, navigation page cross table, and sub-report accounting period and organization cross table.

[0063] S102: Obtain the SQL scripts corresponding to each of the multiple indicators, parse the SQL scripts corresponding to each of the multiple indicators, and determine the business process logic relationship between the multiple indicators.

[0064] The relationship between metrics and business rules is stored in the metric dimension relationship table. Each metric can be broken down into a basic metric and a business constraint. For example, in the number of landline phone calls received, the basic metric is the number of calls received, and the business constraint is the number of landlines. In the number of landline phone calls received in a city, the basic metric is the number of calls received, and the business constraint is the city and the number of landlines. This still reflects the business process logic of the metric.

[0065] By parsing the SQL scripts of multiple metrics in the target report, the business logic relationships between multiple metrics can be realized, and the relationship between each metric and the target report can be automatically configured, thus solidifying the metric and data table model.

[0066] S103: Based on the business process logic, after data arrangement of the instance tables corresponding to the multiple indicators, a target report in the form of the data table model is generated and displayed. The multiple indicators in the target report correspond to SQL scripts for reverse lookup of data lists.

[0067] According to the business process logic, the instance tables corresponding to each of the multiple indicators are categorized, and a view application table is created through data orchestration as an intermediate table for report configuration that closely matches business requirements. Then, through report call configuration, the target report in the form of the data table model is generated and displayed based on the configuration transformation of the SQL scripts corresponding to the multiple indicators.

[0068] Furthermore, in the target report generated by this method, each indicator is also equipped with a SQL script for reverse lookup of the data list, which makes it easy to trace back to the data list corresponding to each indicator.

[0069] Specifically, in response to a trigger operation on any indicator displayed on the target report, the indicator to be retrieved is determined, a SQL script for retrieving the data list corresponding to the indicator to be retrieved is generated, and the SQL script for retrieving the data list is displayed in a pop-up window.

[0070] When generating the SQL script for the reverse lookup data list corresponding to the indicator to be reverse looked up, the business logic relationship of the indicator to be reverse looked up is obtained; the SQL script of the indicator to be reverse looked up is reverse parsed, and combined with the business logic relationship of the indicator to be reverse looked up, the SQL script for the reverse lookup data list corresponding to the data list of the indicator to be reverse looked up is determined.

[0071] If a user clicks on the SQL script for the reverse lookup data list corresponding to the indicator to be reversed, then in response to the triggered operation for the SQL script for the reverse lookup data list corresponding to the indicator to be reversed, the data list corresponding to the indicator to be reversed is read and displayed according to the SQL script for the reverse lookup data list.

[0072] In actual implementation, when a user clicks on any metric in the target report, the metric's name, the directory to which the metric's business process belongs, the metric's business definition, the address of the metric's physical table, the metric's SQL script, and the SQL script for retrieving the data list can also be displayed.

[0073] When generating the target report, this method pre-defines the corresponding SQL scripts and instance tables for each indicator. The SQL scripts represent the logical relationships of the business process. By parsing the SQL scripts corresponding to multiple indicators, the business logical relationships between multiple indicators can be determined. Then, through data orchestration, a target report with a data table model can be generated.

[0074] For a target business, by pre-configuring the correspondence between indicators and business rules and generating SQL scripts, the indicators can be repeatedly applied when generating all reports within the target business scope. This allows for one-time development without additional configuration work, automatically completing the penetration from indicators to underlying data tables. Indicators are automatically traced back to the underlying database tables, and indicators can quickly retrieve data lists, enabling self-service data extraction and application. Furthermore, the SQL scripts in this method use dynamic concatenation, avoiding the tedious process of developing multiple SQL scripts separately, thus improving the efficiency of report generation.

[0075] Reference Figure 2 The diagram illustrates a functional block diagram of a report generation device provided in an embodiment of this application. The device includes:

[0076] Selection module 100 is used to respond to selection operation to determine multiple indicators corresponding to the target report and the data table model of the target report. Each indicator corresponds to an SQL script that represents the logical relationship of the business process, and the SQL script corresponds to an instance table.

[0077] The parsing module 200 is used to obtain the SQL scripts corresponding to each of the multiple indicators, parse the SQL scripts corresponding to each of the multiple indicators, and determine the business process logic relationship between the multiple indicators.

[0078] The report generation module 300 is used to generate a target report in the form of the data table model by arranging the instance tables corresponding to the multiple indicators according to the business process logic relationship, wherein the multiple indicators in the target report correspond to SQL scripts for reverse lookup of data lists.

[0079] Optionally, the device further includes:

[0080] The add module is used to respond to the indicator add operation by obtaining the data retrieval rules corresponding to the indicator to be added and the business rules of the target business corresponding to the indicator to be added.

[0081] The business relationship matching module is used to obtain the business process logic relationship corresponding to the business rule in the business dimension tree of the target business according to the business rule corresponding to the indicator to be added;

[0082] The SQL script generation module is used to determine and store the SQL script of the indicator to be added based on the data retrieval rules of the indicator to be added and the business process logic relationship corresponding to the indicator to be added.

[0083] The instance table generation module is used to parse the SQL script of the indicator to be added through the SQL parser and read the data to generate the instance table corresponding to the indicator to be added.

[0084] Optionally, the device further includes:

[0085] The business rule analysis module is used to analyze the business dimensions of the target business and obtain multiple different basic business rules for the target business.

[0086] The business rule combination module is used to combine multiple different basic business rules into multiple different combined business rules.

[0087] The dimension tree construction module is used to construct a business dimension tree based on the business process logic relationship between the basic business rules and the combined business rules.

[0088] Optionally, the report generation module includes:

[0089] The data orchestration unit is used to classify the instance tables corresponding to the multiple indicators according to the business process logic relationship, and create view application tables through data orchestration.

[0090] The display unit is used to generate a target report in the form of the data table model for display by calling the configuration through the report and converting the SQL scripts corresponding to the multiple indicators.

[0091] Optionally, the device further includes:

[0092] The reverse lookup data list SQL script generation module is used to respond to a trigger operation on any indicator displayed on the target report, determine the indicator to be reverse looked up, generate the reverse lookup data list SQL script corresponding to the indicator to be reverse looked up, and display the reverse lookup data list SQL script in a pop-up window.

[0093] Optionally, the reverse lookup data list SQL script generation module includes:

[0094] The acquisition unit is used to acquire the business logic relationship of the indicator to be retrieved.

[0095] The reverse parsing unit is used to reverse parse the SQL script of the indicator to be queried, and combine it with the business logic relationship of the indicator to be queried to determine the SQL script of the reverse query data list corresponding to the data list of the indicator to be queried.

[0096] Optionally, the device further includes:

[0097] The data list generation module is used to respond to the triggering operation of the SQL script for retrieving the data list corresponding to the indicator to be queried, and to read and display the data list corresponding to the indicator to be queried according to the SQL script for retrieving the data list.

[0098] Reference Figure 3 The diagram illustrates the architecture of a report management system provided in an embodiment of this application. The device includes an indicator management module and an indicator application module. Specifically, the indicator management module is used to manage indicators, and the indicator application module is used to apply indicators.

[0099] The indicator management module is used to create indicators and determine the SQL script that represents the logical relationship of each business process for each indicator. Specifically, it includes business statistical granularity units and indicator factory units.

[0100] Among them, the business statistics granularity unit has business object management and business perspective management functions. The business object management function mainly manages the data of the target business and defines the basic data table. The business perspective management function mainly manages the business process logic. For example, it establishes a business process directory for the target business and configures information such as the source data source, source table, update cycle, publishing region, billing period field, and partition field for each business process in the business process directory.

[0101] The indicator factory unit includes functions such as atomic indicator management, business process management, business constraint management, statistical period management, and derived indicator management. Atomic indicator management manages basic indicators that do not reflect business processes. Business process management mainly determines the business process logic of indicators. Business constraint management mainly determines business constraints based on business rules. For example, the business constraints of an indicator whose basic indicator is a number can be a city or a landline. Statistical period management mainly manages the statistical time period of indicators. Derived indicator management mainly manages indicators. An indicator reflects two parts in the correspondence between the indicator and the business rules, including the basic indicator and the business constraint conditions. Indicators with business constraint conditions can reflect the business process logic of the indicator, which are called derived indicators.

[0102] The indicator application module is used to respond to a selection operation, determine multiple indicators corresponding to a target report and the data table model of the target report, parse the SQL scripts corresponding to each of the multiple indicators, and generate a target report in the form of the data table model based on the parsed business process logic relationship, through data orchestration of the instance tables corresponding to each of the multiple indicators; and to respond to a trigger operation for any indicator displayed on the target report, determine the indicator to be retrieved, generate the SQL script for the retrieval data list corresponding to the indicator to be retrieved, and read and display the data list corresponding to the indicator to be retrieved based on the SQL script for the retrieval data list.

[0103] The indicator application module includes a view management unit, a data orchestration unit, and an application unit. The view management unit has the functions of basic wide table management and view management. Through basic wide table management and view management, indicator instances are categorized by physical table and managed according to certain business views. After data orchestration and data fusion, reports are quickly generated by flexible combination. The application unit includes a data retrieval tool, a data mining tool, and a reporting tool. The data retrieval tool is used to obtain data according to SQL type commands. The reporting tool is used to display the final generated target report and display the SQL script for reverse lookup data list of each indicator in the target report.

[0104] This application also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the report generation method as described in the claims.

[0105] The various embodiments in this specification are described in a progressive manner, with each embodiment focusing on the differences from other embodiments. The same or similar parts between the various embodiments can be referred to each other.

[0106] Those skilled in the art will understand that embodiments of this application can be provided as methods, apparatus, or computer program products. Therefore, embodiments of this application can take the form of entirely hardware embodiments, entirely software embodiments, or embodiments combining software and hardware aspects. Furthermore, embodiments of this application can take the form of computer program products implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0107] This application describes embodiments with reference to flowchart illustrations and / or block diagrams of methods, terminal devices (systems), and computer program products according to embodiments of this application. It should be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing terminal device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal device, generate instructions for implementing the flowchart illustrations. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0108] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing terminal device to operate in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0109] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal equipment, causing a series of operational steps to be performed on the computer or other programmable terminal equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable terminal equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0110] Although preferred embodiments of the present application have been described, those skilled in the art, upon learning the basic inventive concept, can make other changes and modifications to these embodiments. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments as well as all changes and modifications falling within the scope of the embodiments of the present application.

[0111] Finally, it should be noted that in this document, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or terminal device that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or terminal device. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or terminal device that includes said element.

[0112] This document uses specific examples to illustrate the principles and implementation methods of this application. The descriptions of the above embodiments are only for the purpose of helping to understand the methods and core ideas of this application. At the same time, for those skilled in the art, there will be changes in the specific implementation methods and application scope based on the ideas of this application. Therefore, the content of this specification should not be construed as a limitation of this application.

Claims

1. A report generation method characterized by comprising: The method comprises: in response to a selection operation, determining a plurality of indicators corresponding to a target report and a data table model of the target report, each indicator corresponding to an SQL script representing a business process logical relationship, the SQL script corresponding to an instance table; obtaining the SQL script corresponding to each of the plurality of indicators, parsing the SQL script corresponding to each of the plurality of indicators, and determining the business process logical relationship between the plurality of indicators; according to the business process logical relationship, after data arrangement of the instance table corresponding to each of the plurality of indicators, generating and displaying the target report in the form of the data table model, including classifying the instance table corresponding to each of the plurality of indicators according to the business process logical relationship, creating a view application table through data arrangement, and generating and displaying the target report in the form of the data table model through report calling configuration and configuration conversion of the SQL script corresponding to the plurality of indicators, wherein the plurality of indicators in the target report correspond to a reverse data list SQL script; the method further comprises: in response to an indicator adding operation, obtaining a data extraction rule corresponding to the to-be-added indicator and a business rule corresponding to the to-be-added indicator; according to the business rule corresponding to the to-be-added indicator, obtaining a business process logical relationship corresponding to the business rule in a business dimension tree of the target business; according to the data extraction rule of the to-be-added indicator and the business process logical relationship corresponding to the to-be-added indicator, determining and storing an SQL script of the to-be-added indicator; parsing the SQL script of the to-be-added indicator through an SQL parser, and reading data to generate an instance table corresponding to the to-be-added indicator.

2. The method of claim 1, wherein, The method further comprises: analyzing the business dimensions of a target business to obtain a plurality of mutually different basic business rules of the target business; according to the plurality of mutually different basic business rules, composing a plurality of mutually different combined business rules; according to a business process logical relationship between the basic business rules and the combined business rules, constructing a business dimension tree.

3. The method of claim 1, wherein, After generating and displaying the target report in the form of the data table model, the method further comprises: in response to a trigger operation on any indicator displayed on the target report, determining a to-be-reversed indicator, generating a reverse data list SQL script corresponding to the to-be-reversed indicator, and pop-up displaying the reverse data list SQL script.

4. The method of claim 3, wherein, generating the reverse data list SQL script corresponding to the to-be-reversed indicator comprises: obtaining a business logical relationship of the to-be-reversed indicator; reversely parsing the SQL script of the to-be-reversed indicator, combining the business logical relationship of the to-be-reversed indicator, and determining a reverse data list SQL script corresponding to a data list corresponding to the to-be-reversed indicator.

5. The method of claim 3, wherein, The method further comprises: in response to a trigger operation on the reverse data list SQL script corresponding to the to-be-reversed indicator, reading and displaying a data list corresponding to the to-be-reversed indicator according to the reverse data list SQL script.

6. A report generating apparatus characterized by comprising: The device comprises: The selecting module is configured to determine, in response to a selection operation, a plurality of indexes corresponding to a target report and a data table model of the target report, each index corresponding to an SQL script representing a business process logical relationship, and the SQL script corresponding to an instance table; The parsing module is configured to obtain the SQL script corresponding to each of the plurality of indexes, parse the SQL script corresponding to each of the plurality of indexes, and determine the business process logical relationship between the plurality of indexes; The report generating module is configured to generate the target report in the form of the data table model for display by arranging data of the instance table corresponding to each of the plurality of indexes according to the business process logical relationship, including classifying the instance table corresponding to each of the plurality of indexes according to the business process logical relationship, creating a view application table by data arrangement, and generating the target report in the form of the data table model for display according to the configuration conversion of the SQL script corresponding to the plurality of indexes by report calling configuration, wherein the plurality of indexes in the target report correspond to a reverse lookup data list SQL script; The adding module is configured to obtain, in response to an index adding operation, a data obtaining rule corresponding to a to-be-added index and a business rule corresponding to a target business of the to-be-added index; The business relationship matching module is configured to obtain, according to the business rule corresponding to the to-be-added index, a business process logical relationship corresponding to the business rule in a business dimension tree of the target business; The SQL script generating module is configured to determine and store an SQL script of the to-be-added index according to the data obtaining rule of the to-be-added index and the business process logical relationship corresponding to the to-be-added index; The instance table generating module is configured to parse the SQL script of the to-be-added index by a SQL parser and read data to generate an instance table corresponding to the to-be-added index.

7. A report management system characterized by comprising: The system comprises: The index management module is configured to create indexes and determine an SQL script representing a business process logical relationship for each index, including obtaining, in response to an index adding operation, a data obtaining rule corresponding to a to-be-added index and a business rule corresponding to a target business of the to-be-added index, obtaining, according to the business rule corresponding to the to-be-added index, a business process logical relationship corresponding to the business rule in a business dimension tree of the target business, determining and storing an SQL script of the to-be-added index according to the data obtaining rule of the to-be-added index and the business process logical relationship corresponding to the to-be-added index, and parsing the SQL script of the to-be-added index by a SQL parser and reading data to generate an instance table corresponding to the to-be-added index. The index application module is configured to determine a plurality of indexes corresponding to the target report and a data table model of the target report in response to a selection operation, parse SQL scripts corresponding to the plurality of indexes respectively, generate and display the target report in the form of the data table model by data arrangement on instance tables corresponding to the plurality of indexes according to the business process logical relationship, including classifying the instance tables corresponding to the plurality of indexes according to the business process logical relationship, creating a view application table by data arrangement, generating and displaying the target report in the form of the data table model according to configuration conversion of the SQL scripts corresponding to the plurality of indexes by report calling configuration, and determining an index to be searched back in response to a trigger operation on any index displayed on the target report, generating a search-back data list SQL script corresponding to the index to be searched back, and reading and displaying data list corresponding to the index to be searched back according to the search-back data list SQL script.

8. A computer-readable storage medium, characterized in that, The computer program is stored on the computer readable storage medium and is executed by the processor to implement the report generation method according to any one of claims 1 to 5.

Images