CN113888056A - Report generation method and device - Google Patents
Report generation method and device Download PDFInfo
- Publication number
- CN113888056A CN113888056A CN202111383269.9A CN202111383269A CN113888056A CN 113888056 A CN113888056 A CN 113888056A CN 202111383269 A CN202111383269 A CN 202111383269A CN 113888056 A CN113888056 A CN 113888056A
- Authority
- CN
- China
- Prior art keywords
- basic
- index
- basic index
- target
- report
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000004590 computer program Methods 0.000 claims description 12
- 238000003860 storage Methods 0.000 claims description 12
- 238000012163 sequencing technique Methods 0.000 claims description 7
- 238000007726 management method Methods 0.000 description 21
- 230000006870 function Effects 0.000 description 20
- 238000004891 communication Methods 0.000 description 15
- 238000010586 diagram Methods 0.000 description 14
- 238000004458 analytical method Methods 0.000 description 9
- 238000012545 processing Methods 0.000 description 9
- 238000011161 development Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 6
- 230000008859 change Effects 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 5
- 239000000872 buffer Substances 0.000 description 4
- 238000005553 drilling Methods 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 238000009826 distribution Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000007613 environmental effect Effects 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 239000011521 glass Substances 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000012482 interaction analysis Methods 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Educational Administration (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Game Theory and Decision Science (AREA)
- Artificial Intelligence (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The application provides a report generation method and a report generation device, which can be used in the financial field or other fields, and the method comprises the following steps: receiving a user login request, and outputting and displaying a plurality of basic indexes corresponding to the user login request, wherein the basic indexes are displayed after being sorted based on a preset priority sorting rule; and when a target basic index is received, generating a target report according to the target basic index, wherein the target basic index is at least one of the basic indexes. The method and the device can improve the automation degree and efficiency of report generation.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method and an apparatus for generating a report.
Background
The enterprise management report is used for managing the interior of an enterprise, and managers can obtain the current operating conditions of each department through the enterprise management report so as to guide the operation direction or correct improper operation, and the enterprise management report is used for providing service for enterprise production and operation. At present, in a common enterprise management report generation process, indexes are provided by managers, technicians use SQL statements to perform data summarization, and then the SQL statements are returned to different managers to perform statistics and analysis, office software such as EXCEL is used to generate reports, and then the people who perform summarization summarize each index in the reports, and finally the reports are displayed to the managers.
At present, the biggest technical defect of enterprise management report is overlarge labor consumption; the enterprise management report is formed by combining a plurality of indexes. The single-index designated process comprises index formulation, data query and summarization and finally data analysis, and management personnel and technical personnel are required to communicate and cooperate continuously. In the current enterprise management report generation process, managers need to continuously correct the definition, format and display header of the report, technicians need to continuously correct data query summary statements, and for the enterprise management report, a large amount of labor cost is consumed for operation and maintenance of the report.
Disclosure of Invention
Aiming at the problems in the prior art, the application provides a report generation method and device, which can improve the automation degree and efficiency of report generation.
In order to solve the technical problem, the present application provides the following technical solutions:
in a first aspect, the present application provides a report generating method, including:
receiving a user login request, and outputting and displaying a plurality of basic indexes corresponding to the user login request, wherein the basic indexes are displayed after being sorted based on a preset priority sorting rule;
and when a target basic index is received, generating a target report according to the target basic index, wherein the target basic index is at least one of the basic indexes.
Further, the receiving a user login request and outputting and displaying a plurality of basic indexes corresponding to the user login request includes:
receiving a user login request, and determining a plurality of basic indexes corresponding to the user login request;
acquiring the use frequency and the problem finding times corresponding to each basic index;
and sequencing the basic indexes according to the use frequency and the problem finding frequency corresponding to each basic index, and outputting and displaying.
Further, before the receiving the target basic index, the method further includes:
receiving a basic index creation request, the basic index creation request comprising: basic indexes to be created and corresponding user identifications, database information, SQL sentences, basic index descriptions and basic index public identifications;
and storing the basic indexes to be created and corresponding user identifications, database information, SQL sentences, basic index descriptions and basic index public identifications, and outputting and displaying the basic indexes to be created as basic indexes.
Further, the generating a target report according to the target basic index includes:
according to the target basic index, obtaining database information and SQL sentences corresponding to the report generation request;
determining the position of each target basic index in a target report according to a key concern list corresponding to the user identification in the user login request;
determining basic index data corresponding to each target basic index according to the database information and the SQL statement;
and generating the target report according to the basic index data corresponding to each target basic index and the position of each target basic index in the target report.
Further, the report generation method further includes:
and generating a dynamic trend line graph according to the respective corresponding use frequency of each target basic index in a preset time range, and outputting and displaying the dynamic trend line graph.
In a second aspect, the present application provides a report generating apparatus, including:
the system comprises a first receiving module, a second receiving module and a third receiving module, wherein the first receiving module is used for receiving a user login request, outputting and displaying a plurality of basic indexes corresponding to the user login request, and the basic indexes are displayed after being sorted based on a preset priority sorting rule;
and the report generation module is used for generating a target report according to the target basic index when the target basic index is received, wherein the target basic index is at least one of the plurality of basic indexes.
Further, the first receiving module includes:
the system comprises a receiving unit, a judging unit and a judging unit, wherein the receiving unit is used for receiving a user login request and determining a plurality of basic indexes corresponding to the user login request;
the acquisition unit is used for acquiring the use frequency and the problem finding times corresponding to each basic index;
and the sorting unit is used for sorting the basic indexes according to the use frequency and the problem finding frequency corresponding to each basic index and outputting and displaying the basic indexes.
Further, the report generating device further includes:
a second receiving module, configured to receive a basic index creation request, where the basic index creation request includes: basic indexes to be created and corresponding user identifications, database information, SQL sentences, basic index descriptions and basic index public identifications;
and the index generation module is used for storing the basic index to be created and the corresponding user identifier, database information, SQL (structured query language) statement, basic index description and basic index public identifier thereof, and outputting and displaying the basic index to be created as the basic index.
In a third aspect, the present application provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the report generating method when executing the program.
In a fourth aspect, the present application provides a computer-readable storage medium having stored thereon computer instructions, which when executed, implement the report generation method.
According to the technical scheme, the report generation method and device are provided. Wherein, the method comprises the following steps: receiving a user login request, and outputting and displaying a plurality of basic indexes corresponding to the user login request, wherein the basic indexes are displayed after being sorted based on a preset priority sorting rule; when a target basic index is received, a target report is generated according to the target basic index, wherein the target basic index is at least one of the basic indexes, and the automation degree and efficiency of report generation can be improved; specifically, the labor cost can be saved, the report generation time can be shortened, repeated development of similar functions can be avoided, and the development cost can be saved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flowchart illustrating a report generation method according to an embodiment of the present application;
FIG. 2 is a flowchart illustrating a report generation method according to another embodiment of the present application;
FIG. 3 is a flowchart illustrating a report generation method according to another embodiment of the present application;
FIG. 4 is a flow chart illustrating a basic index configuration process in an application example of the present application;
fig. 5 is a schematic structural diagram of a report generation apparatus in an embodiment of the present application;
fig. 6 is a schematic structural diagram of a report generation apparatus in an embodiment of the present application;
fig. 7 is a schematic block diagram of a system configuration of an electronic device according to an embodiment of the present application.
Detailed Description
In order to make those skilled in the art better understand the technical solutions in the present specification, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
In the prior art, the efficiency of generating the report is low due to the insufficient standardization capability of the report; one report is composed of indexes, basic indexes of an enterprise are probably basically stable and limited within a period of time, but the combination of the indexes can be endless; meanwhile, with the continuous development of science and technology, enterprises also continuously change the service management, mechanism and flow, and the basic indexes are also continuously changed.
Based on this, in order to solve the problems existing in the prior art, the present application provides a report generation method and apparatus, a user only needs to log in a cloud portal, and newly build or quote an existing basic index, so that the report configuration can be completed in a configuration manner; meanwhile, the basic indexes can be established by a plurality of users together and are continuously perfect, and as time goes on, the final customization of the management report only needs to arrange and combine the basic indexes in the basic index component resource pool according to the current market environment and the operation condition of an enterprise, so that the priority of the basic indexes is improved or reduced, and the management report is rapidly adjusted. Aiming at the problem that managers at different levels pay attention to different data dimensions, the data can be automatically subdivided and summarized according to different hierarchical structures according to user configuration, so that the managers at different levels can conveniently perform index reference and analysis; the report automatic pushing function can be provided, the use condition of basic indexes, the use condition of basic data sources and the like are automatically analyzed, a dynamic trend graph is formed, the combination of an analysis type report and a list-level report is realized, a manager can obtain the index list clearly, data analysis can be provided, and the reason of the index trend can be conveniently understood; and the basic indexes are recommended by combining the basic indexes and the problem risk numbers discovered by the associated data sources, so that the operation and maintenance of the management report forms a virtuous circle, and the manual operation and maintenance cost is reduced.
Based on this, in order to improve the automation degree and efficiency of report generation, the embodiment of the present application provides a report generation apparatus, which may be a server or a client device, where the client device may include a smart phone, a tablet electronic device, a network set-top box, a portable computer, a desktop computer, a Personal Digital Assistant (PDA), an in-vehicle device, an intelligent wearable device, and the like. Wherein, intelligence wearing equipment can include intelligent glasses, intelligent wrist-watch and intelligent bracelet etc..
In practical applications, the report generation part may be executed on the server side as described above, or all operations may be completed in the client device. The selection may be specifically performed according to the processing capability of the client device, the limitation of the user usage scenario, and the like. This is not a limitation of the present application. The client device may further include a processor if all operations are performed in the client device.
The client device may have a communication module (i.e., a communication unit), and may be communicatively connected to a remote server to implement data transmission with the server. The server may include a server on the task scheduling center side, and in other implementation scenarios, the server may also include a server on an intermediate platform, for example, a server on a third-party server platform that is communicatively linked to the task scheduling center server. The server may include a single computer device, or may include a server cluster formed by a plurality of servers, or a server structure of a distributed apparatus.
The server and the client device may communicate using any suitable network protocol, including network protocols not yet developed at the filing date of this application. The network protocol may include, for example, a TCP/IP protocol, a UDP/IP protocol, an HTTP protocol, an HTTPS protocol, or the like. Of course, the network Protocol may also include, for example, an RPC Protocol (Remote Procedure Call Protocol), a REST Protocol (Representational State Transfer Protocol), and the like used above the above Protocol.
It should be noted that the report generation method and apparatus disclosed in the present application can be used in the field of financial technology, and can also be used in any field other than the field of financial technology.
The following examples are intended to illustrate the details.
In order to improve the automation degree and efficiency of report generation, the present embodiment provides a report generation method in which the execution subject is a report generation apparatus, where the report generation apparatus includes but is not limited to a server, as shown in fig. 1, the method specifically includes the following contents:
step 100: receiving a user login request, and outputting and displaying a plurality of basic indexes corresponding to the user login request, wherein the basic indexes are displayed after being sorted based on a preset priority sorting rule.
Specifically, the multiple basic indexes corresponding to the user login request may be accessible basic indexes of a login user corresponding to the user login request; the corresponding basic indexes of different users can be inconsistent; the basic index can be a column name in a generated report; for example, for an enterprise management daily report, the basic indicators may include: date, customer name, product number, sales volume, sales amount, etc.
Step 200: and when a target basic index is received, generating a target report according to the target basic index, wherein the target basic index is at least one of the basic indexes.
Specifically, a basic index selected by a user on a front-end page can be received, and the basic index is used as a target basic index; the target report may be an enterprise management daily report.
As can be seen from the above description, in the report generation method provided in this embodiment, a user login request is received, and a plurality of basic indexes corresponding to the user login request are output and displayed, where the plurality of basic indexes are displayed after being sorted based on a preset priority sorting rule; when a target basic index is received, a target report is generated according to the target basic index, wherein the target basic index is at least one of the basic indexes, and the automation degree and efficiency of report generation can be improved; specifically, different basic indexes can be output and displayed according to different login users, the recommendation flexibility of the basic indexes is improved, meanwhile, the basic indexes can be sequenced, the recommendation sequence is determined, the user can select the basic indexes conveniently, and the generation efficiency of the report can be improved.
In order to improve the accuracy of recommending the basic indexes, the basic indexes are sorted according to the use frequency and the number of times of finding problems, so that a user can conveniently select the basic indexes, and further the efficiency of generating a report is improved, referring to fig. 2, in an embodiment of the present application, step 100 includes:
step 101: receiving a user login request, and determining a plurality of basic indexes corresponding to the user login request.
Step 102: and acquiring the use frequency and the problem finding times corresponding to each basic index.
Specifically, the frequency of generating a report by selecting a basic index by a user in a preset time period may be used as the frequency of using the basic index, and the frequency of determining an enterprise problem, such as failure in deployment due to environmental abnormality, program deadlock due to unreasonable code configuration parameters, and the like, according to the basic index in the report generated in the preset time period may be used as the frequency of finding a problem corresponding to the basic index; the preset time period can be set according to actual needs, and the application is not limited to this.
Step 103: and sequencing the basic indexes according to the use frequency and the problem finding frequency corresponding to each basic index, and outputting and displaying.
Specifically, weights corresponding to the use frequency and the number of times of finding the problem can be set according to actual needs, a weighted sum of the basic indexes is obtained according to the use frequency, the number of times of finding the problem and the respective weights corresponding to the basic indexes, the basic indexes are sorted from high to low according to the weighted sum of the basic indexes, and the basic indexes can be arranged and displayed on a front-end page according to sorting results.
In order to improve the flexibility of the basic index combination, and combine the new basic index with the existing basic index to generate the report, so as to improve the flexibility of generating the report, referring to fig. 3, in an embodiment of the present application, before step 200, the method further includes:
step 021: receiving a basic index creation request, the basic index creation request comprising: and the basic indexes to be created and the corresponding user identifications, database information, SQL statements, basic index descriptions and basic index public identifications thereof.
Specifically, database information, SQL statements, basic indexes, basic index descriptions and basic index public identifications transmitted by a user from a front-end page can be received; the database information may include a database address, a database type, a database port number, an instance name, and the like; the SQL statement can be used for acquiring basic index data corresponding to the basic index to be created according to a data table in a database; the basic index to be created can be a basic index name, namely a column name corresponding to the report, and the basic index description can be used for describing the function of the basic index; the basic index public mark is used for determining whether the basic index public mark is displayed only for the user corresponding to the user mark or displayed for all users, for example, the basic index public mark is '0', which indicates that the basic index public mark is displayed only for the user corresponding to the user mark, the basic index public mark is '1', which can indicate that all users are displayed, and the user mark user distinguishes different users, such as user names; the user identifier may be a user identifier in the user login request.
Step 022: and storing the basic indexes to be created and corresponding user identifications, database information, SQL sentences, basic index descriptions and basic index public identifications, and outputting and displaying the basic indexes to be created as basic indexes.
Specifically, when the basic indexes are displayed, the newly created basic indexes can be arranged in front of the basic indexes corresponding to the user login request, so that the user can select the basic indexes conveniently.
Referring to fig. 4, in an application example, the process of configuring the basic index specifically includes:
s1: a user logs in a cloud portal; s2: initiating a basic index configuration adding/modifying request; s3: determining whether to use the disclosed basic index, if yes, executing step S4: introducing the disclosed basic indexes, otherwise, executing the step S6; step S5: judging whether the introduced published basic indexes need to be modified, if so, executing the step S6: the user self-defines the configuration as a new basic index, otherwise, the step S7 is executed; s7: and judging whether the basic indexes are finished, if so, ending, wherein all the currently configured basic indexes can be equivalent to the target basic indexes, and otherwise, returning to execute the step S6.
In order to comply with the change of market environment and demand, the combination and priority of the indexes in the managed report need to be frequently modified so that the data finally presented to the manager is correct and can really reflect the problems existing in the current enterprise development, and such enterprise managed report has guiding significance for the decision of the manager, based on which, in order to facilitate the following report analysis, in an embodiment of the present application, the generating of the target report according to the target basic index in step 200 includes:
step 201: and obtaining the database information and the SQL statement corresponding to the report generation request according to the target basic index.
Step 202: and determining the position of each target basic index in the target report according to the key concern list corresponding to the user identifier in the user login request.
Specifically, the basic indicators of key concern of different departments in an enterprise are different, and the sequence is also different; determining a department corresponding to the user identifier according to the corresponding relationship between the user identifier and the department, and determining a key attention item list corresponding to the user identifier in the user login request according to the corresponding relationship between the department and the key attention item list; each focused attention item list may include a plurality of basic indexes, and may be sorted according to the degree of influence on the department, and the focused attention item list may be set according to an actual situation, which is not limited in the present application.
Step 203: and determining the basic index data corresponding to each target basic index according to the database information and the SQL statement.
Step 204: and generating the target report according to the basic index data corresponding to each target basic index and the position of each target basic index in the target report.
In order to facilitate the following analysis of the report, in an embodiment of the present application, the report generating method further includes:
and generating a dynamic trend line graph according to the respective corresponding use frequency of each target basic index in a preset time range, and outputting and displaying the dynamic trend line graph.
Specifically, the dynamic trend line graph may be added to the target report; the preset time range may be set according to actual conditions, which is not limited in this application. For example, the dynamic trend line graph may be plotted on the abscissa with time and on the ordinate with the usage frequency of the target base indicator per month.
To further illustrate the present solution, the present application provides an application example of a report generation method, which is specifically described as follows:
(1) a user logs in a cloud portal, can directly establish a basic index according to own requirements to complete index definition, data configuration and the like, or quote the existing public basic index according to a data distribution diagram and a trend diagram of the basic index utilization rate and the like.
(2) The user introduces all required base metrics.
(3) And finishing the definition of the report, the combination and the sequencing of all the basic indexes, and creating the report.
(4) And setting report pushing frequency.
(5) And trial is carried out once, report form preview is carried out, and if the report form preview is confirmed that the report form preview does not need to be modified, report form configuration is completed.
In terms of software, in order to improve the automation degree and efficiency of report generation, the present application provides an embodiment of a report generation apparatus for implementing all or part of the contents in the report generation method, and referring to fig. 5, the report generation apparatus specifically includes the following contents:
a first receiving module 10, configured to receive a user login request, and output and display a plurality of basic indexes corresponding to the user login request, where the basic indexes are displayed after being sorted based on a preset priority sorting rule;
and the report generating module 20 is configured to generate a target report according to the target basic index when the target basic index is received, where the target basic index is at least one of the multiple basic indexes.
In an embodiment of the present application, the first receiving module includes:
the system comprises a receiving unit, a judging unit and a judging unit, wherein the receiving unit is used for receiving a user login request and determining a plurality of basic indexes corresponding to the user login request;
the acquisition unit is used for acquiring the use frequency and the problem finding times corresponding to each basic index;
and the sorting unit is used for sorting the basic indexes according to the use frequency and the problem finding frequency corresponding to each basic index and outputting and displaying the basic indexes.
In an embodiment of the present application, the report generating apparatus further includes:
a second receiving module, configured to receive a basic index creation request, where the basic index creation request includes: basic indexes to be created and corresponding user identifications, database information, SQL sentences, basic index descriptions and basic index public identifications;
and the index generation module is used for storing the basic index to be created and the corresponding user identifier, database information, SQL (structured query language) statement, basic index description and basic index public identifier thereof, and outputting and displaying the basic index to be created as the basic index.
The embodiment of the report generation apparatus provided in this specification may be specifically configured to execute the processing procedure of the embodiment of the report generation method, and the functions of the embodiment are not described herein again, and refer to the detailed description of the embodiment of the report generation method.
As shown in fig. 6, in an application example of the present application, the report generation apparatus mainly includes a cloud portal module, a custom configuration module, a data support module, and an interaction analysis module, which are described in detail as follows:
1) the cloud portal module is used for providing a unified portal for a user, the front end uses a technical framework of read + Ant Design, the front end is built based on an NGINX server, the rear end uses a technical framework of SpringBoot + Redis + Oracle, the rear end is built based on a Liberty middleware, and the cloud portal module is deployed on a PaaS cloud; the cloud portal module is mainly used for public basic index configuration display, public report preview, user-defined report preview and user-defined configuration display. Paas (platform as a service), which means platform as a service; a business model in which a server platform is provided as a service, a service provided by a program through a network is referred to as saas (software as a service), and a corresponding server platform or development environment in the cloud computing era is provided as a service in PaaS.
The administrator can check and modify the self-customized report form through logging in the portal, can preview other user-customized report forms, mutually borrows reference, and reuses the configured basic indexes by using the self-defined configuration module. The basic indexes are continuously improved on the cloud portal by different managers, and the customization of the final report only needs to recombine and prioritize the basic indexes according to the current market environment and the operation condition of an enterprise, so that a benign report generation operation mechanism is formed.
2) And the user-defined configuration module provides two functions of basic index configuration and report configuration.
The basic index configuration comprises the following steps: disclosing base index citation and self-defining base index configuration; i.e. the definition of a single index, corresponding to the data source and the presentation style of the index. After the basic index is customized, a manager builds the basic index through a portal, and defines the index, configures a data source, configures a data query statement, configures a data dimension, and performs configuration at regular time, the data source can be equivalent to a data table in a database, and for multiple data sources, a final data summarization rule needs to be formulated, for example, a first column of the data source a and a second column of the data source B intersect to obtain a first basic index. In addition, the basic index can be configured to be disclosed to other users according to the selection of the users, namely, the basic index is displayed in the cloud portal as a public basic index, other users can directly quote the public basic index in the portal as one item of the report form of the public basic index, and the reuse rate of the common index is improved, so that the report form management efficiency is improved.
The report configuration comprises the following steps: index configuration and push configuration; namely, the report definition corresponds to the index combination, the data dimension and the priority and the report final style configuration function. When the report is customized, the basic indexes and the public basic indexes customized by the user can be quoted, and the sequencing of all the basic indexes and the display of the final report are supported. With the change of time, the management requirements are continuously changed, and a user can directly modify the priority of each basic index by sequencing the basic indexes, so that report receiving personnel can timely master the latest management key data and make corresponding management scheme modification.
3) The data support module is mainly responsible for database communication, data summarization and data drilling; after the user customizes the basic index and configures the corresponding database information at the portal, the data support module performs database connection according to the type of the database and the corresponding configuration information, and feeds back the connection state to the portal so as to enable the user to sense. The data summarization is responsible for running the data query SQL statements configured by the user to form final data. In addition, the data source may relate to different databases, and may also source text documents, EXCEL, and the like in addition to database data, and therefore, data summarization also requires summarizing different data details according to a data summarization rule defined by a user to form final index data.
Data drilling is to automatically subdivide and summarize data according to different hierarchical structures, an initial data source of index data is generally detailed data, and concerned data dimensions are different for managers of different levels, so that after the full detailed data is obtained, data subdivision and summarization can be performed according to the data hierarchical dimensions configured in a custom configuration module by the managers. The data dimension finally displayed in the report is subject to the report configuration customized by the user, but the user can see the result drilled by the index data, so that managers at different levels can conveniently quote and analyze the index. Drilling is to change the dimension level and change the analyzed granularity; including drill up (roll up) and drill down (drill down); the upward drilling is to summarize the low-level detail data to the high-level summarized data in a certain dimension or reduce the dimension; refers to an analysis method for automatically generating an aggregation line.
4) And the interactive analysis module is responsible for report pushing, previewing display and analysis. Once the user finishes the report configuration, relevant indexes in the report are automatically operated according to the report generation time customized by the user, the customized report is generated and pushed, and once the user completes the report configuration and the report is not changed, the user can directly check and analyze data through the report pushed by the system. After the report is customized, the report can be directly operated once at the portal and previewed, and the user judges whether a part needing to be modified exists or not through previewing.
The report analysis function shows the sequencing and the proportion of the basic indexes in different dimensions such as the number of quoted basic indexes, the source data amount, the timeliness and the like in the current portal to the user. And automatically analyzing the use condition of the basic indexes, the use condition of the basic data source and the like, and displaying the use frequency of each basic index and data source in all indexes of each month by taking time as an abscissa to form a dynamic trend line graph. In addition, the final purpose of the index is to predict possible problems in advance, so that the basic index and the number of actually found problems are associated, the use frequency is taken as the recommendation basis of the basic index, and the basic index with high use frequency and more found problems is displayed in the module. One or more data sources are configured behind each single index, and the data sources of the commonly used indexes can be correspondingly recommended and sorted according to the use frequency of the indexes and the problem finding number.
For example, the manager uses the manual calling automatic case number X and the pipeline automatic calling automatic case number Y of each application as two public basic indexes and incorporates the two basic indexes into the daily weekly report index. As time goes on, it is found that many other managers bring the basic index Y into their own management reports, and the risk of the found problem is much higher than that of X, so that other users can obtain the information that the basic index Y may be more useful for actual management according to the displayed information after entering the portal; meanwhile, the utilization rate and distribution condition of the current basic indexes, common data sources and other information can be intuitively understood, and the current management key points can be mastered more quickly.
According to the description, the report generation method and the report generation device can improve the automation degree and efficiency of report generation; specifically, the labor cost can be saved, the report generation time can be shortened, repeated development of similar functions can be avoided, and the development cost can be saved.
In terms of hardware, in order to improve the automation degree and efficiency of report generation, the present application provides an embodiment of an electronic device for implementing all or part of contents in the report generation method, where the electronic device specifically includes the following contents:
a processor (processor), a memory (memory), a communication Interface (Communications Interface), and a bus; the processor, the memory and the communication interface complete mutual communication through the bus; the communication interface is used for realizing information transmission between the report generating device and related equipment such as a user terminal; the electronic device may be a desktop computer, a tablet computer, a mobile terminal, and the like, but the embodiment is not limited thereto. In this embodiment, the electronic device may be implemented with reference to the embodiment for implementing the report generating method and the embodiment for implementing the report generating apparatus in the embodiments, and the contents of the embodiments are incorporated herein, and repeated descriptions are omitted here.
Fig. 7 is a schematic block diagram of a system configuration of an electronic device 9600 according to an embodiment of the present application. As shown in fig. 7, the electronic device 9600 can include a central processor 9100 and a memory 9140; the memory 9140 is coupled to the central processor 9100. Notably, this fig. 7 is exemplary; other types of structures may also be used in addition to or in place of the structure to implement telecommunications or other functions.
In one or more embodiments of the present application, the report generation functionality can be integrated into the central processor 9100. The central processor 9100 may be configured to control as follows:
step 100: receiving a user login request, and outputting and displaying a plurality of basic indexes corresponding to the user login request, wherein the basic indexes are displayed after being sorted based on a preset priority sorting rule.
Step 200: and when a target basic index is received, generating a target report according to the target basic index, wherein the target basic index is at least one of the basic indexes.
From the above description, the electronic device provided in the embodiments of the present application can improve the automation degree and efficiency of report generation.
In another embodiment, the report generating apparatus may be configured separately from the central processor 9100, for example, the report generating apparatus may be configured as a chip connected to the central processor 9100, and the report generating function is realized by the control of the central processor.
As shown in fig. 7, the electronic device 9600 may further include: a communication module 9110, an input unit 9120, an audio processor 9130, a display 9160, and a power supply 9170. It is noted that the electronic device 9600 also does not necessarily include all of the components shown in fig. 7; further, the electronic device 9600 may further include components not shown in fig. 7, which may be referred to in the art.
As shown in fig. 7, a central processor 9100, sometimes referred to as a controller or operational control, can include a microprocessor or other processor device and/or logic device, which central processor 9100 receives input and controls the operation of the various components of the electronic device 9600.
The memory 9140 can be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information relating to the failure may be stored, and a program for executing the information may be stored. And the central processing unit 9100 can execute the program stored in the memory 9140 to realize information storage or processing, or the like.
The input unit 9120 provides input to the central processor 9100. The input unit 9120 is, for example, a key or a touch input device. Power supply 9170 is used to provide power to electronic device 9600. The display 9160 is used for displaying display objects such as images and characters. The display may be, for example, an LCD display, but is not limited thereto.
The memory 9140 can be a solid state memory, e.g., Read Only Memory (ROM), Random Access Memory (RAM), a SIM card, or the like. There may also be a memory that holds information even when power is off, can be selectively erased, and is provided with more data, an example of which is sometimes called an EPROM or the like. The memory 9140 could also be some other type of device. Memory 9140 includes a buffer memory 9141 (sometimes referred to as a buffer). The memory 9140 may include an application/function storage portion 9142, the application/function storage portion 9142 being used for storing application programs and function programs or for executing a flow of operations of the electronic device 9600 by the central processor 9100.
The memory 9140 can also include a data store 9143, the data store 9143 being used to store data, such as contacts, digital data, pictures, sounds, and/or any other data used by an electronic device. The driver storage portion 9144 of the memory 9140 may include various drivers for the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging applications, contact book applications, etc.).
The communication module 9110 is a transmitter/receiver 9110 that transmits and receives signals via an antenna 9111. The communication module (transmitter/receiver) 9110 is coupled to the central processor 9100 to provide input signals and receive output signals, which may be the same as in the case of a conventional mobile communication terminal.
Based on different communication technologies, a plurality of communication modules 9110, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, may be provided in the same electronic device. The communication module (transmitter/receiver) 9110 is also coupled to a speaker 9131 and a microphone 9132 via an audio processor 9130 to provide audio output via the speaker 9131 and receive audio input from the microphone 9132, thereby implementing ordinary telecommunications functions. The audio processor 9130 may include any suitable buffers, decoders, amplifiers and so forth. In addition, the audio processor 9130 is also coupled to the central processor 9100, thereby enabling recording locally through the microphone 9132 and enabling locally stored sounds to be played through the speaker 9131.
As can be seen from the above description, the electronic device provided in the embodiments of the present application can improve the automation degree and efficiency of report generation.
An embodiment of the present application further provides a computer-readable storage medium capable of implementing all the steps in the report generation method in the foregoing embodiment, where the computer-readable storage medium stores a computer program, and the computer program implements all the steps of the report generation method in the foregoing embodiment when being executed by a processor, for example, the processor implements the following steps when executing the computer program:
step 100: receiving a user login request, and outputting and displaying a plurality of basic indexes corresponding to the user login request, wherein the basic indexes are displayed after being sorted based on a preset priority sorting rule.
Step 200: and when a target basic index is received, generating a target report according to the target basic index, wherein the target basic index is at least one of the basic indexes.
From the above description, it can be seen that the computer-readable storage medium provided in the embodiments of the present application can improve the automation degree and efficiency of report generation.
In the present application, each embodiment of the method is described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. Reference is made to the description of the method embodiments.
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 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.
The principle and the implementation mode of the present application are explained by applying specific embodiments in the present application, and the description of the above embodiments is only used to help understanding the method and the core idea of the present application; meanwhile, for a person skilled in the art, according to the idea of the present application, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present application.
Claims (10)
1. A report generation method is characterized by comprising the following steps:
receiving a user login request, and outputting and displaying a plurality of basic indexes corresponding to the user login request, wherein the basic indexes are displayed after being sorted based on a preset priority sorting rule;
and when a target basic index is received, generating a target report according to the target basic index, wherein the target basic index is at least one of the basic indexes.
2. A report generation method according to claim 1, wherein the receiving a user login request and outputting and displaying a plurality of basic indexes corresponding to the user login request comprises:
receiving a user login request, and determining a plurality of basic indexes corresponding to the user login request;
acquiring the use frequency and the problem finding times corresponding to each basic index;
and sequencing the basic indexes according to the use frequency and the problem finding frequency corresponding to each basic index, and outputting and displaying.
3. A report generation method according to claim 1, further comprising, before said receiving a target base indicator:
receiving a basic index creation request, the basic index creation request comprising: basic indexes to be created and corresponding user identifications, database information, SQL sentences, basic index descriptions and basic index public identifications;
and storing the basic indexes to be created and corresponding user identifications, database information, SQL sentences, basic index descriptions and basic index public identifications, and outputting and displaying the basic indexes to be created as basic indexes.
4. A report generation method according to claim 1, wherein said generating a target report according to said target base index comprises:
according to the target basic index, obtaining database information and SQL sentences corresponding to the report generation request;
determining the position of each target basic index in a target report according to a key concern list corresponding to the user identification in the user login request;
determining basic index data corresponding to each target basic index according to the database information and the SQL statement;
and generating the target report according to the basic index data corresponding to each target basic index and the position of each target basic index in the target report.
5. A report generation method according to claim 1, further comprising:
and generating a dynamic trend line graph according to the respective corresponding use frequency of each target basic index in a preset time range, and outputting and displaying the dynamic trend line graph.
6. A report generation apparatus, comprising:
the system comprises a first receiving module, a second receiving module and a third receiving module, wherein the first receiving module is used for receiving a user login request, outputting and displaying a plurality of basic indexes corresponding to the user login request, and the basic indexes are displayed after being sorted based on a preset priority sorting rule;
and the report generation module is used for generating a target report according to the target basic index when the target basic index is received, wherein the target basic index is at least one of the plurality of basic indexes.
7. A report generation apparatus according to claim 6, characterized in that said first receiving module comprises:
the system comprises a receiving unit, a judging unit and a judging unit, wherein the receiving unit is used for receiving a user login request and determining a plurality of basic indexes corresponding to the user login request;
the acquisition unit is used for acquiring the use frequency and the problem finding times corresponding to each basic index;
and the sorting unit is used for sorting the basic indexes according to the use frequency and the problem finding frequency corresponding to each basic index and outputting and displaying the basic indexes.
8. A report generation apparatus according to claim 6, further comprising:
a second receiving module, configured to receive a basic index creation request, where the basic index creation request includes: basic indexes to be created and corresponding user identifications, database information, SQL sentences, basic index descriptions and basic index public identifications;
and the index generation module is used for storing the basic index to be created and the corresponding user identifier, database information, SQL (structured query language) statement, basic index description and basic index public identifier thereof, and outputting and displaying the basic index to be created as the basic index.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the report generating method according to any of claims 1 to 5 when executing the program.
10. A computer-readable storage medium having computer instructions stored thereon that, when executed, implement the report generation method of any of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111383269.9A CN113888056A (en) | 2021-11-22 | 2021-11-22 | Report generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111383269.9A CN113888056A (en) | 2021-11-22 | 2021-11-22 | Report generation method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113888056A true CN113888056A (en) | 2022-01-04 |
Family
ID=79015922
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111383269.9A Pending CN113888056A (en) | 2021-11-22 | 2021-11-22 | Report generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113888056A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111831636A (en) * | 2020-07-28 | 2020-10-27 | 平安国际融资租赁有限公司 | Data processing method, device, computer system and readable storage medium |
| CN112632122A (en) * | 2020-12-18 | 2021-04-09 | 平安普惠企业管理有限公司 | Report retrieval method, device, equipment and storage medium based on multiple indexes |
| CN112783468A (en) * | 2019-11-06 | 2021-05-11 | 北京沃东天骏信息技术有限公司 | Target object sorting method and device |
| CN113221522A (en) * | 2021-04-28 | 2021-08-06 | 北京达佳互联信息技术有限公司 | Report generation method, device, system, electronic equipment and storage medium |
-
2021
- 2021-11-22 CN CN202111383269.9A patent/CN113888056A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112783468A (en) * | 2019-11-06 | 2021-05-11 | 北京沃东天骏信息技术有限公司 | Target object sorting method and device |
| CN111831636A (en) * | 2020-07-28 | 2020-10-27 | 平安国际融资租赁有限公司 | Data processing method, device, computer system and readable storage medium |
| CN112632122A (en) * | 2020-12-18 | 2021-04-09 | 平安普惠企业管理有限公司 | Report retrieval method, device, equipment and storage medium based on multiple indexes |
| CN113221522A (en) * | 2021-04-28 | 2021-08-06 | 北京达佳互联信息技术有限公司 | Report generation method, device, system, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8539514B2 (en) | Workflow integration and portal systems and methods | |
| EP3907631B1 (en) | Applet processing method and apparatus, device and storage medium | |
| US20110238498A1 (en) | Service stage for subscription management | |
| US9509560B2 (en) | Unified configuration for cloud integration | |
| CN111367988A (en) | Data import method and device | |
| US10313421B2 (en) | Providing Odata service based on service operation execution flow | |
| KR101086620B1 (en) | Smart office system and server for managing the sames and method for managing the sames | |
| CN112346717A (en) | Micro service system creating method, device, equipment, medium and micro service system | |
| CN111897890A (en) | Financial business processing method and device | |
| EP3016044A1 (en) | Method, system and apparatus for network management based on business relationship information | |
| CN115688715A (en) | Report generation method and device and computer readable medium | |
| CN105468345A (en) | Method for remotely changing visit job at mobile phone end in fast moving consumer goods system | |
| CN113190229A (en) | Method and device for generating government affair page | |
| CN116828039A (en) | Questionnaire pushing method, questionnaire pushing device and electronic equipment | |
| CN112242909A (en) | Management template generation method and device, electronic equipment and storage medium | |
| CN113888056A (en) | Report generation method and device | |
| CN113434423B (en) | Interface testing method and device | |
| CN115495519A (en) | Report data processing method and device | |
| CN112102058A (en) | Management system parameter configuration method and device | |
| CN111241089B (en) | ERP system secondary development method, system, device and readable storage medium | |
| CN115409002A (en) | Method and device for obtaining report, electronic equipment and computer storage medium | |
| CN114968917A (en) | Method and device for rapidly importing file data | |
| US20140157150A1 (en) | Contextual collaboration | |
| CN111885180B (en) | Message issuing method and device | |
| CN113448830B (en) | Method and device for managing software information |
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 |