CN113591448A - Report generation method and device and storage medium - Google Patents

Report generation method and device and storage medium Download PDF

Info

Publication number
CN113591448A
CN113591448A CN202110888200.5A CN202110888200A CN113591448A CN 113591448 A CN113591448 A CN 113591448A CN 202110888200 A CN202110888200 A CN 202110888200A CN 113591448 A CN113591448 A CN 113591448A
Authority
CN
China
Prior art keywords
report
data
template
component
calculation result
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
Application number
CN202110888200.5A
Other languages
Chinese (zh)
Inventor
吕玉振
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Jingdong Technology Holding Co Ltd
Original Assignee
Jingdong Technology Holding Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Jingdong Technology Holding Co Ltd filed Critical Jingdong Technology Holding Co Ltd
Priority to CN202110888200.5A priority Critical patent/CN113591448A/en
Publication of CN113591448A publication Critical patent/CN113591448A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/20Natural language analysis
    • G06F40/205Parsing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/20Natural language analysis
    • G06F40/253Grammatical analysis; Style critique

Abstract

The present disclosure relates to a report generation method, apparatus and storage medium, the method comprising: receiving a report configuration request, wherein the report configuration request comprises: data demand indexes and data extraction indexes; determining a parameter configuration table and an executable file according to the data demand index and the data extraction index; calculating the executable file through a big data operation center to obtain a calculation result; and determining a report template according to the data extraction index, and generating a report according to the report template, the calculation result, the parameter configuration table and the component library. By adopting the technical means, the problems that in the prior art, the personalized requirements of the report can not be met for different users, and meanwhile, the report meeting the personalized requirements of the users can not be reused and the like are solved.

Description

