CN105808228A - Generation method of dynamic configuration statement - Google Patents
Generation method of dynamic configuration statement Download PDFInfo
- Publication number
- CN105808228A CN105808228A CN201410855300.8A CN201410855300A CN105808228A CN 105808228 A CN105808228 A CN 105808228A CN 201410855300 A CN201410855300 A CN 201410855300A CN 105808228 A CN105808228 A CN 105808228A
- Authority
- CN
- China
- Prior art keywords
- statement
- generation method
- configuration
- selecting
- report
- 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 generation method of a dynamic configuration statement. The generation method comprises the following steps: 1) selecting the type of the statement in a statement system; 2) configuring the database link of the statement system; 3) selecting a configured business main body, and setting an incidence relation between the main bodies; 4) selecting the analysis dimension of the main body, i.e., the attribute of the main body; 5) selecting the metric of the main body; 6) configuring the form of the selected statement; 7) selecting the configured business main body; 8) previewing a configuration result; 9) revising the statement; 10) storing the configured statement; and 11) checking the statement data in the statement system. The generation method of the dynamic configuration statement causes users to conveniently and quickly manufacture and generate various business statements, statement manufacture difficulty is lowered, and working efficiency is improved.
Description
Technical field
The present invention relates to a kind of data processing technique, particularly relate to a kind of generation method of dynamic configuration report.
Background technology
Form is a part indispensable in enterprise application software system, automatically or assists generation miscellaneous service form by computer, it is possible to achieve the standardized management of business, greatly improves work efficiency, accelerate every profession and trade IT application process.
The technology of existing generation form can be divided three classes: the first kind is the mode adopting hard coded, is usually and is write code realization by project personnel.Equations of The Second Kind report generation scheme is to adopt all kinds of softwares such as Static Electro sublist, such as Eecel form.3rd class report generation scheme is to adopt general report-building tool, for solving the generation of dynamic statement.
There is a lot of problem in report generation technology of the prior art, conventional tool depends directly on the database schema of bottom when arranging report data, it is necessary to the mode of manual coding statement or tables of data auxiliary view formulates data from data base.Add the difficulty of report making, it is necessary to special data base administrator participates in.Secondly, part industry is comparatively special to statement form requirement, it is necessary to when generating form, the feature according to data dynamically generates different statement forms.
Summary of the invention
The technique effect of the present invention can overcome drawbacks described above, it is provided that a kind of generation method of dynamic configuration report, and it is applied to enterprise-class computers application software form development system.
For achieving the above object, the present invention adopts the following technical scheme that and comprises the steps: 1) in reporting system, select the type of form；2) database link of reporting system is configured；3) business division of option and installment, arranges inter-entity incidence relation；4) the analysis dimension of entity, i.e. entity attributes are selected；5) metric of entity is selected；6) configuration selected report tableau format；7) business division of option and installment；8) preview configuration result；9) amendment form；10) configuration form is stored；11) in reporting system, report data is checked.
Preferably, data base adopts SQLserver data base.
Preferably, method adopts DotNet development platform.
Adopt the generation method of dynamic configuration report of the present invention so that user fast and easy can make and generate miscellaneous service form, reduces the difficulty of report making, improves work efficiency.
Detailed description of the invention
This dynamic configuration report generates method and comprises the steps:: 1) select the type of form in reporting system；2) database link of reporting system is configured；3) business division of option and installment, arranges inter-entity incidence relation；4) the analysis dimension of entity, i.e. entity attributes are selected；5) metric of entity is selected；6) configuration selected report tableau format；7) business division of option and installment；8) preview configuration result；9) amendment form；10) configuration form is stored；11) in reporting system, report data is checked.Data base adopts SQLserver data base, and method adopts DotNet development platform.
SQL is the abbreviation of English StructuredQueryLanguage, looks like for SQL.The major function of SQL language contacts with various Databases exactly, links up.According to the regulation of ANSI (ANSI), SQL is taken as the standard language of Relational DBMS.SQL statement can be used to perform various operation, for instance the more data in new database, extracts data etc. from data base.At present, most popular Relational DBMSs, SQL language standard is all have employed such as Oracle, Sybase, MicrosoftSQLServer, Access etc..
First select the type of form, be generally divided into list type, summary formula, matrix form and drill through formula, then configuring the database link of reporting system, after link, inputting various information, link the list of business entities of the data base showing correspondence after successfully.The Business Entity of option and installment, inter-entity incidence relation is set, selects the analysis latitude of entity, select the metric of entity, preview configuration result: after having configured, can preview configuration result, click " preview button ", storage configuration form: after form has configured, preserve configuration.Configuration storage, in Database Systems, lists " configuration Report List " on the right side of form configuration platform.If needing the allocation list amendment after preserve, selection right side list can in " showing in control panel " more.
Claims (3)
1. the generation method of a dynamic configuration report, it is characterised in that comprise the steps: 1) in reporting system, select the type of form；2) database link of reporting system is configured；3) business division of option and installment, arranges inter-entity incidence relation；4) the analysis dimension of entity, i.e. entity attributes are selected；5) metric of entity is selected；6) configuration selected report tableau format；7) business division of option and installment；8) preview configuration result；9) amendment form；10) configuration form is stored；11) in reporting system, report data is checked.
2. the generation method of dynamic configuration report according to claim 1, it is characterised in that data base adopts SQLserver data base.
3. the generation method of dynamic configuration report according to claim 1, it is characterised in that method adopts DotNet development platform.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410855300.8A CN105808228A (en) | 2014-12-31 | 2014-12-31 | Generation method of dynamic configuration statement |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410855300.8A CN105808228A (en) | 2014-12-31 | 2014-12-31 | Generation method of dynamic configuration statement |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105808228A true CN105808228A (en) | 2016-07-27 |
Family
ID=56464922
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410855300.8A Pending CN105808228A (en) | 2014-12-31 | 2014-12-31 | Generation method of dynamic configuration statement |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105808228A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106293740A (en) * | 2016-08-10 | 2017-01-04 | 桐乡华锐自控技术装备有限公司 | A kind of report form developing method being applied to PLC, DCS device data |
| CN108415917A (en) * | 2017-03-13 | 2018-08-17 | 平安科技（深圳）有限公司 | A kind of generation method of Visual Report Forms and the generating means of Visual Report Forms |
| CN109684387A (en) * | 2018-12-24 | 2019-04-26 | 成都四方伟业软件股份有限公司 | Report generation method and device |
| CN111949649A (en) * | 2019-05-14 | 2020-11-17 | 杭州海康威视数字技术股份有限公司 | Dynamic body storage system, storage method and data query method |
| CN112949269A (en) * | 2021-04-06 | 2021-06-11 | 携程旅游信息技术（上海）有限公司 | Method, system, equipment and storage medium for generating visual data analysis report |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101308490A (en) * | 2008-04-28 | 2008-11-19 | 北京航空航天大学 | Dynamic report generation method and platform |
| CN102117296A (en) * | 2009-12-31 | 2011-07-06 | 青岛海尔软件有限公司 | Method for generating dynamic configuration report |
| CN102156741A (en) * | 2011-04-16 | 2011-08-17 | 武钢集团昆明钢铁股份有限公司 | Custom dynamic report system and implementation method thereof |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
-
2014
- 2014-12-31 CN CN201410855300.8A patent/CN105808228A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101308490A (en) * | 2008-04-28 | 2008-11-19 | 北京航空航天大学 | Dynamic report generation method and platform |
| CN102117296A (en) * | 2009-12-31 | 2011-07-06 | 青岛海尔软件有限公司 | Method for generating dynamic configuration report |
| CN102156741A (en) * | 2011-04-16 | 2011-08-17 | 武钢集团昆明钢铁股份有限公司 | Custom dynamic report system and implementation method thereof |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106293740A (en) * | 2016-08-10 | 2017-01-04 | 桐乡华锐自控技术装备有限公司 | A kind of report form developing method being applied to PLC, DCS device data |
| CN108415917A (en) * | 2017-03-13 | 2018-08-17 | 平安科技（深圳）有限公司 | A kind of generation method of Visual Report Forms and the generating means of Visual Report Forms |
| CN108415917B (en) * | 2017-03-13 | 2021-01-15 | 平安科技（深圳）有限公司 | Visual report generation method and visual report generation device |
| CN109684387A (en) * | 2018-12-24 | 2019-04-26 | 成都四方伟业软件股份有限公司 | Report generation method and device |
| CN111949649A (en) * | 2019-05-14 | 2020-11-17 | 杭州海康威视数字技术股份有限公司 | Dynamic body storage system, storage method and data query method |
| CN112949269A (en) * | 2021-04-06 | 2021-06-11 | 携程旅游信息技术（上海）有限公司 | Method, system, equipment and storage medium for generating visual data analysis report |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20220035815A1 (en) | Processing database queries using format conversion | |
| CN105808228A (en) | Generation method of dynamic configuration statement | |
| US8589450B2 (en) | Mapping non-relational database objects into a relational database model | |
| US7849050B2 (en) | Apparatus and method for analyzing impact and lineage of multiple source data objects | |
| US20140115012A1 (en) | Data model optimization using multi-level entity dependencies | |
| CN105808538A (en) | Method and device for generating mobile report form | |
| CN101727320A (en) | Method and tools for identifying impact of database changes on an application | |
| CN102270225A (en) | Data change log monitoring method and device | |
| CN111367893A (en) | Method and device for database version iteration | |
| US20180357278A1 (en) | Processing aggregate queries in a graph database | |
| RU2406115C2 (en) | Accessing complex data | |
| CN106980617B (en) | Method and system for operating database based on JSON statement | |
| US8527552B2 (en) | Database consistent sample data extraction | |
| CN108460092B (en) | Automatic generation method and system for sql query statement containing database built-in function | |
| US20080183747A1 (en) | Apparatus and method for analyzing relationships between multiple source data objects | |
| Lodhi et al. | Design of a simple and effective object-to-relational mapping technique | |
| CN102779092B (en) | Quote check system and quote inspection method | |
| Rybola et al. | Transformation of Binary Relationships with Particular Multiplicity. | |
| CN116303478B (en) | Relational database Schema management system and method | |
| US8386497B2 (en) | Query generation based on hierarchical filters | |
| Stumptner et al. | BIAccelerator–a template-based approach for rapid ETL development | |
| Al-Jumaily et al. | OCL2Trigger: Deriving active mechanisms for relational databases using model-driven architecture | |
| CN107943926A (en) | The attribute increase method, apparatus and medium of a kind of tables of data | |
| Mancas | On the paramount importance of database constraints | |
| Kaenchaliao et al. | Impact Analysis on Database Instance from Functional Requirements’ Input Changes |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160727 |
|
| WD01 | Invention patent application deemed withdrawn after publication |