CN111159991B - Report modeling design device and method - Google Patents
Report modeling design device and method Download PDFInfo
- Publication number
- CN111159991B CN111159991B CN201911276068.1A CN201911276068A CN111159991B CN 111159991 B CN111159991 B CN 111159991B CN 201911276068 A CN201911276068 A CN 201911276068A CN 111159991 B CN111159991 B CN 111159991B
- Authority
- CN
- China
- Prior art keywords
- report
- format
- meta
- model
- members
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a report modeling design device and method, belongs to the field of enterprise information management, and solves the problem that data rules, actual data and formats of existing report data are tightly bound. The device comprises: the report modeling module is used for setting model attributes and report constituent elements to obtain a report meta-model; the rule setting module is used for setting a fetch rule and an operation rule on report form constituent elements in the report form meta-model; the format setting module is used for designing a report format template, selecting report constituent elements in one or more associated report meta-models, loading the report constituent elements on the report format template, generating a report format, and recording the corresponding relation between cell coordinates and the report meta-models in the report format; and the report generation module is used for acting the corresponding cell in the report format on the basis of the corresponding relation between the cell coordinate in the initial report and the report meta-model and the access rule and the operation rule set on the report constituting element in the report meta-model related to the report format to generate report data.
Description
Technical Field
The invention relates to the technical field of enterprise information management, in particular to a report modeling design device and method.
Background
In the existing filled report product, the process of designing the report is usually to manually draw a format in an Excel-like interface, and set a fetch rule, an operation rule and an audit rule for the cells. In the existing analytical report products, various data rules are often set on format cells in a coding mode.
Whether the filled report or the analysis report product, the report data is stored according to the cell coordinates. Under the implementation mode, the data rule and the actual data are tightly bound with the format, and the format simultaneously carries the display rule and the fetch rule, and the implementation mode has the following defects:
1. after the format is changed, the meaning of the content represented by the same row and column coordinate position is changed, and the associated number-taking operation auditing rule needs to be searched and reset, so that the adjustment workload is large;
2. the format change can cause the meaning change of the data at the same position, the data is discontinuous, and the historical versions of the report data are not easy to compare.
Disclosure of Invention
In view of the above analysis, the present invention aims to provide a report modeling design device and method, which are used for solving the problem of tight binding of data rules, actual data and formats in the existing report data.
The aim of the invention is mainly realized by the following technical scheme:
in one aspect, a report modeling design apparatus is provided, the apparatus including:
the report modeling module is used for setting model attributes and report constituent elements to obtain a report meta-model;
the rule setting module is used for setting a fetch rule and an operation rule on the report form constituent elements in each report form meta-model;
the format setting module is used for designing a report format template based on the business requirements of a report target audience, selecting all or part of report constituent elements in one or more associated report meta-models, dragging and dropping the report constituent elements onto the report format template, generating a report format, and recording the corresponding relation between cell coordinates and the report meta-models in the report format;
and the report generation module is used for acting the number taking rules and the operation rules set on the report constituting elements in one or more report meta-models related to the report format on the corresponding cells in the report format based on the corresponding relation between the cell coordinates in the report format and the report meta-models to generate report data.
Based on the scheme, the invention also makes the following improvements:
further, the report forming element includes:
a main project for describing independent cells on the report;
the sub-table is used for describing a table area on the report and comprises row member definitions and column member definitions;
the multidimensional cross table is used for describing a cross analysis table area on the report and comprises row dimension, column dimension and dimension member definition.
Further, the report modeling module includes:
the report model scheme setting unit is used for setting model attributes, wherein the model attributes at least comprise meta model names and meta model forms; the meta model is in the form of one of a main item, a sub-table and a multidimensional cross table;
a main item setting unit, configured to set item names and value data types of one or more main items in the main item form metamodel;
the sub-table setting unit is used for setting the project names, the input forms and the value data types of one or more row members and column members in the sub-table form meta-model; the input form in the sub-form metamodel is fixed text or dynamic data; when the input form in the sub-form meta-model is a fixed text, the row members and the column members are obtained through preset; when the input form in the sub-form meta-model is dynamic data, the row members and the column members are obtained and generated dynamically based on database query;
the cross table setting unit is used for setting the title, the input form and the value data type of one or more dimension members of row dimension and dimension members of column dimension in the multi-dimensional cross table form meta-model; the input form in the multi-dimensional cross table form meta-model is fixed text or dynamic data; when the input form in the multi-dimensional cross table form meta-model is a fixed text, the row members and the column members are obtained through preset; when the input form in the multi-dimensional cross table form meta-model is dynamic data, the row members and the column members are obtained and generated dynamically based on database query.
Further, the rule setting module includes:
the access rule setting unit is used for setting access rules for the report meta-model; the number taking rule is arranged on a main item, the intersection of a row member and a column member in a sub-table, or the intersection of a dimension member of a row dimension and a dimension member of a column dimension in a multi-dimensional cross table, or the whole sub-table or the multi-dimensional cross table;
the operation rule setting unit is used for setting operation rules among main items, operation rules among row members in the sub-table, operation rules among column members in the sub-table, operation rules among crossing points of the row members and the column members in the sub-table, operation rules among dimension members of row dimensions in the multi-dimensional crossing table, operation rules among dimension members of column dimensions in the multi-dimensional crossing table, and operation rules of crossing points of dimension members of row dimensions and dimension members of column dimensions in the multi-dimensional crossing table.
Further, the rule setting module further includes an audit rule setting unit, configured to set audit rules on report constituent elements in the report meta-model:
the method is used for setting auditing rules among main projects, auditing rules among row members in a sub-table, auditing rules among column members in the sub-table, auditing rules of intersections of the row members and the column members in the sub-table, auditing rules among dimension members of row dimensions in a multi-dimensional cross table, auditing rules among dimension members of column dimensions in the multi-dimensional cross table, and auditing rules of intersections of dimension members of row dimensions and dimension members of column dimensions in the multi-dimensional cross table.
Further, the format setting module includes:
the format management unit is used for designing a report format template based on the business requirements of the report target audience;
the model selection unit is used for dragging part or all of report form constituent elements in one or more associated report form metamodels to a format design area of the report form format template based on the content in the report form format template, adaptively adjusting the sequence among the report form constituent elements according to the format requirement of the report form format template, generating a report form format, and recording the corresponding relation between the cell coordinates in the report form format and the report form metamodel;
the secondary processing setting unit is used for setting secondary processing rules for the report form constituent elements according to the requirements of business on report form display and statistics in the process of generating a report form format;
and the style setting unit is used for adaptively adjusting style display rules of the report format based on the processing results of the model selection unit and the secondary processing setting unit and updating the report format.
Further, in the model selection unit, a data cell is generated after the main item element is dragged and dropped, and a table area is generated after the sub-table element and the multidimensional cross table element are dragged and dropped.
Further, the device also comprises a data storage module for storing the business keyword information of the report and the report data in the report generation module; the report data in the report generation module is stored in the form of 'report ID + report meta-model name + report constituent elements + values'.
On the other hand, a report modeling design method is provided, and the method comprises the following steps:
setting model attributes and report form constituent elements to obtain a report form meta-model;
setting a fetching rule and an operation rule on report form constituent elements in each report form meta-model;
designing a report format template based on the business requirements of a report target audience, displaying all or part of report constituent elements in one or more associated report meta-models based on the content in the report format template, selecting and dragging and dropping the report constituent elements onto the report format template to generate a report format, and recording the corresponding relation between cell coordinates in the report format and the report meta-models;
and applying the number taking rules and the operation rules set on the report form constituent elements in one or more report meta-models related to the report format to corresponding cells in the report format based on the corresponding relation between the cell coordinates and the report meta-models in the report format to generate report data.
Based on the scheme, the invention also makes the following improvements:
further, the report format generating step further includes:
setting secondary processing rules for report form constituent elements according to requirements of business on report form display and statistics in the process of generating report form format;
and adjusting style display rules of the report format and updating the report format.
The invention has the following beneficial effects:
according to the report modeling design device provided by the invention, the report data model is set through the report modeling module, the report data acquisition rule is set through the rule management module, the report display format is designed through the format design module, the data model, the data rule and the display rule are decoupled and separated, and are respectively adjusted in different modules, so that the influence and the limitation among the data model, the data rule and the display rule are reduced, and the following application effects are realized:
1. sharing the model setting among different formats, reducing repeated setting workload among the formats;
2. the display adjustment of the format does not need a large amount of adjustment of fetch, operation and audit setting;
3. the data model and the display of the report are separated, the data structure is stabilized, the report format can be separated, the report data can be independently stored and accessed according to the model structure, the comparison of the historical version report data is not influenced by the format change, and the integration relationship of an external system is not influenced;
4. the data access no longer needs to analyze the format, which is beneficial to improving the access, calculation and analysis performance of the data, and making the data become meaningful, thereby exerting the value of report data to the maximum extent.
The method has the same principle as the device, so the method has the corresponding technical effects of the device.
In the invention, the technical schemes can be mutually combined to realize more preferable combination schemes. Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
The drawings are only for purposes of illustrating particular embodiments and are not to be construed as limiting the invention, like reference numerals being used to refer to like parts throughout the several views.
FIG. 1 is a schematic diagram of a report modeling design apparatus in an embodiment of the present invention;
FIG. 2 is a flowchart of a report modeling design method in an embodiment of the invention.
Detailed Description
Preferred embodiments of the present invention will now be described in detail with reference to the accompanying drawings, which form a part hereof, and together with the description serve to explain the principles of the invention, and are not intended to limit the scope of the invention.
Example 1
The invention discloses a report modeling design device, the structure schematic diagram of which is shown in fig. 1, and the device comprises:
the report modeling module is used for setting model attributes and report constituent elements to obtain a report meta-model;
the rule setting module is used for setting a fetch rule and an operation rule on the report form constituent elements in each report form meta-model;
the format setting module is used for designing a report format template based on the business requirements of a report target audience, selecting all or part of report forming elements in one or more associated report meta-models based on the content in the report format template, dragging and dropping the report forming elements onto the report format template to generate a report format, and recording the corresponding relation between the coordinates of cells in the report format and the report meta-models;
and the report generation module is used for acting the number taking rules and the operation rules set on the report constituting elements in one or more report meta-models related to the report format on the corresponding cells in the report format based on the corresponding relation between the cell coordinates in the report format and the report meta-models to generate report data.
Compared with the prior art, the report modeling design device provided by the embodiment separates the report meta-model, the report format and the report rule setting; the set of report meta-models can obtain corresponding report formats according to different report format requirements, so that the use frequency of different report meta-models is effectively improved, and the value of a data report is furthest exerted; if the format is changed, the format setting module is only required to carry out adaptive adjustment, and the acquisition rule and the operation rule are not required to be set on the report form constituent elements; the problems of large modification difficulty and large modification workload caused by binding data rules, actual data and data formats are avoided.
Preferably, the report forming element includes: a main project for describing independent cells on the report; the sub-table is used for describing a table area on the report and comprises row member definitions and column member definitions; the multidimensional cross table is used for describing a cross analysis table area on the report and comprises row dimension, column dimension and dimension member definition.
Preferably, the report modeling module includes:
the report model scheme setting unit is used for setting model attributes, wherein the model attributes at least comprise meta model names and meta model forms, and information such as sequence numbers, meta model codes, keyword combinations, meta model descriptions, creation organization, application reports, current versions, release states, sharing or not can be added according to actual demands; the meta model is in the form of one of a main item, a sub-table and a multidimensional cross table;
the main item setting unit is used for setting item names and value data types of one or more main items in the main item form metamodel, and can also add information such as item codes, value reference entities, data length, decimal places, application descriptions and the like according to actual requirements.
The sub-table setting unit is used for setting the project names, input forms and value data types of one or more row members and column members in the sub-table form meta-model, and can also add information such as row codes, column codes, value reference entities, data lengths, decimal places, application instructions and the like according to actual demands; the input form in the sub-form metamodel is fixed text or dynamic data; when the input form in the sub-form meta-model is a fixed text, the row members and the column members are obtained through preset, for example, three column members, namely three columns of a television, a refrigerator and an air conditioner, can be set; when the input form in the sub-form meta-model is dynamic data, the row member and the column member are dynamically obtained and dynamically generated based on database query, for example, a column member named as a household appliance can be set, and is dynamically obtained and generated from a database commodity table, and three actual column members are automatically generated in the operation period, so that the sub-model setting is not required to be adjusted when the type of the washing machine is increased in the future. For editable reports, the row members may not be set, entered by the user during editing.
The cross table setting unit is used for setting the title, the input form and the value data type of one or more row dimension members, one or more column dimension members and one or more column dimension members in the multidimensional cross table form meta-model, and can be used for adding information such as row codes, column codes, value reference entities, data length, decimal places, application description and the like according to actual requirements; the input form in the multi-dimensional cross table form meta-model is fixed text or dynamic data; when the input form in the multi-dimensional cross table form meta-model is a fixed text, the row members and the column members are obtained through preset; when the input form in the multi-dimensional cross table form meta-model is dynamic data, the row members and the column members are obtained and generated dynamically based on database query. The members of the row and column dimensions form a cross table structure by cross multiplication. For example: the regional column dimension members are set to comprise northeast, north China and south China regions, the commodity column dimension members are set to be televisions, refrigerators and air conditioners, and after the regional dimension members and the commodity dimension members are crossed, the regional column dimension members are used for expressing the data region structure in the table 1:
table 1 data region structure example of multidimensional interleaving table
Preferably, the rule setting module includes:
the access rule setting unit is used for setting access rules for the report meta-model; the number taking rule is arranged on a main project, the intersection of a row member and a column member in a sub-table, or the intersection of a dimension member of a row dimension and a dimension member of a column dimension in a multi-dimensional cross table, or the whole sub-table or the multi-dimensional cross table, and one-time overall acquisition of whole table data is performed;
an operation rule setting unit for setting an operation rule between main items, an operation rule between row members in a sub-table (corresponding to an entire row operation), an operation rule between column members in a sub-table (corresponding to an entire column operation), an operation rule between intersections of row members and column members in a sub-table (corresponding to a cell free operation), an operation rule between dimension members of row dimensions in a multi-dimensional cross table (entire row operation), an operation rule between dimension members of column dimensions in a multi-dimensional cross table (entire column operation), an operation rule between intersections of dimension members of row dimensions and dimension members of column dimensions in a multi-dimensional cross table (cell operation).
Preferably, the rule setting module further includes an audit rule setting unit, configured to set audit rules on report constituent elements in the report meta-model, and if necessary, check correctness of report data according to preset audit rules:
the method is used for setting auditing rules among main projects, auditing rules among row members in a sub-table, auditing rules among column members in the sub-table, auditing rules of intersections of the row members and the column members in the sub-table, auditing rules among dimension members of row dimensions in a multi-dimensional cross table, auditing rules among dimension members of column dimensions in the multi-dimensional cross table, and auditing rules of intersections of dimension members of row dimensions and dimension members of column dimensions in the multi-dimensional cross table. Similar to the operation rule setting position, the auditing rule sets a comparison expression, for example, a item=b item+c item+d item, D item > E item+f item, G item > H item+i item, and the like. Prompt information given when the auditing rule is not satisfied can be set.
Preferably, the format setting module includes:
the format management unit is used for designing a report format template based on the business requirements of the report target audience; formats can be added, modified and deleted according to requirements, and multiple versions of formats can be managed;
the model selection unit is used for displaying part or all report forming elements in one or more associated report meta-models, selecting and dragging and dropping the report forming elements on the report format template to generate data cells or data areas, generating a data cell after dragging and dropping a main item element, and generating a table area after dragging and dropping a sub-table and a multidimensional cross table; the order among the report form constituent elements is adaptively adjusted according to the format requirement of the report form format template so that the generated format meets the expected requirement, thereby generating a report form format, and recording the corresponding relation between the cell coordinates and the report meta-model in the report form format;
the secondary processing setting unit is used for setting secondary processing rules for the report form constituent elements according to the requirements of business on report form display and statistics in the process of generating a report form format; for example, for sub-table elements, multi-layer grouping statistical rules, row sub-meter, column sub-meter rules for sub-table data can be set;
and the style setting unit is used for adaptively adjusting style display rules of the report format, such as display rules of set fonts, colors, lines, column widths and the like, based on the processing results of the model selecting unit and the secondary processing setting unit, and updating the report format.
Preferably, the report generating module may further input service keyword information of a report, and specifically includes: report unit, report time, and business information such as contract or engineering project. In actual operation, the access rule and the operation rule set on the model bound on the executable format acquire data and execute operation, and the data is displayed on the format after being generated. And the correctness of the data can be checked according to the requirements on the auditing rules on the generated report executable model.
Considering that in the prior art, data are stored according to the format row-column coordinates, the following problems are caused: (1) The data is stored according to row and column coordinates, the row and column coordinates lack business meaning, and the data access and utilization are difficult; (2) Because the format needs to be analyzed when inquiring and reading report data, the row and column coordinates are positioned, the processing is complex, and the performance is poor; (3) The integrated mapping relationship set by the cell coordinates needs to be adjusted repeatedly.
Based on the problems, the device also comprises a data storage module which is used for storing the business keyword information of the report and the report data in the report generation module on the basis of the report modeling design; when the data in the format is stored, the data in the report generation module is not stored according to the format row and column coordinates, and the data in the report generation module is stored according to the form of report ID, report meta-model name, report constituent element and value, so that the stored data is ensured to be irrelevant to the format. For example: the 6 th row and the 3 rd column in the table are bound with the money fund (code: HBZJ) row members and the current year (code: BNS) column members of the model, when the data are stored, the cell data are stored according to four dimensions of report ID and model ID, HBZJ, BNS, and the coordinates of 6 rows and 3 columns are not stored. Future format changes, the position is adjusted to 10 rows and 4 columns, and as long as the model elements bound by the new position are ensured to be unchanged, display data or revision update can still be loaded according to the item of currency fund. After the report data is stored according to the model, a third party system acquires the report data, the data integration relationship can be configured according to the model elements, the integration relationship is not influenced by format change, after the report data has the model meaning, the report model is published and shared, the report data can be directly used as a stable data source for big data analysis, and the data integration and access performance can be greatly improved.
Example 2
In another embodiment of the present invention, a report modeling design method is disclosed, a flowchart is shown in fig. 2, and the method includes the following steps:
step S1: setting model attributes and report form constituent elements to obtain a report form meta-model;
step S2: setting a fetching rule and an operation rule on report form constituent elements in each report form meta-model;
step S3: designing a report format template based on the business requirements of a report target audience, displaying all or part of report constituent elements in one or more associated report meta-models based on the content in the report format template, selecting and dragging and dropping the report constituent elements onto the report format template to generate a report format, and recording the corresponding relation between cell coordinates in the report format and the report meta-models;
step S4: and applying the number taking rules and the operation rules set on the report form constituent elements in one or more report meta-models related to the report format to corresponding cells in the report format based on the corresponding relation between the cell coordinates and the report meta-models in the report format to generate report data.
Preferably, the report generating format further includes:
setting secondary processing rules for report form constituent elements according to requirements of business on report form display and statistics in the process of generating report form format;
and adjusting style display rules of the report format and updating the report format.
The specific implementation process of the method embodiment of the present invention may be referred to the above device embodiment, and this embodiment is not described herein. The method embodiment has the same principle as the device embodiment, so the method also has the corresponding technical effects of the device embodiment.
Those skilled in the art will appreciate that all or part of the flow of the methods of the embodiments described above may be accomplished by way of a computer program to instruct associated hardware, where the program may be stored on a computer readable storage medium. Wherein the computer readable storage medium is a magnetic disk, an optical disk, a read-only memory or a random access memory, etc.
The present invention is not limited to the above-mentioned embodiments, and any changes or substitutions that can be easily understood by those skilled in the art within the technical scope of the present invention are intended to be included in the scope of the present invention.
Claims (9)
1. A report modeling design apparatus, the apparatus comprising:
the report modeling module is used for setting model attributes and report constituent elements to obtain a report meta-model; the report form constituent elements comprise main items, sub-tables and multidimensional intersecting tables; a main project for describing independent cells on the report; the sub-table is used for describing a table area on the report and comprises row member definitions and column member definitions; the multidimensional cross table is used for describing a cross analysis table area on the report and comprises row dimension, column dimension and dimension member definition;
the rule setting module is used for setting a fetch rule and an operation rule on the report form constituent elements in each report form meta-model;
the format setting module is used for designing a report format template based on the business requirements of a report target audience, selecting all or part of report constituent elements in one or more associated report meta-models, dragging and dropping the report constituent elements onto the report format template, generating a report format, and recording the corresponding relation between cell coordinates and the report meta-models in the report format;
and the report generation module is used for acting the number taking rules and the operation rules set on the report constituting elements in one or more report meta-models related to the report format on the corresponding cells in the report format based on the corresponding relation between the cell coordinates in the report format and the report meta-models to generate report data.
2. The report modeling design device of claim 1, wherein the report modeling module comprises:
the report model scheme setting unit is used for setting model attributes, wherein the model attributes at least comprise meta model names and meta model forms; the meta model is in the form of one of a main item, a sub-table and a multidimensional cross table;
a main item setting unit, configured to set item names and value data types of one or more main items in the main item form metamodel;
the sub-table setting unit is used for setting the project names, the input forms and the value data types of one or more row members and column members in the sub-table form meta-model; the input form in the sub-form metamodel is fixed text or dynamic data; when the input form in the sub-form meta-model is a fixed text, the row members and the column members are obtained through preset; when the input form in the sub-form meta-model is dynamic data, the row members and the column members are obtained and generated dynamically based on database query;
the cross table setting unit is used for setting the title, the input form and the value data type of one or more dimension members of row dimension and dimension members of column dimension in the multi-dimensional cross table form meta-model; the input form in the multi-dimensional cross table form meta-model is fixed text or dynamic data; when the input form in the multi-dimensional cross table form meta-model is a fixed text, the row members and the column members are obtained through preset; when the input form in the multi-dimensional cross table form meta-model is dynamic data, the row members and the column members are obtained and generated dynamically based on database query.
3. The report modeling design device as defined in claim 2, wherein the rule setting module includes:
the access rule setting unit is used for setting access rules for the report meta-model; the number taking rule is arranged on a main item, the intersection of a row member and a column member in a sub-table, or the intersection of a dimension member of a row dimension and a dimension member of a column dimension in a multi-dimensional cross table, or the whole sub-table or the multi-dimensional cross table;
the operation rule setting unit is used for setting operation rules among main items, operation rules among row members in the sub-table, operation rules among column members in the sub-table, operation rules among crossing points of the row members and the column members in the sub-table, operation rules among dimension members of row dimensions in the multi-dimensional crossing table, operation rules among dimension members of column dimensions in the multi-dimensional crossing table, and operation rules of crossing points of dimension members of row dimensions and dimension members of column dimensions in the multi-dimensional crossing table.
4. The report modeling design apparatus as defined in claim 3, wherein the rule setting module further comprises an audit rule setting unit for setting audit rules on report constituent elements in the report meta-model:
the method is used for setting auditing rules among main projects, auditing rules among row members in a sub-table, auditing rules among column members in the sub-table, auditing rules of intersections of the row members and the column members in the sub-table, auditing rules among dimension members of row dimensions in a multi-dimensional cross table, auditing rules among dimension members of column dimensions in the multi-dimensional cross table, and auditing rules of intersections of dimension members of row dimensions and dimension members of column dimensions in the multi-dimensional cross table.
5. The report modeling design device as claimed in any of claims 1-4, wherein the format setting module includes:
the format management unit is used for designing a report format template based on the business requirements of the report target audience;
the model selection unit is used for dragging part or all of report form constituent elements in one or more associated report form metamodels to a format design area of the report form format template based on the content in the report form format template, adaptively adjusting the sequence among the report form constituent elements according to the format requirement of the report form format template, generating a report form format, and recording the corresponding relation between the cell coordinates in the report form format and the report form metamodel;
the secondary processing setting unit is used for setting secondary processing rules for the report form constituent elements according to the requirements of business on report form display and statistics in the process of generating a report form format;
and the style setting unit is used for adaptively adjusting style display rules of the report format based on the processing results of the model selection unit and the secondary processing setting unit and updating the report format.
6. The report modeling design device according to claim 5, wherein in the model selection unit, a data cell is generated after the main item element is dragged and dropped, and a table area is generated after the sub-table element and the multidimensional cross-table element are dragged and dropped.
7. The report modeling design device according to claim 6, further comprising a data storage module for storing business keyword information of the report and report data in a report generation module; the report data in the report generation module is stored in the form of 'report ID + report meta-model name + report constituent elements + values'.
8. A report modeling design method is characterized by comprising the following steps:
setting model attributes and report form constituent elements to obtain a report form meta-model; the report form constituent elements comprise main items, sub-tables and multidimensional intersecting tables; a main project for describing independent cells on the report; the sub-table is used for describing a table area on the report and comprises row member definitions and column member definitions; the multidimensional cross table is used for describing a cross analysis table area on the report and comprises row dimension, column dimension and dimension member definition;
setting a fetching rule and an operation rule on report form constituent elements in each report form meta-model;
designing a report format template based on the business requirements of a report target audience, displaying all or part of report constituent elements in one or more associated report meta-models, selecting and dragging and dropping the report format template to generate a report format, and recording the corresponding relation between cell coordinates and the report meta-models in the report format;
and applying the number taking rules and the operation rules set on the report form constituent elements in one or more report meta-models related to the report format to corresponding cells in the report format based on the corresponding relation between the cell coordinates and the report meta-models in the report format to generate report data.
9. The report modeling design method as defined in claim 8, wherein the generating report format further comprises:
setting secondary processing rules for report form constituent elements according to requirements of business on report form display and statistics in the process of generating report form format;
and adjusting style display rules of the report format and updating the report format.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911276068.1A CN111159991B (en) | 2019-12-12 | 2019-12-12 | Report modeling design device and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911276068.1A CN111159991B (en) | 2019-12-12 | 2019-12-12 | Report modeling design device and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111159991A CN111159991A (en) | 2020-05-15 |
| CN111159991B true CN111159991B (en) | 2023-06-27 |
Family
ID=70556810
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911276068.1A Active CN111159991B (en) | 2019-12-12 | 2019-12-12 | Report modeling design device and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111159991B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113158635B (en) * | 2021-04-30 | 2024-01-30 | 中国工商银行股份有限公司 | Electronic report generation method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103744831A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Compilation method and device for multi-dimensional report |
| CN105320690A (en) * | 2014-07-30 | 2016-02-10 | 北京中海纪元数字技术发展股份有限公司 | Metadata based rapid statistic form generation method and system |
| CN109766338A (en) * | 2018-11-28 | 2019-05-17 | 杭州云为科技有限公司 | Self-defined report design method, electronic equipment, storage medium and system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761081A (en) * | 2013-12-29 | 2014-04-30 | 远光软件股份有限公司 | Method and device for compiling composite report provided with master-retail reports |
-
2019
- 2019-12-12 CN CN201911276068.1A patent/CN111159991B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103744831A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Compilation method and device for multi-dimensional report |
| CN105320690A (en) * | 2014-07-30 | 2016-02-10 | 北京中海纪元数字技术发展股份有限公司 | Metadata based rapid statistic form generation method and system |
| CN109766338A (en) * | 2018-11-28 | 2019-05-17 | 杭州云为科技有限公司 | Self-defined report design method, electronic equipment, storage medium and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111159991A (en) | 2020-05-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11157489B2 (en) | Data querying | |
| US20210117437A1 (en) | Data model transformation | |
| CN110955717A (en) | Visual dynamic display method and system based on big data | |
| US7475080B2 (en) | Adaptive data warehouse meta model method | |
| KR102143889B1 (en) | System for metadata management | |
| Silva et al. | SQL: From traditional databases to big data | |
| CN110647549A (en) | Data index analyzing and executing method and device based on business dynamic modeling | |
| WO2008070240A2 (en) | Data charting with adaptive learning | |
| EP1909198A2 (en) | Semantical partitioning of data | |
| US20010037228A1 (en) | System and method for using metadata to flexibly analyze data | |
| CN102426582A (en) | Data operation management device and data operation management method | |
| US20140244690A1 (en) | Generate in-memory views from universe schema | |
| CN111414405A (en) | Data acquisition method and device and electronic equipment | |
| CN112527373A (en) | Visual platform expanding method based on operation integrated management center service | |
| US9298686B2 (en) | System and method for simulating discrete financial forecast calculations | |
| US20070294631A1 (en) | Apparatus and method for embedding and utilizing report controls within an online report | |
| KR20190087841A (en) | A data input/output system using grid interface | |
| US7197696B1 (en) | System, method and computer program product to populate data into spreadsheets and execute functions and programs within the same | |
| CN111159991B (en) | Report modeling design device and method | |
| CN111881660A (en) | Report generation method and device, computer equipment and storage medium | |
| EP3086244B1 (en) | Database system and method of operation thereof | |
| Reniers et al. | Schema design support for semi-structured data: Finding the sweet spot between NF and De-NF | |
| US11636421B1 (en) | Model driven reporting | |
| US7617221B2 (en) | Rendering database queries with blank space | |
| US11036471B2 (en) | Data grouping for efficient parallel processing |
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 |