Report generation method and device and storage medium
Technical Field
The present disclosure relates to the field of communications, and in particular, to a method and an apparatus for generating a report, and a storage medium.
Background
The report system needs to perform report statistics based on personalized and customized business requirements, but in the current report system scheme, in consideration of the fact that the report requirement amount in the early stage is small, in order to meet the purpose of rapid iterative development, a lighter development mode is used for performing report statistics. For example, ABS (i.e. asset securitization) reports are obtained by extracting data from the market layer of each ABS business system and calculating, and then pushing the data to the business system by means of push operation to complete the display of the front-end data results. In the current reporting system scheme: the report requirements of a service party or a product are difficult to obtain a statistical script in a short time and cannot provide a result quickly, so that the individualized requirements of the report cannot be met in time; customized reports based on individual requirements cannot be effectively recycled, wheels are repeatedly built according to the requirements of different report types, and the requirement of constructing report data by an abstract template cannot be met; due to the change of the report requirement input parameters, the manual modification of the script is time-consuming and labor-consuming, and the script needs to be re-counted.
In the course of implementing the disclosed concept, the inventors found that there are at least the following technical problems in the related art: the report form which can not meet the individual requirements of the report form for different users can not be reused, and the like.
Disclosure of Invention
In order to solve the above technical problem or at least partially solve the above technical problem, embodiments of the present disclosure provide a report generation method, an apparatus, and a storage medium, so as to solve at least the problems that in the prior art, personalized requirements of reports cannot be met for different users, and meanwhile, reports meeting the personalized requirements of users cannot be reused.
The purpose of the present disclosure is realized by the following technical scheme:
in a first aspect, an embodiment of the present disclosure provides a report generating method, including: receiving a report configuration request, wherein the report configuration request comprises: data demand indexes and data extraction indexes; determining a parameter configuration table and an executable file according to the data demand index and the data extraction index; calculating the executable file through a big data operation center to obtain a calculation result; and determining a report template according to the data extraction index, and generating a report according to the report template, the calculation result, the parameter configuration table and the component library.
In an exemplary embodiment, the determining a parameter configuration table and an executable file according to the data requirement index and the data extraction index includes: acquiring an index data table corresponding to the data demand index; calling a business type analysis service to determine a plurality of data types according to the data extraction indexes, and storing the plurality of data types through the index data table; and determining the parameter configuration table and the executable file according to the index data table in which the plurality of data types are stored.
In an exemplary embodiment, the performing, by the big data job center, a calculation process on the executable file to obtain a calculation result includes: sending the executable file to the big data operation center in a precompiled mode; calculating the executable file through the big data operation center to obtain a calculation result; and storing the calculation result in a temporary data table or storing the calculation result in a management data table of a data management system.
In an exemplary embodiment, after the computing process is performed on the executable file through the big data job center, and a computing result is obtained, the method further includes: calling a service type analysis service to determine a service type according to the report configuration request; calling a target component from the component library according to the service type, wherein the target component comprises: one or more business components and/or one or more technology components; and generating the report according to the report template, the calculation result, the parameter configuration table and the target component.
In one exemplary embodiment, before the calling the target component from the component library according to the service type, the method further comprises: respectively defining component attributes and component objects corresponding to each commonly used component; respectively packaging the component attributes and the component objects corresponding to each common component to obtain a plurality of common components; saving the plurality of commonly used components in the component library, wherein the plurality of commonly used components comprise the target component.
In an exemplary embodiment, after the computing process is performed on the executable file through the big data job center, and a computing result is obtained, the method further includes: calling a service type analysis service to determine a service type according to the report configuration request; building a construction project according to the service type, and adding one or more component classes to the construction project; determining a target component according to the build project after adding the one or more component classes, wherein the target component comprises: one or more business components and/or one or more technology components; and generating the report according to the report template, the calculation result, the parameter configuration table and the target component.
In an exemplary embodiment, before determining the report template according to the data extraction index, the method further includes: respectively defining template types and template layout information corresponding to each common template; respectively carrying out template building processing on the template type and the template layout information corresponding to each common template to obtain a plurality of common templates; and storing the plurality of common templates in the template library, wherein the plurality of common templates comprise the report template.
In an exemplary embodiment, after generating a report according to the report template, the calculation result, the parameter configuration table, and the component library, the method further includes: analyzing the report to obtain an abstract syntax tree; optimizing the abstract syntax tree to mark static nodes in the abstract syntax tree; rendering the abstract syntax tree marked with the static nodes to obtain a display report; and sending the display report to a display end, and displaying the display report at the display end.
In a second aspect, an embodiment of the present disclosure provides a report generating apparatus, including: the report configuration module is used for receiving a report configuration request, wherein the report configuration request comprises: data demand indexes and data extraction indexes; the determining module is used for determining a parameter configuration table and an executable file according to the data demand index and the data extraction index; the computing module is used for computing the executable file through the big data operation center to obtain a computing result; and the generating module is used for determining a report template according to the data extraction indexes and generating a report according to the report template, the calculation result, the parameter configuration table and the component library.
In a third aspect, embodiments of the present disclosure provide an electronic device. The electronic equipment comprises a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory are communicated with each other through the communication bus; a memory for storing a computer program; and a processor for implementing the report generation method or the image processing method when executing the program stored in the memory.
In a fourth aspect, embodiments of the present disclosure provide a computer-readable storage medium. The computer-readable storage medium has stored thereon a computer program which, when executed by a processor, implements the report generating method or the image processing method as described above.
Compared with the prior art, the technical scheme provided by the embodiment of the disclosure at least has part or all of the following advantages: receiving a report configuration request, wherein the report configuration request comprises: data demand indexes and data extraction indexes; determining a parameter configuration table and an executable file according to the data demand index and the data extraction index; calculating the executable file through a big data operation center to obtain a calculation result; and determining a report template according to the data extraction index, and generating a report according to the report template, the calculation result, the parameter configuration table and the component library. By adopting the technical means, the problems that in the prior art, the personalized requirements of the report can not be met for different users, and meanwhile, the report meeting the personalized requirements of the users can not be reused are solved, so that the efficiency of generating and using the report is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure.
In order to more clearly illustrate the embodiments of the present disclosure or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the related art will be briefly described below, and it is obvious for those skilled in the art to obtain other drawings without inventive exercise.
Fig. 1 schematically illustrates a hardware structure block diagram of a computer terminal of a report generation method according to an embodiment of the present disclosure;
FIG. 2 schematically illustrates a flow chart of a report generation method according to an embodiment of the present disclosure;
FIG. 3 schematically illustrates a flow chart of a method of validation of a computed result according to an embodiment of the disclosure;
FIG. 4 is a flow chart diagram schematically illustrating a report generation method according to an embodiment of the present disclosure;
fig. 5 schematically shows a block diagram of a report generation apparatus according to an embodiment of the present disclosure;
fig. 6 schematically shows a block diagram of an electronic device provided in an embodiment of the present disclosure.
Detailed Description
The present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments. It should be noted that, in the present disclosure, the embodiments and features of the embodiments may be combined with each other without conflict.
It should be noted that the terms "first," "second," and the like in the description and claims of the present disclosure and in the above-described drawings are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order.
The method embodiments provided by the embodiments of the present disclosure may be executed in a computer terminal or a similar computing device. Taking an example of running on a computer terminal, fig. 1 schematically shows a hardware structure block diagram of a computer terminal of a report generation method according to an embodiment of the present disclosure. As shown in fig. 1, a computer terminal may include one or more processors 102 (only one is shown in fig. 1), wherein the processors 102 may include but are not limited to a processing device such as a Microprocessor (MPU) or a Programmable Logic Device (PLD) and a memory 104 for storing data, and optionally, the computer terminal may further include a transmission device 106 for communication function and an input/output device 108, it is understood by those skilled in the art that the structure shown in fig. 1 is merely illustrative and not a limitation to the structure of the computer terminal, for example, the computer terminal may further include more or less components than those shown in fig. 1, or have equivalent functions or different configurations than those shown in fig. 1.
The memory 104 may be used to store a computer program, for example, a software program and a module of an application software, such as a computer program corresponding to the report generation method in the embodiment of the present disclosure, and the processor 102 executes various functional applications and data processing by running the computer program stored in the memory 104, so as to implement the method described above. The memory 104 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include memory located remotely from the processor 102, which may be connected to a computer terminal over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The transmission device 106 is used to receive or transmit data via a network. Specific examples of the network described above may include a wireless network provided by a communication provider of the computer terminal. In one example, the transmission device 106 includes a Network adapter (NIC) that can be connected to other Network devices through a base station to communicate with the internet. In one example, the transmission device 106 may be a Radio Frequency (RF) module, which is used to communicate with the internet in a wireless manner.
A report generation method is provided in the disclosed embodiment, fig. 2 schematically shows a flowchart of the report generation method in the disclosed embodiment, and as shown in fig. 2, the flowchart includes the following steps:
step S202, receiving a report configuration request, wherein the report configuration request comprises: data demand indexes and data extraction indexes;
step S204, determining a parameter configuration table and an executable file according to the data demand index and the data extraction index;
step S206, calculating the executable file through a big data operation center to obtain a calculation result;
and S208, determining a report template according to the data extraction index, and generating a report according to the report template, the calculation result, the parameter configuration table and the component library.
By the present disclosure, a report configuration request is received, wherein the report configuration request includes: data demand indexes and data extraction indexes; determining a parameter configuration table and an executable file according to the data demand index and the data extraction index; calculating the executable file through a big data operation center to obtain a calculation result; and determining a report template according to the data extraction index, and generating a report according to the report template, the calculation result, the parameter configuration table and the component library. By adopting the technical means, the problems that in the prior art, the personalized requirements of the report can not be met for different users, and meanwhile, the report meeting the personalized requirements of the users can not be reused are solved, so that the efficiency of generating and using the report is improved.
In step S204, there are a plurality of optional embodiments, one of which is: determining a parameter configuration table and an executable file according to the data demand indicator and the data extraction indicator, including: acquiring an index data table corresponding to the data demand index; calling a business type analysis service to determine a plurality of data types according to the data extraction indexes, and storing the plurality of data types through the index data table; and determining the parameter configuration table and the executable file according to the index data table in which the plurality of data types are stored.
The data demand index is used for indicating the service type and the template type of the report, and meanwhile, the index data table can be determined according to the data demand index. The data extraction index is used for indicating data needing to be acquired or extracted and related information of the data needing to be acquired or extracted, and the data extraction index can be used for determining a plurality of data types, such as whether the data belongs to a dynamic and static pool, a simulation pool, an asset service report and the like. The index data table is used for storing the plurality of data types, a configuration center is added in the embodiment of the disclosure, and the parameter configuration table and the executable file can be determined according to the index data table in which the plurality of data types are stored through the configuration center. Specifically, the statistical logic of the indexes is combed and the parameters needing to be changed are extracted: configuring the parameters to be configured in a parameter configuration table, and fixedly writing the parameters not to be changed in an executable file, wherein the executable file can be a script file. According to the embodiment of the present disclosure, the parameter configuration table and the executable file are obtained through the above steps.
In an optional embodiment, the configuration center comprises: configuring a report template, exporting strategy configuration, configuring a statistical script and configuring a service system; the report template configuration can abstract the report template from different display pages, and the fields in the report indexes are used as elements of the finest strength. And realizing the personalized requirements of the report through the configuration of the configuration center. The embodiment of the invention realizes the personalized demand of the report by adopting the report template configuration, the export strategy configuration, the statistic script configuration and the service system configuration of the configuration center in the report configuration interface according to the service type and the report data content corresponding to the template type in the report configuration list, thereby overcoming the technical problems that the personalized demand of the report in the prior art can not be timely met, the report demand of a service party or a product is difficult to obtain the statistic script in a short time and the result can not be rapidly provided, further meeting the personalized demand of the report and the report demand of the service party or the product can obtain the statistic script in a short time.
Fig. 3 schematically shows a flowchart of a method for confirming a calculation result according to an embodiment of the present disclosure, and as shown in fig. 3, the flowchart includes the following steps:
step S302, the executable file is sent to the big data operation center in a precompiled mode;
step S304, calculating the executable file through the big data operation center to obtain a calculation result;
step S306, storing the calculation result in a temporary data table, or storing the calculation result in a management data table of the data management system.
The executable file can be used as an access script, corresponding report data is inquired through the executable file, uploading of the executable file to the big data operation center is completed in a precompiled mode, and meanwhile execution frequency is configured. And storing the calculation result in a temporary data table or storing the calculation result in a management data table of a data management system according to the calculation result obtained by the calculation processing of the big data operation center. And when a report is generated according to the report template, the calculation result, the parameter configuration table and the component library in the subsequent process, acquiring the calculation result from a temporary data table or a management data table of a data management system.
In step S208, there are a plurality of optional embodiments, one of which is: after the executable file is calculated and processed through the big data operation center and a calculation result is obtained, the method further comprises the following steps: calling a service type analysis service to determine a service type according to the report configuration request; calling a target component from the component library according to the service type, wherein the target component comprises: one or more business components and/or one or more technology components; and generating the report according to the report template, the calculation result, the parameter configuration table and the target component.
Taking ABS as an example, the ABS, Asset-backed Securities, is a securitization of assets. The ABS traffic types include: white bar ABS, gold bar ABS, warranty ABS, gold alloy ABS, poor ABS, and the like. And calling a service type analysis service to determine the service type according to the report configuration request, wherein the service type can be determined according to the data demand index. And calling a target component from the component library according to the service type, and finally generating the report according to the report template, the calculation result, the parameter configuration table and the target component. Wherein the target assembly comprises: one or more business components and/or one or more technical components, wherein the business components comprise components such as an upstream business system and a data asset platform; technical components include JSF, JMQ (i.e., messaging system), and SGM (i.e., service monitoring governance) components. The corresponding service components and technical components can be called according to different service types. The business component and the technical component can assist the execution of the report statistical data according to the open platform supporting the big data.
Before calling a target component from the component library according to the service type, the method further comprises: respectively defining component attributes and component objects corresponding to each commonly used component; respectively packaging the component attributes and the component objects corresponding to each common component to obtain a plurality of common components; saving the plurality of commonly used components in the component library, wherein the plurality of commonly used components comprise the target component.
A component is a simple encapsulation of data and methods, and a component is a specific object. The components may have their own properties and methods. Attributes are simple visitors of component data, and methods are some simple and visible functions of a component. The use of components can enable drag-and-drop programming, fast property handling, and true object-oriented design. The common components in the component library can be obtained by packaging by a user, specifically, corresponding component attributes and component objects are defined for each common component, the component attributes and the component objects obtained by packaging and defining are packaged, and a plurality of common components can be obtained through the steps. And storing the plurality of commonly used components in the component library, and calling the target component from the component library when the target component needs to be called.
In step S208, there are a plurality of optional embodiments, one of which is: after the executable file is calculated and processed through the big data operation center and a calculation result is obtained, the method further comprises the following steps: calling a service type analysis service to determine a service type according to the report configuration request; building a construction project according to the service type, and adding one or more component classes to the construction project; determining a target component according to the build project after adding the one or more component classes, wherein the target component comprises: one or more business components and/or one or more technology components; and generating the report according to the report template, the calculation result, the parameter configuration table and the target component.
A component can be understood as a reusable module, which is a business object consisting of a set of processes, data encapsulation, and user interfaces. The components of the disclosed embodiments are of three types: the system comprises a composite component, an extension component and a user-defined component. A composite component: the existing various components are combined to form a new component, and the performance of the centralized component is centralized. An extension component: and deriving a new assembly from the entry of the assembly of the existing assembly, and adding new performance to the original assembly or changing the control energy of the original assembly. Self-defining the components: derived directly from the control class. The control class provides all the entry capabilities required by the component, including keyboard and mouse event handling.
When the target component needs to be called, the target component does not need to be called from the component library, and the target component can be automatically determined according to specific conditions. Specifically, under the condition of determining the service type, a construction project is built according to the service type, one or more component classes are added to the construction project, and a target component is determined according to the construction project after the one or more component classes are added. It should be noted that a component may also be composed of one class, or may be composed of multiple classes, or may be a complete application.
The report template comprises: monthly report forms, seasonal report forms, operation cycle report forms, dynamic and static pool statistical report forms, simulation pool report forms, refined analysis report forms, cash flow analysis report forms, cycle period exhausted report forms, quantitative analysis report forms and the like.
Before step S208 is executed, that is, before the report template is determined according to the data extraction index, the method further includes: respectively defining template types and template layout information corresponding to each common template; respectively carrying out template building processing on the template type and the template layout information corresponding to each common template to obtain a plurality of common templates; and storing the plurality of common templates in the template library, wherein the plurality of common templates comprise the report template.
The report template in the template library can be set up in advance by a user, and specifically comprises the following steps: and defining corresponding template types and template layout information for each common template, and performing template construction processing on the template types and the template layout information obtained by definition to obtain a plurality of common templates.
After step S208 is executed, that is, after a report is generated according to the report template, the calculation result, the parameter configuration table, and the component library, the method further includes: analyzing the report to obtain an abstract syntax tree; optimizing the abstract syntax tree to mark static nodes in the abstract syntax tree; rendering the abstract syntax tree marked with the static nodes to obtain a display report; and sending the display report to a display end, and displaying the display report at the display end.
The report is parsed into an AST (abstract syntax tree) first, and then a rendering function is generated using the AST. Since the static nodes of the abstract syntax tree do not need to be re-rendered all the time, an optimization operation is needed at this stage after the AST is generated and before the rendering function is generated: all static nodes are marked after AST traversal, so that when a node is updated, if the node is found to have the mark, the node is not re-rendered. Static node: that is, no variables are included in a tag, with no possibility of change. The abstract syntax tree includes text nodes and element nodes in addition to static nodes. And the rendering processing is to render the abstract syntax tree marked with the static nodes through a rendering function, and after rendering, a display report is obtained. The steps can be understood as three steps of analysis, optimization and rendering, and three modules can be abstracted out from the three contents to realize respective functions: a parser, an optimizer, and a renderer.
Optionally, a service background center is added in the embodiment of the present disclosure, where the service background center includes modules such as template management, index management, policy management, script management, notification management, settlement management, parameter management, and data authority management, and the maintenance of the report can be implemented through configuration of the service background center.
In order to better understand the technical solutions, the embodiments of the present disclosure also provide an alternative embodiment for explaining the technical solutions.
Fig. 4 schematically illustrates a flow chart of a matching rule modification of an embodiment of the present disclosure, as shown in fig. 4:
s402, receiving a report configuration request, wherein the report configuration request comprises: data demand indexes and data extraction indexes;
s404, acquiring an index data table corresponding to the data demand index;
s406, calling a service type analysis service to determine a plurality of data types according to the data extraction indexes, and storing the plurality of data types through the index data table;
s408, determining the parameter configuration table and the executable file according to the index data table in which the data types are stored;
s410, calculating the executable file through a big data operation center to obtain a calculation result;
s412, determining a report template according to the data extraction indexes, and determining a target assembly;
and S414, generating a report according to the report template, the calculation result, the parameter configuration table and the target component.
By the present disclosure, a report configuration request is received, wherein the report configuration request includes: data demand indexes and data extraction indexes; determining a parameter configuration table and an executable file according to the data demand index and the data extraction index; calculating the executable file through a big data operation center to obtain a calculation result; and determining a report template according to the data extraction index, and generating a report according to the report template, the calculation result, the parameter configuration table and the component library. By adopting the technical means, the problems that in the prior art, the personalized requirements of the report can not be met for different users, and meanwhile, the report meeting the personalized requirements of the users can not be reused are solved, so that the efficiency of generating and using the report is improved.
Through the above description of the embodiments, those skilled in the art can clearly understand that the method according to the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but the former is a better implementation mode in many cases. Based on such understanding, the technical solutions of the present disclosure or portions thereof that contribute to the prior art may be embodied in the form of a software product, where the computer software product is stored in a storage medium (such as a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, and an optical disk), and includes several instructions for enabling a terminal device (which may be a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present disclosure.
The present embodiment further provides a report generating device, which is used to implement the foregoing embodiments and preferred embodiments, and the description of the report generating device is omitted for brevity. As used below, the term "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated.
Fig. 5 schematically shows a block diagram of a report generation apparatus according to an alternative embodiment of the present disclosure, and as shown in fig. 5, the apparatus includes:
a receiving module 502, configured to receive a report configuration request, where the report configuration request includes: data demand indexes and data extraction indexes;
a determining module 504, configured to determine a parameter configuration table and an executable file according to the data requirement indicator and the data extraction indicator;
the calculation module 506 is configured to perform calculation processing on the executable file through the big data operation center to obtain a calculation result;
the generating module 508 is configured to determine a report template according to the data extraction index, and generate a report according to the report template, the calculation result, the parameter configuration table, and the component library.
By the present disclosure, a report configuration request is received, wherein the report configuration request includes: data demand indexes and data extraction indexes; determining a parameter configuration table and an executable file according to the data demand index and the data extraction index; calculating the executable file through a big data operation center to obtain a calculation result; and determining a report template according to the data extraction index, and generating a report according to the report template, the calculation result, the parameter configuration table and the component library. By adopting the technical means, the problems that in the prior art, the personalized requirements of the report can not be met for different users, and meanwhile, the report meeting the personalized requirements of the users can not be reused are solved, so that the efficiency of generating and using the report is improved.
Optionally, the determining module 504 is further configured to obtain an index data table corresponding to the data demand index; calling a business type analysis service to determine a plurality of data types according to the data extraction indexes, and storing the plurality of data types through the index data table; and determining the parameter configuration table and the executable file according to the index data table in which the plurality of data types are stored.
The data demand index is used for indicating the service type and the template type of the report, and meanwhile, the index data table can be determined according to the data demand index. The data extraction index is used for indicating data needing to be acquired or extracted and related information of the data needing to be acquired or extracted, and the data extraction index can be used for determining a plurality of data types, such as whether the data belongs to a dynamic and static pool, a simulation pool, an asset service report and the like. The index data table is used for storing the plurality of data types, a configuration center is added in the embodiment of the disclosure, and the parameter configuration table and the executable file can be determined according to the index data table in which the plurality of data types are stored through the configuration center. Specifically, the statistical logic of the indexes is combed and the parameters needing to be changed are extracted: configuring the parameters to be configured in a parameter configuration table, and fixedly writing the parameters not to be changed in an executable file, wherein the executable file can be a script file. According to the embodiment of the present disclosure, the parameter configuration table and the executable file are obtained through the above steps.
In an optional embodiment, the configuration center comprises: configuring a report template, exporting strategy configuration, configuring a statistical script and configuring a service system; the report template configuration can abstract the report template from different display pages, and the fields in the report indexes are used as elements of the finest strength. And realizing the personalized requirements of the report through the configuration of the configuration center. The embodiment of the invention realizes the personalized demand of the report by adopting the report template configuration, the export strategy configuration, the statistic script configuration and the service system configuration of the configuration center in the report configuration interface according to the service type and the report data content corresponding to the template type in the report configuration list, thereby overcoming the technical problems that the personalized demand of the report in the prior art can not be timely met, the report demand of a service party or a product is difficult to obtain the statistic script in a short time and the result can not be rapidly provided, further meeting the personalized demand of the report and the report demand of the service party or the product can obtain the statistic script in a short time.
Optionally, the computing module 506 is further configured to send the executable file to the big data job center in a precompiled manner; calculating the executable file through the big data operation center to obtain a calculation result; and storing the calculation result in a temporary data table or storing the calculation result in a management data table of a data management system.
The executable file can be used as an access script, corresponding report data is inquired through the executable file, uploading of the executable file to the big data operation center is completed in a precompiled mode, and meanwhile execution frequency is configured. And storing the calculation result in a temporary data table or storing the calculation result in a management data table of a data management system according to the calculation result obtained by the calculation processing of the big data operation center. And when a report is generated according to the report template, the calculation result, the parameter configuration table and the component library in the subsequent process, acquiring the calculation result from a temporary data table or a management data table of a data management system.
Optionally, the generating module 508 is further configured to invoke a service type analysis service, so as to determine a service type according to the report configuration request; calling a target component from the component library according to the service type, wherein the target component comprises: one or more business components and/or one or more technology components; and generating the report according to the report template, the calculation result, the parameter configuration table and the target component.
Taking ABS as an example, the ABS, Asset-backed Securities, is a securitization of assets. The ABS traffic types include: white bar ABS, gold bar ABS, warranty ABS, gold alloy ABS, poor ABS, and the like. And calling a service type analysis service to determine the service type according to the report configuration request, wherein the service type can be determined according to the data demand index. And calling a target component from the component library according to the service type, and finally generating the report according to the report template, the calculation result, the parameter configuration table and the target component. Wherein the target assembly comprises: one or more business components and/or one or more technical components, wherein the business components comprise components such as an upstream business system and a data asset platform; technical components include JSF, JMQ (i.e., messaging system), and SGM (i.e., service monitoring governance) components. The corresponding service components and technical components can be called according to different service types. The business component and the technical component can assist the execution of the report statistical data according to the open platform supporting the big data.
Optionally, the generating module 508 is further configured to define component attributes and component objects corresponding to each commonly used component, respectively; respectively packaging the component attributes and the component objects corresponding to each common component to obtain a plurality of common components; saving the plurality of commonly used components in the component library, wherein the plurality of commonly used components comprise the target component.
A component is a simple encapsulation of data and methods, and a component is a specific object. The components may have their own properties and methods. Attributes are simple visitors of component data, and methods are some simple and visible functions of a component. The use of components can enable drag-and-drop programming, fast property handling, and true object-oriented design. The common components in the component library can be obtained by packaging by a user, specifically, corresponding component attributes and component objects are defined for each common component, the component attributes and the component objects obtained by packaging and defining are packaged, and a plurality of common components can be obtained through the steps. And storing the plurality of commonly used components in the component library, and calling the target component from the component library when the target component needs to be called.
Optionally, the generating module 508 is further configured to invoke a service type analysis service, so as to determine a service type according to the report configuration request; building a construction project according to the service type, and adding one or more component classes to the construction project; determining a target component according to the build project after adding the one or more component classes, wherein the target component comprises: one or more business components and/or one or more technology components; and generating the report according to the report template, the calculation result, the parameter configuration table and the target component.
A component can be understood as a reusable module, which is a business object consisting of a set of processes, data encapsulation, and user interfaces. The components of the disclosed embodiments are of three types: the system comprises a composite component, an extension component and a user-defined component. A composite component: the existing various components are combined to form a new component, and the performance of the centralized component is centralized. An extension component: and deriving a new assembly from the entry of the assembly of the existing assembly, and adding new performance to the original assembly or changing the control energy of the original assembly. Self-defining the components: derived directly from the control class. The control class provides all the entry capabilities required by the component, including keyboard and mouse event handling.
When the target component needs to be called, the target component does not need to be called from the component library, and the target component can be automatically determined according to specific conditions. Specifically, under the condition of determining the service type, a construction project is built according to the service type, one or more component classes are added to the construction project, and a target component is determined according to the construction project after the one or more component classes are added. It should be noted that a component may also be composed of one class, or may be composed of multiple classes, or may be a complete application.
The report template comprises: monthly report forms, seasonal report forms, operation cycle report forms, dynamic and static pool statistical report forms, simulation pool report forms, refined analysis report forms, cash flow analysis report forms, cycle period exhausted report forms, quantitative analysis report forms and the like.
Optionally, the generating module 508 is further configured to respectively define a template type and template layout information corresponding to each common template; respectively carrying out template building processing on the template type and the template layout information corresponding to each common template to obtain a plurality of common templates; and storing the plurality of common templates in the template library, wherein the plurality of common templates comprise the report template.
The report template in the template library can be set up in advance by a user, and specifically comprises the following steps: and defining corresponding template types and template layout information for each common template, and performing template construction processing on the template types and the template layout information obtained by definition to obtain a plurality of common templates.
Optionally, the generating module 508 is further configured to parse the report to obtain an abstract syntax tree; optimizing the abstract syntax tree to mark static nodes in the abstract syntax tree; rendering the abstract syntax tree marked with the static nodes to obtain a display report; and sending the display report to a display end, and displaying the display report at the display end.
The report is parsed into an AST (abstract syntax tree) first, and then a rendering function is generated using the AST. Since the static nodes of the abstract syntax tree do not need to be re-rendered all the time, an optimization operation is needed at this stage after the AST is generated and before the rendering function is generated: all static nodes are marked after AST traversal, so that when a node is updated, if the node is found to have the mark, the node is not re-rendered. Static node: that is, no variables are included in a tag, with no possibility of change. The abstract syntax tree includes text nodes and element nodes in addition to static nodes. And the rendering processing is to render the abstract syntax tree marked with the static nodes through a rendering function, and after rendering, a display report is obtained. The steps can be understood as three steps of analysis, optimization and rendering, and three modules can be abstracted out from the three contents to realize respective functions: a parser, an optimizer, and a renderer.
Optionally, a service background center is added in the embodiment of the present disclosure, where the service background center includes modules such as template management, index management, policy management, script management, notification management, settlement management, parameter management, and data authority management, and the maintenance of the report can be implemented through configuration of the service background center.
It should be noted that, the above modules may be implemented by software or hardware, and for the latter, the following may be implemented, but not limited to: the modules are all positioned in the same processor; alternatively, the modules are respectively located in different processors in any combination.
Embodiments of the present disclosure provide an electronic device.
Fig. 6 schematically shows a block diagram of an electronic device provided in an embodiment of the present disclosure.
Referring to fig. 6, an electronic device 600 provided in the embodiment of the present disclosure includes a processor 601, a communication interface 602, a memory 603, and a communication bus 604, where the processor 601, the communication interface 602, and the memory 603 complete communication with each other through the communication bus 604; a memory 603 for storing a computer program; the processor 601 is configured to implement the steps in any of the above method embodiments when executing the program stored in the memory.
Optionally, the electronic apparatus may further include a transmission device and an input/output device, wherein the input/output device is connected to the processor.
Optionally, in this embodiment, the processor may be configured to execute the following steps by a computer program:
s1, receiving a report configuration request, wherein the report configuration request comprises: data demand indexes and data extraction indexes;
s2, determining a parameter configuration table and an executable file according to the data demand index and the data extraction index;
s3, calculating the executable file through the big data operation center to obtain a calculation result;
s4, determining a report template according to the data extraction index, and generating a report according to the report template, the calculation result, the parameter configuration table and the component library.
Embodiments of the present disclosure also provide a computer-readable storage medium. The computer-readable storage medium has stored thereon a computer program which, when executed by a processor, performs the steps of any of the method embodiments described above.
Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
s1, receiving a report configuration request, wherein the report configuration request comprises: data demand indexes and data extraction indexes;
s2, determining a parameter configuration table and an executable file according to the data demand index and the data extraction index;
s3, calculating the executable file through the big data operation center to obtain a calculation result;
s4, determining a report template according to the data extraction index, and generating a report according to the report template, the calculation result, the parameter configuration table and the component library.
The computer-readable storage medium may be contained in the apparatus/device described in the above embodiments; or may be present alone without being assembled into the device/apparatus. The computer-readable storage medium carries one or more programs which, when executed, implement the method according to an embodiment of the disclosure.
According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
Optionally, the specific examples in this embodiment may refer to the examples described in the above embodiments and optional implementation manners, and this embodiment is not described herein again.
It will be apparent to those skilled in the art that the modules or steps of the present disclosure described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented by program code executable by a computing device, such that they may be stored in a storage device and executed by a computing device, and in some cases, the steps shown or described may be performed in an order different than that described herein, or they may be separately fabricated into individual integrated circuit modules, or multiple ones of them may be fabricated into a single integrated circuit module. As such, the present disclosure is not limited to any specific combination of hardware and software.
The above description is only a preferred embodiment of the present disclosure and is not intended to limit the present disclosure, and various modifications and changes may be made to the present disclosure by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the principle of the present disclosure should be included in the protection scope of the present disclosure.

Claims (10)

1. A report generation method is characterized by comprising the following steps:
receiving a report configuration request, wherein the report configuration request comprises: data demand indexes and data extraction indexes;
determining a parameter configuration table and an executable file according to the data demand index and the data extraction index;
calculating the executable file through a big data operation center to obtain a calculation result;
and determining a report template according to the data extraction index, and generating a report according to the report template, the calculation result, the parameter configuration table and the component library.
2. The method of claim 1, wherein determining a parameter configuration table and an executable file from the data demand metric and the data extraction metric comprises:
acquiring an index data table corresponding to the data demand index;
calling a business type analysis service to determine a plurality of data types according to the data extraction indexes, and storing the plurality of data types through the index data table;
and determining the parameter configuration table and the executable file according to the index data table in which the plurality of data types are stored.
3. The method of claim 1, wherein the performing computation processing on the executable file through a big data operation center to obtain a computation result comprises:
sending the executable file to the big data operation center in a precompiled mode;
calculating the executable file through the big data operation center to obtain a calculation result;
and storing the calculation result in a temporary data table or storing the calculation result in a management data table of a data management system.
4. The method of claim 1, wherein generating a report from the report template, the calculation result, the parameter configuration table, and a component library comprises:
calling a service type analysis service to determine a service type according to the report configuration request;
calling a target component from the component library according to the service type, wherein the target component comprises: one or more business components and/or one or more technology components;
and generating the report according to the report template, the calculation result, the parameter configuration table and the target component.
5. The method of claim 4, wherein prior to said invoking a target component from said component library according to said service type, said method further comprises:
respectively defining component attributes and component objects corresponding to each commonly used component;
respectively packaging the component attributes and the component objects corresponding to each common component to obtain a plurality of common components;
saving the plurality of commonly used components in the component library, wherein the plurality of commonly used components comprise the target component.
6. The method of claim 1, wherein after the calculation processing is performed on the executable file through the big data job center, and a calculation result is obtained, the method further comprises:
calling a service type analysis service to determine a service type according to the report configuration request;
building a construction project according to the service type, and adding one or more component classes to the construction project;
determining a target component according to the build project after adding the one or more component classes, wherein the target component comprises: one or more business components and/or one or more technology components;
and generating the report according to the report template, the calculation result, the parameter configuration table and the target component.
7. The method of claim 1, wherein prior to determining a reporting model based on the data extraction metrics, the method further comprises:
respectively defining template types and template layout information corresponding to each common template;
respectively carrying out template building processing on the template type and the template layout information corresponding to each common template to obtain a plurality of common templates;
and storing the plurality of common templates in the template library, wherein the plurality of common templates comprise the report template.
8. The method of claim 1, wherein after generating a report from the report template, the calculation results, the parameter configuration table, and the component library, the method further comprises:
analyzing the report to obtain an abstract syntax tree;
optimizing the abstract syntax tree to mark static nodes in the abstract syntax tree;
rendering the abstract syntax tree marked with the static nodes to obtain a display report;
and sending the display report to a display end, and displaying the display report at the display end.
9. A report generation apparatus, comprising:
the report configuration module is used for receiving a report configuration request, wherein the report configuration request comprises: data demand indexes and data extraction indexes;
the determining module is used for determining a parameter configuration table and an executable file according to the data demand index and the data extraction index;
the computing module is used for computing the executable file through the big data operation center to obtain a computing result;
and the generating module is used for determining a report template according to the data extraction indexes and generating a report according to the report template, the calculation result, the parameter configuration table and the component library.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the method of any one of claims 1 to 8.
CN202110888200.5A 2021-08-03 2021-08-03 Report generation method and device and storage medium Pending CN113591448A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110888200.5A CN113591448A (en) 2021-08-03 2021-08-03 Report generation method and device and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110888200.5A CN113591448A (en) 2021-08-03 2021-08-03 Report generation method and device and storage medium

Publications (1)

Publication Number Publication Date
CN113591448A true CN113591448A (en) 2021-11-02

Family

ID=78254636

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110888200.5A Pending CN113591448A (en) 2021-08-03 2021-08-03 Report generation method and device and storage medium

Country Status (1)

Country Link
CN (1) CN113591448A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114116747A (en) * 2021-11-25 2022-03-01 北京力控元通科技有限公司 Production execution system data analysis method and device

Citations (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120191580A1 (en) * 2011-01-25 2012-07-26 Intuit Inc. Methods systems and computer program products for generating financial statement complying with accounting standard
US20150046366A1 (en) * 2013-08-09 2015-02-12 Lingua Next Technologies Pvt. Ltd Method And System For Batch Generation Of Reports
CN106293661A (en) * 2015-05-22 2017-01-04 阿里巴巴集团控股有限公司 The generation of pictorial statement, generation processing method and processing device
CN107885709A (en) * 2017-09-29 2018-04-06 深圳市共济科技股份有限公司 A kind of report form generation method, system and storage medium
CN107908631A (en) * 2017-07-25 2018-04-13 平安科技(深圳)有限公司 Data processing method, device, storage medium and computer equipment
CN107977351A (en) * 2017-12-28 2018-05-01 平安科技(深圳)有限公司 Electronic report forms generation method, device, computer equipment and storage medium
CN109254988A (en) * 2018-08-03 2019-01-22 京信通信系统(中国)有限公司 Report automatic test approach, device, computer storage medium and equipment
US20190228389A1 (en) * 2018-01-19 2019-07-25 Alibaba Group Holding Limited Fund flow report generation method and device
CN110717320A (en) * 2019-10-11 2020-01-21 上海管和信息科技有限公司 Form/report designer and method suitable for multiple platforms and information management system
CN111177231A (en) * 2019-12-20 2020-05-19 中国建设银行股份有限公司 Report generation method and report generation device
US20200175120A1 (en) * 2018-11-29 2020-06-04 International Business Machines Corporation Multiple parameter based composite rule data validation
CN111666743A (en) * 2020-04-28 2020-09-15 平安科技(深圳)有限公司 Report automatic generation method and device, computer equipment and storage medium
CN111680478A (en) * 2020-06-17 2020-09-18 华自科技股份有限公司 Configuration software based report generation method, device, equipment and storage medium
CN111797604A (en) * 2020-06-30 2020-10-20 深圳壹账通智能科技有限公司 Report generation method, device, equipment and computer readable storage medium
CN112861496A (en) * 2021-03-22 2021-05-28 平安商业保理有限公司 Report generation display method and device, computer equipment and readable storage medium
US11023667B1 (en) * 2019-12-20 2021-06-01 Veeva Systems Inc. System and method for generating and managing pseudo data fields in CRM

Patent Citations (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120191580A1 (en) * 2011-01-25 2012-07-26 Intuit Inc. Methods systems and computer program products for generating financial statement complying with accounting standard
US20150046366A1 (en) * 2013-08-09 2015-02-12 Lingua Next Technologies Pvt. Ltd Method And System For Batch Generation Of Reports
CN106293661A (en) * 2015-05-22 2017-01-04 阿里巴巴集团控股有限公司 The generation of pictorial statement, generation processing method and processing device
CN107908631A (en) * 2017-07-25 2018-04-13 平安科技(深圳)有限公司 Data processing method, device, storage medium and computer equipment
CN107885709A (en) * 2017-09-29 2018-04-06 深圳市共济科技股份有限公司 A kind of report form generation method, system and storage medium
CN107977351A (en) * 2017-12-28 2018-05-01 平安科技(深圳)有限公司 Electronic report forms generation method, device, computer equipment and storage medium
US20190228389A1 (en) * 2018-01-19 2019-07-25 Alibaba Group Holding Limited Fund flow report generation method and device
CN109254988A (en) * 2018-08-03 2019-01-22 京信通信系统(中国)有限公司 Report automatic test approach, device, computer storage medium and equipment
US20200175120A1 (en) * 2018-11-29 2020-06-04 International Business Machines Corporation Multiple parameter based composite rule data validation
CN110717320A (en) * 2019-10-11 2020-01-21 上海管和信息科技有限公司 Form/report designer and method suitable for multiple platforms and information management system
CN111177231A (en) * 2019-12-20 2020-05-19 中国建设银行股份有限公司 Report generation method and report generation device
US11023667B1 (en) * 2019-12-20 2021-06-01 Veeva Systems Inc. System and method for generating and managing pseudo data fields in CRM
CN111666743A (en) * 2020-04-28 2020-09-15 平安科技(深圳)有限公司 Report automatic generation method and device, computer equipment and storage medium
CN111680478A (en) * 2020-06-17 2020-09-18 华自科技股份有限公司 Configuration software based report generation method, device, equipment and storage medium
CN111797604A (en) * 2020-06-30 2020-10-20 深圳壹账通智能科技有限公司 Report generation method, device, equipment and computer readable storage medium
CN112861496A (en) * 2021-03-22 2021-05-28 平安商业保理有限公司 Report generation display method and device, computer equipment and readable storage medium

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114116747A (en) * 2021-11-25 2022-03-01 北京力控元通科技有限公司 Production execution system data analysis method and device

Similar Documents

Publication Publication Date Title
CN110704518B (en) Business data processing method and device based on Flink engine
CN112835560A (en) WEB multi-terminal low-code intelligent software development platform
CN112561386A (en) Method, device and equipment for acquiring business process
CN107862425B (en) Wind control data acquisition method, device and system and readable storage medium
CN104391934A (en) Data calibration method and device
CN115640045B (en) Low-code development platform based on domain-driven design and business system creation method
CN107766042A (en) A kind of visual data manager and device of the model file based on CSAR
CN104133765B (en) The test case sending method of network activity and test case server
CN108416568A (en) Government affairs business data processing method, device and terminal device
CN110347383A (en) The front end development approach and device of cross-platform desktop application
CN112733017A (en) Label management method and device, storage medium and electronic device
CN111159897B (en) Target optimization method and device based on system modeling application
CN115934097A (en) Method, device, storage medium and electronic device for generating executable statement
CN113591448A (en) Report generation method and device and storage medium
CN106897060A (en) Based on patterned data processing method and device
CN112926008A (en) Method and device for generating form page, electronic equipment and storage medium
CN111562964A (en) Settlement service system simulator implementation method based on rule engine
CN102486731B (en) Strengthen the visualization method of the call stack of software of software, equipment and system
CN103561113A (en) Web Service interface generating method and device
CN113467782B (en) Method, device and equipment for determining business process
CN115878112A (en) Multi-party complex business agreement intelligent contract generating system and generating method thereof
CN115328457A (en) Method and device for realizing form page based on parameter configuration
CN110765610B (en) PDM integration method, PDM integration device, computer equipment and storage medium
CN104391782A (en) Network-equipment managing-software client-end simulating method on basis of XML (X Extensive Markup Language) script
CN114610372A (en) Processing method and device for review file, storage medium, processor and terminal

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