CN114548062B - Report arranging method - Google Patents
Report arranging method Download PDFInfo
- Publication number
- CN114548062B CN114548062B CN202210447487.2A CN202210447487A CN114548062B CN 114548062 B CN114548062 B CN 114548062B CN 202210447487 A CN202210447487 A CN 202210447487A CN 114548062 B CN114548062 B CN 114548062B
- Authority
- CN
- China
- Prior art keywords
- report
- data
- field
- statistical
- dimension
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a report arranging method, which belongs to the technical field of report arranging and comprises the following steps: s1: configuring data information, statistical information and a report display template of a report; s2: configuring a dimension table, a fact table and a statistical result table of data storage; s3: generating an executable report template according to the configuration of the dimension table, the fact table and the statistical result table, and regularly acquiring report data according to the executable report template; s4: and displaying the report data according to the report display template and the statistical result table to finish the arrangement of the report. Compared with the prior art, the report layout is simpler to realize, drilling-down and scrolling analysis can be performed without more configuration, the development difficulty is low, and the maintenance cost is low; when the data change, the method can perform ad hoc query, timing statistics and accumulated statistical data according to the rules configured by the template, and is suitable for the purposes of displaying the data in real time, querying a statistical report in timing, displaying on a large screen and the like.
Description
Technical Field
The invention belongs to the technical field of report arrangement, and particularly relates to a report arrangement method.
Background
The common report development modes include three types: one is to develop reports through Excel, such as the Simitet reporting tool; one is through code development reporting; one is to develop reports through a reporting tool, such as a run-dry reporting tool.
And a report is developed through Excel, a docking database cannot be made, and data are difficult to maintain and collect. Through the code development report form, a large amount of manual work is needed, and the cost is relatively high. The report tool is used for developing the report, the modeling process of the report tool needs to be familiar, and generally no data acquisition process exists.
The report form construction modes have defects in the using process, cannot be well combined with the existing system, cannot acquire data in real time, and cannot easily perform drilling-down and rolling-up analysis.
Disclosure of Invention
The invention provides a report arranging method for solving the problems.
The technical scheme of the invention is as follows: a report arranging method comprises the following steps:
s1: configuring data information, statistical information and a report display template of a report;
s2: configuring a dimension table, a fact table and a statistical result table of data storage according to the data information and the statistical information of the report;
s3: generating an executable report template according to the configuration of the dimension table, the fact table and the statistical result table, and regularly acquiring report data according to the executable report template;
s4: and displaying the report data according to the report display template and the statistical result table to finish the arrangement of the report.
Further, in step S1, the data information of the report includes the source database and the target database; the statistical information of the report comprises a statistical model name, a statistical model description, a statistical type, a statistical range and a statistical execution time expression; the report display template of the report comprises an associated report display template, a report name and a report mapping field.
Furthermore, in the statistical information of the report, the statistical types include ad hoc query, timing statistics and accumulation statistics;
carrying out ad hoc query on statistical data passing through a specified time range;
timing and counting the time configured according to the execution time expression and timing and counting data;
performing accumulated statistics on data in a real-time statistical time range, performing real-time statistics on data of the same day in a time range, and performing timing statistics on data of other days; and the statistical data are calculated according to the configured executable report template.
Furthermore, in the report display template, the associated report display template is used for representing the mapping relation between the statistical result and the report display template; the associated report display template comprises a table, a line graph, a bar graph, a pie chart and a radar chart.
Further, in step S2, the dimension table of the configuration data storage includes a name, a main key, a service unique identifier field, and a dimension related information field of the configuration dimension table; wherein, the main key of the dimension table is used for being associated with the fact table; each field includes a field name, a field description, a field type, a field length, a field exposure length, and a statistics type, and the field is used to create a database physical table of the dimension table.
Further, in step S2, the fact table of the configuration data storage includes the name of the configuration fact table, the primary key, the foreign key associated with the dimension table, and the fact data field for statistics; wherein each field comprises a field name, a field description, a field type, a field length, a field presentation length and a statistic type, and the field is used for creating a database physical table of the fact table.
Further, in step S2, the statistics result table of the configuration data storage includes the name of the configuration statistics result table, the primary key, the foreign key associated with the dimension table and the fact table, and the field for the report display template to use; each field comprises a field name, a field description, a field type, a field length, a field display length and a statistic type, and the field is used for creating a database physical table of the statistic result table.
Further, in step S3, the executable report template is a set of SQL execution statements, and the generating of the executable report template by using the SQL method includes the following sub-steps:
s31: if the keywords defined in the data information of the report are the INSERT keywords, analyzing the INSERT keywords, and combining the table name of the report configuration information and the analyzed INSERT keywords to obtain an INSERT statement; if the keywords defined in the data information of the report are the updating keywords, analyzing the updating keywords, and combining the table name of the report configuration information and the analyzed updating keywords to obtain an UPDATE statement;
s32: analyzing query keywords, table keywords and table association keywords in the data information of the report, and combining to obtain a first SQL statement;
s33: analyzing the time condition keywords in the data information of the report to obtain a second SQL statement;
s34: analyzing the query condition keywords in the data information of the report to obtain a third SQL statement;
s35: splicing the first SQL statement, the second SQL statement and the third SQL statement based on the INSERT statement to obtain a first executable statement;
s36: and based on the UPDATE statement, splicing the first SQL statement, the second SQL statement and the third SQL statement to obtain a second executable statement, forming the first executable statement and the second executable statement into a group of SQL execution statements, and completing the generation of the executable report template.
Further, in step S3, the specific method of acquiring data is as follows: and acquiring data to a corresponding database physical table according to a data table of storage dimension, a data table of storage fact and a data table of storage statistical result by specifying the execution time (immediate) or the time (timing) configured by the statistical execution time expression.
Further, in step S4, the method for displaying the report includes displaying the report data through the configured report display template, drilling down to the report detail display report data, and scrolling to the set dimension display report data;
the specific method for displaying the report data through the configured report display template comprises the following steps: replacing the identifier in the report display template with the report data of the report template, and displaying the report data;
the specific method for displaying the report data by drilling down to the report detail comprises the following steps: according to the transmitted dimension, directly returning report data combined by the dimension table and the fact table to a display page for displaying the report data; the incoming dimension format comprises the name of the dimension table and a service unique identification field;
the specific method for displaying the report data from scrolling to the set dimension comprises the following steps: and reducing unselected dimension tables, calculating the statistical information of the report again according to the report configuration, and displaying the report data.
The invention has the beneficial effects that:
(1) compared with the prior art, the report layout is simpler to realize, drilling-down and scrolling analysis can be performed without more configuration, the development difficulty is low, and the maintenance cost is low; when the data change, the method can perform ad hoc query, timing statistics and accumulated statistical data according to the rules configured by the template, and is suitable for the purposes of displaying the data in real time, querying a statistical report in timing, displaying on a large screen and the like.
(2) The report generation method provided by the invention generates the data required by report display through the definition of the template, and is associated with the report display template. And mapping through the generated report data and the identifier of the report display template, and replacing the display data of the report in real time. When the report is subjected to drill-down analysis, detail data display is dynamically organized according to the dimension table and the fact table. When the report is subjected to the scroll analysis, the secondary statistical data display is dynamically organized according to the dimension table and the statistical result table. Therefore, the generated report can more quickly and accurately display the statistical data and detail data which are needed currently, repeated arrangement and layout are not needed, development cost and maintenance cost are reduced, and a display mode for quickly generating the report is provided.
(3) The report template can generate data required by the report by configuring the statistical type, the statistical range, the display template, the dimension table, the fact table, the statistical result table and the like of the report, and further obtain the report conforming to the statistical range.
Drawings
FIG. 1 is a flow chart of a report orchestration method;
fig. 2 is a schematic diagram of an electronic device.
Detailed Description
The embodiments of the present invention will be further described with reference to the accompanying drawings.
As shown in fig. 1, the present invention provides a report arranging method, which comprises the following steps:
s1: configuring data information, statistical information and a report display template of a report;
s2: configuring a dimension table, a fact table and a statistical result table of data storage according to the data information and the statistical information of the report;
s3: generating an executable report template according to the configuration of the dimension table, the fact table and the statistical result table, and regularly acquiring report data according to the executable report template;
s4: and displaying the report data according to the report display template and the statistical result table to finish the arrangement of the report.
In the embodiment of the present invention, in step S1, the data information of the report includes a source database and a target database; the statistical information of the report comprises a statistical model name, a statistical model description, a statistical type, a statistical range and a statistical execution time expression; the report display template of the report comprises an associated report display template, a report name and a report mapping field.
Wherein, the statistical range is as follows: the default of the days, months, quarters and years is counted according to the natural time, and can be customized, for example, the default of the days is 00:00:00 of the current day to 00:00:00 of the next day, and can be defined as 17:00:00 of the previous day to 17:00:00 of the current day.
In the embodiment of the invention, in the statistical information of the report, the statistical types comprise ad hoc query, timing statistics and accumulated statistics;
carrying out ad hoc query on statistical data passing through a specified time range;
timing and counting time configured according to the execution time expression, and timing and counting data;
performing accumulated statistics on data in a real-time statistical time range, performing real-time statistics on data of the same day in a time range, and performing timing statistics on data of other days; and the statistical data are calculated according to the configured executable report template. In the embodiment of the invention, in the report display template, the associated report display template is used for expressing the mapping relation between the statistical result and the report display template; the associated report display template comprises a table, a line graph, a bar graph, a pie chart and a radar chart.
In the embodiment of the invention, the dimension table of the configuration data storage comprises a name, a main key, a service unique identification field and a dimension related information field of the configuration dimension table; wherein, the main key of the dimension table is used for being associated with the fact table; each field includes a field name, a field description, a field type, a field length, a field exposure length, and a statistics type, and the field is used to create a database physical table of the dimension table.
If the material data needs to be counted from the dimensions of time and storeroom, 3 dimensions of time, storeroom, material and the like need to be established.
For example, the storehouse dimension table needs to create a storehouse dimension ID as a main key of the storehouse dimension table and is associated with the fact table; creating a storehouse code as a service unique identification field; and establishing a storehouse name for report display, and establishing service time for screening storehouse dimension values in different time dimensions. Dimension data needs to be derived from original data, for example, data of 9 months in 2021, statistics is carried out, an inserted table and fields are generated by definition of a dimension table and contents of inserted keywords, data sources are generated by splicing keyword contents of duplication elimination query, a table, table association, time conditions and the like, keyword identification is analyzed according to analysis contents of keywords, Chinese names of fields of a database table are converted into English names, and the time conditions are analyzed according to a statistical range and a statistical execution time expression defined by a statistical template.
In the embodiment of the invention, the fact table of the configuration data storage comprises the name of the configuration fact table, a main key, a foreign key associated with the dimension table and a fact data field for statistics; wherein each field comprises a field name, a field description, a field type, a field length, a field presentation length and a statistic type, and the field is used for creating a database physical table of the fact table.
And generating the fact table data by firstly generating the fact table data from the original data and then updating the association relation of the fact table and the dimension table according to the data association. If the monthly material warehouse-in and warehouse-out conditions need to be counted, 3 data fields for data counting, such as the material quantity, the material unit price, the warehouse-in and warehouse-out type and the like, are established according to the storage condition of the original data.
In the embodiment of the present invention, in step S2, the statistics result table of the configuration data storage includes the name of the configuration statistics result table, a primary key, a foreign key associated with the dimension table and the fact table, and a field used for using the report display template; each field comprises a field name, a field description, a field type, a field length, a field display length and a statistic type, and the field is used for creating a database physical table of the statistic result table.
If the monthly warehouse-in and warehouse-out conditions of the materials need to be counted, fields such as the display time, the name of the warehouse, the name of the materials, the warehouse-in quantity, the total warehouse-in price, the warehouse-in unit price and the like are established according to the report display conditions. The statistical result table data mainly comes from the dimension table and the fact table, the dimension data is inserted firstly, and then other fields are updated one by one. For example, counting data of 9 months in 2021, configuring a material statistical result table, and inserting dimension data; and then updating the warehousing quantity through SQL, and finally updating the warehousing unit price through a formula.
In the embodiment of the present invention, in step S3, the executable report template is a set of SQL execution statements, and the SQL method is adopted to generate the executable report template, which includes the following sub-steps:
s31: if the keywords defined in the data information of the report are the INSERT keywords, analyzing the INSERT keywords, and combining the table name of the report configuration information and the analyzed INSERT keywords to obtain an INSERT statement; if the keywords defined in the data information of the report are the updating keywords, analyzing the updating keywords, and combining the table name of the report configuration information and the analyzed updating keywords to obtain an UPDATE statement;
s32: analyzing query keywords, table keywords and table association keywords in the data information of the report, and combining to obtain a first SQL statement;
s33: analyzing the time condition keywords in the data information of the report to obtain a second SQL statement;
s34: analyzing the query condition keywords in the data information of the report to obtain a third SQL statement;
s35: splicing the first SQL statement, the second SQL statement and the third SQL statement based on the INSERT statement to obtain a first executable statement;
s36: and based on the UPDATE statement, splicing the first SQL statement, the second SQL statement and the third SQL statement to obtain a second executable statement, forming the first executable statement and the second executable statement into a group of SQL execution statements, and completing the generation of the executable report template. In the embodiment of the invention, the SQL mode is used for acquiring the data to the dimension table, the fact table and the statistical result table, which all need to configure the relationship between the source data and the target data. Some fields in the statistical result table need to be obtained by using a formula mode, and the current fields in the UPDATE current table SET = formula conversion contents. Some fields in the statistical result table can also be directly derived from the original data table of the database, such as names, and the like, and can be directly written into the SQL statement for execution.
An INSERT statement includes, but is not limited to, the INSERT INTO table name (column 1, column 2.). VALUES (value 1, value 2.); the UPDATE statement includes, but is not limited to, the UPDATE table name SET column name = new value WHERE column name = a certain value.
The data acquisition in the SQL mode needs to be realized in a graphical interface dragging mode. And the SQL mode is configured on the dimension table, the fact table or the statistical result table. The configuration interface comprises three parts: keywords, database table definitions, and computing configurations.
The data processing in the formula mode needs to be realized through a graphical interface in a dragging mode. Configured on the field definition of the statistical result table in a formula mode. The configuration interface comprises three parts: keywords, database table definitions, and computing configurations.
In this embodiment of the present invention, in step S3, the specific method for acquiring data is as follows: and acquiring data to a corresponding database physical table according to a data table of storage dimension, a data table of storage fact and a data table of storage statistical result by specifying the execution time (immediate) or the time (timing) configured by the statistical execution time expression.
The data table for generating the storage dimension comprises a material statistics-time dimension table, a material statistics-warehouse dimension table and a material statistics-material dimension table. The data table storing facts includes a material statistics-fact table. The data table for storing the statistical results comprises a material statistics-statistical results table.
And acquiring data into a specific physical table according to the specified range or the time configured by counting the execution time expression and the configuration information of the dimension table, the fact table and the statistical result table. For example, material information of 2021 year and 9 month is counted, time data of 2021 year and 9 month is generated and stored in a material statistics-time dimension table, warehouse data of a time period from 1 day of 2021 year and 9 month to 1 day of 2021 year and 10 month are generated and stored in a material statistics-warehouse dimension table, material data in the generated time period is stored in a material statistics-material dimension table, and specific material data in the generated time period is stored in a material statistics-material fact table. And then storing the material warehouse-in and warehouse-out data in the time period of generating the original data into a material statistics-statistics result table according to the 3 latitude tables and the fact table.
In the embodiment of the present invention, in step S4, the method for displaying a report includes displaying report data through a configured report display template, drilling down to report detail display report data, and scrolling to set dimension display report data;
the specific method for displaying the report data through the configured report display template comprises the following steps: replacing the identifier in the report display template with the report data of the report template, and displaying the report data;
the generation of the report is realized by replacing the identifier of the report display template with the report data, wherein the identifier consists of a keyword, a starting symbol and an ending symbol.
The specific method for displaying the report data by drilling down to the report detail comprises the following steps: according to the transmitted dimension, directly returning report data combined by the dimension table and the fact table to a display page for displaying the report data; the incoming dimension format comprises the name of the dimension table and a service unique identification field; the incoming latitude range is the defined dimension table range, and the incoming format is latitude table name, field and value, and the incoming latitude content is resolved into the latitude content of the FROM fact table WHERE of all fields of the SELECT fact table.
The specific method for displaying the report data from scrolling to the set dimension comprises the following steps: and reducing unselected dimension tables, calculating the statistical information of the report again according to the report configuration, and displaying the report data. The incoming latitude range is a defined dimension table range, and the incoming format is a latitude table name, a field and a value, and the incoming latitude range is analyzed into latitude fields of latitude content GROUP BY incoming FROM a FROM statistical result table WHERE of all fields of a SELECT statistical result table. If the SUM of all fields of the statistical result table is the SUM, the SUM is converted into SUM (field), and if the SUM is the formula calculation, the formula calculation is continued.
The invention also provides an electronic device capable of implementing the above process, as shown in fig. 2. The electronic device comprises a bus, a processor, a memory, a storage, a timer and a communication interface. The processor, the memory and the storage are used for processing report data, the timer is used for processing report data and collecting and processing the report data at regular time, and the communication interface is used for calling an external program. When data are collected and processed regularly, the timer calls the processor to execute a report data collecting and processing command, the processor calls the report template information stored in the memory to process the original data in the memory, and the generated report statistical result is stored in the memory. When the external program needs to use the report, the statistical result data in the storage is obtained through the communication interface, and then the report page is generated and returned to the external program for use by combining the report display template in the memory.
It will be appreciated by those of ordinary skill in the art that the embodiments described herein are intended to assist the reader in understanding the principles of the invention and are to be construed as being without limitation to such specifically recited embodiments and examples. Those skilled in the art can make various other specific changes and combinations based on the teachings of the present invention without departing from the spirit of the invention, and these changes and combinations are within the scope of the invention.
Claims (8)
1. A report arranging method is characterized by comprising the following steps:
s1: configuring data information, statistical information and a report display template of a report;
s2: configuring a dimension table, a fact table and a statistical result table of data storage according to the data information and the statistical information of the report;
s3: generating an executable report template according to the configuration of the dimension table, the fact table and the statistical result table, and regularly acquiring report data according to the executable report template;
s4: displaying report data according to the report display template and the statistical result table to complete the arrangement of the report;
in step S3, the executable report template is a set of SQL execution statements, and the executable report template is generated by using an SQL method, including the following sub-steps:
s31: if the keywords defined in the data information of the report are the INSERT keywords, analyzing the INSERT keywords, and combining the table name of the report configuration information and the analyzed INSERT keywords to obtain an INSERT statement; if the keywords defined in the data information of the report are the updating keywords, analyzing the updating keywords, and combining the table name of the report configuration information and the analyzed updating keywords to obtain an UPDATE statement;
s32: analyzing query keywords, table keywords and table association keywords in the data information of the report, and combining to obtain a first SQL statement;
s33: analyzing the time condition keywords in the data information of the report to obtain a second SQL statement;
s34: analyzing the query condition keywords in the data information of the report to obtain a third SQL statement;
s35: splicing the first SQL statement, the second SQL statement and the third SQL statement based on the INSERT statement to obtain a first executable statement;
s36: based on the UPDATE statement, splicing the first SQL statement, the second SQL statement and the third SQL statement to obtain a second executable statement, and forming a group of SQL execution statements by the first executable statement and the second executable statement to complete the generation of an executable report template;
the method is realized by using an SQL mode to regularly acquire report data in a graphical interface dragging mode, the SQL mode is configured on a dimension table, a fact table or a statistical result table, and the configuration interface comprises three parts: keyword, database table definition and calculation configuration;
in the step S4, the method for displaying the report includes displaying the report data through the configured report display template, drilling down to the report detail display report data, and scrolling to the set dimension display report data;
the specific method for displaying the report data through the configured report display template comprises the following steps: replacing the identifier in the report display template with the report data of the report template, and displaying the report data;
the specific method for displaying the report data by drilling down to the report detail comprises the following steps: according to the transmitted dimension, directly returning report data combined by the dimension table and the fact table to a display page for displaying the report data; the incoming dimension format comprises the name of the dimension table and a service unique identification field;
the specific method for displaying the report data from scrolling to the set dimension comprises the following steps: and reducing unselected dimension tables, calculating the statistical information of the report again according to the report configuration, and displaying the report data.
2. The reporting setup method as claimed in claim 1, wherein in the step S1, the data information of the report includes a source database and a target database; the statistical information of the report comprises a statistical model name, a statistical model description, a statistical type, a statistical range and a statistical execution time expression; the report display template of the report comprises an associated report display template, a report name and a report mapping field.
3. The report arranging method according to claim 2, wherein the statistical information of the report includes statistical types including ad hoc query, timing statistics, and cumulative statistics;
the ad hoc query is used for counting data through a specified time range;
the timing statistics is carried out according to the time configured by the execution time expression, and the data is counted in a timing mode;
the accumulated statistics is used for carrying out real-time statistics on data within a time range, carrying out real-time statistics on data within the current day within a time range, and carrying out timing statistics on data not within the current day.
4. The report arranging method according to claim 2, wherein in the report displaying templates, the associated report displaying template is used for representing a mapping relationship between the statistical result and the report displaying template; the associated report display template comprises a table, a line graph, a bar graph, a pie chart and a radar chart.
5. The reporting layout method as in claim 1, wherein in the step S2, the dimension table of the configuration data storage comprises a name, a primary key, a business unique identifier field and a dimension related information field of the configuration dimension table; wherein the primary key of the dimension table is used for associating with a fact table; each field comprises a field name, a field description, a field type, a field length, a field exposure length and a statistic type, and the field is used for creating a database physical table of the dimension table.
6. The reporting layout method as in claim 1, wherein in the step S2, the fact table of the configuration data storage comprises a name of the configuration fact table, a primary key, a foreign key associated with the dimension table, and a fact data field for statistics; each field comprises a field name, a field description, a field type, a field length, a field presentation length and a statistic type, and the fields are used for creating a database physical table of the fact table.
7. The reporting layout method as in claim 1, wherein in the step S2, the statistics table of the configuration data storage comprises a name of the configuration statistics table, a primary key, a foreign key associated with the dimension table and the fact table, and a field for using the report presentation template; each field comprises a field name, a field description, a field type, a field length, a field display length and a statistic type, and the field is used for creating a database physical table of a statistic result table.
8. The report arranging method according to claim 1, wherein in the step S3, the specific method for acquiring data is as follows: and acquiring data to a corresponding database physical table according to a data table of storage dimension, a data table of storage fact and a data table of storage statistical result by specifying the time configured by the execution time or the statistical execution time expression.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210447487.2A CN114548062B (en) | 2022-04-27 | 2022-04-27 | Report arranging method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210447487.2A CN114548062B (en) | 2022-04-27 | 2022-04-27 | Report arranging method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114548062A CN114548062A (en) | 2022-05-27 |
| CN114548062B true CN114548062B (en) | 2022-08-02 |
Family
ID=81666752
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210447487.2A Active CN114548062B (en) | 2022-04-27 | 2022-04-27 | Report arranging method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114548062B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2004237874A1 (en) * | 2003-12-23 | 2005-07-07 | Canon Kabushiki Kaisha | Method for Specifying Data for the Assembly of a Document Set |
| US7308457B1 (en) * | 2004-01-23 | 2007-12-11 | Niku | Method and apparatus for providing customized filters to restrict datasets retrieved from a database |
| CN101866350A (en) * | 2010-05-11 | 2010-10-20 | 中兴通讯股份有限公司 | Report generation method and device as well as WEB server |
| CN104331290A (en) * | 2014-10-31 | 2015-02-04 | 北京思特奇信息技术股份有限公司 | Resource type management and page display method and system |
| CN109918453A (en) * | 2019-02-13 | 2019-06-21 | 中国三峡建设管理有限公司 | A kind of method and system with Natural Language Search relationship type complex management data of information system |
| CN110489441A (en) * | 2019-08-12 | 2019-11-22 | 厦门商集网络科技有限责任公司 | A kind of extemporaneous querying method and equipment based on big data |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
| CN111143358A (en) * | 2019-12-13 | 2020-05-12 | 航天信息股份有限公司 | Report configuration method and system |
| CN114338855A (en) * | 2022-03-17 | 2022-04-12 | 成都瑞华康源科技有限公司 | Method for realizing parsing and generating HL7, FHIR standard and custom XML message |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103218396B (en) * | 2013-03-07 | 2016-12-28 | 江苏省电力公司南京供电公司 | The management and running visual analysis method of static Web page is generated according to visitation frequency feature |
| CN105320690B (en) * | 2014-07-30 | 2018-09-25 | 北京中海纪元数字技术发展股份有限公司 | A kind of statistics list rapid generation and system based on metadata |
| CN110211646B (en) * | 2019-05-22 | 2021-04-06 | 浙江大学 | OCQL and openEHR-based dynamically configurable medical report generation method |
| CN112835966A (en) * | 2019-11-22 | 2021-05-25 | 北京金山云网络技术有限公司 | Data query method and device and electronic equipment |
| CN111126026B (en) * | 2019-12-17 | 2021-10-08 | 叮当快药科技集团有限公司 | Method and tool for generating visual report form by analyzing SQL statement |
| CN113342821B (en) * | 2021-06-29 | 2023-04-07 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
-
2022
- 2022-04-27 CN CN202210447487.2A patent/CN114548062B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2004237874A1 (en) * | 2003-12-23 | 2005-07-07 | Canon Kabushiki Kaisha | Method for Specifying Data for the Assembly of a Document Set |
| US7308457B1 (en) * | 2004-01-23 | 2007-12-11 | Niku | Method and apparatus for providing customized filters to restrict datasets retrieved from a database |
| CN101866350A (en) * | 2010-05-11 | 2010-10-20 | 中兴通讯股份有限公司 | Report generation method and device as well as WEB server |
| CN104331290A (en) * | 2014-10-31 | 2015-02-04 | 北京思特奇信息技术股份有限公司 | Resource type management and page display method and system |
| CN109918453A (en) * | 2019-02-13 | 2019-06-21 | 中国三峡建设管理有限公司 | A kind of method and system with Natural Language Search relationship type complex management data of information system |
| CN110489441A (en) * | 2019-08-12 | 2019-11-22 | 厦门商集网络科技有限责任公司 | A kind of extemporaneous querying method and equipment based on big data |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
| CN111143358A (en) * | 2019-12-13 | 2020-05-12 | 航天信息股份有限公司 | Report configuration method and system |
| CN114338855A (en) * | 2022-03-17 | 2022-04-12 | 成都瑞华康源科技有限公司 | Method for realizing parsing and generating HL7, FHIR standard and custom XML message |
Non-Patent Citations (6)
| Title |
|---|
| Efficiently supporting ad hoc queries in large datasets of time sequences;Korn Flip 等;《Acm Sigmod Record》;19970601;第26卷(第2期);289-300 * |
| Statistical disclosure in two-dimensional tables: General tables;de Carvalho 等;《Journal of the American Statistical Association》;20120227;第89卷(第428期);1547-1557 * |
| The recommendation dashboard: A system to visualise and organise recommendations;Tschinkel Gerwald 等;《2015 19th International Conference on Information Visualisation》;20150921;241-244 * |
| 基于多结构数据立方体的多维分析挖掘模型;张晓杉;《中国优秀博硕士学位论文全文数据库(硕士)信息科技辑》;20141015(第10期);I138-1178 * |
| 基于数据中台的财务大数据可视化分析的实现;汪争贤 等;《经济研究导刊》;20210715(第20期);128-130 * |
| 数据挖掘在分析型CRM中应用的研究;王士根;《中国优秀博硕士学位论文全文数据库(硕士)信息科技辑》;20071215(第06期);I138-467 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114548062A (en) | 2022-05-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11714841B2 (en) | Systems and methods for processing a natural language query in data tables | |
| US6360188B1 (en) | Time-based modeling | |
| US10191931B2 (en) | Systems and methods for generating event stream data | |
| CN102541867A (en) | Data dictionary generating method and system | |
| CN101944082A (en) | Excel-like report processing method | |
| CN102089759A (en) | A method of generating an analytical data set for input into an analytical model | |
| CN107220274B (en) | Visual data interface market realization method | |
| US11288255B2 (en) | Systems and methods for generating event stream data | |
| CN112463151B (en) | Visual page construction method based on data source | |
| US20190042632A1 (en) | Uniform chart formatting based on semantics in data models | |
| CN115859935A (en) | Data analysis report template generation system and method based on index library | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| Valencia Parra et al. | CHAMALEON: framework to improve data wrangling with complex data | |
| CN113885859A (en) | Low-code report implementation method based on SIS production operation data | |
| CN114548062B (en) | Report arranging method | |
| CN114860737B (en) | Processing method, device, equipment and medium of teaching and research data | |
| CN115905397A (en) | Visual display method, device, system and medium for business data | |
| CN109933622A (en) | A kind of data visualisation system and implementation method | |
| CN112258151B (en) | Pampas-based account checking method, device, computer equipment and storage medium | |
| JP6668580B2 (en) | File editing method, file editing device and file editing program | |
| US20200320250A1 (en) | Systems and Methods for Generating Logical Documents for a Document Evaluation System | |
| CN108932612B (en) | Data processing method and device applied to enterprise annuity and electronic equipment | |
| CN112396343A (en) | Data quality checking method and device | |
| CN111159991A (en) | Report modeling design device and method | |
| CN115796138B (en) | Data processing method, device and medium for rolling plan |
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 |