CN102866985A - Data formatting device and method for on-line analytical processing system - Google Patents
Data formatting device and method for on-line analytical processing system Download PDFInfo
- Publication number
- CN102866985A CN102866985A CN2012103715134A CN201210371513A CN102866985A CN 102866985 A CN102866985 A CN 102866985A CN 2012103715134 A CN2012103715134 A CN 2012103715134A CN 201210371513 A CN201210371513 A CN 201210371513A CN 102866985 A CN102866985 A CN 102866985A
- Authority
- CN
- China
- Prior art keywords
- data
- format
- result data
- mode
- processing system
- 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 Transfer Between Computers (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention provides a data formatting device for an on-line analytical processing system. The device comprises a formatting setting module, a data acquisition module, a formatting processing module and a data transfer module, wherein the formatting setting module sets corresponding formatting modes for different data in a data sheet; the data acquisition module acquires result data corresponding to a request of a client from the data sheet according to the request; the formatting processing module performs formatting processing on the result data according to the formatting mode of the result data; and the data transfer module transfers the formatted result data to the client. Correspondingly, the invention also provides a data formatting method for the on-line analytical processing system. By applying the technical scheme, a user can format index data according to a self-defined formatting mode and display the formatted result data in a report sheet.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of data layout gasifying device for on-line analysing processing system and a kind of providing data formatting method for on-line analysing processing system.
Background technology
To report data user-defined format display mode, be a requisite step in the business analysis, but much providing data formatting all need to carry out when report form showing, does not have dirigibility.
Fig. 1 shows the process flow diagram of traditional report data format.
As shown in Figure 1, client 102 is delivered to the expression formula of request in the on-line analysing processing system, is resolved by expression interpreter 104, and Calculators for Mathematic Expression 106 is calculated, and then by client data is formatd 108, and shows in client.This disposal route is placed on the operation of providing data formatting carries out when client shows, does not have dirigibility.
Therefore, need a kind of new technical scheme, before client shows data, just can format achievement data according to the user-defined format mode, and the data after the format can represent in form, thus the data analysis dirigibility of raising enterprise.
Summary of the invention
Technical matters to be solved by this invention is, a kind of new technical scheme is provided, before client shows data, just can format achievement data according to the user-defined format mode, and the data after the format can represent in form, thereby improve the data analysis dirigibility of enterprise.
In view of this, the invention provides a kind of data layout gasifying device for on-line analysing processing system, comprising: format arranges module, and the different pieces of information in tables of data arranges corresponding format mode; Data acquisition module according to the request of client, obtains result data corresponding to described request from described tables of data; The format processing module according to the format mode of described result data, formats processing to described result data; Data transfer module passes to described client with the described result data after the format processing.Use the technical program, just can format achievement data according to self-defining format mode at server end, and the result data after the format is outputed to client, be illustrated in the form.
In technique scheme, preferably, described format arranges module the format attribute field is set in described tables of data, records the format mode of described different pieces of information by described format attribute field; Described format processing module also from described format attribute field, reads the format mode of described result data.Use the technical program, the format mode of result data can come record by the format attribute field, the format attribute field that the format mode of different pieces of information is corresponding different, thereby can just determine the reading format mode at server end, and finish format.
In technique scheme, preferably, also comprise: user's operational module, the format mode of the corresponding described different pieces of information of reception user input arranges module records in described format attribute field by described format.Use the technical program, the format mode of the corresponding different pieces of information of user's input can be recorded into different format attribute fields, thereby supports that the user uses self-defining format mode, at server end achievement data is formatd.
In technique scheme, preferably, also comprise: data update module, the described result data after the using form processing upgrades described tables of data.Using the technical program, can be the final displayed value of format, also can be by the actual value in the format mode Update Table table unit.
In technique scheme, preferably, comprise when multiple at the format mode of described result data, described format processing module represents the zone according to described result data on described client, from multiple described format mode, select a kind ofly, and by the described format mode of selecting described data are formatd processing.Use the technical program, when result data had the multiple format mode, only format mode can be selected according to the zone that represents of client by system, thus user friendly checking.
The present invention also provides a kind of providing data formatting method for on-line analysing processing system, comprising: step 302, the different pieces of information in tables of data arrange corresponding format mode; Step 304 according to the request of client, is obtained result data corresponding to described request from described tables of data; Step 306 according to the format mode of described result data, formats processing to described result data; Step 308 passes to described client with the described result data after the format processing.Use the technical program, just can format achievement data according to self-defining format mode at server end, and the result data after the format is outputed to client, be illustrated in the form.
In technique scheme, preferably, described step 302 comprises: the format attribute field is set in described tables of data, records the format mode of described different pieces of information by described format attribute field; Before described step 306, also comprise: from described format attribute field, read the format mode of described result data.Use the technical program, the format mode of result data can come record by the format attribute field, the format attribute field that the format mode of different pieces of information is corresponding different, thereby can just determine the reading format mode at server end, and finish format.
In technique scheme, preferably, described step 302 also comprises: receive the format mode of the corresponding described different pieces of information of user's input, and be recorded in the described format attribute field.Use the technical program, the format mode of the corresponding different pieces of information of user's input can be recorded into different format attribute fields, thereby supports that the user uses self-defining format mode, at server end achievement data is formatd.
In technique scheme, preferably, also comprise: the described result data after the using form processing upgrades described tables of data.Using the technical program, can be the final displayed value of format, also can be by the actual value in the format mode Update Table table unit.
In technique scheme, preferably, described step 306 comprises: comprise when multiple at the format mode of described result data, on described client, represent the zone according to described result data, from multiple described format mode, select a kind ofly, and by the described format mode of selecting described data are formatd processing.Use the technical program, when result data had the multiple format mode, only format mode can according to the zone that represents of client, be selected, user friendly checking by system.
Description of drawings
Fig. 1 shows the process flow diagram of traditional report data format;
Fig. 2 shows the block diagram that is used for according to an embodiment of the invention the data layout gasifying device of on-line analysing processing system;
Fig. 3 shows the process flow diagram that is used for according to an embodiment of the invention the providing data formatting method of on-line analysing processing system;
Fig. 4 shows the according to an embodiment of the invention process flow diagram of providing data formatting;
Fig. 5 shows the according to an embodiment of the invention block diagram of providing data formatting type;
Fig. 6 shows according to an embodiment of the invention program interface sectional drawing;
Fig. 7 shows according to an embodiment of the invention program interface sectional drawing.
Embodiment
In order more clearly to understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments the present invention is further described in detail.
Set forth in the following description a lot of details so that fully understand the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following public specific embodiment.
Fig. 2 shows the block diagram that is used for according to an embodiment of the invention the data layout gasifying device of on-line analysing processing system.
As shown in Figure 2, the data layout gasifying device 200 that is used for on-line analysing processing system of embodiments of the invention comprises: format arranges module 202, and the different pieces of information in tables of data arranges corresponding format mode; Data acquisition module 204 according to the request of client, obtains result data corresponding to described request from described tables of data; Format processing module 206 according to the format mode of described result data, formats processing to described result data; Data transfer module 208 passes to described client with the described result data after the format processing.Use the technical program, just can format achievement data according to self-defining format mode at server end, and the result data after the format is outputed to client, be illustrated in the form.
In technique scheme, preferably, described format arranges module 202 the format attribute field is set in described tables of data, records the format mode of described different pieces of information by described format attribute field; Described format processing module 206 also from described format attribute field, reads the format mode of described result data.Use the technical program, the format mode of result data can come record by the format attribute field, the format attribute field that the format mode of different pieces of information is corresponding different, thereby can just determine the reading format mode at server end, and finish format.
In technique scheme, preferably, also comprise: user's operational module 210, the format mode of the corresponding described different pieces of information of reception user input arranges module 202 by described format and is recorded in the described format attribute field.Use the technical program, the format mode of the corresponding different pieces of information of user's input can be recorded into different format attribute fields, thereby supports that the user uses self-defining format mode, at server end achievement data is formatd.
In technique scheme, preferably, also comprise: data update module 212, the described result data after the using form processing upgrade described tables of data and use the technical program, can be the final displayed value of format, also can be by the actual value in the format mode Update Table table unit.
In technique scheme, preferably, comprise when multiple at the format mode of described result data, described format processing module 206 represents the zone according to described result data on described client, from multiple described format mode, select a kind ofly, and by the described format mode of selecting described data are formatd processing.Use the technical program, when result data had the multiple format mode, only format mode can according to the zone that represents of client, be selected, user friendly checking by system.
Fig. 3 shows the process flow diagram that is used for according to an embodiment of the invention the providing data formatting method of on-line analysing processing system.
As shown in Figure 3, the providing data formatting method for on-line analysing processing system of the present invention comprises: step 302, the different pieces of information in tables of data arrange corresponding format mode; Step 304 according to the request of client, is obtained result data corresponding to described request from described tables of data; Step 306 according to the format mode of described result data, formats processing to described result data; Step 308 passes to described client with the described result data after the format processing.Use the technical program, just can format achievement data according to self-defining format mode at server end, and the result data after the format is outputed to client, be illustrated in the form.
In technique scheme, preferably, described step 302 comprises: the format attribute field is set in described tables of data, records the format mode of described different pieces of information by described format attribute field; Before described step 306, also comprise: from described format attribute field, read the format mode of described result data.Use the technical program, the format mode of result data can come record by the format attribute field, the format attribute field that the format mode of different pieces of information is corresponding different, thereby can just determine the reading format mode at server end, and finish format.
In technique scheme, preferably, described step 302 also comprises: receive the format mode of the corresponding described different pieces of information of user's input, and be recorded in the described format attribute field.Use the technical program, the format mode of the corresponding different pieces of information of user's input can be recorded into different format attribute fields, thereby supports that the user uses self-defining format mode, at server end achievement data is formatd.
In technique scheme, preferably, also comprise: the described result data after the using form processing upgrades described tables of data.Using the technical program, can be the final displayed value of format, also can be by the actual value in the format mode Update Table table unit.
In technique scheme, preferably, described step 306 comprises: comprise when multiple at the format mode of described result data, on described client, represent the zone according to described result data, from multiple described format mode, select a kind ofly, and by the described format mode of selecting described data are formatd processing.Use the technical program, when result data had the multiple format mode, only format mode can according to the zone that represents of client, be selected, user friendly checking by system.
Fig. 4 shows the according to an embodiment of the invention process flow diagram of providing data formatting.
As shown in Figure 4, the idiographic flow of the providing data formatting of embodiments of the invention is as follows:
Step 402, client is delivered to the expression formula of request in the on-line analysing processing system.
Step 404 is carried out expression parsing.Resolved by expression interpreter, the grammer of main verification expression formula guarantees the wherein correctness of member's (comprising dimension member and index) object, and expression parsing is become discernible interrogation model in the analytic system of backstage.
Step 406 is carried out expression formula and is calculated.Calculators for Mathematic Expression is according to the member on interrogation model loading ranks and the slice axis, and ranks member and index intersection be the generation unit model afterwards, if model of element does not have buffer memory, counter can according to interrogation model generating database query object, obtain the value of this unit.
Step 408, the calculated value format.The cell value formatter formats processing according to analytical model middle finger target formatting mechanism to the result after calculating, and is restored to client and shows.Wherein, format can be format index displayed value, and actual value is not made an amendment, and can directly revise actual value yet, and amended actual value is written back in the index unit, and whether write-back can be passed through switch setting in the system.
Fig. 5 shows the according to an embodiment of the invention block diagram of providing data formatting type.
As shown in Figure 5, the formatting mechanism 500 of achievement data comprises: format string 502, prefabricated format type 504, extendible user-defined formatization 506.
Wherein, format string comprises: amount of money type, keep decimal place, and add thousand minutes positions etc.Its interfacial effect sectional drawing as shown in Figure 6.
In the analytical model designer, embodiments of the invention are prefabricated present three kinds of format modes commonly used: take ten thousand as unit, take 1,000,000 as unit, take hundred million as unit, these three kinds of modes are used very general in the very large situation of amount of the fund at present.Its interfacial effect sectional drawing as shown in Figure 7.
In addition, we also provide extendible user-defined format mode, and the user can according to the needs custom formats mode of oneself, realize the formatCell method among the interface CellFormatter.Code is as follows:
Import parameter into and can be any type, return character string type after the format.
More than be described with reference to the accompanying drawings technical scheme of the present invention.By technical scheme of the present invention, can carry out providing data formatting to the index of Controlled Analytical Systems and show, thereby satisfy enterprise when carrying out the multi-angular analysis on-line analytical processing, can pass through the flexible and changeable demonstration achievement data of formatting method.Arrange simply, it is more convenient and analyze intuitively and show data to be convenient to enterprise, has improved holistic approach performance and the dirigibility of enterprise.In the time of need to the operation such as filtering to time dimension, can be according to the dynamic formation component model of Report layouts, it is simpler, directly perceived, easy-to-use to be that time series analysis becomes.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a data layout gasifying device that is used for on-line analysing processing system is characterized in that, comprising:
Format arranges module, and the different pieces of information in tables of data arranges corresponding format mode;
Data acquisition module according to the request of client, obtains result data corresponding to described request from described tables of data;
The format processing module according to the format mode of described result data, formats processing to described result data;
Data transfer module passes to described client with the described result data after the format processing.
2. the data layout gasifying device for on-line analysing processing system according to claim 1, it is characterized in that, described format arranges module the format attribute field is set in described tables of data, records the format mode of described different pieces of information by described format attribute field;
Described format processing module also from described format attribute field, reads the format mode of described result data.
3. the data layout gasifying device for on-line analysing processing system according to claim 2 is characterized in that, also comprises:
User's operational module, the format mode of the corresponding described different pieces of information of reception user input arranges module records in described format attribute field by described format.
4. the data layout gasifying device for on-line analysing processing system according to claim 1 is characterized in that, also comprises:
Data update module, the described result data after the using form processing upgrades described tables of data.
5. each described data layout gasifying device for on-line analysing processing system in 4 according to claim 1, it is characterized in that, comprise when multiple at the format mode of described result data, described format processing module represents the zone according to described result data on described client, from multiple described format mode, select a kind ofly, and by the described format mode of selecting described data are formatd processing.
6. a providing data formatting method that is used for on-line analysing processing system is characterized in that, comprising:
Step 302, the different pieces of information in tables of data arrange corresponding format mode;
Step 304 according to the request of client, is obtained result data corresponding to described request from described tables of data;
Step 306 according to the format mode of described result data, formats processing to described result data;
Step 308 passes to described client with the described result data after the format processing.
7. the providing data formatting method for on-line analysing processing system according to claim 6, it is characterized in that, described step 302 comprises: the format attribute field is set in described tables of data, records the format mode of described different pieces of information by described format attribute field;
Before described step 306, also comprise: from described format attribute field, read the format mode of described result data.
8. the providing data formatting method for on-line analysing processing system according to claim 7 is characterized in that described step 302 also comprises:
Receive the format mode of the corresponding described different pieces of information of user's input, and be recorded in the described format attribute field.
9. the providing data formatting method for on-line analysing processing system according to claim 6 is characterized in that, also comprises:
Described result data after the using form processing upgrades described tables of data.
10. each described providing data formatting method for on-line analysing processing system in 9 according to claim 6 is characterized in that described step 306 comprises:
Comprise when multiple at the format mode of described result data, on described client, represent the zone according to described result data, from multiple described format mode, select a kind ofly, and by the described format mode of selecting described data are formatd processing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210371513.4A CN102866985B (en) | 2012-09-28 | 2012-09-28 | For data formatter and the method for on-line analysing processing system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210371513.4A CN102866985B (en) | 2012-09-28 | 2012-09-28 | For data formatter and the method for on-line analysing processing system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102866985A true CN102866985A (en) | 2013-01-09 |
| CN102866985B CN102866985B (en) | 2016-03-30 |
Family
ID=47445863
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210371513.4A Active CN102866985B (en) | 2012-09-28 | 2012-09-28 | For data formatter and the method for on-line analysing processing system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102866985B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104657091A (en) * | 2013-11-20 | 2015-05-27 | 航天信息股份有限公司 | Method for formatted printing of template data in tax control system |
| CN105794161A (en) * | 2013-10-11 | 2016-07-20 | 通用电气航空系统有限责任公司 | Data communication network for aircraft |
| WO2018053859A1 (en) * | 2016-09-26 | 2018-03-29 | 浙江核新同花顺网络信息股份有限公司 | Report form display system and method |
| CN111444251A (en) * | 2020-03-24 | 2020-07-24 | 山东浪潮通软信息科技有限公司 | Flexible and efficient dynamic data conversion method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101158900A (en) * | 2007-11-19 | 2008-04-09 | 北京大学 | Report generation system and method based on moulding plate series |
| CN101183371A (en) * | 2007-12-12 | 2008-05-21 | 中兴通讯股份有限公司 | Method for quick finishing large data-handling and reporting system |
| CN101236637A (en) * | 2008-02-22 | 2008-08-06 | 金蝶软件（中国）有限公司 | Financial affairs system and processing method simultaneously supporting two kinds of accounting system |
| CN101847152A (en) * | 2010-02-01 | 2010-09-29 | 浪潮集团山东通用软件有限公司 | Statistical analysis method and statistical analysis system for statements of various criterions based on data unit |
-
2012
- 2012-09-28 CN CN201210371513.4A patent/CN102866985B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101158900A (en) * | 2007-11-19 | 2008-04-09 | 北京大学 | Report generation system and method based on moulding plate series |
| CN101183371A (en) * | 2007-12-12 | 2008-05-21 | 中兴通讯股份有限公司 | Method for quick finishing large data-handling and reporting system |
| CN101236637A (en) * | 2008-02-22 | 2008-08-06 | 金蝶软件（中国）有限公司 | Financial affairs system and processing method simultaneously supporting two kinds of accounting system |
| CN101847152A (en) * | 2010-02-01 | 2010-09-29 | 浪潮集团山东通用软件有限公司 | Statistical analysis method and statistical analysis system for statements of various criterions based on data unit |
Non-Patent Citations (1)
| Title |
|---|
| 吴剑新: "物流企业商业智能平台体系结构设计", 《重庆科技学院学报（社会科学版）》, no. 24, 31 December 2010 (2010-12-31), pages 91 - 95 * |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105794161A (en) * | 2013-10-11 | 2016-07-20 | 通用电气航空系统有限责任公司 | Data communication network for aircraft |
| CN105794161B (en) * | 2013-10-11 | 2019-06-11 | 通用电气航空系统有限责任公司 | Data communication network for aircraft |
| CN104657091A (en) * | 2013-11-20 | 2015-05-27 | 航天信息股份有限公司 | Method for formatted printing of template data in tax control system |
| CN104657091B (en) * | 2013-11-20 | 2018-11-13 | 航天信息股份有限公司 | Template data formats Method of printing in a kind of taxation control system |
| WO2018053859A1 (en) * | 2016-09-26 | 2018-03-29 | 浙江核新同花顺网络信息股份有限公司 | Report form display system and method |
| US11481465B2 (en) | 2016-09-26 | 2022-10-25 | Hithink Financial Services Inc. | System and method of presentation of online financial report |
| US11727081B2 (en) | 2016-09-26 | 2023-08-15 | Hithink Financial Services Inc. | System and method of presentation of online financial report |
| US12093338B2 (en) | 2016-09-26 | 2024-09-17 | Hithink Financial Services Inc. | System and method of presentation of online financial report |
| CN111444251A (en) * | 2020-03-24 | 2020-07-24 | 山东浪潮通软信息科技有限公司 | Flexible and efficient dynamic data conversion method |
| CN111444251B (en) * | 2020-03-24 | 2023-10-13 | 浪潮通用软件有限公司 | Flexible and efficient dynamic data conversion method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102866985B (en) | 2016-03-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102754072B (en) | Regulation user interface element | |
| CN101739390B (en) | Data transformation based on a technical design document | |
| CN107886439A (en) | Insurance products development approach, device, equipment and computer-readable recording medium | |
| CN107357593A (en) | Source code file construction method, device, electric terminal and readable storage medium storing program for executing | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN102541867A (en) | Data dictionary generating method and system | |
| CN108694214A (en) | Generation method, generating means, readable medium and the electronic equipment of data sheet | |
| CN105593844A (en) | Database access | |
| CN103729713A (en) | Audit result display configuration method and device | |
| CN114115844A (en) | Page generation method and device, computer equipment and storage medium | |
| CN101714078A (en) | Code generation method and device | |
| CN104750771A (en) | Method and system for contextual data analysis using domain information | |
| Ghosh et al. | Modeling and asynchronous distributed simulation analyzing complex systems | |
| CN106779594A (en) | A kind of Workflow management method based on Activiti | |
| CN108491326A (en) | Behavioral test recombination method, device and storage medium | |
| CN107229392A (en) | A kind of method for showing interface and system | |
| CN109710250A (en) | It is a kind of for constructing the visualization engine system and method for user interface | |
| CN102866985B (en) | For data formatter and the method for on-line analysing processing system | |
| CN115544183A (en) | Data visualization method and device, computer equipment and storage medium | |
| CN109408502A (en) | A kind of data standard processing method, device and its storage medium | |
| CN110211581A (en) | A kind of laboratory automatic speech recognition record identification system and method | |
| CN202711253U (en) | Detecting and early-stage pre-warning system for infectious disease aggregation | |
| CN112464279A (en) | Method and system for realizing form design based on service drive | |
| CN106407172A (en) | XML (Extensible Markup Language)-based report generating method | |
| CN108446262A (en) | A kind of list generates, analysis method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 100094 Haidian District North Road, Beijing, No. 68 Applicant after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant before: UFIDA Software Co., Ltd. |
|
| COR | Change of bibliographic data | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |