CN112560413B - Report form expansion method, device and equipment based on configuration mode - Google Patents

Report form expansion method, device and equipment based on configuration mode Download PDF

Info

Publication number
CN112560413B
CN112560413B CN202011483047.XA CN202011483047A CN112560413B CN 112560413 B CN112560413 B CN 112560413B CN 202011483047 A CN202011483047 A CN 202011483047A CN 112560413 B CN112560413 B CN 112560413B
Authority
CN
China
Prior art keywords
report
formula
calculation
cell
formulas
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.)
Active
Application number
CN202011483047.XA
Other languages
Chinese (zh)
Other versions
CN112560413A (en
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.)
China Life Insurance Co ltd
Original Assignee
China Life Insurance 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 China Life Insurance Co ltd filed Critical China Life Insurance Co ltd
Priority to CN202011483047.XA priority Critical patent/CN112560413B/en
Publication of CN112560413A publication Critical patent/CN112560413A/en
Application granted granted Critical
Publication of CN112560413B publication Critical patent/CN112560413B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • 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
    • 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/10—Office automation; Time management
    • 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
    • G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12—Accounting
    • G06Q40/125—Finance or payroll
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D30/00—Reducing energy consumption in communication networks
    • Y02D30/70—Reducing energy consumption in communication networks in wireless communication networks

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • General Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Operations Research (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Computational Linguistics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Development Economics (AREA)
  • Technology Law (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Machine Translation (AREA)

Abstract

The embodiment of the invention provides a report form expanding method, device and equipment based on a configuration mode, wherein the method comprises the following steps: creating a formula and model storage library, wherein the formula and model storage library comprises a calculation model and an operation formula, the calculation model corresponds to each specific application scene, and the operation formula is various formulas applied to a report; reconfiguring rows and columns of the report according to the acquired user configuration information; and acquiring report information, combining the report information and the user configuration information, and configuring a formula and a model for each cell of the rows and the columns of the report based on the formula and the model storage library. The invention realizes the elastic expansion and dynamic configuration of the report.

Description

Report form expansion method, device and equipment based on configuration mode
Technical Field
The invention relates to the technical field of data processing, in particular to a report form expansion method, device and equipment based on a configuration mode.
Background
The financial statement is widely applied to enterprises, and the enterprises adopt statement tools or autonomous development to realize according to the self conditions. The common flexible report forms can be freely packaged according to the needs of the user, the required report forms can be dynamically generated according to the types of subjects, and the development of the report forms comprises the design of a basic format, the design of a business format, the design of a data processing mode and the like.
However, although the existing report technology can realize free assembly, the scalability in terms of report expansion is still insufficient, the report has no restorability after forming, and when there is a need to increase and decrease the report column width or modify formulas in the existing report in some scenes, specific developers are required to re-develop or perfect the report, and as the application scene is complicated, the inextensible report increasingly meets the needs of users.
There is currently no method or apparatus that can solve the above problems.
Disclosure of Invention
In view of this, an object of an exemplary embodiment of the present invention is to provide a report expansion method, apparatus and device based on a configuration mode, so as to solve the problem that the existing financial report cannot be expanded elastically and dynamically.
Based on the above object, an exemplary embodiment of the present invention provides a report form expanding method based on a configuration mode, including:
creating a formula and model storage library, wherein the formula and model storage library comprises a calculation model and an operation formula, the calculation model corresponds to each specific application scene, and the operation formula is various formulas applied to a report;
reconfiguring rows and columns of the report according to the acquired user configuration information;
and acquiring report information, combining the report information and the user configuration information, and configuring a formula and a model for each cell of the rows and the columns of the report based on the formula and the model storage library.
In combination with the foregoing description, in another possible implementation manner of the embodiment of the present invention, the reconfiguring, according to the acquired user configuration information, the rows and columns of the report includes:
according to the required number of report rows and columns in the user configuration information;
judging whether the number of rows and columns of the report form is matched with the required number;
when the report is judged to be negative, configuring the rows and the columns of the report according to the required number, and configuring formulas and models of each cell of the report;
and when the judgment is yes, directly configuring a formula and a model of each cell of the report.
In combination with the foregoing description, in another possible implementation manner of the embodiment of the present invention, the method further includes:
judging the level of the cell;
when the cell is at the lowest level, directly calculating according to a formula and a model to which the cell belongs;
and when the cell is not at the lowest level, performing recursion according to the level until the cell completes the lowest level calculation, wherein in the recursion process of the level, each level of calculation selects an applicable formula and model from the formula and model storage library according to the attribute of the cell.
In combination with the foregoing description, in another possible implementation manner of the embodiment of the present invention, the method further includes:
when the subject data included in the columns of the report are calculated, the subject data included in the columns of the report are forward ordered, and translation analysis is sequentially carried out, so that the filling of calculation results is realized;
the filling process comprises the following steps:
analyzing the formulas and formulas of the model repository and recursively degrading the formulas and formulas into simple formulas;
translating the simple formula to generate a direct subject index character string;
and the subject data corresponding to the report is directly filled into the subject index character string.
In combination with the foregoing description, in another possible implementation manner of the embodiment of the present invention, the method further includes:
and generating an automatic script to generate the value of the report after filling the subject index character string through the automatic script.
In a second aspect, the present invention also relates to a report form expanding device based on a configuration mode, including:
the system comprises a creation module, a calculation module and a calculation module, wherein the creation module is used for creating a formula and model storage library, the formula and model storage library comprises a calculation model and a calculation formula, the calculation model corresponds to each specific application scene, and the calculation formula is various formulas applied to a report;
the first configuration module is used for reconfiguring the rows and columns of the report according to the acquired user configuration information;
and the second configuration module is used for acquiring report information, combining the report information with the user configuration information, and carrying out the configuration of formulas and models on each cell of the rows and the columns of the report based on the formulas and the model storage library.
The above apparatus, the first configuration module is further configured to:
according to the required number of report rows and columns in the user configuration information;
judging whether the number of rows and columns of the report form is matched with the required number;
when the report is judged to be negative, configuring the rows and the columns of the report according to the required number, and configuring formulas and models of each cell of the report;
and when the judgment is yes, directly configuring a formula and a model of each cell of the report.
The device further comprises a first judging module, configured to:
judging the level of the cell;
when the cell is at the lowest level, directly calculating according to a formula and a model to which the cell belongs;
and when the cell is not at the lowest level, performing recursion according to the level until the cell completes the lowest level calculation, wherein in the recursion process of the level, each level of calculation selects an applicable formula and model from the formula and model storage library according to the attribute of the cell.
The device further comprises a translation analysis module, wherein the translation analysis module is used for:
when the subject data included in the columns of the report are calculated, the subject data included in the columns of the report are forward ordered, and translation analysis is sequentially carried out, so that the filling of calculation results is realized;
the filling process comprises the following steps:
analyzing the formulas and formulas of the model repository and recursively degrading the formulas and formulas into simple formulas;
translating the simple formula to generate a direct subject index character string;
and the subject data corresponding to the report is directly filled into the subject index character string.
In a third aspect, the present invention further relates to an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor implements the report expansion method based on the configuration mode when executing the program.
From the above, it can be seen that the report expansion method, device and equipment based on the configuration mode provided by the exemplary embodiment of the invention realize flexible configuration of the report by creating the formula and model repository and according to the configuration information of the user, realize high expandability of the report formula, the report length and the like, and solve the problem of repeated development of the financial report caused by the change of the statistical model.
Drawings
In order to more clearly illustrate the exemplary embodiments of the present invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, and it is apparent that the drawings in the following description are only exemplary embodiments of the present invention and that other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
FIG. 1 is a basic flow diagram of a report form expanding method based on a configuration mode according to an exemplary embodiment of the present invention;
FIG. 2 is a schematic diagram of a column computation flow of a report extension based on configuration mode in accordance with an exemplary embodiment of the present invention;
FIG. 3 is a schematic diagram of a method embodying an exemplary embodiment of the present invention;
FIG. 4 is a schematic diagram of a configuration mode-based report form expanding apparatus according to an exemplary embodiment of the present invention;
fig. 5 is a basic schematic of an apparatus according to an exemplary embodiment of the present invention.
Detailed Description
For the purposes of promoting an understanding of the principles and advantages of the disclosure, reference will now be made to the embodiments illustrated in the drawings and specific language will be used to describe the same.
It should be noted that unless otherwise defined, technical or scientific terms used in the exemplary embodiments of the present invention should be given the ordinary meaning as understood by one of ordinary skill in the art to which the present disclosure pertains. The terms "first," "second," and the like, as used in exemplary embodiments of the present invention, do not denote any order, quantity, or importance, but rather are used to distinguish one element from another. The word "comprising" or "comprises", and the like, means that elements or items preceding the word are included in the element or item listed after the word and equivalents thereof, but does not exclude other elements or items.
At present, report technology adopted by most enterprises is generated according to a table or a graphic template in real time after the background is calculated according to a calculation formula provided by a user. The more prominent flexible report mode has the advantages that a background configuration fixed dimension mode can allow a user to freely select a time dimension and a fixed subject dimension to assemble a report required by the user. When the user clicks the generation button after the assembly is completed, the system automatically converts the dimension selected by the user into an sql automation script and finishes the query. The foreground enables a user to view report results in various modes such as forms, graphs and the like according to the visualization tool.
The conventional report can meet the daily use of users, but when the report needs to be increased, decreased by a few columns or report formulas to be modified, the report needs to be redeveloped or perfected, and along with the continuous enrichment of business scenes, the redeveloped or perfected needs to occupy a large amount of time and consume more human resources. Therefore, the existing report technology has the defect of poor scalability.
The financial report of the exemplary embodiment of the invention is stored in the form of a background database table, wherein the fields of the table include, but are not limited to, report names, report columns, report rows, report calculation formulas corresponding to cells, and levels corresponding to cells.
The invention relates to a report form expansion method, a report form expansion device and report form expansion equipment based on a configuration mode, which are mainly applied to a scene of data statistics through a financial report form, and the basic idea is as follows: the formula and model storage library is created, flexible configuration of the report is realized according to the configuration information of the user, the high expandability of the report formula, the report length and the like is realized, and the problem of repeated development of the financial report due to the change of the statistical model is solved.
Fig. 1 is a basic flow diagram of a report form expansion method based on a configuration mode according to an embodiment of the present invention, which specifically includes the following steps:
in step 110, a formula and model repository is created, the formula and model repository includes a calculation model and an operation formula, the calculation model corresponds to each specific application scenario, and the operation formula is various formulas applied to the report;
in an implementation scenario of an exemplary embodiment of the present invention, the calculation model may include: an insurance company internal fund investment situation table, an insurance company internal stock investment situation table, an insurance company bond investment situation table, an insurance company independent account fund application table, an insurance company fund application table and the like, wherein each type of table corresponds to a calculation model, and the formula and the model repository only need to be selected once when the calculation model is selected; the configuration and expansion of the report can be realized directly by adding, deleting or adjusting the number of rows, the number of columns and the cell format according to the report calculation sample.
The formula comprises a plurality of simple four-rule operation formulas such as a10020002+a10120001-a10210001, unit cell four-rule operation formulas such as ([ 22.16] + [22.18 ])/(22.20 ])), accumulated summation, older fluctuation, older period fluctuation, older month fluctuation, 13 month fund average balance and the like.
In step 120, reconfiguring the rows and columns of the report according to the acquired user configuration information;
the user configuration information firstly comprises user requirements, such as the number information of the rows and columns of the required report, and the rows and columns of the report are reconfigured according to the number information so that the finally generated report meets the user requirements.
In step 130, report information is obtained, and the formula and model configuration is performed on each cell of the report rows and columns based on the formula and model repository in combination with the report information and the user configuration information.
And acquiring report information, wherein the report information comprises acquiring a specific service scene to which the user belongs according to the user configuration information, so that report information, such as a fund application table, under the specific service scene can be acquired.
The fund application table of the system memory is in a standard format, each cell of the rows and columns of the report is configured through the user configuration information and the formula and model storage library, the calculation model and the calculation formula of the report are further configured by the user which is dynamically added or modified in the process, the system analyzes and translates the added or modified calculation model and calculation formula to obtain a subject index stored in the database, and the subject index is filled with corresponding subject data to complete the calculation process of the data.
The method of the invention realizes the dynamic configuration of the report information according to the user requirement and the elastic expansion and contraction of the report by creating the formula and model repository, the user configuration information and the report information.
In one implementation manner of the exemplary embodiment of the present invention, the reconfiguring the rows and columns of the report according to the acquired user configuration information includes:
according to the required number of report rows and columns in the user configuration information; the required number is, for example, 10×10 (columns).
Judging whether the number of rows and columns of the report form is matched with the required number;
when the report is judged to be negative, configuring the rows and the columns of the report according to the required number, and configuring formulas and models of each cell of the report;
and when the judgment is yes, directly configuring a formula and a model of each cell of the report.
The row and column of the report form under the corresponding scene are 6*8, the judging result is unmatched, and when the row and column of the report form under the corresponding scene are 10 x 10, the judging result is matched.
And when the report is judged to be negative, the report is required to be configured in rows and columns according to the 10 x 10 of the required number, and the multiple cells are configured in formulas and models so as to facilitate subsequent calculation.
And when the judgment is yes, configuring the cell directly according to the formula and the model of the cell.
In one implementation of the exemplary embodiment of the present invention, the method further includes a process of determining a level of (data of) the cell, where the process includes:
judging the level of the cell;
when the cell is at the lowest level, directly calculating according to a formula and a model to which the cell belongs;
and when the cell is not at the lowest level, performing recursion according to the level until the cell completes the lowest level calculation, wherein in the recursion process of the level, each level of calculation selects an applicable formula and model from the formula and model storage library according to the attribute of the cell.
The hierarchy may be a corporate hierarchy to which the cell-filled subject data belongs, e.g., a first hierarchy for a head office, a second hierarchy for a branch office, a third hierarchy for a branch office, etc. The lowest level may be the level at which a particular department or group is located.
The report forms are represented as a database model in the background and a two-dimensional plane report form in the front end, and are displayed in a row-column combination mode, namely N cells are formed, the adjustment of the rows and the columns can affect the whole rows or the whole columns, when a user modifies the existing standard report form formula, the formula level is required to be set synchronously, and the reconfiguration of the report forms is saved.
According to the year (such as 2019, 2020) and the period (one period for each month) corresponding to the report is selected by the user, the background is configured according to the report formula according to the corresponding period dynamics, the calculation is performed one by one according to the cell sequence, if the cell is the lowest level, the formulas are directly calculated, different calculation models or operation formulas are selected according to the types of the formulas, and the translation function when translation is required, if the cell is not the lowest level, the recursion layer by layer is required until the lowest level calculation returns step by step, and in the calculation process of each level, different calculation or translation functions are selected according to the types of the formulas.
In an implementation scenario of an exemplary embodiment of the present invention, the method further includes:
when the subject data included in the columns of the report are calculated, the subject data included in the columns of the report are forward ordered, and translation analysis is sequentially carried out, so that the filling of calculation results is realized;
the filling process comprises the following steps:
analyzing the formulas and formulas of the model repository and recursively degrading the formulas and formulas into simple formulas;
translating the simple formula to generate a direct subject index character string;
and the subject data corresponding to the report is directly filled into the subject index character string.
Processing each column of data at one time according to the column number of the report, forward ordering each column of subjects according to the hierarchy, sequentially translating and analyzing and completing filling, see fig. 2, wherein the process comprises the following steps:
in step 210, each column of formulas is obtained according to the sequence number;
in step 220, sorting each column according to the hierarchy, and sequentially reading the formula list;
in step 230, the high-level formula is parsed and downgraded into a complex formula by a conversion function;
in step 240, the complex function is translated into a direct subject index string;
in step 250, the subject data of the corresponding installment populates the corresponding subject index string value.
Specifically, the translation resolution population specific process may include the following:
(1) the formulas of [ ], (), JQN (last year), JNC (older year), JSY (upper period) and the like in the formula are analyzed one by one and recursively degraded into a simple formula;
(2) generating a direct subject index character string by the simple formula through a translation function;
(3) filling corresponding subject index character strings through subject data of corresponding periods, namely analyzing the corresponding subject index character strings into specific single subjects with the level of 1 or four operations of multiple subjects, for example: a10020002+a10120001-a10210001, to prevent divide-by-0 errors, the formula contains a divide-by-0 function.
The translation function may be: for example, (a finance subject+b finance subject) = (c business subject+ (d business subject-e political subject)), the brackets of different levels are required to be analyzed and calculated layer by layer from inside to outside, the result is replaced step by step to realize formula checking, and finally specific calculation is carried out through a calculation model or an operation formula.
In an implementation scenario of an exemplary embodiment of the present invention, the method further includes: and generating an automatic script to generate the value of the report after filling the subject index character string through the automatic script.
Converting the filled character string into an automatic SQL script, wherein the SQL script is as follows: filling the generated specific subject index with the corresponding subject value by inquiring to generate an SQL script composed of numbers and four operators, executing by a database to generate a report cell result, and automatically executing the SQL script to generate the value of the table.
The exemplary embodiment of the present invention further includes: and storing all the calculated table data into a temporary table medium and integrating the data, wherein after the data are integrated, the calculation of all the report cells is completed, and the report is displayed to a user in a unified return mode.
The exemplary embodiment of the present invention further includes: the foreground prints the data into the table or chart data corresponding to the registration template through a visualization tool.
In an exemplary embodiment of the present invention, in executing the method of the present invention, as shown in fig. 3, it is necessary to first determine whether to change the column length interval (whether to newly increase the number of columns), if yes, then it is necessary to newly increase or decrease the column configuration formula, if no, then it is necessary to determine whether to modify the existing report, if yes, then reset the related formula, otherwise set the parameters of the report, then start the report operation, obtain the configured formula and model information, parse the formula into the subject index through the translation function, fill the subject data into the subject index, operate and generate the report, and integrate and visualize the report.
Compared with the fixed format and length of the traditional report, the flexible configuration report enables the formulas in the report to have universal compatibility, and the set formula translation analysis method has universal applicability and can remarkably improve the elasticity of the report. The method can realize the dynamic configuration of the length and the width of the report form by directly adding, deleting or adjusting the number of rows, the number of columns and the cell format, and can moderately shrink or extend to realize the basic requirement.
It is understood that the method may be performed by any apparatus, device, platform, cluster of devices having computing, processing capabilities.
Based on the same inventive concept, fig. 4 is a schematic structural diagram of a report form expansion device based on a configuration mode, where the device may be implemented by software and/or hardware, and is generally integrated in an intelligent terminal, and may be implemented by a report form expansion method based on a configuration mode. As shown in fig. 4, the present embodiment, corresponding to any of the above-mentioned method embodiments, provides a report expanding device based on a configuration mode, which mainly includes a creating module 410, a first configuration module 420, and a second configuration module 430.
The creating module 410 is configured to create a formula and model repository, where the formula and model repository includes a calculation model and an operation formula, the calculation model corresponds to each specific application scenario, and the operation formula is various formulas applied to the report;
the first configuration module 420 is configured to reconfigure a row and a column of the report according to the acquired user configuration information;
the second configuration module 430 is configured to obtain report information, combine the report information with the user configuration information, and configure each cell of the report row and column with a formula and a model based on the formula and model repository.
In an implementation scenario of the exemplary embodiment of the present invention, the first configuration module 420 is further configured to:
according to the required number of report rows and columns in the user configuration information;
judging whether the number of rows and columns of the report form is matched with the required number;
when the report is judged to be negative, configuring the rows and the columns of the report according to the required number, and configuring formulas and models of each cell of the report;
and when the judgment is yes, directly configuring a formula and a model of each cell of the report.
In an implementation scenario of an exemplary embodiment of the present invention, the apparatus further includes a first determining module, configured to:
judging the level of the cell;
when the cell is at the lowest level, directly calculating according to a formula and a model to which the cell belongs;
and when the cell is not at the lowest level, performing recursion according to the level until the cell completes the lowest level calculation, wherein in the recursion process of the level, each level of calculation selects an applicable formula and model from the formula and model storage library according to the attribute of the cell.
In an implementation scenario of the exemplary embodiment of the present invention, the apparatus further includes a translation parsing module, configured to:
when the subject data included in the columns of the report are calculated, the subject data included in the columns of the report are forward ordered, and translation analysis is sequentially carried out, so that the filling of calculation results is realized;
the filling process comprises the following steps:
analyzing the formulas and formulas of the model repository and recursively degrading the formulas and formulas into simple formulas;
translating the simple formula to generate a direct subject index character string;
and the subject data corresponding to the report is directly filled into the subject index character string.
For convenience of description, the above devices are respectively described in terms of functions divided into various modules, and of course, when the exemplary embodiment of the present invention is implemented, the functions of the various modules may be implemented in the same software and/or hardware, and the report expanding device based on the configuration mode provided in the above embodiment may execute the report expanding method based on the configuration mode provided in any embodiment of the present invention, which has corresponding functional modules and beneficial effects for executing the method, and technical details not described in detail in the above embodiment may be referred to the report expanding method based on the configuration mode provided in any embodiment of the present invention, which is not described herein again.
Based on the same inventive concept, corresponding to the method of any embodiment, one or more embodiments of the present disclosure further provide an electronic device, including a memory, a processor, and a computer program stored on the memory and capable of running on the processor, where the processor implements the report expanding method based on the configuration mode according to any embodiment when executing the program.
It should be noted that the method according to the exemplary embodiment of the present invention may be performed by a single apparatus, for example, a computer or a server. The method of the embodiment can also be applied to a distributed scene, and is completed by mutually matching a plurality of devices. In the case of such a distributed scenario, one of the devices may perform only one or more steps of the method of an exemplary embodiment of the present invention, the devices interacting with each other to accomplish the method.
The foregoing describes specific embodiments of the present disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
For convenience of description, the above devices are described as being functionally divided into various modules, respectively. Of course, the functions of the various modules may be implemented in the same piece or pieces of software and/or hardware when implementing the exemplary embodiments of this invention.
Fig. 5 shows a more specific hardware architecture of an electronic device according to this embodiment, where the device may include: a processor 1010, a memory 1020, an input/output interface 1030, a communication interface 1040, and a bus 1050. Wherein processor 1010, memory 1020, input/output interface 1030, and communication interface 1040 implement communication connections therebetween within the device via a bus 1050.
The processor 1010 may be implemented by a general-purpose CPU (Central Processing Unit ), microprocessor, application specific integrated circuit (Application Specific Integrated Circuit, ASIC), or one or more integrated circuits, etc. for executing relevant programs to implement the technical solutions provided in the embodiments of the present disclosure.
The Memory 1020 may be implemented in the form of ROM (Read Only Memory), RAM (Random Access Memory ), static storage device, dynamic storage device, or the like. The memory 1020 may store an operating system and other application programs, and when the technical solutions provided in the embodiments of the present disclosure are implemented by software or firmware, relevant program codes are stored in the memory 1020, and the processor 1010 invokes a report extension method based on a configuration mode to execute the embodiments of the present disclosure.
The input/output interface 1030 is used to connect with an input/output module for inputting and outputting information. The input/output module may be configured as a component in a device (not shown) or may be external to the device to provide corresponding functionality. Wherein the input devices may include a keyboard, mouse, touch screen, microphone, various types of sensors, etc., and the output devices may include a display, speaker, vibrator, indicator lights, etc.
Communication interface 1040 is used to connect communication modules (not shown) to enable communication interactions of the present device with other devices. The communication module may implement communication through a wired manner (such as USB, network cable, etc.), or may implement communication through a wireless manner (such as mobile network, WIFI, bluetooth, etc.).
Bus 1050 includes a path for transferring information between components of the device (e.g., processor 1010, memory 1020, input/output interface 1030, and communication interface 1040).
It should be noted that although the above-described device only shows processor 1010, memory 1020, input/output interface 1030, communication interface 1040, and bus 1050, in an implementation, the device may include other components necessary to achieve proper operation. Furthermore, it will be understood by those skilled in the art that the above-described apparatus may include only the components necessary to implement the embodiments of the present description, and not all the components shown in the drawings.
The electronic device of the foregoing embodiment is configured to implement the corresponding configuration mode-based report expansion method in any of the foregoing embodiments, and has the beneficial effects of the corresponding method embodiment, which is not described herein.
Based on the same inventive concept, corresponding to the method of any of the exemplary embodiments of the present invention, the exemplary embodiments of the present invention also provide a non-transitory computer readable storage medium, including permanent and non-permanent, removable and non-removable media, information storage may be implemented by any method or technology. The information may be computer readable instructions, data structures, modules of the program itself, or other data. Examples of storage media for a computer include, but are not limited to: phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, may be used to store information that may be accessed by a computing device for performing the configuration mode based report expansion methods described in exemplary embodiments of the present invention.
Those of ordinary skill in the art will appreciate that: the discussion of any of the embodiments above is merely exemplary and is not intended to suggest that the scope of the disclosure, including the claims, is limited to these examples; the technical features of the above embodiments or in the different embodiments may also be combined under the idea of the present disclosure, the steps may be implemented in any order, and there are many other variations of the different aspects of the exemplary embodiments of the present invention as described above, which are not provided in detail for the sake of brevity.
Additionally, well-known power/ground connections to Integrated Circuit (IC) chips and other components may or may not be shown within the provided figures, in order to simplify the illustration and discussion, and so as not to obscure the exemplary embodiments of the present invention. Furthermore, the devices may be shown in block diagram form in order to avoid obscuring the example embodiments of the present invention, and this also takes into account the fact that specifics with respect to implementation of such block diagram devices are highly dependent upon the platform within which the example embodiments of the present invention are to be implemented (i.e., such specifics should be well within purview of one skilled in the art). Where specific details (e.g., circuits) are set forth in order to describe example embodiments of the disclosure, it should be apparent to one skilled in the art that example embodiments of the invention can be practiced without, or with variation of, these specific details. Accordingly, the description is to be regarded as illustrative in nature and not as restrictive.
While the present disclosure has been described in conjunction with specific embodiments thereof, many alternatives, modifications, and variations of those embodiments will be apparent to those skilled in the art in light of the foregoing description. For example, other memory architectures (e.g., dynamic RAM (DRAM)) may use the embodiments discussed.
The exemplary embodiments of the present invention are intended to embrace all such alternatives, modifications and variances which fall within the broad scope of the appended claims. It is therefore contemplated to cover any such omissions, modifications, equivalents, improvements or similar fall within the spirit and scope of the exemplary embodiments of the invention.

