CN102117296A - Method for generating dynamic configuration report - Google Patents
Method for generating dynamic configuration report Download PDFInfo
- Publication number
- CN102117296A CN102117296A CN2009102561226A CN200910256122A CN102117296A CN 102117296 A CN102117296 A CN 102117296A CN 2009102561226 A CN2009102561226 A CN 2009102561226A CN 200910256122 A CN200910256122 A CN 200910256122A CN 102117296 A CN102117296 A CN 102117296A
- Authority
- CN
- China
- Prior art keywords
- configuration
- dynamic
- entity
- generation method
- entities
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a data processing technology, in particular to a method for generating a dynamic configuration report. The method for generating the dynamic configuration report comprises the following steps of: A. linking a database of a configuration report system; B. selecting a business main body to be configured and setting the relationship among entities; C. selecting the analysis dimensionality of the entities, i.e. attributes of the entities; D. selecting metric values of the entities; E. previewing a configuration result; F. storing a configuration report; and G. looking up report data in the report system. By adopting the method provided by the invention, users can rapidly make and generate various business reports, thus the making difficulty of reports is reduced, and the working efficiency is improved.
Description
Technical field
The present invention relates to a kind of data processing technique, relate in particular to a kind of generation method of dynamic-configuration form.
Background technology
Form is a part indispensable in the enterprise application software system, by the automatic or auxiliary miscellaneous service form that generates of computing machine, can realize professional standardized management, has greatly improved work efficiency, has quickened the every profession and trade IT application process.
The existing technology that generates form can be divided three classes: the first kind is to adopt the mode of hard coded, generally is to write code by project personnel to realize.The second class report generation scheme is all kinds of softwares such as the static electronic watch of employing, as the Eecel form.The 3rd class report generation scheme is to adopt general report-building tool, the generation that is used to solve dynamic statement.
There are a lot of problems in report generation technology of the prior art, and conventional tool directly depends on the database schema of bottom when report data is set, and needs the mode of manual coding statement or tables of data auxiliary view to come to formulate data from database.Increase the difficulty of report making, needed special data base administrator to participate in.Secondly, it is comparatively special that the part industry requires statement form, need the feature according to data dynamically generate different statement forms when generating form.
Summary of the invention
Technique effect of the present invention can overcome above-mentioned defective, and a kind of generation method of dynamic-configuration form is provided, and it is applied to enterprise-class computers application software form development system.
For achieving the above object, the present invention adopts following technical scheme: it comprises the steps:
A. dispose the database link of reporting system;
B. select the business division of configuration, the inter-entity incidence relation is set;
C. select the analysis dimension of entity, i.e. attributes of entities;
D. select the metric of entity;
E. preview configuration result;
F. storage configuration form;
G. in reporting system, check report data.
SQL server is a function data base management system (DBMS) completely, it can provide the data managing method more much better than former way to manage for the enterprise of any scale, SQL server occupies the industry umber one with its powerful, flexible and wieldy characteristic, SQL server is squeezing into each other enterprise of level, provides each company to have the needed thing of success on enterprise's rank to the information manager.
Dynamic-configuration form development platform has DotNet development platform, two development platforms of SQL Server enterprise-level database system of Microsoft in conjunction with finishing.The major function that realizes the dynamic-configuration form under this development platform is as follows:
1, selects Business Entity and incidence relation
For the dynamic-configuration form, at first need to select the dynamic-configuration Business Entity, then the attribute of Business Entity is analyzed.If the sales data to enterprise is analyzed, the main attribute of sales data has selling time, sell goods, trade debtor, sales force, sales volume, consumption sum etc.Sales data can be used as Business Entity and selects.After Business Entity is selected, need the latitude of Allocation Analysis.
2, the analysis dimension is set
After selecting Business Entity, need be provided with Business Entity is analyzed latitude.As other attributes of time (same day, this month, then, wait on year-on-year basis), Business Entity etc.In the enterprise marketing data analysis, it analyzes latitude can be selling time, sell goods, trade debtor, sales force etc.
3, metric is set
After selecting Business Entity and analyzing latitude, metric is set.In the sales data to enterprise, sales volume, consumption sum all are mensurable values.
4, configuration generates.
After Business Entity in the platform, latitude, metric configuration finished, can be in platform the preview configuration result.After configuration was finished, stored configuration result stored and is provided with in reporting system and checks authority accordingly.
Adopt the generation method of dynamic-configuration form of the present invention, make the user can make things convenient for quick Fabrication and generation miscellaneous service form, reduced the difficulty of report making, improved work efficiency.
Embodiment
This dynamic-configuration report form generation method comprises the steps:
A. dispose the database link of reporting system;
B. select the business division of configuration, the inter-entity incidence relation is set;
C. select the analysis dimension of entity, i.e. attributes of entities;
D. select the metric of entity;
E. preview configuration result;
F. storage configuration form;
G. in reporting system, check report data.
The database link of configuration reporting system: after linking successfully, in platform, list the Business Entity of system.The input server ip address is selected database, inputs user name, password, clicks " Connect " button, and system prompt " linked successfully " after server linked successfully, and shows the list of business entities of corresponding database.
Select configuration Business Entity, the inter-entity incidence relation is set: in the left list, select Business Entity, be dragged in the control panel of right side, if the form of configuration has a plurality of entities, then a plurality of entities are dragged to control panel from the list of business entities of left side, and the incidence relation of inter-entity is set.
Select the analysis latitude of entity, i.e. attributes of entities: the right click Business Entity, select dimension is set, list all properties of Business Entity, the dimension of corresponding attribute.The attribute of Business Entity must have a time dimension, in the attribute list of Business Entity, right click Business Entity attribute, the dimension of selection attribute, just laterally gauge outfit and vertical gauge outfit in dynamic statement, the dimension of an attribute (laterally or vertically) can only be selected one.A plurality of transverse dimensions or vertical dimension can be arranged in the dynamic-configuration form.
Select the metric of entity: after the dimension setting of dynamic-configuration form is finished, need the metric in the configuration dynamic statement, as the sales volume in the production marketing business datum, consumption sum etc.Click right on Business Entity, the ejection function tabulation, selection is provided with the metric function, then display business attributes of entities tabulation, select the attribute in the attribute list that the metric sign is set, after the sign, the time range of metric being set, is data or of that month data or when annual data etc. on the same day as the data area of sales volume metric correspondence.The time range of metric can self-defined increase setting.
The preview configuration result: after configuration is finished, but the preview configuration result is clicked " preview button ".
Stored configuration form: after the form configuration is finished, preserve configuration.Configuration store is listed " configuration Report List " on form configuration platform right side in Database Systems.Allocation list after if desired the preservation is revised more, and selecting the right side to tabulate can be in " showing in the control panel ".
Claims (6)
1. the generation method of a dynamic-configuration form is characterized in that comprising the steps:
A. dispose the database link of reporting system;
B. select the business division of configuration, the inter-entity incidence relation is set;
C. select the analysis dimension of entity, i.e. attributes of entities;
D. select the metric of entity;
E. preview configuration result;
F. storage configuration form;
G. in reporting system, check report data.
2. the generation method of dynamic-configuration form according to claim 1, it is characterized in that in the steps A database link success after, in platform, list the Business Entity of system, the input server ip address is selected database.
3. the generation method of dynamic-configuration form according to claim 1 is characterized in that entity attribute has a time dimension among the step C.
4. the generation method of dynamic-configuration form according to claim 1 is characterized in that the metric of entity comprises sales volume, consumption sum.
5. the generation method of dynamic-configuration form according to claim 1 is characterized in that database adopts the SQLserver database.
6. the generation method of dynamic-configuration form according to claim 1 is characterized in that method adopts the DotNet development platform.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009102561226A CN102117296A (en) | 2009-12-31 | 2009-12-31 | Method for generating dynamic configuration report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009102561226A CN102117296A (en) | 2009-12-31 | 2009-12-31 | Method for generating dynamic configuration report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102117296A true CN102117296A (en) | 2011-07-06 |
Family
ID=44216070
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009102561226A Pending CN102117296A (en) | 2009-12-31 | 2009-12-31 | Method for generating dynamic configuration report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102117296A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104991964A (en) * | 2015-07-23 | 2015-10-21 | 苏州国云数据科技有限公司 | Year-to-year rate and month-to-month rate calculation method based on time dimension |
| CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
| CN105843821A (en) * | 2015-01-16 | 2016-08-10 | 腾讯科技（深圳）有限公司 | Data processing method and system capable of configuring reports |
| CN109190908A (en) * | 2018-08-06 | 2019-01-11 | 成都四方伟业软件股份有限公司 | A kind of Snapshot Method applied to Intellectual analysis tool |
| CN109684387A (en) * | 2018-12-24 | 2019-04-26 | 成都四方伟业软件股份有限公司 | Report generation method and device |
| CN109800401A (en) * | 2018-12-25 | 2019-05-24 | 北京数知科技股份有限公司 | Information report automatic generation method and device |
-
2009
- 2009-12-31 CN CN2009102561226A patent/CN102117296A/en active Pending
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
| CN105843821A (en) * | 2015-01-16 | 2016-08-10 | 腾讯科技（深圳）有限公司 | Data processing method and system capable of configuring reports |
| CN105843821B (en) * | 2015-01-16 | 2019-09-06 | 腾讯科技（深圳）有限公司 | A kind of data processing method and system of configurable report |
| CN104991964A (en) * | 2015-07-23 | 2015-10-21 | 苏州国云数据科技有限公司 | Year-to-year rate and month-to-month rate calculation method based on time dimension |
| CN104991964B (en) * | 2015-07-23 | 2018-01-26 | 苏州国云数据科技有限公司 | Year-on-year ring based on time dimension compares computational methods |
| CN109190908A (en) * | 2018-08-06 | 2019-01-11 | 成都四方伟业软件股份有限公司 | A kind of Snapshot Method applied to Intellectual analysis tool |
| CN109684387A (en) * | 2018-12-24 | 2019-04-26 | 成都四方伟业软件股份有限公司 | Report generation method and device |
| CN109800401A (en) * | 2018-12-25 | 2019-05-24 | 北京数知科技股份有限公司 | Information report automatic generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7818662B2 (en) | Integrating line-of-business application data with documents | |
| US6647390B2 (en) | System and methods for standardizing data for design review comparisons | |
| US7617117B2 (en) | Using a complexity matrix for estimation | |
| US8401993B2 (en) | Analytics integration server within a comprehensive framework for composing and executing analytics applications in business level languages | |
| US20170255608A1 (en) | Dynamic disaggregation and aggregation of spreadsheet data | |
| Humphries | Data warehousing: architecture and implementation | |
| CN102117296A (en) | Method for generating dynamic configuration report | |
| US20100211895A1 (en) | Method for visualization and integration of business intelligence data | |
| US9953331B2 (en) | Extensibility for sales predictor (SPE) | |
| US20140310034A1 (en) | Performance indicator analytical framework | |
| US20100262443A1 (en) | Systems and methods associated with a collaborative strategy editor | |
| US8458178B2 (en) | Dimensional data explorer | |
| US6442554B1 (en) | System and method for generating dependent data | |
| US8707262B2 (en) | Code scoring | |
| US20050234886A1 (en) | Report designer tool and method | |
| CA2546520A1 (en) | Adaptive analytics system and method of using same | |
| US8260822B1 (en) | Systems and methods for storing and querying slowly changing dimensions | |
| Rickards et al. | DATA GOVERNANCE CHALLENGES FACING CONTROLLERS. | |
| AU2008101325A4 (en) | Methods and apparatus for exposing workflow process definitions as business objects | |
| TWI794720B (en) | Performance management analyzing system and method thereof | |
| US9058345B2 (en) | System and method of generating reusable distance measures for data processing | |
| CN101685514A (en) | Method and system for preventing read-only data of form from being falsified | |
| CN111126015B (en) | Report form compiling method and equipment | |
| Birgi et al. | Data Model: A Blueprint for Data Warehouse | |
| US20220100953A1 (en) | System and method for autoproducing a form |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20110706 |