CN117454862A - Report generation method based on engine mode and self-service BI system - Google Patents
Report generation method based on engine mode and self-service BI system Download PDFInfo
- Publication number
- CN117454862A CN117454862A CN202311785542.XA CN202311785542A CN117454862A CN 117454862 A CN117454862 A CN 117454862A CN 202311785542 A CN202311785542 A CN 202311785542A CN 117454862 A CN117454862 A CN 117454862A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- cell
- engine
- information
- 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 35
- 238000013461 design Methods 0.000 claims abstract description 38
- 238000013507 mapping Methods 0.000 claims abstract description 21
- 238000004364 calculation method Methods 0.000 claims abstract description 17
- 238000009877 rendering Methods 0.000 claims abstract description 4
- 230000006870 function Effects 0.000 claims description 14
- 238000013499 data model Methods 0.000 claims description 12
- 238000012545 processing Methods 0.000 claims description 8
- 238000002360 preparation method Methods 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims description 5
- 238000004519 manufacturing process Methods 0.000 abstract description 10
- 238000007619 statistical method Methods 0.000 abstract description 10
- 230000008859 change Effects 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 4
- 230000003068 static effect Effects 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 238000005553 drilling Methods 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
- 230000008092 positive effect Effects 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
- 230000003442 weekly effect Effects 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
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
- G06F17/18—Complex mathematical operations for evaluating statistical data, e.g. average values, frequency distributions, probability functions, regression analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
- G06F40/154—Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Mathematical Analysis (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Mathematical Physics (AREA)
- Pure & Applied Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Computational Mathematics (AREA)
- Artificial Intelligence (AREA)
- Mathematical Optimization (AREA)
- Bioinformatics & Computational Biology (AREA)
- Evolutionary Biology (AREA)
- Operations Research (AREA)
- Probability & Statistics with Applications (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Algebra (AREA)
- Life Sciences & Earth Sciences (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention belongs to the technical field of airport big data production statistical analysis, and discloses a report generation method based on an engine mode and a self-service BI system. The method comprises the following steps: the front end completes the design of a report form, adds the attribute of the cell and the information of the data field and transmits the information to the rear end; the engine analyzes the front-end information and builds cell mapping according to the model definition; combining data set data according to the cell mapping structure to construct a data tree; and returning the result to the front-end rendering. After the self-service BI system is used, first-line statistics personnel change report design at any time according to needs, data calculation, summarization and display are carried out according to needs, each report is averaged from needs to use, the period is shortened to an hour unit, and the on-site operation statistics efficiency is greatly improved.
Description
Technical Field
The invention belongs to the technical field of airport big data production statistical analysis, and particularly relates to a report generation method based on an engine mode and a self-service BI system.
Background
The production statistics analysis of most airports still adopts traditional manual statistics or depends on periodic report iteration, and cannot rapidly cope with the basic requirements of intelligent airports on data analysis. Therefore, the self-service BI system provides the capability of flexibly counting and summarizing data, the data source management capability, the data drilling capability and the like, and assists each department in designing and needing different statistical analysis dimensions of production data based on business.
Through the above analysis, the problems and defects existing in the prior art are as follows: aiming at the complex and changeable requirements of BI statistical analysis under a big data background, the statistical analysis efficiency of production data in the prior art is low, and the statistical analysis data meeting the requirements of all departments can not be generated rapidly.
Disclosure of Invention
In order to overcome the problems in the related art, the embodiment of the invention provides a report generation method based on an engine mode and a self-service BI system.
The technical scheme is as follows: a report generation method based on an engine mode realizes grouping design and formula calculation of a complex report through a report engine and cell mapping relation, meets the report design requirement, and specifically comprises the following steps:
s1, the front end completes report form design, adds cell attribute and data field information and transmits the cell attribute and the data field information to the rear end;
s2, the engine analyzes the front-end information and constructs cell mapping according to model definition;
s3, combining data of the data set according to the cell mapping structure to construct a data tree;
and S4, returning the result to front-end rendering.
In step S2, the engine parses the front-end information, including: the front end defines a report structure in an excel report mode, the report structure comprises cell merging, a data display direction, cell background and font frame lines, and the engine analyzes the front end report definition according to the agreed data structure.
In step S2, the model includes: grouping models, list models, condition models, formula models, and reference models; the grouping model is applied to data grouping design and comprises province and city, and the province information is grouped; the list model is applied to list display design, and selects horizontal or vertical display; the condition model is applied to form information display condition attributes, wherein the display information is related to query condition actions, and the condition attributes comprise xx month xx daily statistics; the formula model is applied to function calculation and comprises sum and weekday function processing; the reference model is applied to the text filling information and needs the value calculated by the reference function, and the content of the reference cell is selected at the text after the calculation in the cell is completed.
In step S3, in the cell mapping structure, the parent cell mapped to B2 is A2 cell relationship, and the configuration of the cell data and the style format is mapped according to the cell coordinate relationship.
In step S3, a data tree is constructed, comprising: through the mapping relation between the data set and the form field, a data link is established, a cell tree relation is established according to the cell configuration attribute, cell tree relation data is filled based on the data set field information filled by cells, and therefore the filling position of the data in the cells is calculated, the data is realized, and the data is combined with the cell mapping to form a data tree.
The invention further provides a report generation self-service BI system based on an engine mode, which is realized by applying the report generation method based on the engine mode, and comprises the following steps:
the data source access unit is used for configuring a data source of statistical data and filling in data source connection information, and the data source comprises: the system comprises an integrated system, a station platform system and a middle platform system;
the data defining module is used for defining a data model and constructing a data set required by query;
the report design unit is used for selecting a data set required by a report through the report designer, designing the header attribute of the report, filling the header content, selecting the corresponding field of the data set, including the flight date, dragging the data set field into the corresponding cell, adding the personalized attribute to the cell according to the requirement, carrying out cell combination by using the attribute provided by the tool bar or carrying out data calculation by using the function of excel, and increasing the query condition;
the portal display unit is used for configuring a system menu, filling codes of the design report form under the corresponding display menu, and completing release.
Further, in defining the data model unit, the data set includes: single table data or SQL combined data view.
Further, in the definition data model unit, after basic data preparation is completed, the type attribute and alias information of the data are adjusted in the data preparation stage, and a query field is designed.
Further, in the report design unit, personalized attributes are added to the cells according to the requirement, merging or calculation is carried out, and query conditions are increased.
Further, the system is mounted on a computer device, and includes: at least one processor, a memory, and a computer program stored in the memory and executable on the at least one processor.
By combining all the technical schemes, the invention has the advantages and positive effects that: the invention provides the report generation method based on the engine mode and the self-service BI system for meeting the complex and changeable requirements of the BI statistical analysis under the big data background, thereby improving the statistical analysis efficiency of the production data and rapidly generating the statistical analysis data meeting the requirements of the report of each department.
Compared with the prior art, the invention is used in the landing of an airport, and provides a design of operation auxiliary decision report statistics for personnel related to a statistics room and an operation command room. According to the user feedback of the system for 3 months before use and 4 months after use, the engine type self-service BI system greatly improves the data statistics efficiency of first-line personnel, and before the system is used, a series of work such as demand explanation, program design, program development, program online and the like is required to be carried out, the online period is long, each report is put forward from the demand to the online for at least 7 days, if the period of important guarantee is met, the actual online use period is longer, the online restart is borne, and the system is unavailable and the like. After the self-service BI system is used, first-line statistics personnel change report design at any time according to needs, data calculation, summarizing and displaying are carried out according to needs, each report is averaged from needs to use, the period is shortened to an hour unit, and the on-site operation statistics efficiency is greatly improved.
The invention changes the traditional report development mode, assists in improving the operation statistics efficiency, enriches the data use scene, displays in multiple dimensions, and plays a potential value of the data. And the multi-data set different period inquiry condition linkage binding and static data set mode processes airport operation bulletin filling class, period report class (daily report, weekly report, monthly report, annual report and historical data comparison) and the like. Compared with the traditional report design mode, the invention adopts a designer to directly and intuitively design the production data, eliminates complicated updating online flow, and can display the statistical data after the design is completed.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the disclosure and together with the description, serve to explain the principles of the disclosure;
FIG. 1 is a diagram of an engine mode based report generation self-service BI system provided by an embodiment of the present invention;
FIG. 2 is a flowchart of a report generation method based on an engine mode according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a cell map provided by an embodiment of the present invention;
FIG. 4 is a schematic diagram of a report generation method based on an engine mode according to an embodiment of the present invention;
in the figure: 1. a data source access unit; 2. defining a data model unit; 3. a report design unit; 4. and a portal display unit.
Detailed Description
In order that the above objects, features and advantages of the invention will be readily understood, a more particular description of the invention will be rendered by reference to the appended drawings. In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. The invention may be embodied in many other forms than described herein and similarly modified by those skilled in the art without departing from the spirit or scope of the invention, which is therefore not limited to the specific embodiments disclosed below.
The report generation method based on the engine mode and the self-service BI system provided by the embodiment of the invention have the innovation points that: the invention completes the design of the complex report based on the report designer, flexibly processes various user requirements such as merging cells, formula processing, line color change, data filling, dimension calculation, report drilling, condition and dictionary association and the like, and meets the actual production statistical requirement. The designer designs the report and obtains the report, adjusts the statistical requirement at any time, shortens the synchronization period, contains abundant industry statistical template selections simultaneously, and greatly improves the daily production efficiency.
It can be understood that the invention realizes the grouping design and formula calculation of the complex report through the report engine and the cell mapping relation, meets various design requirements of the report,
in embodiment 1, the report generating self-service BI system based on the engine mode provided by the embodiment of the invention is a one-stop data application system integrating data source management, data set management, a self-service report designer, a report display portal and the like. When the system is designed by first-line statistics personnel, a statistics report can be formed on real-time production data quickly, and airport operation decision analysis is assisted.
As shown in fig. 1, the method specifically includes:
the data source access unit 1 is configured to configure a data source of statistical data, fill in data source connection information, and the data source includes: the system comprises an integrated system, a station platform system and a middle platform system;
the data model defining unit 2 is used for defining a data model, and the current data model comprises a SQL set, a static set, an interface set and other common models. The SQL set is a data result set associated with SQL query, the static set is static data meeting the requirement of filling information or annual index type information, the interface set is a background interface query result set, a data set required by query is constructed according to scene requirements, and the data set comprises single-table data or SQL combined data views;
after basic data preparation is completed, if necessary, the type attribute, alias information and the like of the data are adjusted in the data preparation stage, in order to meet the actual needs, the type attribute of the table data can be selected, for example, the field attribute is changed from a numerical value to a character string, meanwhile, the alias information of the field is changed according to the needs for dimension display, meanwhile, according to the needs, a query field is designed, a custom query is set at the tail of a data set, for example { name } is added at the tail of an SQL set, the field query ff.name of the name is configured in a data set attribute column, and accordingly query filtering on the design field can be automatically spliced after the SQL set.
Illustratively, in the definition data model element 2, a cell map is constructed from the group model, the list model, the condition model, the formula model, and the reference model. The grouping model is applied to data grouping design, such as province and city, and the province information is grouped; the list model is applied to list display design, and can select horizontal or vertical display; the condition model is applied to form information to display condition attributes, such as xx month xx daily statistics, and display information is related to query condition actions; the formula model is applied to function calculation, such as sum, weekday and other function processing; the reference model is applied to a value of a text filling information to be calculated by a reference function, and the content of the reference cell can be selected at the text after the calculation in a certain cell is completed.
The report design unit 3 is used for selecting a data set required by a report through the report designer, designing the header attribute of the report, filling the header content, selecting the corresponding field of the data set, such as the flight date, dragging the data set field into the corresponding cell, adding personalized attribute to the cell according to the requirement, carrying out cell merging by using the attribute provided by the tool bar or carrying out data calculation by using the function of excel (comprising sum function summation, weekday date processing and the like, and using the same way as the excel formula library), and increasing the query condition.
The portal display unit 4 is used for configuring a system menu, filling codes of the design report under the corresponding display menu through system menu configuration, and completing release and use.
Based on the functional principle of each unit, report design can be completed rapidly according to requirements in the actual use process. The data statistics period is greatly shortened while the accuracy of the data is ensured.
Embodiment 2 of the invention provides a report generating method based on an engine mode, aiming at rapidly completing the operation statistical analysis requirements of different dimensionalities and different businesses of each department.
In the aspect of report generation, the design and implementation flow of an engine are used as the core field of the report, the front end defines a report structure through the traditional report modes such as excel and the like, such as cell merging, data display directions, cell background, font frame lines and the like, the engine analyzes the front end report definition according to the agreed data structure, cell mapping is constructed based on model attribute design, such as the father cell of B2 is the cell relation of A2 and the like, data are obtained through the mapping relation of a data set and a table field and combined with the cell mapping, the data are calculated at cell filling positions, and a data tree is formed.
Taking most report business requirements as an example, the method comprises complex requirements such as grouping combination and the like, and the target report is shown in table 1.
TABLE 1
The user draws the report form wanted by himself through the front page and drags the needed data into the corresponding table, sets the wanted style and the inquiry condition and transmits to the report engine for processing according to the agreed data format.
Specifically, as shown in fig. 2, the report generating method based on the engine mode provided by the embodiment of the invention includes the following steps:
s1, the front end completes report form design, adds information such as cell attributes, data fields and the like, and transmits the information to the rear end;
in the front-end report form design sample, the added information of cell attributes, data fields and the like is shown in table 2.
TABLE 2
S2, the engine analyzes the front-end information, builds cell mapping according to model definition, and logically calculates cell logic tree nodes according to each cell father cell relation.
Wherein the cell mapping diagram principle is shown in fig. 3.
S3, finding the data set field filled in each cell according to the cell mapping structure, acquiring the data set field value and filling the data set field value into the corresponding cell, realizing filling of data set data and cell data, and constructing a data tree.
And S4, returning the result to front-end rendering.
In the embodiment of the invention, fig. 4 is a diagram of a report generating method based on an engine mode provided by the invention.
In the foregoing embodiments, the descriptions of the embodiments are emphasized, and in part, not described or illustrated in any particular embodiment, reference is made to the related descriptions of other embodiments.
The content of the information interaction and the execution process between the devices/units and the like is based on the same conception as the method embodiment of the present invention, and specific functions and technical effects brought by the content can be referred to in the method embodiment section, and will not be described herein.
The embodiment of the invention also provides a computer device, which comprises: at least one processor, a memory, and a computer program stored in the memory and executable on the at least one processor, which when executed by the processor performs the steps of any of the various method embodiments described above.
Embodiments of the present invention also provide a computer readable storage medium storing a computer program which, when executed by a processor, performs the steps of the respective method embodiments described above.
The embodiment of the invention also provides an information data processing terminal, which is used for providing a user input interface to implement the steps in the method embodiments when being implemented on an electronic device, and the information data processing terminal is not limited to a mobile phone, a computer and a switch.
The embodiment of the invention also provides a server, which is used for realizing the steps in the method embodiments when being executed on the electronic device and providing a user input interface.
Embodiments of the present invention provide a computer program product which, when run on an electronic device, causes the electronic device to perform the steps of the method embodiments described above.
While the invention has been described with respect to what is presently considered to be the most practical and preferred embodiments, it is to be understood that the invention is not limited to the disclosed embodiments, but on the contrary, is intended to cover various modifications, equivalents, and alternatives falling within the spirit and scope of the invention.
Claims (10)
1. The report generating method based on the engine mode is characterized in that the method realizes grouping design and formula calculation of the complex report through the mapping relation between the report engine and the unit lattice, and meets the report design requirement, and specifically comprises the following steps:
s1, the front end completes report form design, adds cell attribute and data field information and transmits the cell attribute and the data field information to the rear end;
s2, the engine analyzes the front-end information and constructs cell mapping according to model definition;
s3, combining data of the data set according to the cell mapping structure to construct a data tree;
and S4, returning the result to front-end rendering.
2. The report generating method based on the engine mode according to claim 1, wherein in step S2, the engine parses the front-end information, comprising: the front end defines a report structure in an excel report mode, the report structure comprises cell merging, a data display direction, cell background and font frame lines, and the engine analyzes the front end report definition according to the agreed data structure.
3. The report generating method based on the engine mode according to claim 1, wherein in step S2, the model includes: grouping models, list models, condition models, formula models, and reference models; the grouping model is applied to data grouping design and comprises province and city, and the province information is grouped; the list model is applied to list display design, and selects horizontal or vertical display; the condition model is applied to form information display condition attributes, wherein the display information is related to query condition actions, and the condition attributes comprise xx month xx daily statistics; the formula model is applied to function calculation and comprises sum and weekday function processing; the reference model is applied to the text filling information and needs the value calculated by the reference function, and the content of the reference cell is selected at the text after the calculation in the cell is completed.
4. The report generating method based on the engine mode according to claim 1, wherein in the cell mapping structure, in step S3, the parent cell mapped to B2 is an A2 cell relationship, and the configuration of the cell data and the style format is mapped according to the cell coordinate relationship.
5. The report generating method based on the engine mode according to claim 1, wherein in step S3, constructing a data tree comprises: through the mapping relation between the data set and the form field, a data link is established, a cell tree relation is established according to the cell configuration attribute, cell tree relation data is filled based on the data set field information filled by cells, and therefore the filling position of the data in the cells is calculated, the data is realized, and the data is combined with the cell mapping to form a data tree.
6. An engine mode-based report generation self-service BI system, which is characterized in that the system is implemented by applying the engine mode-based report generation method according to any one of claims 1 to 5, and the system comprises:
a data source access unit (1) for configuring a data source of statistical data, filling in data source connection information, the data source comprising: the system comprises an integrated system, a station platform system and a middle platform system;
a definition data model unit (2) for defining a data model and constructing a data set required by inquiry;
the report design unit (3) is used for selecting a data set required by a report through a report designer, designing the header attribute of the report, filling the header content, selecting the corresponding field of the data set, including the flight date, dragging the data set field into the corresponding cell, adding the personalized attribute to the cell according to the requirement, carrying out cell merging by using the attribute provided by the tool bar or carrying out data calculation by using the function of excel, and increasing the query condition;
and the portal display unit (4) is used for configuring a system menu, filling codes of the design report form under the corresponding display menu and finishing release.
7. The engine-schema-based report generating self-service BI system according to claim 6, wherein in defining the data model unit (2), the dataset comprises: single table data or SQL combined data view.
8. The engine-schema-based report generating self-service BI system according to claim 6, wherein after the basic data preparation is completed in the defining data model unit (2), the type attribute and alias information of the data are adjusted in the data preparation stage, and the query field is designed.
9. The self-service BI system for generating an engine-mode-based report according to claim 6, wherein in the report design unit (3), personalized attributes are added to the cells as required, and the combination or calculation is performed to increase the query conditions.
10. The engine-mode-based report generating self-service BI system of claim 6, wherein the system is onboard a computer device, comprising: at least one processor, a memory, and a computer program stored in the memory and executable on the at least one processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311785542.XA CN117454862A (en) | 2023-12-25 | 2023-12-25 | Report generation method based on engine mode and self-service BI system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311785542.XA CN117454862A (en) | 2023-12-25 | 2023-12-25 | Report generation method based on engine mode and self-service BI system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117454862A true CN117454862A (en) | 2024-01-26 |
Family
ID=89584068
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311785542.XA Pending CN117454862A (en) | 2023-12-25 | 2023-12-25 | Report generation method based on engine mode and self-service BI system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117454862A (en) |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| CN102591968A (en) * | 2011-12-31 | 2012-07-18 | 深圳联友科技有限公司 | Achievement method of expansion form and expansion engine |
| US20130290822A1 (en) * | 2011-12-29 | 2013-10-31 | Bibo Labs, Inc. | Spreadsheet-based programming language adapted for report generation |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN104360992A (en) * | 2014-12-02 | 2015-02-18 | 福建工程学院 | WEB report design system built based on EXCEL platform and implementation method |
| CN106407171A (en) * | 2016-11-03 | 2017-02-15 | 华能澜沧江水电股份有限公司 | System and method for generating safety monitoring self-defined report based on tree structure |
| CN109669949A (en) * | 2018-12-27 | 2019-04-23 | 广州云趣信息科技有限公司 | A kind of dynamic report generation method and system realization based on data model |
| CN111126026A (en) * | 2019-12-17 | 2020-05-08 | 叮当快药科技集团有限公司 | Method and tool for generating visual report form by analyzing SQL statement |
| CN111428458A (en) * | 2020-03-03 | 2020-07-17 | 中国平安人寿保险股份有限公司 | Universal report generation method and device and computer readable storage medium |
| CN111881192A (en) * | 2020-08-03 | 2020-11-03 | 浪潮云信息技术股份公司 | Method and system for generating visual configuration report, electronic equipment and storage medium |
| CN112052242A (en) * | 2020-09-02 | 2020-12-08 | 平安科技（深圳）有限公司 | Data query method and device, electronic equipment and storage medium |
| CN112463797A (en) * | 2020-12-08 | 2021-03-09 | 航天信息股份有限公司 | Report generation method, system, storage medium and electronic equipment |
| CN113688617A (en) * | 2021-08-19 | 2021-11-23 | 北京齐尔布莱特科技有限公司 | Method for generating table page and computing equipment |
| CN115081414A (en) * | 2022-08-17 | 2022-09-20 | 广州思迈特软件有限公司 | Spreadsheet generation method, device, equipment and medium based on data model |
| CN116468010A (en) * | 2023-02-27 | 2023-07-21 | 河钢数字技术股份有限公司 | Report generation method, device, terminal and storage medium |
-
2023
- 2023-12-25 CN CN202311785542.XA patent/CN117454862A/en active Pending
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| US20130290822A1 (en) * | 2011-12-29 | 2013-10-31 | Bibo Labs, Inc. | Spreadsheet-based programming language adapted for report generation |
| CN102591968A (en) * | 2011-12-31 | 2012-07-18 | 深圳联友科技有限公司 | Achievement method of expansion form and expansion engine |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN104360992A (en) * | 2014-12-02 | 2015-02-18 | 福建工程学院 | WEB report design system built based on EXCEL platform and implementation method |
| CN106407171A (en) * | 2016-11-03 | 2017-02-15 | 华能澜沧江水电股份有限公司 | System and method for generating safety monitoring self-defined report based on tree structure |
| CN109669949A (en) * | 2018-12-27 | 2019-04-23 | 广州云趣信息科技有限公司 | A kind of dynamic report generation method and system realization based on data model |
| CN111126026A (en) * | 2019-12-17 | 2020-05-08 | 叮当快药科技集团有限公司 | Method and tool for generating visual report form by analyzing SQL statement |
| CN111428458A (en) * | 2020-03-03 | 2020-07-17 | 中国平安人寿保险股份有限公司 | Universal report generation method and device and computer readable storage medium |
| CN111881192A (en) * | 2020-08-03 | 2020-11-03 | 浪潮云信息技术股份公司 | Method and system for generating visual configuration report, electronic equipment and storage medium |
| CN112052242A (en) * | 2020-09-02 | 2020-12-08 | 平安科技（深圳）有限公司 | Data query method and device, electronic equipment and storage medium |
| CN112463797A (en) * | 2020-12-08 | 2021-03-09 | 航天信息股份有限公司 | Report generation method, system, storage medium and electronic equipment |
| CN113688617A (en) * | 2021-08-19 | 2021-11-23 | 北京齐尔布莱特科技有限公司 | Method for generating table page and computing equipment |
| CN115081414A (en) * | 2022-08-17 | 2022-09-20 | 广州思迈特软件有限公司 | Spreadsheet generation method, device, equipment and medium based on data model |
| CN116468010A (en) * | 2023-02-27 | 2023-07-21 | 河钢数字技术股份有限公司 | Report generation method, device, terminal and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 朱文婷 等: "基于XSLT和XML的报表开发技术在船员管理系统中的应用", 上海船舶运输科学研究所学报, vol. 37, no. 04, 30 December 2014 (2014-12-30), pages 56 - 61 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210117437A1 (en) | Data model transformation | |
| US7734619B2 (en) | Method of presenting lineage diagrams representing query plans | |
| US8479093B2 (en) | Metamodel-based automatic report generation | |
| US6651055B1 (en) | OLAP query generation engine | |
| AU2020260374B2 (en) | Building reports | |
| CN102426582B (en) | Data manipulation management devices and data manipulation management method | |
| CN102521417A (en) | Method for processing multi-dimensional data based on virtual data cube and system of method | |
| CN108694214A (en) | Generation method, generating means, readable medium and the electronic equipment of data sheet | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| CN111831282A (en) | Low-code form development method and system based on VUE technology | |
| CN102222110A (en) | Data processing device and method | |
| CN110543303A (en) | Visual business platform | |
| CN114003843A (en) | Page generation method, device, equipment and storage medium | |
| CN111552848A (en) | Avionics system fault analysis method based on graph database | |
| US20120256926A1 (en) | Gesture, text, and shape recognition based data visualization | |
| JP2022093293A (en) | Online report preparation system using excel tool | |
| CN110413598A (en) | List data amending method, device, electronic equipment and storage medium | |
| CN112988142A (en) | Attribute table generation method and device | |
| CN116991923A (en) | Drag type data model visual modeling system and method based on browser | |
| CN117454862A (en) | Report generation method based on engine mode and self-service BI system | |
| CN115934716A (en) | Method for importing Excel table data into database based on metadata definition and implementation | |
| CN116010439A (en) | Visual Chinese SQL system and query construction method | |
| US20140344235A1 (en) | Determination of data modification | |
| CN114281797A (en) | Method for quickly creating basic level data aggregation warehouse based on agile low-code platform | |
| CN111488379A (en) | Method for optimizing Hbase large data query |
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 |