Claims (4)

1. A report form expanding method based on a configuration mode is characterized by comprising the following steps:
creating a formula and model storage library, wherein the formula and model storage library comprises a calculation model and an operation formula, the calculation model corresponds to each specific application scene, and the operation formula is various formulas of a report applied to each specific application scene;
reconfiguring rows and columns of the report according to the acquired user configuration information;
acquiring report information, combining the report information with the user configuration information, and configuring a formula and a calculation model for each cell of the rows and the columns of the report based on the formula and the model storage library;
the reconfiguring the rows and columns of the report according to the acquired user configuration information comprises the following steps:
according to the required number of report rows and columns in the user configuration information;
judging whether the number of rows and columns of the report form is matched with the required number;
when the report is judged to be negative, configuring rows and columns of the report according to the required number, and configuring formulas and calculation models by using a plurality of unit cells so as to facilitate subsequent calculation;
when the judgment is yes, directly configuring formulas and calculation models of each cell of the report; the method further comprises the steps of:
judging the level of the cell;
when the cell is at the lowest level, calculating directly according to a formula and a calculation model to which the cell belongs;
when the cell is not at the lowest level, performing recursion according to the level until the cell completes the lowest level calculation, wherein in the recursion process of the level, each level of calculation selects an applicable formula and calculation model from the formula and model storage library according to the attribute of the cell; wherein the hierarchy may be a corporate hierarchy to which the cell-filled subject data pertains;
the method further comprises the steps of:
processing each column of data at one time according to the column number of the report, forward ordering each column of subjects according to the hierarchy, sequentially translating and analyzing and completing filling, wherein the filling process comprises the following steps:
in step 210, each column of formulas is obtained according to the sequence number;
in step 220, sorting each column according to the hierarchy, and sequentially reading the formula list;
in step 230, the high-level formulas are parsed and downgraded into low-level formulas by the conversion function;
in step 240, the low-level formula is translated into a direct subject index string;
in step 250, the subject data of the corresponding installment populates the corresponding subject index string value.
2. The method according to claim 1, wherein the method further comprises:
and generating an automatic script to generate the value of the report after filling the subject index character string through the automatic script.
3. A report form expanding device based on a configuration mode, which is characterized by comprising:
the system comprises a creation module, a calculation module and a calculation module, wherein the creation module is used for creating a formula and model storage library, the formula and model storage library comprises a calculation model and a calculation formula, the calculation model corresponds to each specific application scene, and the calculation formula is various formulas of a report applied to each specific application scene;
the first configuration module is used for reconfiguring the rows and columns of the report according to the acquired user configuration information;
the second configuration module is used for acquiring report information, combining the report information with the user configuration information, and carrying out configuration of formulas and calculation models on each cell of the rows and the columns of the report based on the formulas and the model storage library; the first configuration module is further configured to:
according to the required number of report rows and columns in the user configuration information;
judging whether the number of rows and columns of the report form is matched with the required number;
when the report is judged to be negative, configuring rows and columns of the report according to the required number, and configuring formulas and calculation models by using a plurality of unit cells so as to facilitate subsequent calculation;
when the judgment is yes, directly configuring formulas and calculation models of each cell of the report;
the device further comprises a first judging module for:
judging the level of the cell;
when the cell is at the lowest level, directly calculating according to a formula and a model to which the cell belongs;
when the cell is not at the lowest level, performing recursion according to the level until the cell completes the lowest level calculation, wherein in the recursion process of the level, each level of calculation selects an applicable formula and calculation model from the formula and model storage library according to the attribute of the cell;
the device also comprises
The translation analysis module is used for: processing each column of data at one time according to the column number of the report, forward ordering each column of subjects according to the hierarchy, sequentially translating and analyzing and completing filling, wherein the filling process comprises the following steps:
in step 210, each column of formulas is obtained according to the sequence number;
in step 220, sorting each column according to the hierarchy, and sequentially reading the formula list;
in step 230, the high-level formulas are parsed and downgraded into low-level formulas by the conversion function;
in step 240, the low-level formula is translated into a direct subject index string;
in step 250, the subject data of the corresponding installment populates the corresponding subject index string value.
4. 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 configuration mode based report extension method of any one of claims 1 to 2 when the program is executed by the processor.
CN202011483047.XA 2020-12-15 2020-12-15 Report form expansion method, device and equipment based on configuration mode Active CN112560413B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011483047.XA CN112560413B (en) 2020-12-15 2020-12-15 Report form expansion method, device and equipment based on configuration mode

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011483047.XA CN112560413B (en) 2020-12-15 2020-12-15 Report form expansion method, device and equipment based on configuration mode

Publications (2)

Publication Number Publication Date
CN112560413A CN112560413A (en) 2021-03-26
CN112560413B true CN112560413B (en) 2023-08-04

Family

ID=75064021

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011483047.XA Active CN112560413B (en) 2020-12-15 2020-12-15 Report form expansion method, device and equipment based on configuration mode

Country Status (1)

Country Link
CN (1) CN112560413B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114416832B (en) * 2022-01-26 2022-11-15 重庆允丰科技有限公司 Method for configuring formula field and report and computer storage medium

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103544574A (en) * 2013-11-07 2014-01-29 南京国电南自轨道交通工程有限公司 Transformer station intelligent expert system based on editable formula scripts
CN103793464A (en) * 2013-12-19 2014-05-14 国家电网公司 Method for exporting reports on basis of neutral formats
CN107609131A (en) * 2017-09-18 2018-01-19 中国银行股份有限公司 A kind of report file generation method and device
CN110473080A (en) * 2019-07-30 2019-11-19 阿里巴巴集团控股有限公司 A kind of report processing method, device and computer equipment
WO2020108545A1 (en) * 2018-11-29 2020-06-04 腾讯科技（深圳）有限公司 Statement processing method, statement decoding method and apparatus, storage medium and device
CN111626028A (en) * 2020-05-29 2020-09-04 深圳前海微众银行股份有限公司 Report generation method, device and equipment based on function analysis and computer medium
CN112036118A (en) * 2020-07-03 2020-12-04 山东浪潮通软信息科技有限公司 Configurable dynamic data report display method and system

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040111666A1 (en) * 2002-12-05 2004-06-10 Hollcraft James G. Software replicator functions for generating reports

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103544574A (en) * 2013-11-07 2014-01-29 南京国电南自轨道交通工程有限公司 Transformer station intelligent expert system based on editable formula scripts
CN103793464A (en) * 2013-12-19 2014-05-14 国家电网公司 Method for exporting reports on basis of neutral formats
CN107609131A (en) * 2017-09-18 2018-01-19 中国银行股份有限公司 A kind of report file generation method and device
WO2020108545A1 (en) * 2018-11-29 2020-06-04 腾讯科技（深圳）有限公司 Statement processing method, statement decoding method and apparatus, storage medium and device
CN110473080A (en) * 2019-07-30 2019-11-19 阿里巴巴集团控股有限公司 A kind of report processing method, device and computer equipment
CN111626028A (en) * 2020-05-29 2020-09-04 深圳前海微众银行股份有限公司 Report generation method, device and equipment based on function analysis and computer medium
CN112036118A (en) * 2020-07-03 2020-12-04 山东浪潮通软信息科技有限公司 Configurable dynamic data report display method and system

