CN103034905A - Method for analyzing report intelligently - Google Patents
Method for analyzing report intelligently Download PDFInfo
- Publication number
- CN103034905A CN103034905A CN2011102914511A CN201110291451A CN103034905A CN 103034905 A CN103034905 A CN 103034905A CN 2011102914511 A CN2011102914511 A CN 2011102914511A CN 201110291451 A CN201110291451 A CN 201110291451A CN 103034905 A CN103034905 A CN 103034905A
- Authority
- CN
- China
- Prior art keywords
- databases
- selection formula
- calculation
- selection
- analyzing
- 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
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method for analyzing a report intelligently. The method is low in cost, high in efficiency and multifunctional. The method comprises steps of (1), establishing dynamic link with various databases through data source interfaces and completing the analyzing of a figure selection formula during calculation; (2), directly linking the figure selection formula and databases and providing relative data in accordance with a screening condition; (3) defining the figure selection formula through a middle sheet and storing calculation results; and (4), sending the calculation results of the middle sheet to an appointed file. By the aid of the method, large databases such as Structured Query Language (SQL) Server and Oracle and Excel are integrated to a network business data collaborative environment, an analytical system facing to end users is constructed, and a group of reports can conduct rapid figure selection, multi-level judgment operation and complex analytical calculation for a plurality of types of databases at the same time through custom formulas.
Description
Technical field
The present invention relates to a kind of analytical approach, especially a kind of form intelligent analysis method.
Background technology
At society, the enterprise of all kinds of community services is provided, no matter be telecommunications, bank or various government utility, all need to rely on the support of powerful information management system, finish the whole process that service is provided.Various statistics, analytical statement need to generate integrative analysis report by peek, all there is following problem in comparatively ripe analytical approach at present: cost is high, dirigibility is low, compatibility is low, chart is single, the limitation such as difficulty are used in not strong, the initial study of extension of network, so that the method can't be popularized.
Summary of the invention
The invention provides a kind of form intelligent analysis method of realizing that cost is low, efficient is high, function is many.
Realize the form intelligent analysis method of the object of the invention, comprise the steps:
(1) dynamically is connected with various Databases by data resource interface, and finishes when calculating parsing to figure selection formula;
(2) with figure selection formula and database direct correlation, extract relevant data according to screening conditions;
(3) define figure selection formula and preserve result of calculation by middle table;
(4) result of calculation of middle table is sent to the file of appointment.
The beneficial effect of form intelligent analysis method of the present invention is as follows:
1, the large databases such as Excel and SQL Server, Oracle is integrated into a Network data collaborative environment, makes up the analytic system towards the final user.
2, by self-defined computing formula, realize one group of form simultaneously corresponding multiple types of data storehouse rapid access, multistage judgement computing and complicated analytical calculation.
As long as 3, managerial personnel use EXECL, need not write line code, just can design the miscellaneous service form according to the management intention of oneself, really realized the target of " Continuous optimization, change on demand ".
Description of drawings
Fig. 1 is the process flow diagram of form intelligent analysis method of the present invention.
Embodiment
As shown in Figure 1, form intelligent analysis method of the present invention comprises the steps:
(1) dynamically is connected with various Databases by data resource interface, and finishes when calculating parsing to figure selection formula;
(2) with figure selection formula and database direct correlation, extract relevant data according to screening conditions;
(3) define figure selection formula and preserve result of calculation by middle table;
(4) result of calculation of middle table is sent to the file of appointment.
Form intelligent analysis method of the present invention is conceived to daily service application, and they are divided into independent business function and flow process, i.e. so-called " service ".Figuratively speaking, these " services " just as the building blocks in the high toy of pleasure not of uniform size, the flexible combination between them can adapt to different service management needs.This will become the new model of business event information system management, thereby greatly promote the professional agility of the every profession and trades such as telecommunications, bank, retail, government, bring people faster easily community service response.This patent connects various dissimilar data sources simultaneously with unified figure selection formula, so that the cost that builds up an information system reduces greatly, efficient improves greatly, and the reusability of function is large.
Embodiment recited above is described preferred implementation of the present invention; be not that scope of the present invention is limited; design under the spiritual prerequisite not breaking away from the present invention; various distortion and improvement that the common engineering technical personnel in this area make technical solution of the present invention all should fall in the definite protection domain of claims of the present invention.
Claims (1)
1. a form intelligent analysis method comprises the steps:
(1) dynamically is connected with various Databases by data resource interface, and finishes when calculating parsing to figure selection formula;
(2) with figure selection formula and database direct correlation, extract relevant data according to screening conditions;
(3) define figure selection formula and preserve result of calculation by middle table;
(4) result of calculation of middle table is sent to the file of appointment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011102914511A CN103034905A (en) | 2011-09-30 | 2011-09-30 | Method for analyzing report intelligently |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011102914511A CN103034905A (en) | 2011-09-30 | 2011-09-30 | Method for analyzing report intelligently |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103034905A true CN103034905A (en) | 2013-04-10 |
Family
ID=48021781
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011102914511A Pending CN103034905A (en) | 2011-09-30 | 2011-09-30 | Method for analyzing report intelligently |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103034905A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN104317820A (en) * | 2014-09-28 | 2015-01-28 | 网神信息技术（北京）股份有限公司 | Statistical method and device of report |
| CN108197093A (en) * | 2017-12-28 | 2018-06-22 | 重庆南华中天信息技术有限公司 | Across language across the unlimited data source of frame Visual Report Forms design method and system |
| CN110888774A (en) * | 2019-11-07 | 2020-03-17 | 中盈优创资讯科技有限公司 | Big data report processing method and device based on HBASE |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1438591A (en) * | 2002-02-10 | 2003-08-27 | 华为技术有限公司 | Method for realizing intelligent report forms |
| CN101556579A (en) * | 2009-05-08 | 2009-10-14 | 用友软件股份有限公司 | Formula processing system used for dynamic report areas and method thereof |
| CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
-
2011
- 2011-09-30 CN CN2011102914511A patent/CN103034905A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1438591A (en) * | 2002-02-10 | 2003-08-27 | 华为技术有限公司 | Method for realizing intelligent report forms |
| CN101556579A (en) * | 2009-05-08 | 2009-10-14 | 用友软件股份有限公司 | Formula processing system used for dynamic report areas and method thereof |
| CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
Non-Patent Citations (3)
| Title |
|---|
| 方智慧: "《跟我学财会电算化软件》", 30 April 1998 * |
| 杨桦: "《会计电算化》", 30 September 2009 * |
| 王全录 等: "《财务软件应用》", 28 February 2009 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN104317820A (en) * | 2014-09-28 | 2015-01-28 | 网神信息技术（北京）股份有限公司 | Statistical method and device of report |
| CN108197093A (en) * | 2017-12-28 | 2018-06-22 | 重庆南华中天信息技术有限公司 | Across language across the unlimited data source of frame Visual Report Forms design method and system |
| CN110888774A (en) * | 2019-11-07 | 2020-03-17 | 中盈优创资讯科技有限公司 | Big data report processing method and device based on HBASE |
| CN110888774B (en) * | 2019-11-07 | 2023-06-23 | 中盈优创资讯科技有限公司 | HBASE-based big data report processing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108681590A (en) | Incremental data processing method and processing device, computer equipment, computer storage media | |
| WO2010030392A3 (en) | Interpersonal spacetime interaction system | |
| CN101714157A (en) | Method, device and heterogeneous database system for generating heterogeneous database report | |
| CN106066895B (en) | Intelligent query system | |
| CN107247811B (en) | SQL statement performance optimization method and device based on Oracle database | |
| CN104111996A (en) | Health insurance outpatient clinic big data extraction system and method based on hadoop platform | |
| TW200506670A (en) | A system and method for dynamic controlling attendance of employees | |
| CN107273369B (en) | Table data modification method and device | |
| CN101710320A (en) | Statistical index data processing method and device | |
| CN103034905A (en) | Method for analyzing report intelligently | |
| CN108540577B (en) | Multi-block chain cross composite application system of intelligent supply chain Internet of things management platform | |
| CN102880709A (en) | Data warehouse management system and data warehouse management method | |
| CN104899295A (en) | Heterogeneous data source data association analysis method | |
| CN102789487A (en) | Data query and retrieval processing device and data query and retrieval processing method | |
| WO2005074590A3 (en) | System and method for automatically updating business information reports | |
| MXPA02008319A (en) | Method for workflow processing through computer network. | |
| CN110413708A (en) | A kind of data analysis system of service-oriented term | |
| CN105847043A (en) | Mobile user internet surfing diagnosis method | |
| CN109213776A (en) | A kind of report form showing method and device | |
| CN101576922A (en) | Access system and access method | |
| CN102043758A (en) | Method and device for automatically counting numerical values | |
| CN103020280B (en) | A kind of method SQL query statement expanded by various dimensions KPI function | |
| CN103473305A (en) | Method and system for performing decision-making process show in statistic analysis | |
| CN107480186B (en) | Business model data processing method and computer equipment | |
| CN106228335A (en) | Hrms |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130410 |
|
| RJ01 | Rejection of invention patent application after publication |