CN109344380B - Method and device for opening report - Google Patents
Method and device for opening report Download PDFInfo
- Publication number
- CN109344380B CN109344380B CN201811119324.1A CN201811119324A CN109344380B CN 109344380 B CN109344380 B CN 109344380B CN 201811119324 A CN201811119324 A CN 201811119324A CN 109344380 B CN109344380 B CN 109344380B
- Authority
- CN
- China
- Prior art keywords
- snapshot
- report
- information
- generating
- executing
- 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
Links
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a device for opening a report, wherein the method comprises the following steps: generating at least one snapshot of a report in advance; for each of the snapshots, performing: judging whether current report information corresponding to the current snapshot in the report is updated after the current snapshot is generated in real time, if so, determining that the current snapshot is unavailable, otherwise, determining that the current snapshot is available; and after receiving an instruction for opening the report, reading the available snapshot in the at least one snapshot, and loading report information corresponding to the unavailable snapshot in the at least one snapshot to open the report. The invention provides a method and a device for opening a report, which can reduce the time required for opening the report.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a method and a device for opening a report.
Background
Reports are often used in work, at present, in the process of opening the report each time, the dimension data, the classification data, the data authority, the cell attributes, the formula information, the dimension combination relation and the like of each dimension of the report need to be correlated, and the dimension information arrangement, the cell attribute setting, the formula information formation and the like all consume a large amount of time. Therefore, the process of opening the report takes much time.
Disclosure of Invention
The embodiment of the invention provides a method and a device for opening a report, which can reduce the time required for opening the report.
In one aspect, an embodiment of the present invention provides a method for opening a report, including:
generating at least one snapshot of a report in advance;
for each of the snapshots, performing: judging whether current report information corresponding to the current snapshot in the report is updated or not in real time after the current snapshot is generated, if so, determining that the current snapshot is unavailable, otherwise, determining that the current snapshot is available;
and after receiving an instruction for opening the report, reading the available snapshot in the at least one snapshot, and loading report information corresponding to the unavailable snapshot in the at least one snapshot to open the report.
Preferably, the first and second electrodes are formed of a metal,
the at least one snapshot of the pre-generated report includes:
dividing the report into row information, column information, cell information, report data information and formula information in advance;
generating a snapshot corresponding to the column information according to the column information;
generating a snapshot corresponding to the row information according to the row information;
generating a snapshot corresponding to the cell information according to the cell information;
generating a snapshot corresponding to the report data information according to the report data information;
and generating a snapshot corresponding to the formula information according to the formula information.
Preferably, the first and second liquid crystal display panels are,
the reading of the available snapshot in the at least one snapshot and the loading of the report information corresponding to the unavailable snapshot in the at least one snapshot to open the report includes:
a1: judging whether the snapshot corresponding to the column information is available, if so, executing A1, otherwise, executing A2;
a2: reading the snapshot corresponding to the column information, and executing A4;
a3: loading the column information, and executing A4;
a4: judging whether the snapshot corresponding to the row information is available, if so, executing A5, otherwise, executing A6;
a5: reading the snapshot corresponding to the row information, and executing A7;
a6: loading the line information and executing A7;
a7: judging whether the snapshot corresponding to the cell information is available, if so, executing A8, otherwise, executing A9;
a8: reading the snapshot corresponding to the cell information, and concurrently executing A10 and A11;
a9: loading the cell information, and concurrently executing A10 and A11;
a10: judging whether the snapshot corresponding to the report data information is available, if so, reading the snapshot corresponding to the report data information, otherwise, loading the report data information;
a11: and judging whether the snapshot corresponding to the formula information is available, if so, reading the snapshot corresponding to the formula information, and otherwise, loading the formula information.
Preferably, the first and second electrodes are formed of a metal,
the generating a snapshot corresponding to the column information according to the column information includes:
determining the report internal code of the report;
determining at least one first combination of dimensions of the data column of the report corresponding to the report internal code;
determining the attribute of the data column corresponding to each first combination;
generating a snapshot corresponding to the column information according to the attribute of the data column corresponding to each first combination;
the generating a snapshot corresponding to the row information according to the row information includes:
determining at least one second combination of an instance internal code, an organization internal code and a filtering dimension of the report;
determining the attribute of the row of the report corresponding to each second combination;
generating a data packet corresponding to each second combination according to the attribute of the row of the report corresponding to each second combination;
generating a snapshot corresponding to the row information according to the data packet corresponding to each second combination;
the generating a snapshot corresponding to the cell information according to the cell information includes:
determining at least one third combination of instance internal codes, organization internal codes and filtering dimensions of the report;
determining the attributes of the cells of the report corresponding to each third combination;
generating a data packet corresponding to each third combination according to the attribute of the cell of the report corresponding to each third combination;
and generating a snapshot corresponding to the cell information according to the data packet corresponding to each third combination.
Preferably, the first and second liquid crystal display panels are,
the method further comprises the following steps: setting a format snapshot for the report in advance;
after receiving an instruction of opening the report, judging whether the report is in an unmodifiable state, if so, reading the format snapshot of the report, and realizing the opening of the report.
Preferably, the first and second liquid crystal display panels are,
after the determining that the current snapshot is not available, further comprising:
and generating a new snapshot according to the updated current report information, and determining that the snapshot corresponding to the updated current report information is available.
Preferably, the first and second electrodes are formed of a metal,
the method further comprises the following steps:
and receiving an external deleting instruction, deleting any snapshot in the at least one snapshot, and determining that the deleted snapshot is unavailable.
On the other hand, an embodiment of the present invention provides an apparatus for opening a report, including:
the generating unit is used for generating at least one snapshot of the report;
a detection unit configured to, for each of the snapshots, perform: judging whether current report information corresponding to the current snapshot in the report is updated after the current snapshot is generated in real time, if so, determining that the current snapshot is unavailable, otherwise, determining that the current snapshot is available;
and the opening unit is used for reading the available snapshot in the at least one snapshot after receiving the instruction of opening the report, loading report information corresponding to the unavailable snapshot in the at least one snapshot, and realizing opening of the report.
Preferably, the first and second liquid crystal display panels are,
the generating unit is configured to:
dividing the report into row information, column information, cell information, report data information and formula information in advance;
generating a snapshot corresponding to the column information according to the column information;
generating a snapshot corresponding to the row information according to the row information;
generating a snapshot corresponding to the cell information according to the cell information;
generating a snapshot corresponding to the report data information according to the report data information;
and generating a snapshot corresponding to the formula information according to the formula information.
Preferably, the first and second electrodes are formed of a metal,
the opening unit is used for:
a1: judging whether the snapshot corresponding to the column information is available, if so, executing A1, otherwise, executing A2;
a2: reading a snapshot corresponding to the column information, and executing A4;
a3: loading the column information, and executing A4;
a4: judging whether the snapshot corresponding to the row information is available, if so, executing A5, otherwise, executing A6;
a5: reading the snapshot corresponding to the row information, and executing A7;
a6: loading the line information, and executing A7;
a7: judging whether the snapshot corresponding to the cell information is available, if so, executing A8, otherwise, executing A9;
a8: reading the snapshot corresponding to the cell information, and concurrently executing A10 and A11;
a9: loading the cell information, and concurrently executing A10 and A11;
a10: judging whether the snapshot corresponding to the report data information is available, if so, reading the snapshot corresponding to the report data information, otherwise, loading the report data information;
a11: and judging whether the snapshot corresponding to the formula information is available, if so, reading the snapshot corresponding to the formula information, and otherwise, loading the formula information.
Preferably, the first and second electrodes are formed of a metal,
the generating unit, when executing the generating of the snapshot corresponding to the column information according to the column information, is configured to:
determining the report internal code of the report;
determining at least one first combination of dimensions of the data column of the report corresponding to the report internal code;
determining the attribute of the data column corresponding to each first combination;
generating a snapshot corresponding to the column information according to the attribute of the data column corresponding to each first combination;
the generating unit, when executing the generating of the snapshot corresponding to the line information according to the line information, is configured to:
determining at least one second combination of instance internal codes, organization internal codes and filtering dimensions of the report;
determining the attribute of the row of the report corresponding to each second combination;
generating a data packet corresponding to each second combination according to the attribute of the row of the report corresponding to each second combination;
generating a snapshot corresponding to the row information according to the data packet corresponding to each second combination;
the generating unit, when executing the generating of the snapshot corresponding to the cell information according to the cell information, is configured to:
determining at least one third combination of instance internal codes, organization internal codes and filtering dimensions of the report;
determining the attributes of the cells of the report corresponding to each third combination;
generating a data packet corresponding to each third combination according to the attribute of the cell of the report corresponding to each third combination;
and generating a snapshot corresponding to the cell information according to the data packet corresponding to each third combination.
Preferably, the first and second electrodes are formed of a metal,
the apparatus further comprises:
the setting unit is used for setting format snapshots for the report;
and the opening unit is further used for judging whether the report is in an unmodified state or not after receiving an instruction of opening the report, and reading the format snapshot of the report to open the report if the report is in the unmodified state.
Preferably, the first and second electrodes are formed of a metal,
the detecting unit is further configured to generate a new snapshot according to the updated current report information after determining that the current snapshot is unavailable, and determine that the snapshot corresponding to the updated current report information is available.
Preferably, the first and second electrodes are formed of a metal,
the apparatus further comprises:
and the deleting unit is used for receiving an external deleting instruction, deleting any snapshot in the at least one snapshot and determining that the deleted snapshot is unavailable.
In the embodiment of the invention, at least one snapshot of the report is generated, when the report needs to be opened, only the updated report information is loaded, and for the report information which does not have the updated report information, the corresponding snapshot is directly read, and the time for reading the snapshot is less, so that the time for opening the report is greatly reduced.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
FIG. 1 is a flowchart of a method for opening a report according to an embodiment of the present invention;
FIG. 2 is a flowchart of another method for opening a report according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating an apparatus for opening a report according to an embodiment of the present invention;
fig. 4 is a schematic diagram of another apparatus for opening a report according to an embodiment of the present invention.
Detailed Description
To make the objects, technical solutions and advantages of the embodiments of the present invention clearer and more complete, the technical solutions in the embodiments of the present invention will be described below with reference to the drawings in the embodiments of the present invention, it is obvious that the described embodiments are some, but not all embodiments of the present invention, and based on the embodiments of the present invention, all other embodiments obtained by a person of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.
As shown in fig. 1, an embodiment of the present invention provides a method for opening a report, where the method may include the following steps:
step 101: generating at least one snapshot of a report in advance;
step 102: for each of the snapshots, performing: judging whether current report information corresponding to the current snapshot in the report is updated or not in real time after the current snapshot is generated, if so, determining that the current snapshot is unavailable, otherwise, determining that the current snapshot is available;
step 103: and after receiving an instruction for opening the report, reading the available snapshot in the at least one snapshot, and loading report information corresponding to the unavailable snapshot in the at least one snapshot to open the report.
In the embodiment of the invention, at least one snapshot of the report is generated, when the report needs to be opened, only the updated report information is loaded, and for the report information which does not have the updated report information, the corresponding snapshot is directly read, and the time for reading the snapshot is less, so that the time for opening the report is greatly reduced.
Step 101 may be implemented when the report is first opened.
In an embodiment of the present invention, the at least one snapshot of the pre-generated report includes:
dividing the report into row information, column information, cell information, report data information and formula information in advance;
generating a snapshot corresponding to the column information according to the column information;
generating a snapshot corresponding to the row information according to the row information;
generating a snapshot corresponding to the cell information according to the cell information;
generating a snapshot corresponding to the report data information according to the report data information;
and generating a snapshot corresponding to the formula information according to the formula information.
In the embodiment of the invention, the report is divided into five parts, namely row information, column information, cell information, report data information and formula information, and a corresponding snapshot is generated aiming at each part. Correspondingly, when the snapshot is detected, if the column information is updated, the snapshot corresponding to the column information is determined to be unavailable, if the row information is updated, the snapshot corresponding to the row information is determined to be unavailable, if the cell information is updated, the snapshot corresponding to the cell information is determined to be unavailable, if the report data information is updated, the snapshot corresponding to the report data information is determined to be unavailable, and if the formula information is updated, the snapshot corresponding to the formula information is determined to be unavailable.
In an embodiment of the present invention, the reading an available snapshot in the at least one snapshot, and loading report information corresponding to an unavailable snapshot in the at least one snapshot to open the report includes:
a1: judging whether the snapshot corresponding to the column information is available, if so, executing A1, otherwise, executing A2;
a2: reading the snapshot corresponding to the column information, and executing A4;
a3: loading the column information, and executing A4;
a4: judging whether the snapshot corresponding to the row information is available, if so, executing A5, otherwise, executing A6;
a5: reading the snapshot corresponding to the row information, and executing A7;
a6: loading the line information and executing A7;
a7: judging whether the snapshot corresponding to the cell information is available, if so, executing A8, otherwise, executing A9;
a8: reading the snapshot corresponding to the cell information, and concurrently executing A10 and A11;
a9: loading the cell information, and concurrently executing A10 and A11;
a10: judging whether the snapshot corresponding to the report data information is available, if so, reading the snapshot corresponding to the report data information, otherwise, loading the report data information;
a11: and judging whether the snapshot corresponding to the formula information is available, if so, reading the snapshot corresponding to the formula information, and otherwise, loading the formula information.
In the embodiment of the invention, when the report is opened, the processing is carried out according to the sequence of the column information, the row information and the cell information, and after the cell information is processed, the report data information and the formula information can be processed firstly and then, or the report data information and the formula information can be processed in parallel.
In an embodiment of the present invention, the generating a snapshot corresponding to the column information according to the column information includes:
determining the report internal code of the report;
determining at least one first combination of dimensions of the data column of the report corresponding to the report internal code;
determining the attribute of the data column corresponding to each first combination;
generating a snapshot corresponding to the column information according to the attribute of the data column corresponding to each first combination;
the generating a snapshot corresponding to the row information according to the row information includes:
determining at least one second combination of instance internal codes, organization internal codes and filtering dimensions of the report;
determining the attribute of the row of the report corresponding to each second combination;
generating a data packet corresponding to each second combination according to the attribute of the row of the report corresponding to each second combination;
generating a snapshot corresponding to the row information according to the data packet corresponding to each second combination;
the generating a snapshot corresponding to the cell information according to the cell information includes:
determining at least one third combination of an instance internal code, an organization internal code and a filtering dimension of the report;
determining the attributes of the cells of the report corresponding to each third combination;
generating a data packet corresponding to each third combination according to the attribute of the cell of the report corresponding to each third combination;
and generating a snapshot corresponding to the cell information according to the data packet corresponding to each third combination.
Specifically, the snapshot corresponding to the column information may be generated by:
taking a report model as a reference (because data columns of different organizations or activities generally have no change, the snapshot takes the report model as the reference and does not take the report as the reference), taking report internal codes as minimum data packets, taking the combination of all dimensions of the data columns contained in the current report as a minimum unit, and taking the content of each minimum unit as an attribute of each data column, wherein the attributes of the data columns include: and the value object, the data type, the read-only information and the like corresponding to the data column. In addition, the snapshot corresponding to the column information may be named as follows: TBDCOL _4 bit model inner code.
Specifically, the snapshot corresponding to the row information may be generated in the following manner:
taking a report as a reference, taking the combination of an example internal code, an organization internal code and a filtering dimension as a minimum data packet, taking the combination of all dimensions of an information column contained in the current report as a minimum unit, and taking the content of each minimum unit as an attribute of each row, wherein the attributes of the rows comprise: and the self-defining item, the grading information, the data grade and other information corresponding to the line. In addition, the snapshot corresponding to the row information may be named as follows: the middle 10 bits are taken as the internal code of the TBEDIT _ CACHE _ report.
Specifically, the snapshot corresponding to the cell information may be generated in the following manner:
taking the report as a reference, taking the combination of instance internal code, organization internal code and filtering dimension as a minimum data packet, taking the combination of all dimensions contained in the current report as a minimum unit, and taking the content of each minimum unit as an attribute of a corresponding cell, wherein the attributes of the cells comprise: budget data, data state, execution data, data source, etc. In addition, the snapshot corresponding to the cell information may be named as follows: the middle 10 bits are taken as the internal code of the TBDATA _ CACHE _ report.
In addition, the generation mode of the snapshot corresponding to the report data information and the snapshot corresponding to the formula information is similar to the generation mode of the snapshot corresponding to the cell information.
In an embodiment of the invention, the method further comprises: setting a format snapshot for the report in advance;
after receiving an instruction of opening the report, judging whether the report is in an unmodifiable state, if so, reading the format snapshot of the report, and realizing the opening of the report.
In the embodiment of the invention, the format snapshot is set for the whole report, and if the report is in an unmodified state, the report can be opened by directly reading the format snapshot. Specifically, the report does not need to be modified in the examination and approval, and the data, the rows and the columns and the like of the report do not change in the examination and approval, so that the format snapshot corresponding to the report is directly stored after the examination and approval is submitted, when the examination and approval person opens the report, the format snapshot is directly read, the data do not need to be fetched from the database through complex logic, and the efficiency of opening the report is greatly improved.
Aiming at the report which does not need to modify data in examination and approval, when the report is submitted and approved, the storage of report format snapshots is increased, and when an approver opens the report in a task to be handled, the information of the report is directly loaded through the format snapshots without reorganizing the data.
The snapshot identification interfaces are changed as follows:
in an embodiment of the present invention, after the determining that the current snapshot is not available, further includes:
and generating a new snapshot according to the updated current report information, and determining that the snapshot corresponding to the updated current report information is available.
In the embodiment of the invention, along with the update of the report information, the snapshot of the report information is correspondingly updated, so that more snapshots can be available when the report is opened.
In an embodiment of the invention, the method further comprises:
and receiving an external deleting instruction, deleting any snapshot in the at least one snapshot, and determining that the deleted snapshot is unavailable.
In the embodiment of the invention, the snapshot can be deleted, so that the condition that the snapshot is inconsistent with actual data or the function problem caused by snapshot error can be prevented from occurring in the using process of the snapshot. The user can manually clear the snapshot through the step, so that the accuracy and the continuity of the snapshot are ensured.
As shown in fig. 2, a method for opening a report provided in an embodiment of the present invention includes:
step 201: the method comprises the steps of dividing a report into row information, column information, cell information, report data information and formula information in advance, generating snapshots corresponding to the column information according to the column information, generating snapshots corresponding to the row information according to the row information, generating snapshots corresponding to the cell information according to the cell information, generating snapshots corresponding to the report data information according to the report data information, and generating snapshots corresponding to the formula information according to the formula information.
Step 202: for each snapshot, performing: judging whether current report information corresponding to a current snapshot in a report is updated after the current snapshot is generated in real time, if so, determining that the current snapshot is unavailable, otherwise, determining that the current snapshot is available, wherein the current report information comprises: row information, column information, cell information, report data information, and formula information.
Step 203: and judging whether the snapshot corresponding to the column information is available, if so, executing the step 204, otherwise, executing the step 205.
Step 204: and the snapshot corresponding to the column information is read, and step 206 is executed.
Step 205: and loading the column information, generating a new snapshot according to the column information, determining that the new snapshot corresponding to the column information is available, and executing step 206.
Step 206: and judging whether the snapshot corresponding to the row information is available, if so, executing step 207, otherwise, executing step 208.
Step 207: and the snapshot corresponding to the row information is read, and step 209 is executed.
Step 208: and loading the row information, generating a new snapshot according to the row information, determining that the new snapshot corresponding to the row information is available, and executing step 209.
Step 209: and judging whether the snapshot corresponding to the cell information is available, if so, executing step 210, otherwise, executing step 211.
Step 210: and reading the snapshot corresponding to the cell information, and concurrently executing step 212 and step 215.
Step 211: loading the cell information, generating a new snapshot according to the cell information, determining that the new snapshot corresponding to the cell information is available, and concurrently executing step 212 and step 215.
Step 212: and judging whether the snapshot corresponding to the report data information is available, if so, executing step 213, otherwise, executing step 214.
Step 213: and reading the snapshot corresponding to the report data information.
Step 214: and loading report data information, generating a new snapshot according to the report data information, and determining that the new snapshot corresponding to the report data information is available.
Step 215: and judging whether the snapshot corresponding to the formula information is available, if so, executing step 216, otherwise, executing step 217.
Step 216: and reading a snapshot corresponding to the formula information.
Step 217: and loading formula information, generating a new snapshot according to the formula information, and determining that the new snapshot corresponding to the formula information is available.
The report form in the embodiment of the invention can be a budget table, and the embodiment of the invention is suitable for comprehensive budget planning.
In the embodiment of the invention, snapshots corresponding to row information, column information, cell information, report data information and formula information of the report are preset. When the report is subsequently opened, only the changed part of the data is rearranged, and the unchanged part of the data directly reads the corresponding snapshot, so that the speed of opening the report can be greatly increased.
In the embodiment of the present invention, whether a snapshot is available or not may be marked by a snapshot identifier, and when the snapshot identifier is 0, it indicates that the snapshot is not available, and when the snapshot identifier is 1, it indicates that the snapshot is available.
With the example internal code, the organization internal code, the report number and the filtering dimension as the reference, three rows of TBBBST _ LSBBJ, TBBBST _ SJLSBBJ and TBBBST _ GSLSBBJ are added in the TBBBST (data table for recording report states), and the data are recorded respectively: the snapshot identifier of the format snapshot, the snapshot identifier of the snapshot corresponding to the report data information and the snapshot identifier of the snapshot corresponding to the formula information.
Specifically, the modification mechanism of the snapshot identifier is as follows:
the snapshot identification modification logic of the report format snapshot is as follows: for all entries that may cause report format modification, after the modification is completed, updating the value of TBBBST _ LSBBJ in the active-enabled TBBBST to be 0 indicates that the format snapshot is not up-to-date and data in the report needs to be reloaded, and the modification points are as follows:
A. budget sample definition: table sample definition storage, examination release and formula storage.
B. Public/private budget dimension definition-dimension data classification: save, delete, copy, move up, move down, move. The method specifically comprises the following steps:
(a) After the dimension classification is modified, the report using the classification is searched, so that all the corresponding reports in the TBBBST are searched under the started activity, and the LSBJB identifications are all changed into 0.
(b) After the dimension classification is modified, a dimension formula using the classification is searched, namely, a formula of FLNM is defined in TBJSZ, then a model where the report using the formula is located is found, all reports in the model enable activities and all organizations correspondingly in TBBBST, and TBBBST _ LSBBJ identifications are all changed into 0.
C. Public/private budget dimension definition-dimension data: saving takes into account modifications of the custom items, which also regenerate the temporary table for modifications of the dimensions.
D. The dimension combination relation defines: and storing, storing and adding newly, and changing the data of the report contained in the TBBBST and the TBBBST _ LSBBJ identifier into 0 under the enabled activity according to the set applicable report.
E. Public/private budget organization definition: and judging the change of the organization property, and if the organization property is modified, performing all reports corresponding to the organization under the condition of activity enabled in the TBBBST, wherein the TBBBST _ LSBBJ identification is completely changed into 0.
F. Budget adjustment: if the table adds or deletes rows to or from the information column during adjustment, the adjustment is stored while identifying the condition, and the TBBBST _ LSBBJ flag in TBBBST is changed to 0.
G. Item dimension dictionary: since the data columns need to be expanded according to the start and end dates of the items when the item dimensions are filtered, the time stamp of the temporary table needs to be compared with the time stamp of the item modification when the item dimensions are opened, and whether the temporary table needs to be regenerated or not needs to be judged.
Specifically, the modification mechanism of the snapshot identifier of the snapshot corresponding to the report data information is as follows:
for all entries that may modify data, after modification, the value of TBBBST _ sjslbbjd of TBBBST data corresponding to SLNM, ZZNM, DYBH, and GLWD is updated to 0, and the main control entries are as follows:
A. in-table calculations and summaries
B. Off-table computation
C. Outside watch summary
D. Collection of pre-arithmetic numbers
E. Excel import
Specifically, the modification mechanism of the snapshot identifier of the snapshot corresponding to the formula information is as follows:
for all entries that may modify a formula or formula-related data, after data modification, updating TBBBST _ GSLSBBJ of corresponding SLNM, ZZNM, DYBH, GLWD data in TBBBST to 0, the main control entries are as follows:
A. formula definition modification;
B. the formulas relate to the addition and deletion of classified data.
In the embodiment of the present invention, generating the snapshot may be implemented by the following interfaces:
TBCacheEntity TBCache＝new TBCacheEntity()；
TBCache.ifApplyCache＝this.ifApplyCache；
TBCache.ifApplyFormatCache＝this.ifApplyFormatCache；
TBCache.ifApplyFormulaCache＝this.ifApplyFormulaCache；
PubFunction.RebuildCache(TBCache,FASLNM,BBDYNM,ZZNM,GLWD,
bzParameter.Model,this.sDataTable,this.sEditTable)；
as shown in fig. 3 and 4, an embodiment of the present invention provides a device for opening a report. The device embodiments may be implemented by software, or by hardware, or by a combination of hardware and software. From a hardware level, as shown in fig. 3, a hardware structure diagram of a device for opening a report according to an embodiment of the present invention is shown, where the device in the embodiment may generally include other hardware, such as a forwarding chip responsible for processing a packet, in addition to the processor, the memory, the network interface, and the nonvolatile memory shown in fig. 3. Taking a software implementation as an example, as shown in fig. 4, as a logical apparatus, the apparatus is formed by reading a corresponding computer program instruction in a non-volatile memory into a memory by a CPU of a device in which the apparatus is located and running the computer program instruction. The device for opening the report provided by the embodiment comprises:
a generating unit 401, configured to generate at least one snapshot of a report;
a detecting unit 402, configured to, for each snapshot, perform: judging whether current report information corresponding to the current snapshot in the report is updated after the current snapshot is generated in real time, if so, determining that the current snapshot is unavailable, otherwise, determining that the current snapshot is available;
the opening unit 403 is configured to, after receiving an instruction to open a report, read an available snapshot in the at least one snapshot, load report information corresponding to an unavailable snapshot in the at least one snapshot, and open the report.
In an embodiment of the present invention, the generating unit is configured to:
dividing the report into row information, column information, cell information, report data information and formula information in advance;
generating a snapshot corresponding to the column information according to the column information;
generating a snapshot corresponding to the row information according to the row information;
generating a snapshot corresponding to the cell information according to the cell information;
generating a snapshot corresponding to the report data information according to the report data information;
and generating a snapshot corresponding to the formula information according to the formula information.
In an embodiment of the present invention, the opening unit is configured to:
a1: judging whether the snapshot corresponding to the column information is available, if so, executing A1, otherwise, executing A2;
a2: reading the snapshot corresponding to the column information, and executing A4;
a3: loading the column information, and executing A4;
a4: judging whether the snapshot corresponding to the row information is available, if so, executing A5, otherwise, executing A6;
a5: reading the snapshot corresponding to the row information, and executing A7;
a6: loading the line information and executing A7;
a7: judging whether the snapshot corresponding to the cell information is available, if so, executing A8, otherwise, executing A9;
a8: reading the snapshot corresponding to the cell information, and concurrently executing A10 and A11;
a9: loading the cell information, and concurrently executing A10 and A11;
a10: judging whether the snapshot corresponding to the report data information is available, if so, reading the snapshot corresponding to the report data information, otherwise, loading the report data information;
a11: and judging whether the snapshot corresponding to the formula information is available, if so, reading the snapshot corresponding to the formula information, and otherwise, loading the formula information.
In an embodiment of the present invention, when the generating unit is executed to generate the snapshot corresponding to the column information according to the column information, the generating unit is configured to:
determining the report internal code of the report;
determining at least one first combination of dimensions of the data column of the report corresponding to the report internal code;
determining the attribute of the data column corresponding to each first combination;
generating a snapshot corresponding to the column information according to the attribute of the data column corresponding to each first combination;
the generating unit, when executing the generating of the snapshot corresponding to the row information according to the row information, is configured to:
determining at least one second combination of an instance internal code, an organization internal code and a filtering dimension of the report;
determining the attribute of the row of the report corresponding to each second combination;
generating a data packet corresponding to each second combination according to the attribute of the row of the report corresponding to each second combination;
generating a snapshot corresponding to the row information according to the data packet corresponding to each second combination;
the generating unit, when executing the generating of the snapshot corresponding to the cell information according to the cell information, is configured to:
determining at least one third combination of an instance internal code, an organization internal code and a filtering dimension of the report;
determining the attribute of the cell of the report corresponding to each third combination;
generating a data packet corresponding to each third combination according to the attribute of the cell of the report corresponding to each third combination;
and generating a snapshot corresponding to the cell information according to the data packet corresponding to each third combination.
In an embodiment of the present invention, the apparatus further comprises:
the setting unit is used for setting format snapshots for the report;
and the opening unit is further used for judging whether the report is in an unmodified state or not after receiving an instruction of opening the report, and reading the format snapshot of the report to open the report if the report is in the unmodified state.
In an embodiment of the present invention, the detecting unit is further configured to generate a new snapshot according to the updated current report information after determining that the current snapshot is unavailable, and determine that the snapshot corresponding to the updated current report information is available.
In an embodiment of the present invention, the apparatus further comprises:
and the deleting unit is used for receiving an external deleting instruction, deleting any snapshot in the at least one snapshot and determining that the deleted snapshot is unavailable.
For the information interaction, execution process and other contents between the units in the above device, the specific contents may refer to the description in the embodiment of the method of the present invention because the same conception is based on, and are not described herein again.
The embodiment of the invention provides a readable medium, which comprises an execution instruction, wherein when a processor of a storage controller executes the execution instruction, the storage controller executes any method for opening a report, which is provided by the embodiment of the invention.
An embodiment of the present invention provides a storage controller, including: a processor, a memory, and a bus;
the memory is used for storing an execution instruction, the processor is connected with the memory through the bus, and when the storage controller runs, the processor executes the execution instruction stored in the memory, so that the storage controller executes any method for opening a report provided by the embodiment of the invention.
The embodiments of the invention at least have the following beneficial effects:
1. in the embodiment of the invention, at least one snapshot of the report is generated, when the report needs to be opened, only the updated report information is loaded, and for the report information which does not have the updated report information, the corresponding snapshot is directly read, and the time for reading the snapshot is less, so that the time for opening the report is greatly reduced.
2. In the embodiment of the invention, snapshots corresponding to row information, column information, cell information, report data information and formula information of the report are preset. When the report is subsequently opened, only the data of the changed part of the data is rearranged, and the corresponding snapshot is directly read from the part of the data which is not changed, so that the speed of opening the report can be greatly improved.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising a" \8230; "does not exclude the presence of additional like elements in a process, method, article, or apparatus that comprises the element.
Those of ordinary skill in the art will understand that: all or part of the steps for realizing the method embodiments can be completed by hardware related to program instructions, the program can be stored in a computer readable storage medium, and the program executes the steps comprising the method embodiments when executed; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.
Finally, it should be noted that: the above description is only a preferred embodiment of the present invention, and is only used to illustrate the technical solutions of the present invention, and not to limit the protection scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention shall fall within the protection scope of the present invention.
Claims (2)
1. A method for opening a report is characterized in that at least one snapshot of the report is generated in advance, and the method further comprises the following steps:
for each of the snapshots, performing: judging whether current report information corresponding to the current snapshot in the report is updated or not in real time after the current snapshot is generated, if so, determining that the current snapshot is unavailable, otherwise, determining that the current snapshot is available;
after receiving a report opening instruction, reading an available snapshot in the at least one snapshot, and loading report information corresponding to the unavailable snapshot in the at least one snapshot to open the report;
the at least one snapshot of the pre-generated report includes:
dividing the report into row information, column information, cell information, report data information and formula information in advance;
generating a snapshot corresponding to the column information according to the column information;
generating a snapshot corresponding to the row information according to the row information;
generating a snapshot corresponding to the cell information according to the cell information;
generating a snapshot corresponding to the report data information according to the report data information;
generating a snapshot corresponding to the formula information according to the formula information;
the reading of the available snapshot in the at least one snapshot and the loading of the report information corresponding to the unavailable snapshot in the at least one snapshot to open the report includes:
a1: judging whether the snapshot corresponding to the column information is available, if so, executing A1, otherwise, executing A2;
a2: reading the snapshot corresponding to the column information, and executing A4;
a3: loading the column information, and executing A4;
a4: judging whether the snapshot corresponding to the row information is available, if so, executing A5, otherwise, executing A6;
a5: reading the snapshot corresponding to the row information, and executing A7;
a6: loading the line information, and executing A7;
a7: judging whether the snapshot corresponding to the cell information is available, if so, executing A8, otherwise, executing A9;
a8: reading the snapshot corresponding to the cell information, and concurrently executing A10 and A11;
a9: loading the cell information, and concurrently executing A10 and A11;
a10: judging whether the snapshot corresponding to the report data information is available, if so, reading the snapshot corresponding to the report data information, otherwise, loading the report data information;
a11: judging whether the snapshot corresponding to the formula information is available, if so, reading the snapshot corresponding to the formula information, otherwise, loading the formula information;
the generating a snapshot corresponding to the column information according to the column information includes:
determining the report internal code of the report;
determining at least one first combination of dimensions of the data column of the report corresponding to the report internal code;
determining the attribute of the data column corresponding to each first combination;
generating a snapshot corresponding to the column information according to the attribute of the data column corresponding to each first combination;
the generating a snapshot corresponding to the row information according to the row information includes:
determining at least one second combination of an instance internal code, an organization internal code and a filtering dimension of the report;
determining the attribute of the row of the report corresponding to each second combination;
generating a data packet corresponding to each second combination according to the attribute of the row of the report corresponding to each second combination;
generating a snapshot corresponding to the row information according to the data packet corresponding to each second combination;
the generating a snapshot corresponding to the cell information according to the cell information includes:
determining at least one third combination of an instance internal code, an organization internal code and a filtering dimension of the report;
determining the attributes of the cells of the report corresponding to each third combination;
generating a data packet corresponding to each third combination according to the attribute of the cell of the report corresponding to each third combination;
generating a snapshot corresponding to the cell information according to the data packet corresponding to each third combination;
further comprising: setting a format snapshot for the report in advance;
after receiving a report opening instruction, judging whether the report is in an unmodifiable state, if so, reading a format snapshot of the report to open the report;
and/or the presence of a gas in the atmosphere,
after the determining that the current snapshot is not available, further comprising:
generating a new snapshot according to the updated current report information, and determining that the snapshot corresponding to the updated current report information is available;
and/or the presence of a gas in the gas,
further comprising:
and receiving an external deleting instruction, deleting any snapshot in the at least one snapshot, and determining that the deleted snapshot is unavailable.
2. An apparatus for opening a report, comprising:
the generating unit is used for generating at least one snapshot of the report;
a detection unit configured to, for each of the snapshots, perform: judging whether current report information corresponding to the current snapshot in the report is updated or not in real time after the current snapshot is generated, if so, determining that the current snapshot is unavailable, otherwise, determining that the current snapshot is available;
the opening unit is used for reading the available snapshot in the at least one snapshot after receiving the instruction of opening the report, loading report information corresponding to the unavailable snapshot in the at least one snapshot, and realizing opening of the report;
the generating unit is configured to:
dividing the report into row information, column information, cell information, report data information and formula information in advance;
generating a snapshot corresponding to the column information according to the column information;
generating a snapshot corresponding to the row information according to the row information;
generating a snapshot corresponding to the cell information according to the cell information;
generating a snapshot corresponding to the report data information according to the report data information;
generating a snapshot corresponding to the formula information according to the formula information;
the opening unit is used for:
a1: judging whether the snapshot corresponding to the column information is available, if so, executing A1, otherwise, executing A2;
a2: reading the snapshot corresponding to the column information, and executing A4;
a3: loading the column information, and executing A4;
a4: judging whether the snapshot corresponding to the row information is available, if so, executing A5, otherwise, executing A6;
a5: reading the snapshot corresponding to the row information, and executing A7;
a6: loading the line information, and executing A7;
a7: judging whether the snapshot corresponding to the cell information is available, if so, executing A8, otherwise, executing A9;
a8: reading the snapshot corresponding to the cell information, and concurrently executing A10 and A11;
a9: loading the cell information, and concurrently executing A10 and A11;
a10: judging whether the snapshot corresponding to the report data information is available, if so, reading the snapshot corresponding to the report data information, otherwise, loading the report data information;
a11: judging whether the snapshot corresponding to the formula information is available, if so, reading the snapshot corresponding to the formula information, otherwise, loading the formula information;
the generating unit, when executing the generating of the snapshot corresponding to the column information according to the column information, is configured to:
determining the report internal code of the report;
determining at least one first combination of dimensions of the data column of the report corresponding to the report internal code;
determining the attribute of the data column corresponding to each first combination;
generating a snapshot corresponding to the column information according to the attribute of the data column corresponding to each first combination;
the generating unit, when executing the generating of the snapshot corresponding to the line information according to the line information, is configured to:
determining at least one second combination of instance internal codes, organization internal codes and filtering dimensions of the report;
determining the attribute of the row of the report corresponding to each second combination;
generating a data packet corresponding to each second combination according to the attribute of the row of the report corresponding to each second combination;
generating a snapshot corresponding to the row information according to the data packet corresponding to each second combination;
the generating unit, when executing the generating of the snapshot corresponding to the cell information according to the cell information, is configured to:
determining at least one third combination of an instance internal code, an organization internal code and a filtering dimension of the report;
determining the attributes of the cells of the report corresponding to each third combination;
generating a data packet corresponding to each third combination according to the attribute of the cell of the report corresponding to each third combination;
generating a snapshot corresponding to the cell information according to the data packet corresponding to each third combination;
further comprising:
the setting unit is used for setting format snapshots for the report;
the opening unit is further used for judging whether the report is in an unmodified state or not after receiving an instruction of opening the report, and if so, reading the format snapshot of the report to open the report;
and/or the presence of a gas in the atmosphere,
the detecting unit is further configured to generate a new snapshot according to the updated current report information after the current snapshot is determined to be unavailable, and determine that the snapshot corresponding to the updated current report information is available;
and/or the presence of a gas in the gas,
further comprising:
and the deleting unit is used for receiving an external deleting instruction, deleting any snapshot in the at least one snapshot and determining that the deleted snapshot is unavailable.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811119324.1A CN109344380B (en) | 2018-09-25 | 2018-09-25 | Method and device for opening report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811119324.1A CN109344380B (en) | 2018-09-25 | 2018-09-25 | Method and device for opening report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109344380A CN109344380A (en) | 2019-02-15 |
| CN109344380B true CN109344380B (en) | 2023-04-07 |
Family
ID=65306808
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811119324.1A Active CN109344380B (en) | 2018-09-25 | 2018-09-25 | Method and device for opening report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109344380B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111126022A (en) * | 2020-01-06 | 2020-05-08 | 深圳维格智数科技有限公司 | Data synchronization protocol and method for real-time cooperation on-line electronic form |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101719131A (en) * | 2009-12-01 | 2010-06-02 | 金蝶软件（中国）有限公司 | Method, device and system for processing report data |
| CN104408030A (en) * | 2014-10-28 | 2015-03-11 | 用友软件股份有限公司 | XBRL (eXtensible Business Reporting Language) instance generation method and XBRL instance generation device |
| EP3198492A1 (en) * | 2014-11-05 | 2017-08-02 | Huawei Technologies Co., Ltd. | Method and dashboard server for providing interactive dashboard |
-
2018
- 2018-09-25 CN CN201811119324.1A patent/CN109344380B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101719131A (en) * | 2009-12-01 | 2010-06-02 | 金蝶软件（中国）有限公司 | Method, device and system for processing report data |
| CN104408030A (en) * | 2014-10-28 | 2015-03-11 | 用友软件股份有限公司 | XBRL (eXtensible Business Reporting Language) instance generation method and XBRL instance generation device |
| EP3198492A1 (en) * | 2014-11-05 | 2017-08-02 | Huawei Technologies Co., Ltd. | Method and dashboard server for providing interactive dashboard |
Non-Patent Citations (1)
| Title |
|---|
| 无插件网页快照报表连续显示技术;沈疆海等;《计算机***应用》;20110315(第03期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109344380A (en) | 2019-02-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP3522141B2 (en) | Automatic generation method of program inheriting correction program, automatic program generation device, and recording medium recording program for automatically generating program inheriting correction program | |
| CN101183322B (en) | Method for deferred logging and apparatus thereof | |
| US20160328413A1 (en) | Recovering data lost in data de-duplication system | |
| US7624275B2 (en) | Disk drive, control method thereof and disk-falsification detection method | |
| US20060136433A1 (en) | File formats, methods, and computer program products for representing workbooks | |
| CN110955661B (en) | Data fusion method and device, readable storage medium and electronic equipment | |
| KR20100115818A (en) | Dynamic formulas for spreadsheet cells | |
| CN108647935B (en) | Financial voucher generation rule updating method and device | |
| WO2020143240A1 (en) | Method for quickly recovering data in flash memory database | |
| US10331848B2 (en) | Method for managing complex genomic data workflows | |
| CN110196847A (en) | Data processing method and device, storage medium and electronic device | |
| CN109146625B (en) | Content-based multi-version App update evaluation method and system | |
| CN106886539B (en) | Data archiving system and method | |
| CN111798939B (en) | Crystal structure database construction method and structure search method | |
| CN109344380B (en) | Method and device for opening report | |
| US9411692B2 (en) | Applying write elision | |
| US8745005B1 (en) | Checkpoint recovery using a B-tree intent log with syncpoints | |
| WO2016101915A1 (en) | Lucene index file modification | |
| CN106897224B (en) | Method and device for determining software testing range | |
| JP2019211805A (en) | Database migration support system and program | |
| CN102855288A (en) | Method and device for processing difference data | |
| CN103210389B (en) | A kind for the treatment of method and apparatus of metadata | |
| JP2822869B2 (en) | Library file management device | |
| CN117608536B (en) | Gap data online template customization and supplementary recording system and method thereof | |
| KR101518483B1 (en) | Method for permanently deleting the data on hard disk |
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 |