Also Published As

Publication number Publication date
CN112560413A (en) 2021-03-26

Similar Documents

Publication Publication Date Title
US7721252B2 (en) Apparatus and method for product-line architecture description and verification
CN103412853B (en) A kind of automatic example generation method for file convertor
US11321318B2 (en) Dynamic access paths
CN111506579B (en) Method, program and equipment for generating intelligent contract code
CN113408222B (en) File generation method and device, electronic equipment and storage medium
CN112633625B (en) Audit and doubt point automatic scanning method and device, electronic equipment and storage medium
CN107391357A (en) Application crashes replay method, device and mobile terminal
CN111079944A (en) Method and device for realizing interpretation of transfer learning model, electronic equipment and storage medium
CN113255258A (en) Logic synthesis method and device, electronic equipment and storage medium
CN112560413B (en) Report form expansion method, device and equipment based on configuration mode
CN111767217A (en) JS unit test case generation method and device
CN103136100A (en) Method and system for Android test
CN114780100A (en) Compiling method, electronic device, and storage medium
CN115495082B (en) TLV format data automatic conversion method and related equipment
CN116225450A (en) Text conversion method and apparatus, computing device and readable storage medium
CN115357696A (en) Dynamic chart billboard display method based on components and related equipment
CN114443042A (en) Service arrangement execution method based on rule engine and related equipment
CN109858169B (en) Modelica-based model flattening method
CN113791775B (en) Metadata flow arranging method and device, storage medium and electronic equipment
CN117172191B (en) Layout generation method and system
US20090063068A1 (en) Numerical test data reporting in an image file and subsequent analysis
CN115794868A (en) Calculation field generation method based on recursion
CN115756588A (en) Swagger-based API document management system and method
CN117827902A (en) Service data processing method, device, computer equipment and storage medium
CN111400194A (en) Snapshot creating method, snapshot executing method, snapshot creating device, snapshot executing device and equipment based on test tool

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant