CN109117467A - Generation method, system, equipment and the medium of configurable dynamic data report - Google Patents
Generation method, system, equipment and the medium of configurable dynamic data report Download PDFInfo
- Publication number
- CN109117467A CN109117467A CN201810846176.7A CN201810846176A CN109117467A CN 109117467 A CN109117467 A CN 109117467A CN 201810846176 A CN201810846176 A CN 201810846176A CN 109117467 A CN109117467 A CN 109117467A
- Authority
- CN
- China
- Prior art keywords
- statistical
- data
- statistics
- unit
- selection
- 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 37
- 238000007619 statistical method Methods 0.000 claims abstract description 99
- 230000008676 import Effects 0.000 claims abstract description 34
- 238000004364 calculation method Methods 0.000 claims description 9
- 238000004590 computer program Methods 0.000 claims description 2
- 238000013524 data verification Methods 0.000 claims description 2
- 230000015654 memory Effects 0.000 description 16
- 230000006870 function Effects 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010219 correlation analysis Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000010223 real-time analysis Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
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
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)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses generation method, system, equipment and the medium of a kind of configurable dynamic data report, the generation method is the following steps are included: step 1, selection statistics table；Step 2 defines data list structure；Step 3 checks statistical data；Step 4 imports statistical data；Step 5, selection statistical indicator；Step 6 defines statistical indicator；Step 7, selection statistical classification；Step 8 defines statistical classification；Step 9, selection scope of statistics；Step 10 defines scope of statistics；Step 11, selection report show template；Step 12, statistical analysis；Step 13, result are shown and export.The regular and a variety of data displaying template of statistical analysis that the present invention imports template by flexibly configurable data, can customize, can rapidly the data of variform be handled and be statisticallyd analyze, and data sheet generation, displaying and export are carried out according to the displaying template of self-defined report, it is able to satisfy diversified statistical demand.
Description
Technical field
The invention belongs to report generation technical fields, are related to a kind of generation method of configurable dynamic data report, are
System, equipment and medium.
Background technique
With the fast development of the Internet technologies such as mobile interchange, cloud computing, big data, data sheet is as a kind of important
Information carrier, not only with research and analysis value, while can to every decision provide reference and guidance, even more to existing
The feedback and assurance of situation.Therefore, the data of different shape are counted by a variety of dimensions and different emphasis in real time
Analysis, and carry out targetedly statistical data from different emphasis and show, facilitate policymaker and status is well understood and deposits
The problem of, to purposefully adjust decision, be more reasonably laid out.
Current research is primarily only the report displaying for existing statistical data.It is right by different configuration methods
Existing statistical data collection carries out screening and Dynamic Display.Although the prior art can be reduced developer for exhibition to a certain extent
The problem of Data duplication exploitation code shown, improve development efficiency and rate of code reuse.But these technologies are solved only to
The showing problem of the report of some statistical data is not provided with for the various types of the data source of variform or various
The methods and techniques that the statistical analysis and report of object are shown.
Summary of the invention
The present invention is in view of the above-mentioned problems, one of the objects of the present invention is to provide a kind of configurable dynamic data reports
Generation method, can be to the statistical analysis that be customized of data that dynamic imports, while statistical result can be made by oneself
Adopted report is shown and export.
The second object of the present invention is the provision of a kind of generation system of configurable dynamic data report, can be to dynamic
The statistical analysis that the data that state imports are customized, while self-defined report displaying and export can be carried out to statistical result.
The third object of the present invention is to provide a kind of generation method for realizing above-mentioned configurable dynamic data report
Electronic equipment.
The fourth object of the present invention is to provide a kind of generation method for storing above-mentioned configurable dynamic data report
Computer readable storage medium.
An object of the present invention adopts the following technical scheme that realization:
A kind of generation method of configurable dynamic data report comprising following steps:
Step 1, selection statistics table: according to statistical analysis demand, statistics table is selected, if statistics table has been deposited
And it is complete errorless, execute step 3, otherwise first carry out step 2；
Step 2 defines data list structure: according to the tables of data template of downloading, define statistics table structure and its and other
Then the relationship of tables of data uploads the structure of statistics table, execute step 1；
Step 3 checks statistical data: checking the statistical data of statistics table, if statistical data is completely errorless, holds
Row step 5, it is no to then follow the steps 4；
Step 4 imports statistical data: the data of download statistics tables of data import template, import template according to data, edit and lead
Enter statistical data, executes step 3；
Step 5, selection statistical indicator: according to statistical analysis demand, selection needs the index that counts, if index exists and just
It determines justice, executes step 7, it is no to then follow the steps 6；
Step 6 defines statistical indicator: according to statistical analysis demand, defining the calculation formula of statistical indicator title and index, executes
Step 5；
Step 7, selection statistical classification: according to statistical analysis demand, selection needs the classification that counts, if classification exists and just
It determines justice, executes step 9, it is no to then follow the steps 8；
Step 8 defines statistical classification: according to statistical analysis demand, defining statistical classification title, coding and its and statistics table
Relationship, execute step 7；
Step 9, selection scope of statistics: according to statistical analysis demand, selection needs the range counted, if scope of statistics exists simultaneously
It correctly defines, executes step 11, it is no to then follow the steps 10；
Step 10 defines scope of statistics: according to statistical analysis demand, defining scope of statistics title, coding and its and statistical data
The relationship of table executes step 9；
Step 11, selection report show template: according to statistical analysis demand, the data column for selecting statistical report form to need to show are raw
At template is shown, step 12 is executed；
Step 12, statistical analysis: for statistical analysis to statistics table according to the statistical indicator of definition, classification, range；
Step 13, result are shown and export: according to template is shown, showing statistical result, while statistical result is exported to EXCEL
Table.
Preferably, the tables of data template include table name, column name, column coding, data type, length, decimal digits, whether
For empty, outer key name, reference data library, reference list and referenced column.
Preferably, after step 11, further includes:
Step 14, statistical data verification: it according to the statistical classification of configuration, scope of statistics, according to template is shown, pre-generates and opens up
Show the other information other than statistical indicator, the relationship between data and tables of data to verify the statistics table of importing
It defines whether correctly and whether meets statistical demand, it is no to then follow the steps 1 if meeting statistical demand executes step 12.
Preferably, statistics table is a tables of data, or is made of multiple tables of data according to certain corresponding relationship；
Statistical data is saved in database, together if there is multiple statistics tables when statistical data imports statistics table
When according to data import the corresponding relationship between the statistical data that defines of template, the corresponding relationship between statistics table is also saved
Into database.
The second object of the present invention adopts the following technical scheme that realization:
A kind of generation system of configurable dynamic data report comprising:
Statistical data table unit is selected, for statistics table being selected, if statistics table is according to statistical analysis demand
In the presence of and it is complete errorless, execute and check statistical data unit, otherwise first carry out and define data list structure unit；
Define data list structure unit, for the tables of data template according to downloading, define statistics table structure and its and its
Then the relationship of his tables of data uploads the structure of statistics table, execute selection statistical data table unit；
It checks statistical data unit, is checked for the statistical data to statistics table, if statistical data is completely errorless,
Selection statistical indicator unit is executed, otherwise executes and imports statistical data unit；
Statistical data unit is imported, the data for download statistics tables of data import template, import template according to data, editor is simultaneously
Statistical data is imported, executes and checks statistical data unit；
Statistical indicator unit is selected, for according to statistical analysis demand, selection to need the index that counts, if index exists and
Correct definition executes selection statistical classification unit, otherwise executes and define statistical indicator unit；
Statistical indicator unit is defined, for the calculation formula of statistical indicator title and index being defined, being held according to statistical analysis demand
Row selection statistical indicator unit；
Statistical classification unit is selected, for according to statistical analysis demand, selection to need the classification that counts, if classification exists and
Correct definition executes selection scope of statistics unit, otherwise executes and define statistical classification unit；
Statistical classification unit is defined, for defining statistical classification title, coding and its and statistical data according to statistical analysis demand
The relationship of table executes selection statistical classification unit；
Scope of statistics unit is selected, the range for counting according to statistical analysis demand, selection needs, if scope of statistics exists
And correctly define, it executes selection report and shows stencil unit, otherwise execute and define scope of statistics unit；
Scope of statistics unit is defined, for defining scope of statistics title, coding and its and statistical data according to statistical analysis demand
The relationship of table executes selection scope of statistics unit；
Report is selected to show stencil unit, the data column for selecting statistical report form to need to show according to statistical analysis demand are raw
At template is shown, statistical analysis unit is executed；
Statistical analysis unit, it is for statistical analysis to statistics table for according to the statistical indicator of definition, classification, range；
As a result displaying and lead-out unit, for showing statistical result, while statistical result being exported to according to template is shown
EXCEL table.
The third object of the present invention adopts the following technical scheme that realization:
A kind of electronic equipment, comprising: one or more processors；Storage device, for storing one or more programs, when described
One or more programs are executed by one or more of processors, so that one or more of processors realize mesh of the present invention
One of configurable dynamic data report generation method.
The fourth object of the present invention adopts the following technical scheme that realization:
A kind of computer readable storage medium, is stored thereon with computer program, which realizes this hair when being executed by processor
The generation method of the configurable dynamic data report of the bright first purpose.
Compared with prior art, generation method, system, equipment and the medium for the dynamic data report that the present invention can configure,
The beneficial effect is that:
The present invention is for the deficiencies in the prior art in report form processing technical field, the main data source for being to solve variform
Various types or various objects statistical analysis and report show the problem of.By flexibly configurable data import template,
The statistical analysis rule that can customize and a variety of data show template, and method and system of the invention can be rapidly to a variety of shapes
The statistical analysis that the data of state carry out processing and are customized to the data of dynamic importing, and according to the displaying mould of self-defined report
Version carries out data sheet generation, displaying and export, is not limited by industry, field, is able to satisfy diversified statistical demand.
Detailed description of the invention
Fig. 1 is the flow chart of the generation method for the dynamic data report that the embodiment of the present invention one can configure；
Fig. 2 is the flow chart of the generation method for the dynamic data report that the embodiment of the present invention two can configure；
Fig. 3 is the structural schematic diagram of the electronic equipment of the embodiment of the present invention four.
Specific embodiment
In the following, being described further in conjunction with attached drawing and specific embodiment to the present invention, it should be noted that not
Under the premise of conflicting, new implementation can be formed between various embodiments described below or between each technical characteristic in any combination
Example.
Embodiment one
A kind of generation method of configurable dynamic data report, mainly solve variform data source various types or
The problem of statistical analysis and report of various objects are shown.It please refers to shown in Fig. 1 comprising following steps:
Step 1. selects statistics table: according to statistical analysis demand, statistics table is selected, if statistics table has been deposited
And it is complete errorless, execute step 3, otherwise first carry out step 2.
Statistical data can also can be made of multiple tables of data according to certain corresponding relationship with only one tables of data.
If there is multiple statistics tables, these statistics tables be by between customized table structure and table and table be associated with into
Row data import, and data structure is easy to use.When importing statistics table, can not only store data into database,
Simultaneously according to the corresponding relationship imported between the data that template defines, the corresponding relationship between statistics table can also be saved
Into database.Multi-data source can support big data, varied complexity with multiple associated database table data
Statistical analysis, it is high-efficient.
Step 2. defines data list structure: first according to the tables of data template of downloading (tables of data template is as shown in table 1.1),
The structure of statistics table and its relationship with other tables of data are defined, statistical data table structure is then uploaded, executes step 1；
| Table name | Column name | Column coding | Data type | Length | Decimal digits | It whether is empty | Outer key name | Reference data library | Reference list | Referenced column |
1.1 tables of data template of table
Step 3. checks statistical data: checking the data of statistics table, if statistical data is completely errorless, executes step
Rapid 5, it is no to then follow the steps 4；
Step 4. imports statistical data: the data of download statistics tables of data import template and edit according to template and import statistical number
According to execution step 3；
Step 5. selects statistical indicator: according to statistical analysis demand, selection needs the index that counts, if index exists and
Correct definition executes step 7, no to then follow the steps 6；
Step 6. defines statistical indicator: according to statistical analysis demand, defining the calculation formula of statistical indicator title and index, holds
Row step 5；
Step 7. selects statistical classification: according to statistical analysis demand, selection needs the classification that counts, if classification exists and just
It determines justice, executes step 9, it is no to then follow the steps 8；
Step 8. defines statistical classification: according to statistical analysis demand, defining statistical classification title, coding and its and statistics table
Relationship, execute step 7；
Step 9. selects scope of statistics: according to statistical analysis demand, selection needs the range counted, if scope of statistics exists simultaneously
It correctly defines, executes step 11, it is no to then follow the steps 10；
Step 10. defines scope of statistics: according to statistical analysis demand, defining scope of statistics title, coding and its and statistical data
The relationship of table executes step 9；
Step 11. selects report to show template: according to statistical analysis demand, the data column for selecting statistical report form to need to show are raw
At template is shown, step 12 is executed；
Step 12. statistical analysis: according to the statistical indicator of definition, classification, range, to dynamic import the data of statistics table into
Row statistical analysis；
It is existing that these statistical parameters of statistical indicator, statistical classification, scope of statistics can choose system, customized can also match
It sets.Corresponding relationship between the data of statistics table and these statistical parameters can be saved in data in configuration parameter simultaneously
In library.I.e. it is customized to be also possible to user for data statistic analysis rule, by customized statistical indicator and range, according to number
According to the incidence relation between table, be finally for database tables of data it is for statistical analysis, therefore support complicated and diversified number
According to correlation analysis
It should be understood that data of the invention are the tables of data of database, statistical analysis part can pass through storing process, calculation
The various flexible modes such as method model, cloud computing are for statistical analysis, and the efficiency and analysis that greatly improve statistical analysis is complicated
Degree, adapts to the growth requirement of big data.The data that either source data, the data of intermediate treatment or result are shown all are deposited
Storage is in the tables of data of database, and not only definition is convenient, can be repeated multiple times, and can be superimposed or accrual accounting data, statistics
Index, scope of statistics, data relationship are for statistical analysis.
Step 13 result is shown and export: showing template according to report, shows statistical result, while can be by the system of displaying
Meter result exports to EXCEL table.
Embodiment two
The difference of embodiment two and embodiment one is before statistical analysis, it is determined that after report shows template, addition pair
The verifying function of statistical data.It is specifically shown referring to figure 2., a kind of generation method of configurable dynamic data report, packet
Include following steps:
Step 1. selects statistics table: according to statistical analysis demand, statistics table is selected, if statistics table has been deposited
And it is complete errorless, execute step 3, otherwise first carry out step 2.
Step 2. defines data list structure: first according to the tables of data template of downloading (tables of data template such as 2.1 institute of table
Show), the structure of statistics table and its relationship with other tables of data are defined, statistical data table structure is then uploaded, executes step
Rapid 1；
| Table name | Column name | Column coding | Data type | Length | Decimal digits | It whether is empty | Outer key name | Reference data library | Reference list | Referenced column |
2.1 tables of data template of table
Step 3. checks statistical data: checking the data of statistics table, if statistical data is completely errorless, executes step
Rapid 5, it is no to then follow the steps 4；
Step 4. imports statistical data: the data of download statistics tables of data import template and edit according to template and import statistical number
According to execution step 3；
Step 5. selects statistical indicator: according to statistical analysis demand, selection needs the index that counts, if index exists and
Correct definition executes step 7, no to then follow the steps 6；
Step 6. defines statistical indicator: according to statistical analysis demand, defining the calculation formula of statistical indicator title and index, holds
Row step 5；
Step 7. selects statistical classification: according to statistical analysis demand, selection needs the classification that counts, if classification exists and just
It determines justice, executes step 9, it is no to then follow the steps 8；
Step 8. defines statistical classification: according to statistical analysis demand, defining statistical classification title, coding and its and statistics table
Relationship, execute step 7；
Step 9. selects scope of statistics: according to statistical analysis demand, selection needs the range counted, if scope of statistics exists simultaneously
It correctly defines, executes step 11, it is no to then follow the steps 10；
Step 10. defines scope of statistics: according to statistical analysis demand, defining scope of statistics title, coding and its and statistical data
The relationship of table executes step 9；
Step 11. selects report to show template: according to statistical analysis demand, the data column for selecting statistical report form to need to show are raw
At template is shown, step 14 is executed；
The verification of step 14. statistical data: according to the statistical classification of configuration, scope of statistics, template is shown according to report, is pre-generated
With the other information except displaying statistical indicator, between the data and tables of data to verify the statistics table of importing
Whether contextual definition is correct and whether meets statistical demand, executes step 12 if met, no to then follow the steps 1；
Step 12. statistical analysis: it is for statistical analysis to statistics table according to the statistical indicator of definition, classification, range, it holds
Row step 13；
Step 13 result is shown and export: showing template according to report, shows statistical result, while can be as needed by displaying
Statistical result exports to EXCEL table.
Embodiment three
Embodiment three provides a kind of generation system of configurable dynamic data report, the dynamic number that can configure for embodiment one
According to the virtual bench of the generation method of report comprising:
Statistical data table unit is selected, for statistics table being selected, if statistics table is according to statistical analysis demand
In the presence of and it is complete errorless, execute and check statistical data unit, otherwise first carry out and define data list structure unit；
Define data list structure unit, for the tables of data template according to downloading, define statistics table structure and its and its
Then the relationship of his tables of data uploads the structure of statistics table, execute selection statistical data table unit；
It checks statistical data unit, is checked for the statistical data to statistics table, if statistical data is completely errorless,
Selection statistical indicator unit is executed, otherwise executes and imports statistical data unit；
Statistical data unit is imported, the data for download statistics tables of data import template, import template according to data, editor is simultaneously
Statistical data is imported, executes and checks statistical data unit；
Statistical indicator unit is selected, for according to statistical analysis demand, selection to need the index that counts, if index exists and
Correct definition executes selection statistical classification unit, otherwise executes and define statistical indicator unit；
Statistical indicator unit is defined, for the calculation formula of statistical indicator title and index being defined, being held according to statistical analysis demand
Row selection statistical indicator unit；
Statistical classification unit is selected, for according to statistical analysis demand, selection to need the classification that counts, if classification exists and
Correct definition executes selection scope of statistics unit, otherwise executes and define statistical classification unit；
Statistical classification unit is defined, for defining statistical classification title, coding and its and statistical data according to statistical analysis demand
The relationship of table executes selection statistical classification unit；
Scope of statistics unit is selected, the range for counting according to statistical analysis demand, selection needs, if scope of statistics exists
And correctly define, it executes selection report and shows stencil unit, otherwise execute and define scope of statistics unit；
Scope of statistics unit is defined, for defining scope of statistics title, coding and its and statistical data according to statistical analysis demand
The relationship of table executes selection scope of statistics unit；
Report is selected to show stencil unit, the data column for selecting statistical report form to need to show according to statistical analysis demand are raw
At template is shown, statistical analysis unit is executed；
Statistical analysis unit, it is for statistical analysis to statistics table for according to the statistical indicator of definition, classification, range；
As a result displaying and lead-out unit, for showing statistical result, while statistical result being exported to according to template is shown
EXCEL table.
Example IV
Fig. 3 is the structural schematic diagram for a kind of electronic equipment that the embodiment of the present invention four provides, as shown in figure 3, the electronic equipment packet
Include processor 310, memory 320, input unit 330 and output device 340；The quantity of processor 310 can in computer equipment
Be it is one or more, in Fig. 3 by taking a processor 310 as an example；Processor 310, memory 320, input in electronic equipment
Device 330 can be connected with output device 340 by bus or other modes, in Fig. 3 for being connected by bus.
Memory 320 is used as a kind of computer readable storage medium, can be used for storing software program, journey can be performed in computer
Sequence and module, such as the corresponding program instruction/mould of generation method of the configurable dynamic data report in the embodiment of the present invention
Block.Software program, instruction and the module that processor 310 is stored in memory 320 by operation, thereby executing electronic equipment
Various function application and data processing, that is, realize the generation method of above-mentioned configurable dynamic data report.
Memory 320 can mainly include storing program area and storage data area, wherein storing program area can store operation system
Application program needed for system, at least one function；Storage data area, which can be stored, uses created data etc. according to terminal.This
Outside, memory 320 may include high-speed random access memory, can also include nonvolatile memory, for example, at least one
Disk memory, flush memory device or other non-volatile solid state memory parts.In some instances, memory 320 can be into one
Step includes the memory remotely located relative to processor 310, these remote memories can be set by network connection to electronics
It is standby.The example of above-mentioned network includes but is not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
Input unit 330 can be used for receiving the subscriber identity information of input.Output device 340 may include the display such as display screen
Equipment.
Embodiment five
The embodiment of the present invention five also provides a kind of storage medium comprising computer executable instructions, and the computer is executable to be referred to
It enables when being executed by computer processor for executing a kind of generation method of configurable dynamic data report, this method packet
It includes:
Step 1, selection statistics table: according to statistical analysis demand, statistics table is selected, if statistics table has been deposited
And it is complete errorless, execute step 3, otherwise first carry out step 2；
Step 2 defines data list structure: according to the tables of data template of downloading, define statistics table structure and its and other
Then the relationship of tables of data uploads the structure of statistics table, execute step 1；
Step 3 checks statistical data: checking the statistical data of statistics table, if statistical data is completely errorless, holds
Row step 5, it is no to then follow the steps 4；
Step 4 imports statistical data: the data of download statistics tables of data import template, import template according to data, edit and lead
Enter statistical data, executes step 3；
Step 5, selection statistical indicator: according to statistical analysis demand, selection needs the index that counts, if index exists and just
It determines justice, executes step 7, it is no to then follow the steps 6；
Step 6 defines statistical indicator: according to statistical analysis demand, defining the calculation formula of statistical indicator title and index, executes
Step 5；
Step 7, selection statistical classification: according to statistical analysis demand, selection needs the classification that counts, if classification exists and just
It determines justice, executes step 9, it is no to then follow the steps 8；
Step 8 defines statistical classification: according to statistical analysis demand, defining statistical classification title, coding and its and statistics table
Relationship, execute step 7；
Step 9, selection scope of statistics: according to statistical analysis demand, selection needs the range counted, if scope of statistics exists simultaneously
It correctly defines, executes step 11, it is no to then follow the steps 10；
Step 10 defines scope of statistics: according to statistical analysis demand, defining scope of statistics title, coding and its and statistical data
The relationship of table executes step 9；
Step 11, selection report show template: according to statistical analysis demand, the data column for selecting statistical report form to need to show are raw
At template is shown, step 12 is executed；
Step 12, statistical analysis: for statistical analysis to statistics table according to the statistical indicator of definition, classification, range；
Step 13, result are shown and export: according to template is shown, showing statistical result, while statistical result is exported to EXCEL
Table.
Certainly, a kind of storage medium comprising computer executable instructions, computer provided by the embodiment of the present invention
The method operation that executable instruction is not limited to the described above, can also be performed provided by any embodiment of the invention configurable
Relevant operation in the generation method of dynamic data report.
By the description above with respect to embodiment, it is apparent to those skilled in the art that, the present invention
It can be realized by software and required common hardware, naturally it is also possible to which by hardware realization, but in many cases, the former is more
Good embodiment.Based on this understanding, technical solution of the present invention substantially in other words contributes to the prior art
Part can be embodied in the form of software products, which can store in computer readable storage medium
In, floppy disk, read-only memory (Read-Only Memory, ROM), random access memory (Random such as computer
Access Memory, RAM), flash memory (FLASH), hard disk or CD etc., including some instructions use so that an electronic equipment
(can be mobile phone, personal computer, server or the network equipment etc.) executes method described in each embodiment of the present invention.
It is worth noting that, included is each in the embodiment of the generation system of above-mentioned configurable dynamic data report
A unit and module are only divided according to the functional logic, but are not limited to the above division, as long as can be realized phase
The function of answering；In addition, the specific name of each functional unit is also only for convenience of distinguishing each other, it is not limited to this hair
Bright protection scope.
The above embodiment is only the preferred embodiment of the present invention, and the scope of protection of the present invention is not limited thereto,
The variation and replacement for any unsubstantiality that those skilled in the art is done on the basis of the present invention belong to institute of the present invention
Claimed range.
Claims (7)
1. a kind of generation method of configurable dynamic data report, which is characterized in that itself the following steps are included:
Step 1, selection statistics table: according to statistical analysis demand, statistics table is selected, if statistics table has been deposited
And it is complete errorless, execute step 3, otherwise first carry out step 2；
Step 2 defines data list structure: according to the tables of data template of downloading, define statistics table structure and its and other
Then the relationship of tables of data uploads the structure of statistics table, execute step 1；
Step 3 checks statistical data: checking the statistical data of statistics table, if statistical data is completely errorless, holds
Row step 5, it is no to then follow the steps 4；
Step 4 imports statistical data: the data of download statistics tables of data import template, import template according to data, edit and lead
Enter statistical data, executes step 3；
Step 5, selection statistical indicator: according to statistical analysis demand, selection needs the index that counts, if index exists and just
It determines justice, executes step 7, it is no to then follow the steps 6；
Step 6 defines statistical indicator: according to statistical analysis demand, defining the calculation formula of statistical indicator title and index, executes
Step 5；
Step 7, selection statistical classification: according to statistical analysis demand, selection needs the classification that counts, if classification exists and just
It determines justice, executes step 9, it is no to then follow the steps 8；
Step 8 defines statistical classification: according to statistical analysis demand, defining statistical classification title, coding and its and statistics table
Relationship, execute step 7；
Step 9, selection scope of statistics: according to statistical analysis demand, selection needs the range counted, if scope of statistics exists simultaneously
It correctly defines, executes step 11, it is no to then follow the steps 10；
Step 10 defines scope of statistics: according to statistical analysis demand, defining scope of statistics title, coding and its and statistical data
The relationship of table executes step 9；
Step 11, selection report show template: according to statistical analysis demand, the data column for selecting statistical report form to need to show are raw
At template is shown, step 12 is executed；
Step 12, statistical analysis: for statistical analysis to statistics table according to the statistical indicator of definition, classification, range；
Step 13, result are shown and export: according to template is shown, showing statistical result, while statistical result is exported to EXCEL
Table.
2. the generation method of configurable dynamic data report according to claim 1, it is characterised in that: the tables of data
Whether template includes table name, column name, column coding, data type, length, decimal digits, is empty, outer key name, reference data library, draws
With table and referenced column.
3. the generation method of configurable dynamic data report according to claim 1, it is characterised in that: step 11 it
Afterwards, further includes:
Step 14, statistical data verification: it according to the statistical classification of configuration, scope of statistics, according to template is shown, pre-generates and opens up
Show the other information other than statistical indicator, the relationship between data and tables of data to verify the statistics table of importing
It defines whether correctly and whether meets statistical demand, it is no to then follow the steps 1 if meeting statistical demand executes step 12.
4. the generation method of configurable dynamic data report according to claim 1, it is characterised in that: statistics table
For a tables of data, or it is made of according to certain corresponding relationship multiple tables of data；If there is multiple statistics tables,
When statistical data imports statistics table, statistical data is saved in database, while importing what template defined according to data
Corresponding relationship between statistics table is also saved in database by the corresponding relationship between statistical data.
5. a kind of generation system of configurable dynamic data report, characterized in that it comprises:
Statistical data table unit is selected, for statistics table being selected, if statistics table is according to statistical analysis demand
In the presence of and it is complete errorless, execute and check statistical data unit, otherwise first carry out and define data list structure unit；
Define data list structure unit, for the tables of data template according to downloading, define statistics table structure and its and its
Then the relationship of his tables of data uploads the structure of statistics table, execute selection statistical data table unit；
It checks statistical data unit, is checked for the statistical data to statistics table, if statistical data is completely errorless,
Selection statistical indicator unit is executed, otherwise executes and imports statistical data unit；
Statistical data unit is imported, the data for download statistics tables of data import template, import template according to data, editor is simultaneously
Statistical data is imported, executes and checks statistical data unit；
Statistical indicator unit is selected, for according to statistical analysis demand, selection to need the index that counts, if index exists and
Correct definition executes selection statistical classification unit, otherwise executes and define statistical indicator unit；
Statistical indicator unit is defined, for the calculation formula of statistical indicator title and index being defined, being held according to statistical analysis demand
Row selection statistical indicator unit；
Statistical classification unit is selected, for according to statistical analysis demand, selection to need the classification that counts, if classification exists and
Correct definition executes selection scope of statistics unit, otherwise executes and define statistical classification unit；
Statistical classification unit is defined, for defining statistical classification title, coding and its and statistical data according to statistical analysis demand
The relationship of table executes selection statistical classification unit；
Scope of statistics unit is selected, the range for counting according to statistical analysis demand, selection needs, if scope of statistics exists
And correctly define, it executes selection report and shows stencil unit, otherwise execute and define scope of statistics unit；
Scope of statistics unit is defined, for defining scope of statistics title, coding and its and statistical data according to statistical analysis demand
The relationship of table executes selection scope of statistics unit；
Report is selected to show stencil unit, the data column for selecting statistical report form to need to show according to statistical analysis demand are raw
At template is shown, statistical analysis unit is executed；
Statistical analysis unit, it is for statistical analysis to statistics table for according to the statistical indicator of definition, classification, range；
As a result displaying and lead-out unit, for showing statistical result, while statistical result being exported to according to template is shown
EXCEL table.
6. a kind of electronic equipment characterized by comprising
One or more processors；
Storage device, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processors are real
The now generation method of the configurable dynamic data report as described in any in claim 1-4.
7. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is held by processor
The generation method of the configurable dynamic data report as described in any in claim 1-4 is realized when row.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810846176.7A CN109117467A (en) | 2018-07-27 | 2018-07-27 | Generation method, system, equipment and the medium of configurable dynamic data report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810846176.7A CN109117467A (en) | 2018-07-27 | 2018-07-27 | Generation method, system, equipment and the medium of configurable dynamic data report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109117467A true CN109117467A (en) | 2019-01-01 |
Family
ID=64863698
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810846176.7A Pending CN109117467A (en) | 2018-07-27 | 2018-07-27 | Generation method, system, equipment and the medium of configurable dynamic data report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109117467A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110069575A (en) * | 2019-04-25 | 2019-07-30 | 中电科嘉兴新型智慧城市科技发展有限公司 | A kind of dynamic data statistical method and system based on multidimensional data mark |
| CN110335009A (en) * | 2019-05-24 | 2019-10-15 | 平安科技（深圳）有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN112487107A (en) * | 2020-11-28 | 2021-03-12 | 河北省科学技术情报研究院(河北省科技创新战略研究院) | Processing method for presenting data index hierarchy and classification in electronic form |
| CN113177396A (en) * | 2021-04-30 | 2021-07-27 | 平安证券股份有限公司 | Report generation method and device, computer equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
| CN103473305A (en) * | 2013-09-10 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Method and system for performing decision-making process show in statistic analysis |
| CN105320690A (en) * | 2014-07-30 | 2016-02-10 | 北京中海纪元数字技术发展股份有限公司 | Metadata based rapid statistic form generation method and system |
| CN105843821A (en) * | 2015-01-16 | 2016-08-10 | 腾讯科技（深圳）有限公司 | Data processing method and system capable of configuring reports |
| CN107908675A (en) * | 2017-10-27 | 2018-04-13 | 努比亚技术有限公司 | A kind of method for exhibiting data, terminal and computer-readable recording medium |
-
2018
- 2018-07-27 CN CN201810846176.7A patent/CN109117467A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
| CN103473305A (en) * | 2013-09-10 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Method and system for performing decision-making process show in statistic analysis |
| CN105320690A (en) * | 2014-07-30 | 2016-02-10 | 北京中海纪元数字技术发展股份有限公司 | Metadata based rapid statistic form generation method and system |
| CN105843821A (en) * | 2015-01-16 | 2016-08-10 | 腾讯科技（深圳）有限公司 | Data processing method and system capable of configuring reports |
| CN107908675A (en) * | 2017-10-27 | 2018-04-13 | 努比亚技术有限公司 | A kind of method for exhibiting data, terminal and computer-readable recording medium |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110069575A (en) * | 2019-04-25 | 2019-07-30 | 中电科嘉兴新型智慧城市科技发展有限公司 | A kind of dynamic data statistical method and system based on multidimensional data mark |
| CN110335009A (en) * | 2019-05-24 | 2019-10-15 | 平安科技（深圳）有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN112487107A (en) * | 2020-11-28 | 2021-03-12 | 河北省科学技术情报研究院(河北省科技创新战略研究院) | Processing method for presenting data index hierarchy and classification in electronic form |
| CN113177396A (en) * | 2021-04-30 | 2021-07-27 | 平安证券股份有限公司 | Report generation method and device, computer equipment and storage medium |
| CN113177396B (en) * | 2021-04-30 | 2022-11-25 | 平安证券股份有限公司 | Report generation method and device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109117467A (en) | Generation method, system, equipment and the medium of configurable dynamic data report | |
| CN104391934B (en) | Data verification method and device | |
| CN104268428B (en) | A kind of visual configuration method calculated for index | |
| CN110399420A (en) | A kind of deriving method, electronic equipment and the medium of configurableization Excel format | |
| CN109508355A (en) | A kind of data pick-up method, system and terminal device | |
| CN111124917A (en) | Public test case management and control method, device, equipment and storage medium | |
| CN106293662A (en) | A kind of code change statistics of variables method and device thereof | |
| CN110069279B (en) | Method, device and storage medium for checking direct current control protection program | |
| CN108255602A (en) | Task combined method and terminal device | |
| CN109857631A (en) | Code coverage statistical method, device, equipment and storage medium based on artificial intelligence | |
| CN110990350A (en) | Log analysis method and device | |
| CN107977504A (en) | A kind of asymmetric in-core fuel management computational methods, device and terminal device | |
| CN104346378B (en) | A kind of method, apparatus and system for realizing complex data processing | |
| CN109241163A (en) | The generation method and terminal device of electronic certificate | |
| CN109697224B (en) | Bill message processing method, device and storage medium | |
| CN116204428A (en) | Test case generation method and device | |
| CN103793519A (en) | Automatic tool supporting exportation of mass data | |
| CN116483707A (en) | Test method, test device, test apparatus, test program, and test program | |
| CN109614416A (en) | A kind of invoice management method and device based on data statistic analysis | |
| CN115480940A (en) | Page calling method, device and medium for financial ratio indexes | |
| CN113779132B (en) | Data importing method, device, computer equipment and storage medium | |
| CN112256978B (en) | Data processing method, device and medium based on data model | |
| CN114610803A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN114630314B (en) | Updating method, device, equipment and storage medium of terminal information base | |
| CN113076316B (en) | Information relation mapping analysis method, device, equipment and storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190101 |
|
| RJ01 | Rejection of invention patent application after publication |