CN112183041A - Report form adjusting method, device, equipment and storage medium based on indexes - Google Patents
Report form adjusting method, device, equipment and storage medium based on indexes Download PDFInfo
- Publication number
- CN112183041A CN112183041A CN202011045442.XA CN202011045442A CN112183041A CN 112183041 A CN112183041 A CN 112183041A CN 202011045442 A CN202011045442 A CN 202011045442A CN 112183041 A CN112183041 A CN 112183041A
- Authority
- CN
- China
- Prior art keywords
- report
- adjusted
- adjusting
- index
- adjustment
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 60
- 230000004048 modification Effects 0.000 claims abstract description 15
- 238000012986 modification Methods 0.000 claims abstract description 15
- 230000015654 memory Effects 0.000 claims description 18
- 238000007792 addition Methods 0.000 claims description 6
- 238000012217 deletion Methods 0.000 claims description 6
- 230000037430 deletion Effects 0.000 claims description 6
- 230000008859 change Effects 0.000 abstract description 6
- 230000001172 regenerating effect Effects 0.000 abstract description 5
- 230000006870 function Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 238000004364 calculation method Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 4
- 238000004590 computer program Methods 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 230000001953 sensory effect Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Educational Administration (AREA)
- Quality & Reliability (AREA)
- Marketing (AREA)
- Game Theory and Decision Science (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the invention discloses a report adjusting method, a report adjusting device, report adjusting equipment and a storage medium based on indexes. The report form adjusting method based on the indexes comprises the following steps: acquiring a report adjusting instruction; the report adjusting instruction comprises a report identifier to be adjusted and an index item adjusting instruction; the report to be adjusted comprises at least one index item; acquiring a report to be adjusted according to the report to be adjusted identifier; and adjusting the index item of the report to be adjusted according to the index item adjusting instruction to obtain a report adjusting result. The report sample change and report rule modification operations can be completed only by adjusting the original report without regenerating the report, so that the time cost and the labor cost required for regenerating the report are saved, and the working efficiency is improved.
Description
Technical Field
The invention relates to the technical field of report processing, in particular to a report adjusting method, a report adjusting device, report adjusting equipment and a storage medium based on indexes.
Background
The report forms are basic measures and ways for enterprise management, are basic Business requirements of the enterprise, and are also the basis for implementing a Business Intelligence (BI) strategy. The report can help the enterprise to access, format, and present data information to the user in a reliable and secure manner. The enterprise operation condition is deeply known, and the method is a strong driving force for enterprise development. When the report rule changes, how to quickly adjust the original report and how to present the new report to the user have important significance for improving the working efficiency of enterprises.
At present, once a form sample or a rule of a report is modified, the report form sample needs to be re-developed and the aperture of a data item needs to be adjusted, the report form sample can be used after being on-line, the requirement of timeliness cannot be met for emergency requirements, and only a plurality of reports can be developed to meet the requirement for the report form with the form sample changed before and after a time point. There is a need for a report adjustment method that does not require re-development of reports.
Disclosure of Invention
The embodiment of the invention provides a report adjusting method, a report adjusting device, equipment and a storage medium based on indexes, and aims to achieve the purposes of report sample change and report rule modification operation only by adjusting an original report without regenerating the report.
In a first aspect, an embodiment of the present invention provides a report adjustment method based on an index, including:
acquiring a report adjusting instruction; the report adjusting instruction comprises a report identifier to be adjusted and an index item adjusting instruction; the report to be adjusted comprises at least one index item;
acquiring a report to be adjusted according to the report to be adjusted identifier;
and adjusting the index item of the report to be adjusted according to the index item adjusting instruction to obtain a report adjusting result.
Optionally, the adjusting the index item of the report to be adjusted according to the index item adjusting instruction includes:
analyzing the report adjusting instruction to obtain a report adjusting operation type;
and adjusting the report index comparison relation table corresponding to the report to be adjusted according to the report adjustment operation type.
Optionally, the adjusting the index item of the report to be adjusted according to the index item adjusting instruction includes:
adjusting the logical corresponding relation of the index items in the report to be adjusted; and/or the presence of a gas in the gas,
and performing addition, modification or deletion on the index items in the report to be adjusted.
Optionally, after the report to be adjusted is obtained according to the report to be adjusted identifier, the method further includes:
adjusting the form sample corresponding to the report to be adjusted according to the report display requirement to obtain a report adjustment result; the report display requirement comprises the display time of the sample;
and establishing an incidence relation among the report to be adjusted, the report adjustment result and the display time of the sample, and storing the report to be adjusted and the report adjustment result.
Optionally, the adjusting the index item of the report to be adjusted according to the index item adjusting instruction includes:
acquiring a report index comparison relation table corresponding to the report to be adjusted according to the report to be adjusted identifier;
adjusting the report index comparison relation table according to the report adjustment instruction to obtain an adjusted report index comparison relation table;
and displaying the report matched with the report index comparison relation table according to the adjusted report index comparison relation table.
Optionally, the adjusting the logical correspondence of the index items in the report to be adjusted includes:
acquiring a target index item from a fact table according to the report form adjusting instruction;
and according to the index item adjusting instruction, adjusting the logical corresponding relation of the index items in the report index comparison relation table of the index items to be adjusted by using the target index items.
Optionally, the adding, modifying or deleting the index item in the report to be adjusted includes:
acquiring a target index item from a fact table according to the report form adjusting instruction; and according to the report adjustment instruction, utilizing the target index item to perform new addition, modification or deletion operation on the index item of the configuration table of the index item to be adjusted.
Optionally, after the establishing of the association relationship between the report to be adjusted, the report adjustment result, and the presentation time of the sample, and storing the report to be adjusted and the report adjustment result, the method further includes:
receiving target query time input by a user;
comparing the target query time with the display time of the table sample to obtain a time comparison result;
if the target query time is later than the display time of the form sample, displaying the report adjustment result; and if the target query time is earlier than the display time of the form sample, displaying the to-be-adjusted form.
Optionally, after the report to be adjusted is adjusted according to the report adjustment instruction and a report adjustment result is obtained, the method further includes:
and responding to a report inquiry instruction input by a user, and displaying the report adjustment result.
In a second aspect, an embodiment of the present invention further provides an apparatus for adjusting a report based on an index, where the apparatus includes:
the adjustment instruction acquisition module is used for acquiring a report adjustment instruction; the report adjusting instruction comprises a report identifier to be adjusted and an index item adjusting instruction; the report to be adjusted comprises at least one index item;
the report to be adjusted acquiring module is used for acquiring the report to be adjusted according to the report to be adjusted identifier;
and the index item adjusting module is used for adjusting the index item of the report to be adjusted according to the index item adjusting instruction so as to obtain a report adjusting result.
In a third aspect, an embodiment of the present invention further provides an electronic device, where the electronic device includes:
one or more processors;
a memory for storing one or more programs;
when the one or more programs are executed by the one or more processors, the one or more processors implement a report adjustment method based on an index according to any embodiment of the present invention.
In a fourth aspect, an embodiment of the present invention further provides a non-transitory computer-readable storage medium storing computer instructions for causing a computer to execute a method for index-based report adjustment according to any embodiment.
According to the embodiment of the invention, the report adjusting instruction is obtained, and the index item adjustment is carried out on the report to be adjusted according to the index item adjusting instruction in the report adjusting instruction to obtain the report adjusting result, so that the report sample change and report rule modification operation can be completed only by adjusting the original report without generating the report again, the time cost and the labor cost required for generating the report again are saved, and the working efficiency is improved.
Drawings
FIG. 1 is a flowchart of a report adjusting method based on indicators according to a first embodiment of the present invention;
FIG. 2 is a flowchart of a report adjusting method based on indicators according to a second embodiment of the present invention;
FIG. 3 is a flowchart illustrating an index-based report adjustment according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a report adjustment apparatus based on indicators in a fourth embodiment of the present invention;
fig. 5 is a schematic structural diagram of an electronic device to which the index-based report adjustment method according to the embodiment of the present invention is applied.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a diagram of a report adjustment method based on indexes according to a first embodiment of the present invention, which is applicable to a case where a report is adjusted when report samples and report rules change. The method can be executed by a report adjusting device based on indexes, the device can be realized in a software and/or hardware mode, and the device can be configured in the electronic equipment. As shown in fig. 1, the method specifically includes:
s110, acquiring a report form adjusting instruction; the report adjusting instruction comprises a report identifier to be adjusted and an index item adjusting instruction; the report to be adjusted comprises at least one index item;
wherein, the index item is the minimum unit of report form composition. The index items can be divided into basic indexes and derived indexes, the basic indexes are the bottommost indexes, and the basic indexes are subjects in the general ledger field; the derived index may be the result of calculation of several basic indexes, or may be the result of calculation of several derived indexes. At least one index item can form a report.
The report adjustment instruction includes a to-be-adjusted report identifier for identifying the report to be adjusted, and the to-be-adjusted report identifier may be, for example, a report number, a report name, or a report storage address, which is not limited herein and is specifically determined according to an actual situation. The index item adjusting instruction comprises an adjusting requirement of the index item in the report to be adjusted, and information such as an identifier of the index item to be adjusted. The report to be adjusted refers to a target report needing to be adjusted in the report adjusting instruction. The report adjustment instruction acquired by the electronic device is input by a user through a SMIS (Statistical Management Information System), and optionally, the electronic device is a back-end server of the SMIS.
S120, acquiring a report to be adjusted according to the report to be adjusted identifier;
optionally, the report to be adjusted is stored in the local data or the cloud, and the electronic device obtains the report to be adjusted from the local data or the cloud according to the report to be adjusted identifier.
S130, adjusting the index item of the report to be adjusted according to the index item adjusting instruction to obtain a report adjusting result.
The index item adjusting instruction comprises an index identification needing to be adjusted in the report to be adjusted and a requirement for adjusting the index item, and the electronic equipment adjusts the index item needing to be adjusted in the report to be adjusted according to the index item adjusting instruction to obtain the adjusted report.
In this embodiment of the present invention, optionally, the adjusting the index item of the report to be adjusted according to the index item adjusting instruction includes: analyzing the report adjusting instruction to obtain a report adjusting operation type; and adjusting the report index comparison relation table corresponding to the report to be adjusted according to the report adjustment operation type.
The report adjustment instruction is analyzed to obtain information such as a report adjustment operation type, a report identifier to be adjusted, an index item adjustment instruction and the like from the report adjustment instruction. The report adjustment operation type is related to the adjustment requirement of the user on the report to be adjusted, and optionally, the report adjustment operation type includes modifying the number of index items of the report to be adjusted, modifying the content of the index items, or finely adjusting the sample corresponding to the report to be adjusted.
The report index comparison relation table is in one-to-one correspondence with the report to be adjusted, and comprises the identifier of the report to be adjusted and the identifiers of all the index items forming the report to be adjusted. The report index comparison relation table is pre-constructed according to user requirements before the report to be adjusted is initially generated, and the report to be adjusted is generated according to the pre-constructed report index comparison relation table. The report to be adjusted is adjusted, and the index comparison relation table corresponding to the report to be adjusted is substantially adjusted.
In the embodiment of the present invention, optionally, the adjusting the index item of the report to be adjusted according to the index item adjusting instruction includes: acquiring a report index comparison relation table corresponding to the report to be adjusted according to the report to be adjusted identifier; adjusting the report index comparison relation table according to the report adjustment instruction to obtain an adjusted report index comparison relation table; and displaying the report matched with the report index comparison relation table according to the adjusted report index comparison relation table.
Under the condition that the identifier of the report to be adjusted is known, the report index comparison relation table corresponding to the report to be adjusted can be obtained from a local database or a cloud. And positioning the index item to be adjusted in the report index comparison relation table according to the index adjustment instruction in the report adjustment instruction, and adjusting the index item to be adjusted to obtain the adjusted report index comparison relation table. And displaying the corresponding report according to the adjusted report index comparison relation table, wherein the report is the report adjusted according to the report adjustment instruction. Optionally, the obtained report adjustment result is stored in a local database or a cloud.
The embodiment of the invention obtains the report adjustment operation type by analyzing the report adjustment instruction; and adjusting the report index comparison relation table corresponding to the report to be adjusted according to the report adjusting operation type. Therefore, the adjustment of the table to be adjusted can be completed only by adjusting the report index comparison table without reconstructing the report index comparison table, and the time cost is reduced.
In this embodiment of the present invention, optionally, after adjusting the report to be adjusted according to the report adjustment instruction and obtaining a report adjustment result, the method further includes: and responding to a report inquiry instruction input by a user, and displaying the report adjustment result.
Wherein, the report inquiry instruction comprises a report mark. The report has the most direct function of being read by a user, and the electronic equipment responds to a report inquiry instruction input by the user and displays a report adjusting result to the user through display equipment such as a display. The embodiment of the invention provides a report query function for the user, so that the user can query the report adjustment result according to the self requirement, and the user experience is improved.
According to the embodiment of the invention, the report adjusting instruction is obtained, and the index item adjustment is carried out on the report to be adjusted according to the index item adjusting instruction in the report adjusting instruction to obtain the report adjusting result, so that the report sample change and report rule modification operation can be completed only by adjusting the original report without generating the report again, the time cost and the labor cost required for generating the report again are saved, and the working efficiency is improved.
Example two
Fig. 2 is a flowchart of a report adjustment method based on indexes in the second embodiment of the present invention, and the present embodiment is further optimized based on the above embodiments. The concrete optimization is as follows: adjusting the index item of the report to be adjusted according to the index item adjusting instruction, comprising: adjusting the logical corresponding relation of the index items in the report to be adjusted; and/or adding, modifying or deleting the index item in the report to be adjusted.
As shown in fig. 2, the method includes:
s210, acquiring a report form adjusting instruction; the report adjusting instruction comprises a report identifier to be adjusted and an index item adjusting instruction; the report to be adjusted comprises at least one index item;
s220, acquiring a report to be adjusted according to the report to be adjusted identifier;
s230, adjusting the logical corresponding relation of the index items in the report to be adjusted; and/or adding, modifying or deleting the index item in the report to be adjusted.
The logical corresponding relation of the index items can be the checking relation of the report, and the logical corresponding relation of the indexes in the report comprises the derived index items in the report index items. As described in the previous examples: the derived index may be the result of calculation of several basic indexes, or may be the result of calculation of several derived indexes. Therefore, the logical corresponding relation of the index items in the report to be adjusted is adjusted, namely the index items in the report to be adjusted are adjusted.
The newly adding operation of the index items in the report to be adjusted means that at least one index item is newly added in the report to be adjusted. The operation of modifying or deleting the index items in the report to be adjusted means that at least one index item is deleted from the report to be adjusted or at least one index item in the report to be adjusted is modified.
The embodiment of the invention provides a method for completing the operation of adding, modifying or deleting the index items and the logical corresponding relation of the index items in the report only by adjusting the report index comparison relation table, and the report is not required to be generated again, thereby simplifying the report modification process, improving the user experience and saving the user time.
In this embodiment of the present invention, optionally, the adjusting the logical correspondence of the index item in the report to be adjusted includes: acquiring a target index item from a fact table according to the report form adjusting instruction; and according to the index item adjusting instruction, adjusting the logical corresponding relation of the index items in the report index comparison relation table of the index items to be adjusted by using the target index items.
The fact table includes all the index items, and is not limited to include only the index items included in a certain report. For example, taking the SMIS system as an example, the fact table includes index items included in all reports in the SMIS.
The target index item is an index item for adjusting an index to be adjusted in the report to be adjusted, which is obtained from the fact table, for example, if the code of the report to be adjusted is a001, there is a derived index S1111111 in the report a001, and the logical correspondence of the derived index S1111111 is changed, for example, the logical correspondence of S1111111 is changed to S1111111 ═ 220+330, where 220 and 330 are the codes of the target index item, at this time, only the target index is obtained from the fact table according to the code of the target index, the derived index S1111111 is recalculated by using the target index, and then the original S1111111 is adjusted to be recalculated to S1111111 in the report index comparison table.
In this embodiment of the present invention, optionally, the adding, modifying, or deleting operation on the index item in the report to be adjusted includes: acquiring a target index item from a fact table according to the report form adjusting instruction; and according to the report adjustment instruction, utilizing the target index item to perform new addition, modification or deletion operation on the index item of the configuration table of the index item to be adjusted.
Illustratively, the report a001 to be adjusted is composed of index items numbered 110, 220, S1111111, and S2222222, and when the report adjustment instruction is to add a new index item 330 to the report a001, the electronic device obtains the index item 330 from the fact table, and adds the index item 330 to the report index comparison table corresponding to the report a001 to be adjusted. Correspondingly, when the report adjustment instruction is to delete the index item 110 in the a001, the report index comparison relation table corresponding to the report a001 to be adjusted is adjusted, and the index item 110 in the report index comparison relation table is deleted. When the report adjustment instruction is to replace the index item 110 in the report a001 to be adjusted with the index item 440, the electronic device obtains the index item 440 from the fact table, and modifies the index 110 into the index 440 in the report index comparison relation table corresponding to the report a001 to be adjusted.
The embodiment of the invention obtains the target index item by working in the fact table; according to the index item adjusting instruction, the target index item is utilized to adjust the report index comparison relation table of the index item to be adjusted, the adjustment of the report can be realized by adjusting only the report index comparison relation table, the difficulty of report modification is reduced, and the user experience is improved.
EXAMPLE III
Fig. 3 is a flowchart of a report adjustment method based on an index in the third embodiment of the present invention, and the present embodiment is further optimized based on the above embodiments. The concrete optimization is as follows:
after the report to be adjusted is obtained according to the report to be adjusted identifier, the method further comprises the following steps: adjusting the form sample corresponding to the report to be adjusted according to the report display requirement to obtain a report adjustment result; the report display requirement comprises the display time of the sample; and establishing an incidence relation among the report to be adjusted, the report adjustment result and the display time of the sample, and storing the report to be adjusted and the report adjustment result.
As shown in fig. 3, the method includes:
s310, acquiring a report form adjusting instruction; the report adjusting instruction comprises a report identifier to be adjusted and an index item adjusting instruction; the report to be adjusted comprises at least one index item;
s320, acquiring a report to be adjusted according to the report to be adjusted identifier;
s330, adjusting the sample corresponding to the report to be adjusted according to the report display requirement to obtain a report adjustment result; the report display requirement comprises the display time of the sample;
wherein, the table sample refers to a table sample unit: is the format of a report, which is all the words, symbols or numbers required to define an empty table with no data. Once a cell is defined as table-like, the contents entered therein are valid for all table pages. The adjustment of the samples in the embodiment of the invention refers to the fine adjustment of the samples, and does not relate to the large-range adjustment of the samples corresponding to the report to be adjusted, such as the operation of adjusting the double lists into the cross list. The display time of the form sample refers to the time when the displayed form sample changes, the report display requirement can be that the report is displayed according to the first style before the display time, and the report is displayed according to the second style after the display time. And adjusting the form sample corresponding to the report to be adjusted, wherein the form sample corresponding to the report to be adjusted is mainly changed, and the report index comparison relation corresponding to the report to be adjusted is essentially changed.
S340, establishing a report to be adjusted, an association relation between a report adjustment result and the display time of the sample, and storing the report to be adjusted and the report adjustment result.
The electronic equipment establishes an incidence relation among the report to be adjusted, the report adjustment result and the display time of the sample, and the incidence relation refers to the fact that the electronic equipment binds the report to be adjusted and the display time of the sample according to the report display requirement, the report adjustment result and the display time of the sample, and then the report to be adjusted and the report adjustment result are stored in a local database or a cloud.
In this embodiment of the present invention, optionally, after the establishing an association relationship between the report to be adjusted, the report adjustment result, and the presentation time of the sample form, and storing the report to be adjusted and the report adjustment result, the method further includes: receiving target query time input by a user; comparing the target query time with the display time of the table sample to obtain a time comparison result; if the target query time is later than the display time of the form sample, displaying the report adjustment result; and if the target query time is earlier than the display time of the form sample, displaying the to-be-adjusted form.
The target query time is the time for the user to input the query instruction. Receiving target query time input by a user; comparing the target query time with the display time of the table sample to obtain a time comparison result; if the target query time is later than the presentation time of the table sample, the report is displayed according to the comparison relation of the report indexes at the moment, the electronic equipment acquires the report adjustment result from a local database or a cloud according to the presentation time of the table sample, and the report adjustment result is presented to a user through the display equipment; and if the target query time is earlier than the presentation time of the form sample, displaying the form according to the form index comparison relation II, acquiring the form to be adjusted from a local database or a cloud end by the electronic equipment according to the presentation time of the form sample, and presenting the form to be adjusted to the user through the display equipment. Illustratively, the function may be implemented using case where statements at the SMIS system program level. The corresponding report sample can be judged and displayed according to the date parameter input by the user in the report query, two reports do not need to be developed, and better user experience is achieved.
According to the embodiment of the invention, the form sample corresponding to the report to be adjusted is adjusted according to the report display requirement to obtain the report adjustment result, the incidence relation among the report to be adjusted, the report adjustment result and the display time of the form sample is established, and the report to be adjusted and the report adjustment result are stored, so that the requirement of changing the report form sample can be met without developing two reports, the user experience is improved, the time required for generating two reports is saved, and the requirement of timeliness can be met.
Example four
Fig. 4 is a schematic structural diagram of an index-based report adjustment apparatus according to a sixth embodiment of the present invention, which is applicable to a case where a report is adjusted when a report sample and a report rule are changed. The method can be executed by a report adjusting device based on indexes, the device can be realized in a software and/or hardware mode, and the device can be configured in the electronic equipment. As shown in fig. 4, the apparatus may include: an adjustment instruction obtaining module 410, a report to be adjusted obtaining module 420 and an index item adjusting module 430.
An adjustment instruction obtaining module 410, configured to obtain a report adjustment instruction; the report adjusting instruction comprises a report identifier to be adjusted and an index item adjusting instruction; the report to be adjusted comprises at least one index item;
a to-be-adjusted report acquisition module 420, configured to acquire a to-be-adjusted report according to the to-be-adjusted report identifier;
and the index item adjusting module 430 is configured to perform index item adjustment on the report to be adjusted according to the index item adjusting instruction to obtain a report adjustment result.
According to the embodiment of the invention, the report adjustment result is obtained by obtaining the report adjustment instruction and adjusting the index item of the report to be adjusted according to the index item adjustment instruction in the report adjustment instruction, so that report sample change and report rule modification operations can be completed only by adjusting the original report without regenerating the report, thereby saving the time cost and labor cost required for regenerating the report and improving the working efficiency.
Optionally, the index item adjusting module 430 includes: the report adjusting instruction analyzing submodule is used for analyzing the report adjusting instruction to obtain a report adjusting operation type; and the report index comparison relation table adjusting submodule is used for adjusting the report index comparison relation table corresponding to the report to be adjusted according to the report adjusting operation type.
Optionally, the index item adjusting module 430 includes: the index item adjusting submodule is used for adjusting the logical corresponding relation of the index items in the report to be adjusted; and/or adding, modifying or deleting the index item in the report to be adjusted.
Optionally, the apparatus further comprises: the report sample adjusting module is used for adjusting the report sample corresponding to the report to be adjusted according to the report display requirement after the report to be adjusted is obtained according to the report to be adjusted identifier so as to obtain a report adjustment result; the report display requirement comprises the display time of the sample; and the incidence relation establishing module is used for establishing incidence relation among the report to be adjusted, the report adjusting result and the display time of the sample, and storing the report to be adjusted and the report adjusting result.
Optionally, the index item adjusting module 430 includes: the report index comparison relation table acquisition sub-module is used for acquiring a report index comparison relation table corresponding to the report to be adjusted according to the report to be adjusted identifier; the report index comparison relation table adjusting submodule is used for adjusting the report index comparison relation table according to the report adjusting instruction to obtain an adjusted report index comparison relation table; and the report display module is used for displaying the report matched with the report index comparison relation table according to the adjusted report index comparison relation table.
Optionally, the index item adjusting submodule includes: the target index item acquisition unit is used for acquiring a target index item from a fact table according to the report adjustment instruction; and the logical correspondence adjusting unit is used for adjusting the logical correspondence of the index items in the report index comparison relation table of the index items to be adjusted by using the target index items according to the index item adjusting instruction.
Optionally, the index item adjusting submodule includes: the target index item acquisition unit is used for acquiring a target index item from a fact table according to the report adjustment instruction; and the index item processing unit is used for performing new addition, modification or deletion operation on the index items of the configuration table of the index items to be adjusted by using the target index items according to the report adjustment instruction.
Optionally, the apparatus further comprises: the target query time receiving module is used for receiving the target query time input by the user after the incidence relation among the report to be adjusted, the report adjustment result and the display time of the sample is established and the report to be adjusted and the report adjustment result are stored; the time comparison module is used for comparing the target query time with the display time of the table sample to obtain a time comparison result; the report to be adjusted display module is used for displaying the report adjustment result if the target query time is later than the display time of the sample; and if the target query time is earlier than the display time of the form sample, displaying the to-be-adjusted form.
Optionally, the apparatus further comprises: and the report adjustment result display module is used for responding to a report inquiry instruction input by a user and displaying the report adjustment result after adjusting the report to be adjusted according to the report adjustment instruction and obtaining the report adjustment result.
The report adjusting device based on the index provided by the embodiment of the invention can execute the report adjusting method based on the index provided by any embodiment of the invention, and has the corresponding functional module and the beneficial effect of executing the report adjusting method based on the index.
EXAMPLE five
The invention also provides an electronic device and a readable storage medium according to the embodiment of the invention.
Fig. 5 is a schematic structural diagram of an electronic device suitable for implementing the index-based report adjustment method in the embodiment of the present invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be examples only, and are not meant to limit implementations of the present application that are described and/or claimed herein.
As shown in fig. 5, the electronic apparatus includes: one or more processors 510, memory 520, and interfaces for connecting the various components, including high-speed interfaces and low-speed interfaces. The various components are interconnected using different buses and may be mounted on a common motherboard or in other manners as desired. The processor may process instructions for execution within the electronic device, including instructions stored in or on the memory to display graphical information of a GUI on an external input/output apparatus (such as a display device coupled to the interface). In other embodiments, multiple processors and/or multiple buses may be used, along with multiple memories and multiple memories, as desired. Also, multiple electronic devices may be connected, with each device providing portions of the necessary operations (e.g., as an array of devices, a set of blades, or a multi-processor system). In fig. 5, one processor 510 is taken as an example.
The memory 520 is a non-transitory computer readable storage medium, and can be used to store non-transitory software programs, non-transitory computer executable programs, and modules, such as program instructions/modules corresponding to an index-based report adjustment method in the embodiment of the present application (for example, the adjustment instruction obtaining module 410, the to-be-adjusted report obtaining module 420, and the index item adjusting module 430 are included in fig. 4). The processor 510 executes various functional applications and data processing of the electronic device by running non-transitory software programs, instructions and modules stored in the memory 520, that is, implements an index-based report adjustment method in the above method embodiments.
The memory 520 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created by use of the electronic device implementing an index-based report adjustment method, and the like. Further, the memory 520 may include high speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, memory 520 optionally includes memory located remotely from processor 510, and these remote memories may be connected via a network to an electronic device that performs a metric-based report adjustment method. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The electronic device executing the index-based report adjustment method may further include: an input device 530 and an output device 540. The processor 510, the memory 520, the input device 530, and the output device 540 may be connected by a bus or other means, and the bus connection is exemplified in fig. 5.
The input device 530 may receive input numeric or character information and generate key signal inputs related to user settings and function control of an electronic apparatus performing a metric-based report adjustment method, such as input devices of a touch screen, a keypad, a mouse, a track pad, a touch pad, a pointing stick, one or more mouse buttons, a track ball, and a joystick. The output device 540 may include a display device, an auxiliary lighting device (e.g., an LED), a haptic feedback device (e.g., a vibration motor), and the like. The display device may include, but is not limited to, a Liquid Crystal Display (LCD), a Light Emitting Diode (LED) display, and a plasma display. In some implementations, the display device can be a touch screen. Various implementations of the systems and techniques described here can be realized in digital electronic circuitry, integrated circuitry, application specific ASICs (application specific integrated circuits), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.
These computer programs (also known as programs, software applications, or code) include machine instructions for a programmable processor, and may be implemented using high-level procedural and/or object-oriented programming languages, and/or assembly/machine languages. As used herein, the terms "machine-readable medium" and "computer-readable medium" refer to any computer program product, apparatus, and/or device (e.g., magnetic discs, optical disks, memory, Programmable Logic Devices (PLDs)) used to provide machine instructions and/or data to a programmable processor, including a machine-readable medium that receives machine instructions as a machine-readable signal. The term "machine-readable signal" refers to any signal used to provide machine instructions and/or data to a programmable processor.
To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), Wide Area Networks (WANs), the internet, and blockchain networks.
The computer system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other.
It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present application may be executed in parallel, sequentially, or in different orders, and the present invention is not limited thereto as long as the desired results of the technical solutions disclosed in the present application can be achieved.
The above-described embodiments should not be construed as limiting the scope of the present application. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present application shall be included in the protection scope of the present application.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (12)
1. A report form adjusting method based on indexes is characterized by comprising the following steps:
acquiring a report adjusting instruction; the report adjusting instruction comprises a report identifier to be adjusted and an index item adjusting instruction; the report to be adjusted comprises at least one index item;
acquiring a report to be adjusted according to the report to be adjusted identifier;
and adjusting the index item of the report to be adjusted according to the index item adjusting instruction to obtain a report adjusting result.
2. The method according to claim 1, wherein the adjusting the report to be adjusted according to the index adjustment instruction includes:
analyzing the report adjusting instruction to obtain a report adjusting operation type;
and adjusting the report index comparison relation table corresponding to the report to be adjusted according to the report adjustment operation type.
3. The method according to claim 1, wherein the performing the index item adjustment on the report to be adjusted according to the index item adjustment instruction comprises:
adjusting the logical corresponding relation of the index items in the report to be adjusted; and/or the presence of a gas in the gas,
and performing addition, modification or deletion on the index items in the report to be adjusted.
4. The method according to claim 1, wherein after obtaining the report to be adjusted according to the report to be adjusted identifier, the method further comprises:
adjusting the form sample corresponding to the report to be adjusted according to the report display requirement to obtain a report adjustment result; the report display requirement comprises the display time of the sample;
and establishing an incidence relation among the report to be adjusted, the report adjustment result and the display time of the sample, and storing the report to be adjusted and the report adjustment result.
5. The method according to claim 1, wherein the index item adjustment of the report to be adjusted according to the index item adjustment instruction comprises:
acquiring a report index comparison relation table corresponding to the report to be adjusted according to the report to be adjusted identifier;
adjusting the report index comparison relation table according to the report adjustment instruction to obtain an adjusted report index comparison relation table;
and displaying the report matched with the report index comparison relation table according to the adjusted report index comparison relation table.
6. The method according to claim 3, wherein the adjusting the logical correspondence of the indicator item in the report to be adjusted includes:
acquiring a target index item from a fact table according to the report form adjusting instruction;
and according to the index item adjusting instruction, adjusting the logical corresponding relation of the index items in the report index comparison relation table of the index items to be adjusted by using the target index items.
7. The method according to claim 3, wherein the adding, modifying or deleting operation of the index item in the report to be adjusted includes:
acquiring a target index item from a fact table according to the report form adjusting instruction; and according to the report adjustment instruction, utilizing the target index item to perform new addition, modification or deletion operation on the index item of the configuration table of the index item to be adjusted.
8. The method according to claim 4, wherein after the establishing of the association relationship between the report to be adjusted, the report adjustment result and the presentation time of the sample, and storing the report to be adjusted and the report adjustment result, further comprising:
receiving target query time input by a user;
comparing the target query time with the display time of the table sample to obtain a time comparison result;
if the target query time is later than the display time of the form sample, displaying the report adjustment result; and if the target query time is earlier than the display time of the form sample, displaying the to-be-adjusted form.
9. The method according to claim 1, wherein after the index item adjustment is performed on the report to be adjusted according to the index item adjustment instruction to obtain a report adjustment result, the method further comprises:
and responding to a report inquiry instruction input by a user, and displaying the report adjustment result.
10. An index-based report adjustment apparatus, the apparatus comprising:
the adjustment instruction acquisition module is used for acquiring a report adjustment instruction; the report adjusting instruction comprises a report identifier to be adjusted and an index item adjusting instruction; the report to be adjusted comprises at least one index item;
the report to be adjusted acquiring module is used for acquiring the report to be adjusted according to the report to be adjusted identifier;
and the index item adjusting module is used for adjusting the index item of the report to be adjusted according to the index item adjusting instruction so as to obtain a report adjusting result.
11. An electronic device, characterized in that the device comprises:
one or more processors;
a memory for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement a method for index-based report adjustment as recited in any of claims 1-9.
12. A non-transitory computer readable storage medium storing computer instructions for causing a computer to perform a method for index-based report adjustment as set forth in any one of claims 1-9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011045442.XA CN112183041A (en) | 2020-09-28 | 2020-09-28 | Report form adjusting method, device, equipment and storage medium based on indexes |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011045442.XA CN112183041A (en) | 2020-09-28 | 2020-09-28 | Report form adjusting method, device, equipment and storage medium based on indexes |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112183041A true CN112183041A (en) | 2021-01-05 |
Family
ID=73946504
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011045442.XA Pending CN112183041A (en) | 2020-09-28 | 2020-09-28 | Report form adjusting method, device, equipment and storage medium based on indexes |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112183041A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109614599A (en) * | 2018-10-23 | 2019-04-12 | 平安科技（深圳）有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN109740134A (en) * | 2018-12-17 | 2019-05-10 | 泰康保险集团股份有限公司 | Report generation method and device |
| CN109858001A (en) * | 2019-01-11 | 2019-06-07 | 平安科技（深圳）有限公司 | A kind of report form generation method, system, electronic equipment and medium |
| CN110335009A (en) * | 2019-05-24 | 2019-10-15 | 平安科技（深圳）有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN110688541A (en) * | 2019-10-08 | 2020-01-14 | 中国建设银行股份有限公司 | Report data query method and device, storage medium and electronic equipment |
| CN111444696A (en) * | 2020-03-26 | 2020-07-24 | 中国银行股份有限公司 | Report display and editing method and device |
-
2020
- 2020-09-28 CN CN202011045442.XA patent/CN112183041A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109614599A (en) * | 2018-10-23 | 2019-04-12 | 平安科技（深圳）有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN109740134A (en) * | 2018-12-17 | 2019-05-10 | 泰康保险集团股份有限公司 | Report generation method and device |
| CN109858001A (en) * | 2019-01-11 | 2019-06-07 | 平安科技（深圳）有限公司 | A kind of report form generation method, system, electronic equipment and medium |
| CN110335009A (en) * | 2019-05-24 | 2019-10-15 | 平安科技（深圳）有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN110688541A (en) * | 2019-10-08 | 2020-01-14 | 中国建设银行股份有限公司 | Report data query method and device, storage medium and electronic equipment |
| CN111444696A (en) * | 2020-03-26 | 2020-07-24 | 中国银行股份有限公司 | Report display and editing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111639078A (en) | Data query method and device, electronic equipment and readable storage medium | |
| CN111639027B (en) | Test method and device and electronic equipment | |
| CN111694857B (en) | Method, device, electronic equipment and computer readable medium for storing resource data | |
| JP2021174516A (en) | Knowledge graph construction method, device, electronic equipment, storage medium, and computer program | |
| CN112199620A (en) | Page operation method and device, electronic equipment and storage medium | |
| CN111666280B (en) | Comment ordering method, comment ordering device, comment ordering equipment and computer storage medium | |
| US11531847B2 (en) | Data labeling method, apparatus and system | |
| US20210133217A1 (en) | Method and apparatus for importing data into graph database, electronic device and medium | |
| CN112015468B (en) | Interface document processing method and device, electronic equipment and storage medium | |
| CN111913808A (en) | Task allocation method, device, equipment and storage medium | |
| US11442930B2 (en) | Method, apparatus, device and storage medium for data aggregation | |
| CN111767321A (en) | Node relation network determining method and device, electronic equipment and storage medium | |
| CN114021156A (en) | Method, device and equipment for organizing vulnerability automatic aggregation and storage medium | |
| CN112084150A (en) | Model training method, data retrieval method, device, equipment and storage medium | |
| EP3889770A1 (en) | Mini program material processing method and apparatus, electronic device, and medium | |
| CN110517079B (en) | Data processing method and device, electronic equipment and storage medium | |
| CN112069155A (en) | Data multidimensional analysis model generation method and device | |
| CN112328658A (en) | User profile data processing method, device, equipment and storage medium | |
| CN111026916A (en) | Text description conversion method and device, electronic equipment and storage medium | |
| US11941055B2 (en) | Method and apparatus for graph computing, electronic device and storage medium | |
| CN111680508B (en) | Text processing method and device | |
| CN111581049B (en) | Distributed system running state monitoring method, device, equipment and storage medium | |
| CN112183041A (en) | Report form adjusting method, device, equipment and storage medium based on indexes | |
| CN111639116B (en) | Data access connection session protection method and device | |
| CN112541718B (en) | Material processing method and device |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220921 Address after: 25 Financial Street, Xicheng District, Beijing 100033 Applicant after: CHINA CONSTRUCTION BANK Corp. Address before: 12 / F, 15 / F, 99 Yincheng Road, China (Shanghai) pilot Free Trade Zone, Pudong New Area, Shanghai, 200120 Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |