CN102279848A - Method and device for generating report template - Google Patents
Method and device for generating report template Download PDFInfo
- Publication number
- CN102279848A CN102279848A CN2010101957549A CN201010195754A CN102279848A CN 102279848 A CN102279848 A CN 102279848A CN 2010101957549 A CN2010101957549 A CN 2010101957549A CN 201010195754 A CN201010195754 A CN 201010195754A CN 102279848 A CN102279848 A CN 102279848A
- Authority
- CN
- China
- Prior art keywords
- report form
- form template
- statistical
- fact table
- module
- 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.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and device for generating a report template. The method comprises the following steps of: determining a fact table and counting indexes to be counted of the report template, and selecting a counting condition; associating the counting condition with the fact table by using a snowflakes model; and sequencing and grouping the counting indexes in the fact table according to the counting condition, and dynamically memorizing sequencing and grouping results to generate the report template. In the invention, the counting condition is associated with the fact table to be counted of the report template by using the snowflakes model, and the indexes to be counted in the fact table are sequenced and grouped according to the counting condition to dynamically generate the report template. Compared with the conventional fixed report, the invention has the advantages that: implementation is easier and more flexible, a report with a high custom degree can be provided without secondary development, and the development speed of the report template is greatly increased.
Description
Technical field
The present invention relates to computerized information service technology field, more specifically, relate to a kind of method and apparatus that generates report form template.
Background technology
At present, the function that all kinds of report tools provide is very many, yet the demand owing to the client in daily use is diversified, so only used the very little part of set form form.In order to satisfy client's various demands,, especially lack the technical scheme of the higher report form template of simple generation User Defined degree if carry out secondary development based on present all kinds of report tools then need very large workload.
Summary of the invention
The technical matters that the present invention will solve provides a kind of method that generates report form template, can be simply and generate the high report form template of self-defined degree neatly.
The invention provides a kind of method that generates report form template, comprise and determine report form template fact table and statistical indicator to be added up, and select statistical condition; Utilize related statistical condition of snowflake model and fact table; Statistical indicator in the fact table is sorted and divide into groups according to statistical condition, the result after dynamic memory ordering and the grouping is to generate report form template.
An embodiment according to the inventive method is specially the step that the statistical indicator in the fact table sorts according to statistical condition: by ascending order or descending the statistical indicator in the fact table is sorted.
According to another embodiment of the inventive method, before the step that according to statistical condition the statistical indicator in the fact table is sorted and divide into groups, this method also comprises according to user's request creates, edits or the deletion statistical indicator.
According to the another embodiment of the inventive method, before the step that generates report form template, this method also comprises the output format of adjusting form.
According to an embodiment again of the inventive method, after generating report form template, this method also comprises the rights of using that define report form template; In the rights of using of report form template according to the user's request editor, duplicate or delete report form template.
According to an embodiment again of the inventive method, statistical condition comprises Correlation Criteria, filtercondition, time conditions, gathers mode and statistics granularity.
The method of generation report form template provided by the invention utilizes the snowflake model fact table that statistical condition and report form template is to be added up to associate, and according to statistical condition index to be added up in the fact table is sorted and divides into groups, and dynamically generates report form template.The present invention realizes simpler, flexible with respect to the existing fixed form, need not secondary development just can provide the self-defined degree of meeting consumers' demand higher form, has greatly improved the tempo of development of self-defined report template.
Another technical matters that the present invention will solve provides a kind of device that generates report form template, can be simply and generate the high report form template of self-defined degree neatly.
The present invention also provides a kind of device that generates report form template, comprises the information determination module, is used for determining report form template fact table and statistical indicator to be added up; Select module, be used to select statistical condition; Relating module links to each other with the selection module with the information determination module respectively, is used to utilize related statistical condition of snowflake model and fact table; Ordering and grouping module, respectively with the information determination module, select module and relating module to link to each other, be used for the statistical indicator of fact table is sorted and dividing into groups according to statistical condition, the result after dynamic memory ordering and the grouping is with the generation report form template.
An embodiment of the apparatus according to the invention, this device also comprises the statistical indicator processing module, links to each other with grouping module with ordering, is used for creating, editing or the deletion statistical indicator according to user's request.
According to another embodiment of apparatus of the present invention, this device also comprises adjusting module, links to each other with grouping module with ordering, is used to adjust the output format of form.
Another embodiment according to apparatus of the present invention, this device also comprises the rights of using administration module, link to each other with grouping module with ordering, be used to define the rights of using of report form template, and in the rights of using of report form template according to the user's request editor, duplicate or delete report form template.
According to an embodiment again of apparatus of the present invention, statistical condition comprises Correlation Criteria, filtercondition, time conditions, gathers mode and statistics granularity.
The device of generation report form template provided by the invention utilizes the snowflake model fact table that statistical condition and report form template is to be added up to associate, and according to statistical condition index to be added up in the fact table is sorted and divides into groups, and dynamically generates report form template.The present invention realizes simpler, flexible with respect to the existing fixed form, need not secondary development just can provide the self-defined degree of meeting consumers' demand higher form, has greatly improved the tempo of development of self-defined report template.
Description of drawings
Accompanying drawing described herein is used to provide further understanding of the present invention, constitutes the application's a part.In the accompanying drawings:
Fig. 1 is the schematic flow sheet of first embodiment of the inventive method.
Fig. 2 is a concrete synoptic diagram of snowflake model.
Fig. 3 utilizes the present invention to generate the synoptic diagram of the method making report form embodiment of report form template.
Fig. 4 is the structural representation of an embodiment of the present invention's device of generating report form template.
Fig. 5 is the structural representation of another embodiment of the present invention's device of generating report form template.
Fig. 6 is the structural representation of the another embodiment of the present invention's device of generating report form template.
Fig. 7 is the structural representation of an embodiment again of the present invention's device of generating report form template.
Embodiment
With reference to the accompanying drawings the present invention is described more fully, exemplary embodiment of the present invention wherein is described.Exemplary embodiment of the present invention and explanation thereof are used to explain the present invention, but do not constitute improper qualification of the present invention.
The present invention provides a kind of method and apparatus that generates report form template by analyzing the incidence relation of every data in the Service Database, has solved the problem of being familiar with business but the unfamiliar user of the every function of report tool being run into when the configuration self-defined report.
The data model of telecom network management system has such characteristics: data (that is, database table) are divided into two classes, and a class is a raw data, and another kind of is configuration data.Data in the raw data table are produced automatically by equipment, so data volume is very big, and configuration data is by manual entry, so data volume is much smaller.Being actually raw data table by the object added up, is the role of selector switch and configuration data table is served as, is the part of statistical condition.
From the notion of data warehouse, raw data table is a fact table, and configuration data table is the dimension table.The object that fact table is added up, and the dimension table is used for definite data area of being added up.Exist incidence relation between fact table and the dimension table.
Fig. 1 is the schematic flow sheet of first embodiment of the inventive method.
As shown in Figure 1, this embodiment may further comprise the steps:
S102 determines fact table and statistical indicator that report form template is to be added up, and selects statistical condition, wherein, fact table promptly is that the user wants the form inquired about, for example, can be 1 hour traffic table of outgoing circuit group, come 1 hour traffic table of outgoing circuit group, come 1 hour traffic table of outgoing object code; Statistical indicator can be a predefined parameter in some parameter in the fact table or the system, for example, number of call attempts, connects number of times, two-way circuit utilization factor etc.; Statistical condition can comprise Correlation Criteria, filtercondition, time conditions, gather mode and statistics granularity.
Particularly, can be with (that is, the dimension table) condition is called Correlation Criteria, will be called filtercondition at the field of raw data table (that is fact table) at configuration data table.Correlation Criteria is the querying condition of certain field of constraint dimension table as form.Filtercondition is very common, and its constraint is at fact table itself, and it can retrain the data area of being added up to dwindle further to the set of records ends of electing through Correlation Criteria.Filtercondition can be (for example, can select those available circuit numbers greater than 100 record) that puts on respective fields, also can be (for example, the available circuit number is less than the open electric circuit number) that puts on several fields.For filtercondition, can wait the computing formula that defines filtercondition by statistical indicator, comparison operators, logical operator and numerical value.In addition, in the process of making report form template, newly-increased filtercondition can also be joined in the report form template, and can edit and deletion action filtercondition.Filtercondition can be one, also can be a plurality of.Need to prove that the field that filtercondition imposes restriction is not limited in the field of being added up.
By specified associations condition and filtercondition, data area to be added up is just locked.Next, also needing to specify index to be added up is what.That is to say, select Correlation Criteria and filtercondition making an issue of aspect the fact table " OK ", what determine is which row is participated in statistics, and determines that statistical indicator is exactly to make an issue of aspect " row " of fact table, defines which row and participates in statistics.The value of directly taking out row sometimes from database is just passable, for example add up number of calls, available circuit number of some circuit group etc., more then be will row the basis on do computing, calculate the webmaster parameter, for example, percent of call completed, answer seizure ratio, answer bid ratio and occlusion rate etc., even might be the computing formula of user oneself definition, this is to utilize the present invention to generate the outstanding advantage of report form template.
Time conditions comprises the timing statistics type and whether allows to contrast historical data.For example, the timing statistics type can be one or more in continuous time zone, continuous discrete time zone of date and the discrete time zone of discrete date.The mode of gathering can comprise accumulative total or average.The statistics granularity, promptly data result gathers granularity.Report form template can provide multiple statistics granularity, for example, can be by the source end, client information is carried out tabulate statistics, also can carry out tabulate statistics by some attribute of circuit group.The statistics of form can be presented at each statistics granularity among same the form result according to selected statistics granularity, thereby need not a plurality of statistics granularities are repeatedly added up, and has improved the efficient of statistics.
In addition, statistical condition can also comprise and gathers chronomere, for example, can gather by the hour and/or gather by date.When gathering by the hour separately, statistics can gather many days same hour data by the hour; When gathering by date separately, statistics can gather the data of selected hour of every day by date.
S104, utilize related statistical condition of snowflake model and fact table, wherein, snowflake model and star model are conceptual data models commonly used at present, but, the star model is limited to the descriptive power of objective world, generally only limit to constitute a simple scenario to how corresponding incidence relation with a plurality of dimension tables by a fact table, if the complexity of situation (for example promotes, dimension table itself also needs other entity to be further described), then the star model is just powerless, must be by means of snowflake model.
Fig. 2 is a concrete synoptic diagram of snowflake model.
As shown in Figure 2, snowflake model is expanded on the star model based, and it has increased new table-" the classification table in detail " of a class on the basis of fact table and Wei Biao, be used for the dimension table is described.In the star model, the standardization degree of fact table is than higher, and the data redundancy degree of dimension table does not add restriction.And in snowflake model, the purpose of introducing detailed classification table is exactly for the data of dimension table are further decomposed, and with the standardization degree of raising data model, and makes it to have lower granularity.Therefore, the dimension table of snowflake model has less data redundancy, is easy to safeguard, has saved storage space, has higher flexibility.
In Fig. 2, the implication of each element is as follows:
EndType represents endpoint type, and its value can be for for example, arbitrarily/and city/switch/circuit group;
TimeType express time type, its value can be one, one group or all, for example, one day, some days or all days, one hour, some hrs or 24 hours;
AggType represents the mode of gathering, and its value can be for average or add up;
OrderType represents sort method, and its value can be ascending order or descending;
ColumnType represents form row type, and its value can be webmaster parameter or configuration data;
GranType represents to add up granularity, and its value can be for for example, city, switch or circuit group etc.;
Bas_parameter represents statistical indicator, and it is the fundamental element of form, and the field in all fact tables all is the webmaster parameter, and the record of a correspondence all can be arranged at this table;
Param_constraint is applied to a restriction on the statistical indicator, and some such restrictions have just constituted the filtercondition of a form.
S106, statistical indicator in the fact table is sorted and divide into groups according to statistical condition, the result after dynamic memory ordering and the grouping is to generate report form template, and ordering and division operation are the aligning methods to results set, specify by which field ordering, or by which field grouping.For example, can sort to the statistical indicator in the fact table (that is, certain field or certain several field) by ascending order or descending.After ordering and grouping, every definition of above-mentioned report form template stored promptly formed report form template, for example, can realize by one group of database table.
In the prior art fixedly the storing process of form all write in advance, and self-defined report template of the present invention is the backstage storing process that a plurality of conditions by user's input automatically generate, create it in database, rather than finishes writing in advance and build up.Because allow the formula of some statistical indicators of user oneself definition, be impossible so finish writing in advance.Therefore, the present invention need not secondary development just can provide the self-defined degree of meeting consumers' demand high form.
In another embodiment of the inventive method, before the step that according to statistical condition the statistical indicator in the fact table is sorted and divide into groups, can also comprise according to user's request and create, edit or the deletion statistical indicator.
When setting up report form template, can utilize the new statistical indicator of existing parameter-definition, and it is presented among the output result.In the process of the new statistical indicator of definition, data type (for example, integer, floating number, ratio etc.) that can the designated statistics index, and use existing parameter and the required computing formula of operational symbol editor, thus obtain new statistical indicator.
Can determine various statistical indicators neatly by this embodiment, make that the self-defined degree of report form template is higher.
In the another embodiment of the inventive method, before the step that generates report form template, can also comprise the output format of adjusting form.For example, can adjust the front and back order of each row of form, can also provide the configuration column of form and hide and/or Presentation Function according to user's request.For form result's displaying, multiple mode can be provided, for example, form, histogram, broken line graph, pie chart and/or histogram etc., and the demonstration handoff functionality of these modes.In addition, can also adjust the sequencing of content in Correlation Criteria and the filtercondition.
Flexible and various interface display function can be provided by this embodiment, the various demonstration demands that the user proposes can be satisfied.
In an embodiment again of the inventive method, after generating report form template, can also comprise the rights of using that define report form template; In the rights of using of report form template according to the user's request editor, duplicate or delete report form template.
For example, for convenience the user creates new report form template, can at first duplicate existing report form template, and then revise report form template after duplicating based on the difference of two report form templates, has improved the make efficiency of new report form template.
In addition, when generating report form template, can rights of using be set to it, for example, whether be all with the right to use is arranged per family, still have only certain customers that the right to use is arranged.Authorized users just can be edited report form template after login, has guaranteed the security of report form template so effectively.
Fig. 3 utilizes the present invention to generate the synoptic diagram of the method making report form embodiment of report form template.
As shown in Figure 3, behind the definition of finishing form and storing process, can adopt the mode of navigation to make form.Background program accesses the definition to form from database, the actual value that the guiding user fills in terms and conditions is called storing process then, obtains actual report form statistics result, and shows this form.Make form by mode shown in Figure 3, make Report Operations convenient and swift, only need just can make, inquire about, revise statement form and content, saved greatly and made the time of form, and truly realized the self-defined of form with mouse is dilatory.
Fig. 4 is the structural representation of an embodiment of the present invention's device of generating report form template.
As shown in Figure 4, the device of this embodiment comprises information determination module 11, is used for determining report form template fact table and statistical indicator to be added up; Select module 12, be used to select statistical condition, wherein, statistical condition can comprise Correlation Criteria, filtercondition, time conditions, gather mode and statistics granularity; Relating module 13 links to each other with the selection module with the information determination module respectively, is used to utilize related statistical condition of snowflake model and fact table; Ordering and grouping module 14, link to each other with information determination module 11, selection module 12 and relating module 13 respectively, be used for the statistical indicator of fact table is sorted and dividing into groups according to statistical condition, the result after dynamic memory ordering and the grouping is to generate report form template.Particularly, can realize configuration, increase the storing process of ASSOCIATE STATISTICS again, finish concrete data computation, so just realize the making of report form template by storing process by writing database script to configuration data table in the database.
This embodiment is the backstage storing process that automatically generates by a plurality of conditions that the user imports, and creates it in database, rather than finish writing in advance and build up.Because allow the formula of some statistical indicators of user oneself definition, be impossible so finish writing in advance.Therefore, the present invention need not secondary development just can provide the self-defined degree of meeting consumers' demand high form.
Fig. 5 is the structural representation of another embodiment of the present invention's device of generating report form template.
As shown in Figure 5, compare with embodiment among Fig. 4, the device of this embodiment also comprises statistical indicator processing module 21, links to each other with grouping module 14 with ordering, be used for according to user's request create, editor or deletion statistical indicator.
When setting up report form template, can utilize the new statistical indicator of existing parameter-definition, and it is presented among the output result.In the process of the new statistical indicator of definition, data type (for example, integer, floating number, ratio etc.) that can the designated statistics index, and use existing parameter and the required computing formula of operational symbol editor, thus obtain new statistical indicator.
Can determine various statistical indicators neatly by this embodiment, make that the self-defined degree of report form template is higher.
Fig. 6 is the structural representation of the another embodiment of the present invention's device of generating report form template.
As shown in Figure 6, compare with embodiment among Fig. 4, the device of this embodiment also comprises adjusting module 31, links to each other with grouping module 14 with ordering, is used to adjust the output format of form.For example, can adjust the front and back order of each row of form, can also provide the configuration column of form and hide and/or Presentation Function according to user's request.For form result's displaying, multiple mode can be provided, for example, form, histogram, broken line graph, pie chart and/or histogram etc., and the demonstration handoff functionality of these modes.In addition, can also adjust the sequencing of content in Correlation Criteria and the filtercondition.
Flexible and various interface display function can be provided by this embodiment, the various demonstration demands that the user proposes can be satisfied.
Fig. 7 is the structural representation of an embodiment again of the present invention's device of generating report form template.
As shown in Figure 7, compare with the embodiment among Fig. 4, the device of this embodiment also comprises rights of using administration module 41, link to each other with grouping module 14 with ordering, be used to define the rights of using of report form template, and in the rights of using of report form template according to the user's request editor, duplicate or delete report form template.
For example, for convenience the user creates new report form template, can at first duplicate existing report form template, and then revise report form template after duplicating based on the difference of two report form templates, has improved the make efficiency of new report form template.
In addition, when generating report form template, can rights of using be set to it, for example, whether be all with the right to use is arranged per family, still have only certain customers that the right to use is arranged.Authorized users just can be edited report form template after login, has guaranteed the security of report form template so effectively.
Description of the invention provides for example with for the purpose of describing, and is not exhaustively or limit the invention to disclosed form.Many modifications and variations are conspicuous for the ordinary skill in the art.Selecting and describing embodiment is for better explanation principle of the present invention and practical application, thereby and makes those of ordinary skill in the art can understand the various embodiment that have various modifications that the present invention's design is suitable for special-purpose.
Claims (11)
1. a method that generates report form template is characterized in that, described method comprises:
Determine fact table and statistical indicator that report form template is to be added up, and select statistical condition;
Utilize related described statistical condition of snowflake model and described fact table;
Described statistical indicator in the described fact table is sorted and divide into groups according to described statistical condition, the result after dynamic memory ordering and the grouping is to generate described report form template.
2. method according to claim 1 is characterized in that, describedly according to statistical condition the step that the described statistical indicator in the described fact table sorts is specially:
By ascending order or descending the described statistical indicator in the described fact table is sorted.
3. method according to claim 1 is characterized in that, before the described step that according to statistical condition the described statistical indicator in the described fact table is sorted and divide into groups, described method also comprises:
Create, edit or delete described statistical indicator according to user's request.
4. method according to claim 1 is characterized in that, before the step of described generation report form template, described method also comprises:
Adjust the output format of form.
5. method according to claim 1 is characterized in that, after described generation report form template, described method also comprises:
Define the rights of using of described report form template;
In the rights of using of described report form template according to the user's request editor, duplicate or delete described report form template.
6. method according to claim 1 is characterized in that, described statistical condition comprises Correlation Criteria, filtercondition, time conditions, gathers mode and statistics granularity.
7. a device that generates report form template is characterized in that, described device comprises:
The information determination module is used for determining report form template fact table and statistical indicator to be added up;
Select module, be used to select statistical condition;
Relating module links to each other with described selection module with described information determination module respectively, is used to utilize related described statistical condition of snowflake model and described fact table;
Ordering and grouping module, link to each other with described information determination module, described selection module and described relating module respectively, be used for the described statistical indicator of described fact table is sorted and dividing into groups according to described statistical condition, the result after dynamic memory ordering and the grouping is to generate described report form template.
8. device according to claim 7 is characterized in that, described device also comprises:
The statistical indicator processing module links to each other with grouping module with described ordering, is used for creating, edit or delete described statistical indicator according to user's request.
9. device according to claim 7 is characterized in that, described device also comprises:
Adjusting module links to each other with grouping module with described ordering, is used to adjust the output format of form.
10. device according to claim 7 is characterized in that, described device also comprises:
The rights of using administration module links to each other with grouping module with described ordering, is used to define the rights of using of described report form template, and in the rights of using of described report form template according to the user's request editor, duplicate or delete described report form template.
11. device according to claim 7 is characterized in that, described statistical condition comprises Correlation Criteria, filtercondition, time conditions, gathers mode and statistics granularity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010195754.9A CN102279848B (en) | 2010-06-09 | 2010-06-09 | Method and device for generating report template |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010195754.9A CN102279848B (en) | 2010-06-09 | 2010-06-09 | Method and device for generating report template |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102279848A true CN102279848A (en) | 2011-12-14 |
| CN102279848B CN102279848B (en) | 2015-04-01 |
Family
ID=45105303
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010195754.9A Active CN102279848B (en) | 2010-06-09 | 2010-06-09 | Method and device for generating report template |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102279848B (en) |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103186560A (en) * | 2011-12-28 | 2013-07-03 | 金蝶软件（中国）有限公司 | Data sorting method and related device |
| CN103198071A (en) * | 2012-01-06 | 2013-07-10 | 中国移动通信集团山东有限公司 | Data report generation method and device adopting same |
| CN103605779A (en) * | 2013-11-28 | 2014-02-26 | 北京国双科技有限公司 | Report generation method and device |
| CN103793469A (en) * | 2013-12-30 | 2014-05-14 | 远光软件股份有限公司 | Data inquiry statistics method and data inquiry statistics system |
| CN104063361A (en) * | 2014-07-04 | 2014-09-24 | 用友软件股份有限公司 | Report design method and system |
| CN104978305A (en) * | 2014-04-08 | 2015-10-14 | 无锡兰霖网络科技有限公司 | Intelligent computation method of statistical index on the basis of complex function formula |
| CN105045576A (en) * | 2015-06-29 | 2015-11-11 | 用友优普信息技术有限公司 | Management method and apparatus for calculation formulae in business document |
| CN105069096A (en) * | 2015-08-06 | 2015-11-18 | 厦门二五八集团有限公司 | Architecture method and architecture system for user-defined worksheet |
| CN105446949A (en) * | 2015-11-30 | 2016-03-30 | 用友优普信息技术有限公司 | Information display method and information display apparatus |
| CN105447068A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | SAP system based dynamic report generation method and system |
| CN106294299A (en) * | 2016-07-29 | 2017-01-04 | 杭州华三通信技术有限公司 | A kind of report form generation method and device |
| CN107562708A (en) * | 2017-08-31 | 2018-01-09 | 顾杏春 | Form linkage methods of exhibiting and system |
| CN107871010A (en) * | 2017-11-21 | 2018-04-03 | 重庆金融资产交易所有限责任公司 | Electronic installation, the method and storage medium of report database optimization |
| CN109102088A (en) * | 2018-08-09 | 2018-12-28 | 北京智行者科技有限公司 | A kind of processing method of report data |
| CN109213765A (en) * | 2018-08-20 | 2019-01-15 | 中国平安人寿保险股份有限公司 | The associated method, apparatus of tables of data, computer equipment and storage medium |
| CN109376150A (en) * | 2018-09-03 | 2019-02-22 | 中国平安财产保险股份有限公司 | Methods of product development, device, computer equipment and storage medium |
| CN109933759A (en) * | 2017-12-19 | 2019-06-25 | 阿里巴巴集团控股有限公司 | A kind of generation method and device counting class tables of data |
| CN110175319A (en) * | 2019-05-05 | 2019-08-27 | 中国银行股份有限公司 | A kind of report generation method and device |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1564160A (en) * | 2004-04-22 | 2005-01-12 | 重庆市弘越科技有限公司 | Method of seting up and inquirying multiple-demensional data cube |
| CN101111839A (en) * | 2004-11-30 | 2008-01-23 | 科格洛斯公司 | Reporting model generation within a multidimensional enterprise software system |
-
2010
- 2010-06-09 CN CN201010195754.9A patent/CN102279848B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1564160A (en) * | 2004-04-22 | 2005-01-12 | 重庆市弘越科技有限公司 | Method of seting up and inquirying multiple-demensional data cube |
| CN101111839A (en) * | 2004-11-30 | 2008-01-23 | 科格洛斯公司 | Reporting model generation within a multidimensional enterprise software system |
Non-Patent Citations (1)
| Title |
|---|
| 李柯: "基于数据仓库和OLAP 的民航灾害预警决策支持系统", 《西南交通大学学报》 * |
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103186560B (en) * | 2011-12-28 | 2017-04-05 | 金蝶软件（中国）有限公司 | A kind of data reordering method and relevant apparatus |
| CN103186560A (en) * | 2011-12-28 | 2013-07-03 | 金蝶软件（中国）有限公司 | Data sorting method and related device |
| CN103198071B (en) * | 2012-01-06 | 2016-05-25 | 中国移动通信集团山东有限公司 | Datagram table generating method and device thereof |
| CN103198071A (en) * | 2012-01-06 | 2013-07-10 | 中国移动通信集团山东有限公司 | Data report generation method and device adopting same |
| CN103605779A (en) * | 2013-11-28 | 2014-02-26 | 北京国双科技有限公司 | Report generation method and device |
| CN103793469A (en) * | 2013-12-30 | 2014-05-14 | 远光软件股份有限公司 | Data inquiry statistics method and data inquiry statistics system |
| CN104978305A (en) * | 2014-04-08 | 2015-10-14 | 无锡兰霖网络科技有限公司 | Intelligent computation method of statistical index on the basis of complex function formula |
| CN104063361A (en) * | 2014-07-04 | 2014-09-24 | 用友软件股份有限公司 | Report design method and system |
| CN104063361B (en) * | 2014-07-04 | 2017-09-29 | 用友网络科技股份有限公司 | Report design method and Report Form Design system |
| CN105447068A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | SAP system based dynamic report generation method and system |
| CN105045576A (en) * | 2015-06-29 | 2015-11-11 | 用友优普信息技术有限公司 | Management method and apparatus for calculation formulae in business document |
| CN105069096A (en) * | 2015-08-06 | 2015-11-18 | 厦门二五八集团有限公司 | Architecture method and architecture system for user-defined worksheet |
| CN105446949A (en) * | 2015-11-30 | 2016-03-30 | 用友优普信息技术有限公司 | Information display method and information display apparatus |
| CN106294299A (en) * | 2016-07-29 | 2017-01-04 | 杭州华三通信技术有限公司 | A kind of report form generation method and device |
| CN107562708A (en) * | 2017-08-31 | 2018-01-09 | 顾杏春 | Form linkage methods of exhibiting and system |
| CN107871010A (en) * | 2017-11-21 | 2018-04-03 | 重庆金融资产交易所有限责任公司 | Electronic installation, the method and storage medium of report database optimization |
| CN109933759A (en) * | 2017-12-19 | 2019-06-25 | 阿里巴巴集团控股有限公司 | A kind of generation method and device counting class tables of data |
| CN109102088A (en) * | 2018-08-09 | 2018-12-28 | 北京智行者科技有限公司 | A kind of processing method of report data |
| CN109213765A (en) * | 2018-08-20 | 2019-01-15 | 中国平安人寿保险股份有限公司 | The associated method, apparatus of tables of data, computer equipment and storage medium |
| CN109376150A (en) * | 2018-09-03 | 2019-02-22 | 中国平安财产保险股份有限公司 | Methods of product development, device, computer equipment and storage medium |
| CN110175319A (en) * | 2019-05-05 | 2019-08-27 | 中国银行股份有限公司 | A kind of report generation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102279848B (en) | 2015-04-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102279848A (en) | Method and device for generating report template | |
| CN110543303B (en) | Visual service platform | |
| CN102930062B (en) | The method of the quick horizontal extension of a kind of database | |
| CN112015412A (en) | Device and method for generating business model based on form engine | |
| CN111241129B (en) | Industrial production enterprise index data acquisition and calculation system | |
| CN102096688A (en) | Method and device for generating data report | |
| CN109254901A (en) | A kind of Monitoring Indexes method and system | |
| CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
| CN108595604A (en) | A kind of data visualisation system and method for intelligent report forms | |
| CN113642299A (en) | One-key generation method based on power grid statistical form | |
| CN107748752A (en) | A kind of data processing method and device | |
| CN105528337A (en) | Method for exporting PPT report form by data conversion implementation performance management system | |
| CN109766368B (en) | Hive-based data query multi-type view output system and method | |
| CN106649226A (en) | Report generation method and device | |
| CN109271561A (en) | A kind of profile information search method and device | |
| CN110390607A (en) | Objective cost measuring method, system and computer readable storage medium based on subject index system | |
| CN105335822A (en) | Smart power grid unified data model modeling method for big data analysis | |
| CN111190814B (en) | Method and device for generating software test case, storage medium and terminal | |
| CN102857949A (en) | Method and device for planning data consistency guarantees | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN115858810A (en) | Method, system, computer device and storage medium for automatically constructing knowledge graph | |
| CN111666344A (en) | Heterogeneous data synchronization method and device | |
| CN108959458B (en) | Data generation and use method, system, medium and computer device | |
| CN112905720A (en) | Operation data processing method and device based on source data management model | |
| CN108959439A (en) | A kind of data template generation method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |