CN113010591A - Report generation method, device and system based on application interface - Google Patents
Report generation method, device and system based on application interface Download PDFInfo
- Publication number
- CN113010591A CN113010591A CN202110301502.8A CN202110301502A CN113010591A CN 113010591 A CN113010591 A CN 113010591A CN 202110301502 A CN202110301502 A CN 202110301502A CN 113010591 A CN113010591 A CN 113010591A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- preset
- service
- configuration information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000009877 rendering Methods 0.000 claims abstract description 18
- 238000004364 calculation method Methods 0.000 claims description 42
- 238000012216 screening Methods 0.000 claims description 41
- 230000002776 aggregation Effects 0.000 claims description 9
- 238000004220 aggregation Methods 0.000 claims description 9
- 238000005553 drilling Methods 0.000 claims description 7
- 238000005259 measurement Methods 0.000 claims description 7
- 239000000126 substance Substances 0.000 claims description 3
- 238000012163 sequencing technique Methods 0.000 claims description 2
- 238000006116 polymerization reaction Methods 0.000 claims 1
- 238000005516 engineering process Methods 0.000 abstract description 15
- 239000000725 suspension Substances 0.000 abstract description 9
- 230000009286 beneficial effect Effects 0.000 abstract 1
- 238000011144 upstream manufacturing Methods 0.000 description 26
- 238000010586 diagram Methods 0.000 description 24
- 238000003860 storage Methods 0.000 description 20
- 238000004590 computer program Methods 0.000 description 11
- 230000008520 organization Effects 0.000 description 11
- 230000006870 function Effects 0.000 description 10
- 238000012545 processing Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 5
- 230000008901 benefit Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000011022 operating instruction Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000000547 structure data Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24554—Unary operations; Data partitioning operations
- G06F16/24556—Aggregation; Duplicate elimination
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/4401—Bootstrapping
- G06F9/4411—Configuring for operating with peripheral devices; Loading of device drivers
- G06F9/4413—Plug-and-play [PnP]
Abstract
The application discloses a report generation method, a report generation device and a report generation system based on an application interface. The method comprises the following steps: acquiring report configuration information; inquiring business data corresponding to the report configuration information from the data provider system through a standard service interface; summarizing the service data to obtain service summarized data, and configuring a graph and/or a table for the service summarized data in a preset format; and performing page rendering on the configured graph and/or table to generate a report. The beneficial effect of this application lies in: the data suspension technology is matched with the slot architecture for use, and the data suspension technology is utilized, so that resource-consuming operations such as data synchronization and the like are not needed, and the real-time performance and stability of data are ensured; the slot architecture of a unified standard service interface is adopted, the rapid access of each data provider system is supported, the plug and play is realized, and the implementation cost is greatly reduced.
Description
Technical Field
The application relates to the technical field of computers, in particular to a report generation method, a report generation device and a report generation system based on an application interface.
Background
In order to solve the problem of data sources, most of the existing report tools need to extract, convert and load data from a source end to a destination end through a data warehouse technology to perform data landing, and if a data source of one report comes from a plurality of systems, data needs to be extracted from each system respectively. In the prior art, a large amount of frequent data synchronization tasks exist, a large amount of network broadband is occupied, the real-time performance of data is influenced, one part of data is stored repeatedly, and resources are wasted.
In the prior art, when a reporting tool controls data rights, data such as an organization structure of a main data system generally needs to be stored in the local of the reporting system, and once the organization structure data changes, the data synchronization is not timely, the rights configuration is wrong, and data leakage may be caused.
Second, the reporting tool requires professional technical implementers to know the customer's business database tables. Because the implementer needs to sort the business logic of the report, understand the business and the database table structure of the client, and configure the corresponding chart in the report tool, the implementation period of the project is in direct proportion to the business complexity of the report, the implementation process is 1-2 months as short as 1 year as long. If complex logic is encountered, customization may be required, and implementation cost is very high.
Thirdly, the reporting tool must discard the existing reporting logic of the client system and realize the business logic again. The existing report forms of the client need to be developed or configured again according to the service if the existing report forms are reused in the traditional report form system.
Disclosure of Invention
In view of the above, the present application is proposed to provide a report generation method, apparatus and system based on application interface, which overcome the above problems or at least partially solve the above problems.
According to an aspect of the present application, a report generation method based on an application interface is provided, including:
acquiring report configuration information;
inquiring business data corresponding to the report configuration information from the data provider system through a standard service interface;
summarizing the service data to obtain service summarized data, and configuring a graph and/or a table for the service summarized data in a preset format;
and performing page rendering on the configured graph and/or table to generate a report.
Optionally, the obtaining report configuration information includes:
acquiring a report data source;
performing aggregate calculation on the report data source to obtain a calculation result;
screening the calculation result according to a preset condition to obtain a screening result;
and determining report configuration information according to the screening result.
Optionally, determining report configuration information according to the screening result includes:
at least one of sequencing rule setting, quantity limit setting and grouping condition setting is carried out on the screening results to obtain report configuration information;
optionally, the configuring of the graph and/or table with a preset format as the service summary data includes:
configuring a diagram and/or a table by taking a preset diagram type, a preset component or a preset project as service summary data;
the preset component comprises at least one of a coordinate axis, a grid, a title and a legend; the preset items comprise at least one of dimension, measurement, sorting, screening, drilling and linkage.
Optionally, before the step of obtaining report configuration information, the method further includes:
receiving standard service interface registration information of a data provider;
and performing standard service interface registration for the data provider system according to the registration information.
According to another aspect of the present application, there is provided a report generation apparatus based on an application interface, including:
the report configuration module is used for acquiring report configuration information;
the standard service interface module is used for inquiring business data corresponding to the report configuration information from the data provider system;
the chart configuration module is used for summarizing the service data to obtain service summarized data, and configuring a chart and/or a table for the service summarized data in a preset format;
and the page rendering module is used for performing page rendering on the configured graph and/or table to generate a report.
Optionally, the report configuration module is configured to obtain a report data source; the report form data source aggregation calculation method is used for performing aggregation calculation on the report form data source to obtain a calculation result; the device is used for screening the calculation result according to preset conditions to obtain a screening result; and the report configuration information is determined according to the screening result.
Optionally, the report configuration module is configured to perform at least one of arrangement rule setting, quantity limit setting, and grouping condition setting on the screening result to obtain report configuration information.
Optionally, the graph configuration module is configured to configure a graph and/or a table with a preset graph type, a preset component, or a preset item as the service summary data; the preset component comprises at least one of a coordinate axis, a grid, a title and a legend; the preset items comprise at least one of dimension, measurement, sorting, screening, drilling and linkage.
Optionally, the apparatus further comprises: the registration information receiving module is used for receiving the standard service interface registration information of the data provider;
and the interface registration module is used for registering the standard service interface for the data provider system according to the registration information.
According to another aspect of the present application, there is provided an application interface-based report generation system, including:
the report generation device based on the application interface and at least one data provider system; wherein the content of the first and second substances,
the report generating device based on the application interface is connected with at least one data provider system through at least one standard service interface module.
According to the technical scheme, the report configuration information is acquired, the data suspension technology and the slot architecture are utilized to query the business data corresponding to the report configuration information from the data provider system, and then the business data are summarized, so that the graph and/or the table can be configured for the business summarized data, and the report is generated. The technical scheme utilizes a data suspension technology to inquire the service data from the data provider system, thereby avoiding the problem of generating a data synchronization task with the data provider system, avoiding the problem of untimely data synchronization and ensuring the real-time performance of the service data; the service data is only stored in the data provider system, so that the stability and the safety of the service data are improved; the service data does not fall to the ground, so that the occupation of a network broadband is reduced, and the storage resources are saved; the technical scheme adopts a slot architecture of a uniform standard service interface, supports the rapid access of each data provider system, realizes plug and play and greatly reduces the implementation cost; the report tool can be called by other systems, so that the function of assembling other products by taking the report tool as the core of the integrated framework is realized, the data reuse is realized, and the reuse of report configuration information and chart configuration is realized.
The foregoing description is only an overview of the technical solutions of the present application, and in order to make the technical means of the present application more clearly understood, the present application may be implemented in accordance with the content of the description, and in order to make the above and other objects, features, and advantages of the present application more clearly understood, the following detailed description will be made with reference to the accompanying drawings.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the application. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
FIG. 1 illustrates a flow diagram of a report generation method based on an application interface according to an embodiment of the present application;
FIG. 2 illustrates a flowchart for obtaining report configuration information according to an embodiment of the present application;
FIG. 3 illustrates a flow diagram of a configuration diagram and/or table for traffic summary data in a predetermined format according to one embodiment of the present application;
FIG. 4 illustrates a flow diagram of a report generation method based on an application interface according to another embodiment of the present application;
FIG. 5 is a diagram illustrating an apparatus for report generation based on application interface according to an embodiment of the present application;
FIG. 6 illustrates a schematic diagram of an application interface based report generation system according to one embodiment of the present application;
fig. 7 shows a schematic structural diagram of an electronic device in an embodiment of the present application.
Detailed Description
Exemplary embodiments of the present application will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present application are shown in the drawings, it should be understood that the present application may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
The report forms are data dynamically displayed in forms such as tables and charts, and are widely applied to various fields such as finance, tax, traffic and the like. With the rapid development of computer technology, users can generate and display reports by utilizing the functions of computer data processing and interface design, so that the report development can realize the diversification of formats and the dynamism of data.
The report forms are used as basic measures and ways for enterprise management, are basic business requirements of enterprises, and are also the basis for implementing business intelligence strategies. In practical applications, rather than analyzing the business data of a single data provider system separately in different reporting tools, an enterprise should achieve a higher level of analysis capability by integrating the business data of the various data provider systems.
The idea of the application is that: by acquiring the report configuration information, querying the service data corresponding to the report configuration information from the data provider system by using a data suspension technology and a slot architecture, summarizing the service data, and configuring a graph and/or a table for the service summarized data, thereby generating the report.
Each data provider system can be loaded to the report tool through a standard service interface, and each data provider system stores business data required by a user for generating a report through the report tool. The business data not only comprises a data source corresponding to the report configuration information, but also comprises an organization structure based on the data source.
Fig. 1 is a flowchart illustrating a report generation method based on an application interface according to an embodiment of the present application, and as shown in fig. 1, the present embodiment at least includes the following steps S101 to S104:
and step S101, acquiring report configuration information.
The data suspension technology is utilized, so that the business data of the upstream data provider system does not fall into the report tool. In order to generate the report, the user needs to set report configuration information in the background of the report tool.
Data floating technology means that all business data is not stored in the reporting tool's local database, but is still stored in the upstream data provider system. The report tool inquires the service data from the data provider system, so that the problem that the report tool and the data provider system generate data synchronization tasks is solved, the problem that the data synchronization is not timely is avoided, and the real-time performance of the service data is ensured; the service data is only stored in the data provider system, so that the stability and the safety of the service data are improved; meanwhile, as the service data does not fall to the ground, the occupation of the network broadband is reduced, and the storage resource is saved.
The acquired report configuration information can be input by a user through a report tool background, or the user can select according to options given by a report tool background pre-selection frame.
Specifically, a user can input through a report tool background and configure Chinese name information, English name information, remark information and the like for a report;
since the data source required by the user and the organization structure based on the data source are stored in the upstream data provider system, the report tool background can show the data source and the organization structure based on the data source in the upstream data provider system through the pre-selection box. A user can configure a report data source and a logic architecture for the report according to options given by a report tool background preselection frame; or, the user can create a logic architecture meeting the needs of the user more flexibly according to actual needs.
And step S102, inquiring business data corresponding to the report configuration information from a data provider system through a standard service interface.
The method and the device adopt a slot architecture, and after a user sets report configuration information, a standard service interface inquires corresponding business data from a data provider system.
The slot architecture is a set of unified standard service interface specifications, and an upstream data provider system complies with the standard specifications and is automatically loaded to a reporting tool. Each set of slots is a standard set of application programming interfaces. The data provider system inserts the output of the data provider system on a slot framework like a plug-in through a standard service interface, namely, a report tool is conveniently accessed, a plug-and-play mode is realized, and the implementation cost is greatly reduced; meanwhile, the report tool can be called by other systems, so that the function of assembling other products by taking the report tool as the core of the integrated framework is realized, the data multiplexing is realized, and the multiplexing of report configuration information and chart configuration is realized.
The report data source configured for the report by the user corresponds to a data source in the upstream data provider system, and the logical architecture configured for the report by the user corresponds to a logical architecture created by the user or an organization architecture based on the data source in the upstream data provider system. After a user configures a report data source and a logic architecture for a report, the standard service interface inquires a corresponding data source from an upstream data provider system, or the corresponding data source and the organization architecture for the report tool to gather.
Step S103, summarizing the service data to obtain service summarized data, and configuring a diagram and/or a table for the service summarized data in a preset format.
After business data corresponding to the report configuration information is inquired from the upstream data provider system, the report tool summarizes the business data through a report calculation engine to obtain business summarized data, and a graph and/or a table are configured for the business summarized data in a preset format. The report calculation engine can be an Ethern intelligent contract processing engine embedded in the background of the report tool.
And step S104, performing page rendering on the configured graph and/or table to generate the report.
And (3) delivering the graphs and/or tables configured in the preset format to a page rendering module to render the page, wherein the page rendering module can select an Echart histogram component and the like, namely generating a report.
In order to facilitate the follow-up user to check or call the report, the generated report can be cached in a report pool.
From the above description, it can be seen that the present invention achieves the following technical effects:
in the embodiment of the application, report configuration information is acquired, business data corresponding to the report configuration information is inquired from a data provider system through a standard service interface, the business data is summarized to obtain business summarized data, a preset format is used for configuring a graph and/or a table of the business summarized data, page rendering is carried out on the configured graph and/or table, and the report is generated. The data suspension technology is matched with the slot architecture for use, and the data suspension technology is utilized, so that the problem that a report tool and a data provider system generate a data synchronization task is solved, the problem that data synchronization is not timely is avoided, and the real-time performance of service data is ensured; the service data is only stored in the data provider system, so that the stability and the safety of the service data are improved; the service data does not fall to the ground, so that the occupation of a network broadband is reduced, and the storage resources are saved; the slot architecture of a uniform standard service interface is adopted, the rapid access of each data provider system is supported, the plug and play is realized, and the implementation cost is greatly reduced; the report tool can be called by other systems, so that the function of assembling other products by taking the report tool as the core of the integrated framework is realized, the data reuse is realized, and the reuse of report configuration information and chart configuration is realized.
In some embodiments of the present application, as shown in fig. 2, the step S101 of obtaining report configuration information includes the following steps S201 to S204:
step S201, a report data source is obtained.
The user can configure the report data source for the report according to the options given by the report tool background preselection frame, and flexibly create the logic architecture according to the self requirement.
And step S202, carrying out aggregate calculation on the report data source to obtain a calculation result.
Specifically, a plurality of field columns included in the report data source are pulled, and the aggregation calculation types include summation, counting, average value, maximum value, minimum value, product, standard deviation and the like. And matching the corresponding aggregation calculation types for the field columns respectively to obtain calculation result columns of the field columns.
For example, a field column a1, a field column B1 and a field column C1 included in the report data source are pulled, a product calculation is performed on the field column a1, a count calculation is performed on the field column B1, and a sum calculation is performed on the field column C1, so that a product calculation result field column a2 of the field column a1, a count calculation result field column B2 of the field column B1 and a sum calculation result field column C2 of the field column C1 are obtained respectively.
It should be noted that the type of aggregate calculation is not limited to the above list, and various calculation formulas in the industry can be included in the above type of aggregate calculation. And the user can perform custom expansion on the aggregation calculation type according to actual needs.
And step S203, screening the calculation result according to preset conditions to obtain a screening result.
Specifically, the field columns included in the calculation result are pulled, and the preset conditions include equal to, not equal to, greater than or equal to, less than or equal to, including, not including, and the like. And respectively matching the plurality of field columns with corresponding preset conditions to obtain a screening result column of the plurality of field columns.
For example, the field column a2, the field column B2, and the field column C2 included in the calculation result are pulled, the condition screening is not included in the matching of the field column a2, the condition screening is not included in the matching of the field column B2, and the condition screening is equal to the matching of the field column C2, so that the screening result field column A3 of the field column a2, the screening result field column B3 of the field column B2, and the screening result field column C3 of the field column C2 are obtained, respectively.
It should be noted that the preset conditions are not limited to those listed above, and various screening methods in the industry can be included in the preset conditions. And the user can perform customized extension on the preset conditions according to actual needs.
It should also be noted that the above preset conditions can be flexibly combined to screen the calculation results.
For example, the preset conditions of the field column a2 and the field column B2 are logically and-combined, or the preset conditions of the field column a2 and the field column B2 are logically or-combined. By analogy, the description is omitted here.
And step S204, determining the report configuration information according to the screening result.
Specifically, a plurality of field columns included in the screening result are pulled, and at least one of the sorting rule setting, the quantity limit setting and the grouping condition setting is performed on the screening result to obtain report configuration information.
For example, the field column A3, the field column B3, and the field column C3 included in the filtering result are pulled, the sorting rule setting and result filtering setting are performed on the field column A3, the grouping condition setting and sorting rule setting are performed on the field column B3, and the grouping condition setting is performed on the field column C3, so that report configuration information is obtained.
Through the steps S202 to S204, the logic architecture created by the user according to the need of the user is realized.
In some optional embodiments, it should be noted that the above steps S202 to S204 are optional steps.
For example, if the report data source does not need to be subjected to aggregation calculation, step S202 may be omitted, and step S203 directly links step S201; for another example, if the report data source does not need to be subjected to aggregation calculation and screening, step S202 and step S203 may be omitted, and step S204 directly connects with step S201. By analogy, the description is omitted here.
In some embodiments of the present application, as shown in fig. 3, the step S103 includes, in a preset format, configuring the graph and/or the table for the service summary data, including:
step S301, configuring a diagram and/or a table for the service summary data by using a preset diagram type, a preset component or a preset item; the preset components comprise at least one of coordinate axes, grids, titles and legends; the preset items comprise at least one of dimension, measurement, sorting, screening, drilling and linkage.
And inquiring business information corresponding to the report configuration information from the data provider system through the standard service interface, summarizing the business information to obtain business summary information, and taking a preset chart type, a preset component or a preset item as a business summary data configuration chart and/or table.
The preset chart type can be a line chart, a pie chart, a column chart, an area chart and the like, and the user can perform self-defined expansion on the preset chart type according to actual needs.
The preset component comprises at least one of a coordinate axis, a grid, a title and a legend. For example, the user may preset the coordinate axis as a rectangular coordinate system or a polar coordinate system according to actual needs. The user can also perform custom expansion on the preset components according to actual needs, such as prompt information.
The preset items comprise at least one of dimension, measurement, sorting, screening, drilling and linkage. For example, the user can preset the dimension (X axis), the measurement (Y axis), the sorting mode, the filter, the drilling catalog, and the linkage mode according to the actual needs. The user can also perform custom expansion on the preset items according to actual needs.
It should be noted that when the preset items include more than one, the preset items can be flexibly combined into the service summary data configuration diagram and/or table. For example, a user may preset a dimension (X-axis) and two different metrics (Y-axis) to configure a graph and/or table for the service summary data according to actual needs.
In some embodiments of the present application, as shown in fig. 4, before the step of obtaining the report configuration information in step S101, the method further includes:
step S401, receiving standard service interface registration information of the data provider system.
The upstream data provider system is loaded on the report tool through a uniform standard service interface, and in order to ensure that the business data of the upstream data provider system is safer, the standard service interface can be registered as a precondition that the stored business data can be inquired.
Specifically, the data provider system may select a registration mode of the standard service interface according to actual needs, for example, register through the standard service interface itself, or send registration information of the standard service interface to the reporting tool through the third party terminal.
And step S402, performing standard service interface registration for the data provider system according to the registration information.
And the report tool receives the registration information of the standard service interface or receives the registration information sent by the third party terminal, and registers the standard service interface for the upstream data provider system. The business data stored in the registered upstream data provider system can be inquired by the report tool for subsequent summarization.
In some optional embodiments, in step S104, page rendering is performed on the configured graph and/or table, and after the step of generating the report, the method further includes:
and step S501, sharing the report to an intelligent terminal for displaying.
The intelligent terminal can be a WEB terminal, a mobile phone terminal, a PC terminal, a third party system and the like. The generated report can be directly shared to the intelligent terminal for displaying; or, the generated report can be cached in a report pool, and the corresponding report is displayed through a call request of the intelligent terminal.
The following describes in detail a user flow of the report generation method based on the application interface of the present application:
firstly, a user registers a standard service interface according to a registration mode selected by a data provider system.
And secondly, setting report configuration information by the user.
Thirdly, a user inquires business data corresponding to the report configuration information from the data provider system through a standard service interface;
fourthly, the user summarizes the service data through the report calculation engine to obtain service summarized data.
And fifthly, the user uses the preset chart type, the preset component or the preset project as a service summary data configuration chart and/or table.
And sixthly, directly checking the picture and/or the table by the user through the intelligent terminal, or calling the report cached in the report pool by the user through the intelligent terminal.
Fig. 5 is a schematic diagram illustrating an application interface-based report generation apparatus according to an embodiment of the present application, and as shown in fig. 5, the application interface-based report generation apparatus 500 of the present embodiment at least includes:
the report configuration module 510 is configured to obtain report configuration information.
The data suspension technology is utilized, so that the business data of the upstream data provider system does not fall into the report tool. In order to generate the report, the user needs to set report configuration information in the background of the report tool.
Data floating technology means that all business data is not stored in the reporting tool's local database, but is still stored in the upstream data provider system. The report tool inquires the service data from the data provider system, so that the problem that the report tool and the data provider system generate data synchronization tasks is solved, the problem that the data synchronization is not timely is avoided, and the real-time performance of the service data is ensured; the service data is only stored in the data provider system, so that the stability and the safety of the service data are improved; meanwhile, as the service data does not fall to the ground, the occupation of the network broadband is reduced, and the storage resource is saved.
The report configuration information can be input by the user through the report tool background, or the user can select according to options given by the report tool background preselected boxes.
Specifically, a user can input through a report tool background and configure Chinese name information, English name information, remark information and the like for a report;
since the data source required by the user and the organization structure based on the data source are stored in the upstream data provider system, the report tool background can show the data source and the organization structure based on the data source in the upstream data provider system through the pre-selection box. A user can configure a report data source and a logic architecture for the report according to options given by a report tool background preselection frame; or, the user can create a logic architecture meeting the needs of the user more flexibly according to actual needs.
And the at least one standard service interface module 520 is used for inquiring the service data corresponding to the report configuration information from the data provider system.
The method and the device adopt a slot architecture, and after a user sets report configuration information, a standard service interface inquires corresponding business data from a data provider system.
The slot architecture is a set of unified standard service interface specifications, and an upstream data provider system complies with the standard specifications and is automatically loaded to a reporting tool. Each set of slots is a standard set of application programming interfaces. The data provider system inserts the output of the data provider system on a slot framework like a plug-in through a standard service interface, namely, a report tool is conveniently accessed, a plug-and-play mode is realized, and the implementation cost is greatly reduced; meanwhile, the report tool can be called by other systems, so that the function of assembling other products by taking the report tool as the core of the integrated framework is realized, the data multiplexing is realized, and the multiplexing of report configuration information and chart configuration is realized.
The report data source configured for the report by the user corresponds to a data source in the upstream data provider system, and the logical architecture configured for the report by the user corresponds to a logical architecture created by the user or an organization architecture based on the data source in the upstream data provider system. After the user configures the report data source and the logical architecture for the report, the at least one standard service interface module 520 queries the corresponding data source and the organization architecture from the upstream data provider system for the report tool to summarize.
The graph configuration module 530 is configured to summarize the service data to obtain service summarized data, and configure a graph and/or a table for the service summarized data in a preset format.
After business data corresponding to the report configuration information is inquired from the upstream data provider system, the report tool summarizes the business data through a report calculation engine to obtain business summarized data, and a graph and/or a table are configured for the business summarized data in a preset format. The report calculation engine can be an Ethern intelligent contract processing engine embedded in the background of the report tool.
And the page rendering module 540 is configured to perform page rendering on the configured graph and/or table, and generate the report.
The graphs and/or tables configured in the preset format are delivered to the page rendering module 540 to render the page, and the page rendering module 540 may select the Echart histogram component, etc., i.e., generate the report.
In order to facilitate the follow-up user to check or call the report, the generated report can be cached in a report pool.
In some embodiments of the present application, the report configuration module 510 is configured to obtain a report data source; the report data source is used for carrying out aggregation calculation on the report data source to obtain a calculation result; the device is used for screening the calculation result under a preset condition to obtain a screening result; and the report configuration information is determined according to the screening result.
In some embodiments of the present application, the report configuration module 510 is configured to perform at least one of a sorting rule setting, a quantity limit setting, and a grouping condition setting on the screening result, so as to obtain the report configuration information.
In some embodiments of the present application, the apparatus further comprises:
and the registration information receiving module is used for receiving the standard service interface registration information of the data provider system.
The upstream data provider system is loaded on the reporting tool through at least one standard service interface module 520, and in order to make the business data of the upstream data provider system more secure, the standard service interface may be registered as a precondition that the stored business data can be queried.
Specifically, the data provider system may select a registration mode of the standard service interface according to actual needs, for example, register through the standard service interface itself, or send registration information of the standard service interface to the registration information receiving module through the third party terminal.
And the interface registration module is used for registering a standard service interface for the data provider system according to the registration information.
And the registration information receiving module receives registration information of the standard service interface or registration information sent by a third party terminal and registers the standard service interface for the upstream data provider system. The business data stored in the registered upstream data provider system can be inquired by at least one standard service interface module for subsequent summarization.
In some optional embodiments, the apparatus further comprises:
and the sharing module is used for sharing the report to the intelligent terminal for displaying.
Specifically, the intelligent terminal may be a WEB terminal, a mobile phone terminal, a PC terminal, a third party system, and the like. The generated report can be directly shared to the intelligent terminal for displaying; or, the generated report can be cached in a report pool, and the corresponding report is displayed through a checking or calling request of the intelligent terminal.
It should be noted that, the modules of the report generation apparatus based on the application interface in the foregoing embodiment correspond to the report generation method based on the application interface in the foregoing embodiment one by one, and the foregoing method can be implemented one by one, which is not described in detail herein.
Fig. 6 is a schematic diagram illustrating a report generation system based on an application interface according to an embodiment of the present application, and as shown in fig. 6, the report generation system 600 based on an application interface of the present embodiment at least includes:
the report generation device 500 based on the application interface and at least one data provider system 610; wherein the content of the first and second substances,
the application interface based report generating device 500 is connected with at least one data provider system 610 through at least one standard service interface module 520.
It should be noted that, in the system, reference may be made to the specific implementation of the report generation apparatus based on the application interface in the foregoing embodiment of the corresponding apparatus, and details of this embodiment are not described herein again.
Fig. 7 shows a schematic structural diagram of an electronic device according to an embodiment of the present application, and as shown in fig. 7, at a hardware level, the electronic device 700 includes a processor 710, and optionally further includes an internal bus 720, a network interface 730, and a memory 740. The Memory 740 may include a Memory, such as a Random-Access Memory (RAM), and may further include a non-volatile Memory, such as at least 1 disk Memory. Of course, the electronic device may also include hardware required for other services.
The processor, the network interface, and the memory may be connected to each other via an internal bus, which may be an ISA (Industry Standard Architecture) bus, a PCI (Peripheral Component Interconnect) bus, an EISA (Extended Industry Standard Architecture) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one double-headed arrow is shown in FIG. 7, but this does not indicate only one bus or one type of bus.
And the memory is used for storing programs. In particular, the program may include program code comprising computer operating instructions. The memory may include both memory and non-volatile storage and provides instructions and data to the processor.
The processor reads the corresponding computer program from the nonvolatile memory to the memory and then runs the computer program, and forms a report generation device based on the application interface on a logic level. The processor is used for executing the program stored in the memory and is specifically used for executing the following operations:
acquiring report configuration information;
inquiring business data corresponding to the report configuration information from a data provider system through a standard service interface;
summarizing the service data to obtain service summarized data, and configuring a graph and/or a table for the service summarized data in a preset format;
and performing page rendering on the configured graph and/or table to generate the report.
The method executed by the report generating apparatus based on application interface according to the embodiment of fig. 5 of the present application can be applied to the processor 710, or implemented by the processor. The processor may be an integrated circuit chip having signal processing capabilities. In implementation, the steps of the above method may be performed by integrated logic circuits of hardware in a processor or instructions in the form of software. The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but also Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components. The various methods, steps, and logic blocks disclosed in the embodiments of the present application may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in connection with the embodiments of the present application may be directly implemented by a hardware decoding processor, or implemented by a combination of hardware and software modules in the decoding processor. The software module may be located in ram, flash memory, rom, prom, or eprom, registers, etc. storage media as is well known in the art. The storage medium is located in a memory, and a processor reads information in the memory and completes the steps of the method in combination with hardware of the processor.
The electronic device may further execute the method executed by the report generation apparatus based on the application interface in fig. 5, and implement the function of the report generation apparatus based on the application interface in the embodiment shown in fig. 5, which is not described herein again in this embodiment of the present application.
An embodiment of the present application further provides a computer-readable storage medium, where the computer-readable storage medium stores one or more programs, where the one or more programs include instructions, and when the instructions are executed by an electronic device that includes multiple application programs, the instructions can cause the electronic device to perform the method performed by the application interface-based report generation apparatus in the embodiment shown in fig. 5, and are specifically configured to perform:
acquiring report configuration information;
inquiring business data corresponding to the report configuration information from a data provider system through a standard service interface;
summarizing the service data to obtain service summarized data, and configuring a graph and/or a table for the service summarized data in a preset format;
and performing page rendering on the configured graph and/or table to generate the report.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, apparatus, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A report generation method based on an application interface is characterized by comprising the following steps:
acquiring report configuration information;
inquiring business data corresponding to the report configuration information from a data provider system through a standard service interface;
summarizing the service data to obtain service summarized data, and configuring a graph and/or a table for the service summarized data in a preset format;
and performing page rendering on the configured graph and/or table to generate the report.
2. The report generation method based on the application interface of claim 1, wherein the acquiring report configuration information comprises:
acquiring a report data source;
performing polymerization calculation on the report data source to obtain a calculation result;
screening the calculation result under a preset condition to obtain a screening result;
and determining the report configuration information according to the screening result.
3. The report generation method based on the application interface of claim 2, wherein the determining the report configuration information according to the screening result comprises:
at least one of sequencing rule setting, quantity limit setting and grouping condition setting is carried out on the screening result to obtain report configuration information;
4. the report generation method based on the application interface according to claim 1, wherein the configuring the graph and/or the table for the service summary data in the preset format comprises:
configuring a graph and/or a table by taking a preset graph type, a preset component or a preset item as the service summarized data;
the preset components comprise at least one of coordinate axes, grids, titles and legends; the preset items comprise at least one of dimension, measurement, sorting, screening, drilling and linkage.
5. The report generation method based on application interface of claim 1, wherein before the step of obtaining report configuration information, the method further comprises:
receiving standard service interface registration information of a data provider system;
and performing standard service interface registration for the data provider system according to the registration information.
6. A report generation device based on an application interface is characterized by comprising:
the report configuration module is used for acquiring report configuration information;
at least one standard service interface module, which is used for inquiring the business data corresponding to the report configuration information from a data provider system;
the chart configuration module is used for summarizing the service data to obtain service summarized data, and configuring a chart and/or a table for the service summarized data in a preset format;
and the page rendering module is used for performing page rendering on the configured graph and/or table to generate the report.
7. The report generation apparatus based on application interface of claim 6, wherein the report configuration module is configured to obtain a report data source;
the report data source is used for carrying out aggregation calculation on the report data source to obtain a calculation result;
the device is used for screening the calculation result under a preset condition to obtain a screening result;
and the report configuration information is determined according to the screening result.
8. The report generation device based on the application interface according to claim 6, wherein the graph configuration module is configured to configure a graph and/or a table for the business summary data according to a preset graph type, a preset component or a preset item;
the preset components comprise at least one of coordinate axes, grids, titles and legends; the preset items comprise at least one of dimension, measurement, sorting, screening, drilling and linkage.
9. The report generating apparatus based on application interface according to claim 6, wherein the apparatus further comprises:
the registration information receiving module is used for receiving the standard service interface registration information of the data provider;
and the interface registration module is used for registering a standard service interface for the data provider system according to the registration information.
10. An application interface based report generation system, comprising the application interface based report generation apparatus according to any one of claims 6 to 9, and at least one data provider system; wherein the content of the first and second substances,
the report generating device based on the application interface is connected with at least one data provider system through at least one standard service interface module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110301502.8A CN113010591B (en) | 2021-03-22 | 2021-03-22 | Report generation method, device and system based on application interface |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110301502.8A CN113010591B (en) | 2021-03-22 | 2021-03-22 | Report generation method, device and system based on application interface |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113010591A true CN113010591A (en) | 2021-06-22 |
| CN113010591B CN113010591B (en) | 2024-04-19 |
Family
ID=76404092
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110301502.8A Active CN113010591B (en) | 2021-03-22 | 2021-03-22 | Report generation method, device and system based on application interface |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113010591B (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105760370A (en) * | 2014-12-14 | 2016-07-13 | 云南电力调度控制中心 | Plug-in type report framework technology |
| CN107562467A (en) * | 2017-07-26 | 2018-01-09 | 阿里巴巴集团控股有限公司 | Page rendering method, apparatus and equipment |
| CN107908659A (en) * | 2017-10-17 | 2018-04-13 | 深圳前海微众银行股份有限公司 | Data sheet collocation method, report platform and computer-readable recording medium |
| CN108366109A (en) * | 2018-02-01 | 2018-08-03 | 王晓峰 | A kind of meteorological data numerical forecast cloud shared platform and data sharing method |
| CN109189841A (en) * | 2018-07-24 | 2019-01-11 | 中国电力科学研究院有限公司 | A kind of multi-data source access method and system |
| CN109492056A (en) * | 2018-10-24 | 2019-03-19 | 江苏满运软件科技有限公司 | A kind of method and system of business intelligence data inquiry |
| CN110457294A (en) * | 2019-06-28 | 2019-11-15 | 阿里巴巴集团控股有限公司 | A kind of data processing method and device |
| CN110516217A (en) * | 2019-08-09 | 2019-11-29 | 济南浪潮数据技术有限公司 | A kind of auto report completing method and device |
| CN111881192A (en) * | 2020-08-03 | 2020-11-03 | 浪潮云信息技术股份公司 | Method and system for generating visual configuration report, electronic equipment and storage medium |
| CN112199404A (en) * | 2020-09-24 | 2021-01-08 | 建信金融科技有限责任公司 | Report creating method and device, electronic equipment and computer readable storage medium |
-
2021
- 2021-03-22 CN CN202110301502.8A patent/CN113010591B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105760370A (en) * | 2014-12-14 | 2016-07-13 | 云南电力调度控制中心 | Plug-in type report framework technology |
| CN107562467A (en) * | 2017-07-26 | 2018-01-09 | 阿里巴巴集团控股有限公司 | Page rendering method, apparatus and equipment |
| CN107908659A (en) * | 2017-10-17 | 2018-04-13 | 深圳前海微众银行股份有限公司 | Data sheet collocation method, report platform and computer-readable recording medium |
| CN108366109A (en) * | 2018-02-01 | 2018-08-03 | 王晓峰 | A kind of meteorological data numerical forecast cloud shared platform and data sharing method |
| CN109189841A (en) * | 2018-07-24 | 2019-01-11 | 中国电力科学研究院有限公司 | A kind of multi-data source access method and system |
| CN109492056A (en) * | 2018-10-24 | 2019-03-19 | 江苏满运软件科技有限公司 | A kind of method and system of business intelligence data inquiry |
| CN110457294A (en) * | 2019-06-28 | 2019-11-15 | 阿里巴巴集团控股有限公司 | A kind of data processing method and device |
| CN110516217A (en) * | 2019-08-09 | 2019-11-29 | 济南浪潮数据技术有限公司 | A kind of auto report completing method and device |
| CN111881192A (en) * | 2020-08-03 | 2020-11-03 | 浪潮云信息技术股份公司 | Method and system for generating visual configuration report, electronic equipment and storage medium |
| CN112199404A (en) * | 2020-09-24 | 2021-01-08 | 建信金融科技有限责任公司 | Report creating method and device, electronic equipment and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113010591B (en) | 2024-04-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106682097B (en) | Method and device for processing log data | |
| CN110162544B (en) | Heterogeneous data source data acquisition method and device | |
| CN110413634B (en) | Data query method, system, device and computer readable storage medium | |
| CN108170656B (en) | Template creating method, document creating method, rendering method and rendering device | |
| CN111124476B (en) | Business rule configuration and creation method and device | |
| CN110941657B (en) | Service data processing method and device | |
| CN111914520A (en) | Document collaborative editing method and device, computer device and storage medium | |
| CN111400387A (en) | Conversion method and device for import and export data, terminal equipment and storage medium | |
| CN109062906B (en) | Translation method and device for program language resources | |
| CN113495797A (en) | Message queue and consumer dynamic creation method and system | |
| CN109697234B (en) | Multi-attribute information query method, device, server and medium for entity | |
| CN113010591A (en) | Report generation method, device and system based on application interface | |
| CN112491943A (en) | Data request method, device, storage medium and electronic equipment | |
| CN111652580B (en) | Method and device for processing data of nodes | |
| CN110895544A (en) | Interface data processing method, device, system and storage medium | |
| CN110750271B (en) | Service aggregation, method and device for executing aggregated service and electronic equipment | |
| CN114138745A (en) | Data integration method and device, storage medium and processor | |
| CN112597105A (en) | Processing method of file associated object, server side equipment and storage medium | |
| CN113342806A (en) | Big data processing method and device, storage medium and processor | |
| CN113779120A (en) | Data query method, device, equipment and storage medium | |
| CN112182507A (en) | Data quality measuring method, device and equipment | |
| CN111597036A (en) | Server resource configuration method and device | |
| CN114691112A (en) | Data processing method and device and data processing server | |
| CN111597784A (en) | Information sending method, device, terminal equipment and medium | |
| CN117472372B (en) | Responsive form construction method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |