CN102866985B - For data formatter and the method for on-line analysing processing system - Google Patents
For data formatter and the method for on-line analysing processing system Download PDFInfo
- Publication number
- CN102866985B CN102866985B CN201210371513.4A CN201210371513A CN102866985B CN 102866985 B CN102866985 B CN 102866985B CN 201210371513 A CN201210371513 A CN 201210371513A CN 102866985 B CN102866985 B CN 102866985B
- Authority
- CN
- China
- Prior art keywords
- data
- format
- result data
- mode
- format mode
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 63
- 238000012545 processing Methods 0.000 title claims abstract description 36
- 230000008569 process Effects 0.000 claims abstract description 33
- 238000012546 transfer Methods 0.000 claims abstract description 4
- 238000010586 diagram Methods 0.000 description 10
- 238000004458 analytical method Methods 0.000 description 3
- 238000007405 data analysis Methods 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012731 temporal analysis Methods 0.000 description 1
- 238000000700 time series analysis Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Landscapes
- Information Transfer Between Computers (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention provides a kind of data formatter for on-line analysing processing system, comprising: format arranges module, the different pieces of information in tables of data arranges corresponding format mode; Data acquisition module, according to the request of client, obtains the result data that described request is corresponding from described tables of data; Format processing module, according to the format mode of described result data, carries out format process to described result data; Data transfer module, passes to described client by the described result data after format process.Correspondingly, the present invention also provides a kind of providing data formatting method for on-line analysing processing system.Application the technical program, user can format achievement data according to self-defining format mode, and the result data after format, is illustrated in form.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of data formatter for on-line analysing processing system and a kind of providing data formatting method for on-line analysing processing system.
Background technology
To the custom formatting display mode of report data, be a requisite step in business analysis, but a lot of 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, the expression formula of request is delivered in on-line analysing processing system by client 102, is resolved by expression interpreter 104, and Calculators for Mathematic Expression 106 calculates, and then carries out format 108 by client to data, and shows in client.Carry out when this disposal route is placed on client display the operation of providing data formatting, not there is dirigibility.
Therefore, need a kind of new technical scheme, before client display data, just can format achievement data according to custom formatting mode, and the data after format can represent in form, thus improve the data analysis dirigibility of enterprise.
Summary of the invention
Technical matters to be solved by this invention is, a kind of new technical scheme is provided, before client display data, just can format achievement data according to custom formatting mode, and the data after format can represent in form, thus improve the data analysis dirigibility of enterprise.
In view of this, the invention provides a kind of data formatter for on-line analysing processing system, comprising: format arranges module, the different pieces of information in tables of data arranges corresponding format mode; Data acquisition module, according to the request of client, obtains the result data that described request is corresponding from described tables of data; Format processing module, according to the format mode of described result data, carries out format process to described result data; Data transfer module, passes to described client by the described result data after format process.Application the technical program, just can format achievement data according to self-defining format mode at server end, and the result data after format is outputted to client, is illustrated in form.
In technique scheme, preferably, described format arranges module and arrange formatting property field in described tables of data, is recorded the format mode of described different pieces of information by described formatting property field; Described format processing module also from described formatting property field, reads the format mode of described result data.Application the technical program, the format mode of result data, can carry out record by formatting property field, the formatting property field that the format mode of different pieces of information is corresponding different, thus can just determine reading format mode at server end, and complete format.
In technique scheme, preferably, also comprise: user operation module, receive the format mode of the described different pieces of information of correspondence of user's input, module is set by described format and is recorded in described formatting property field.Application the technical program, the format mode of the corresponding different pieces of information of user's input, can be recorded into different formatting property fields, thus supports that user uses self-defining format mode, formats achievement data at server end.
In technique scheme, preferably, also comprise: data update module, the described result data after using form process upgrades described tables of data.Application the technical program, can be format final displayed value, also can be by the actual value in format mode Update Table table unit.
In technique scheme, preferably, when the format mode of described result data comprises multiple, described format processing module represents region according to described result data in described client, select a kind of from multiple described format mode, and described format mode selectively carry out format process to described data.Application the technical program, when result data has multiple format mode, system can represent region according to client, selects most suitable format mode, thus user friendlyly checks.
Present invention also offers 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 arranges corresponding format mode; Step 304, according to the request of client, obtains the result data that described request is corresponding from described tables of data; Step 306, according to the format mode of described result data, carries out format process to described result data; Step 308, passes to described client by the described result data after format process.Application the technical program, just can format achievement data according to self-defining format mode at server end, and the result data after format is outputted to client, is illustrated in form.
In technique scheme, preferably, described step 302 comprises: in described tables of data, arrange formatting property field, is recorded the format mode of described different pieces of information by described formatting property field; Before described step 306, also comprise: from described formatting property field, read the format mode of described result data.Application the technical program, the format mode of result data, can carry out record by formatting property field, the formatting property field that the format mode of different pieces of information is corresponding different, thus can just determine reading format mode at server end, and complete format.
In technique scheme, preferably, described step 302 also comprises: the format mode receiving the described different pieces of information of correspondence of user's input, and is recorded in described formatting property field.Application the technical program, the format mode of the corresponding different pieces of information of user's input, can be recorded into different formatting property fields, thus supports that user uses self-defining format mode, formats achievement data at server end.
In technique scheme, preferably, also comprise: the described result data after using form process upgrades described tables of data.Application the technical program, can be format final displayed value, also can be by the actual value in format mode Update Table table unit.
In technique scheme, preferably, described step 306 comprises: when the format mode of described result data comprises multiple, in described client, region is represented according to described result data, select a kind of from multiple described format mode, and described format mode selectively carry out format process to described data.Application the technical program, when result data has multiple format mode, system can represent region according to client, selects most suitable format mode, user friendlyly checks.
Accompanying drawing explanation
Fig. 1 shows the process flow diagram of traditional report data format;
Fig. 2 shows according to an embodiment of the invention for the block diagram of the data formatter of on-line analysing processing system;
Fig. 3 shows according to an embodiment of the invention for the process flow diagram of the providing data formatting method of on-line analysing processing system;
Fig. 4 shows the process flow diagram of providing data formatting according to an embodiment of the invention;
Fig. 5 shows the block diagram of providing data formatting type according to an embodiment of the invention;
Fig. 6 shows program interface sectional drawing according to an embodiment of the invention;
Fig. 7 shows program interface sectional drawing according to an embodiment of the invention.
Embodiment
In order to more clearly 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 a lot of detail in the following description so that fully understand the present invention, but 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 according to an embodiment of the invention for the block diagram of the data formatter of on-line analysing processing system.
As shown in Figure 2, the data formatter 200 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 the result data that described request is corresponding from described tables of data; Format processing module 206, according to the format mode of described result data, carries out format process to described result data; Data transfer module 208, passes to described client by the described result data after format process.Application the technical program, just can format achievement data according to self-defining format mode at server end, and the result data after format is outputted to client, is illustrated in form.
In technique scheme, preferably, described format arranges module 202 and arrange formatting property field in described tables of data, is recorded the format mode of described different pieces of information by described formatting property field; Described format processing module 206 also from described formatting property field, reads the format mode of described result data.Application the technical program, the format mode of result data, can carry out record by formatting property field, the formatting property field that the format mode of different pieces of information is corresponding different, thus can just determine reading format mode at server end, and complete format.
In technique scheme, preferably, also comprise: user operation module 210, receive the format mode of the described different pieces of information of correspondence of user's input, module 202 is set by described format and is recorded in described formatting property field.Application the technical program, the format mode of the corresponding different pieces of information of user's input, can be recorded into different formatting property fields, thus supports that user uses self-defining format mode, formats achievement data at server end.
In technique scheme, preferably, also comprise: data update module 212, the described result data after using form process upgrades described tables of data application the technical program, can be format final displayed value, also can be by the actual value in format mode Update Table table unit.
In technique scheme, preferably, when the format mode of described result data comprises multiple, described format processing module 206 represents region according to described result data in described client, select a kind of from multiple described format mode, and described format mode selectively carry out format process to described data.Application the technical program, when result data has multiple format mode, system can represent region according to client, selects most suitable format mode, user friendlyly checks.
Fig. 3 shows according to an embodiment of the invention for the process flow diagram of 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, comprising: step 302, and the different pieces of information in tables of data arranges corresponding format mode; Step 304, according to the request of client, obtains the result data that described request is corresponding from described tables of data; Step 306, according to the format mode of described result data, carries out format process to described result data; Step 308, passes to described client by the described result data after format process.Application the technical program, just can format achievement data according to self-defining format mode at server end, and the result data after format is outputted to client, is illustrated in form.
In technique scheme, preferably, described step 302 comprises: in described tables of data, arrange formatting property field, is recorded the format mode of described different pieces of information by described formatting property field; Before described step 306, also comprise: from described formatting property field, read the format mode of described result data.Application the technical program, the format mode of result data, can carry out record by formatting property field, the formatting property field that the format mode of different pieces of information is corresponding different, thus can just determine reading format mode at server end, and complete format.
In technique scheme, preferably, described step 302 also comprises: the format mode receiving the described different pieces of information of correspondence of user's input, and is recorded in described formatting property field.Application the technical program, the format mode of the corresponding different pieces of information of user's input, can be recorded into different formatting property fields, thus supports that user uses self-defining format mode, formats achievement data at server end.
In technique scheme, preferably, also comprise: the described result data after using form process upgrades described tables of data.Application the technical program, can be format final displayed value, also can be by the actual value in format mode Update Table table unit.
In technique scheme, preferably, described step 306 comprises: when the format mode of described result data comprises multiple, in described client, region is represented according to described result data, select a kind of from multiple described format mode, and described format mode selectively carry out format process to described data.Application the technical program, when result data has multiple format mode, system can represent region according to client, selects most suitable format mode, user friendlyly checks.
Fig. 4 shows the process flow diagram of providing data formatting according to an embodiment of the invention.
As shown in Figure 4, the idiographic flow of the providing data formatting of embodiments of the invention is as follows:
Step 402, the expression formula of request is delivered in on-line analysing processing system by client.
Step 404, carries out expression parsing.Resolved by expression interpreter, the grammer of main verification expression formula, ensures the correctness of wherein member's (comprising dimension member and index) object, and expression parsing is become discernible interrogation model in background analysis system.
Step 406, carries out expression formula calculating.Calculators for Mathematic Expression loads the member in ranks and slice axis according to interrogation model, and ranks member and the rear generation unit model of index intersection, if model of element does not have buffer memory, counter can generate database query object according to interrogation model, obtains the value of this unit.
Step 408, calculated value formats.Cell value formatter carries out format process according to analytical model middle finger target formatting mechanism to the result after calculating, is restored to client display.Wherein, format can be format index displayed value, and actual value is not made an amendment, and also directly can revise actual value, and amended actual value is written back in index unit, and whether write-back can be arranged by system breaker in middle.
Fig. 5 shows the block diagram of providing data formatting type according to an embodiment of the invention.
As shown in Figure 5, the formatting mechanism 500 of achievement data comprises: format string 502, prefabricated format type 504, and extendible custom formatting 506.
Wherein, format string comprises: amount of money type, retains decimal place, adds thousand points of positions etc.Its interfacial effect sectional drawing as shown in Figure 6.
In analytical model designer, three kinds of format modes that embodiments of the invention are prefabricated to be commonly used at present: in units of ten thousand, in units of 1,000,000, in units of hundred million, these three kinds of modes use very general when amount of the fund is very large at present.Its interfacial effect sectional drawing as shown in Figure 7.
In addition, we additionally provide extendible custom formatting mode, and user can need custom formats mode according to oneself, realizes the formatCell method in interface CellFormatter.Code is as follows:
Import parameter into and can be any type, return character string type after format.
More than be described with reference to the accompanying drawings technical scheme of the present invention.By technical scheme of the present invention, providing data formatting display can be carried out to the index of Controlled Analytical Systems, thus meet enterprise when carrying out multi-angular analysis on-line analytical processing, the flexible and changeable display achievement data of formatting method can be passed through.Arrange simple, be convenient to enterprise more convenient and analyze intuitively and show data, improve holistic approach performance and the dirigibility of enterprise.When needing time dimension to be carried out to the operations such as filtration, can, according to the dynamic formation component model of Report layouts, be that time series analysis becomes more simple, intuitively, easy-to-use.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, 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 amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (8)
1. for a data formatter for on-line analysing processing system, it 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 the result data that described request is corresponding from described tables of data;
Format processing module, according to the format mode of described result data, carries out format process to described result data;
Data transfer module, passes to described client by the described result data after format process;
Wherein, when the format mode of described result data comprises multiple, described format processing module represents region according to described result data in described client, select a kind of from multiple described format mode, and described format mode selectively carry out format process to described data.
2. the data formatter for on-line analysing processing system according to claim 1, it is characterized in that, described format arranges module and arrange formatting property field in described tables of data, is recorded the format mode of described different pieces of information by described formatting property field;
Described format processing module also from described formatting property field, reads the format mode of described result data.
3. the data formatter for on-line analysing processing system according to claim 2, is characterized in that, also comprise:
User operation module, receives the format mode of the described different pieces of information of correspondence of user's input, arranges module be recorded in described formatting property field by described format.
4. the data formatter for on-line analysing processing system according to claim 1, is characterized in that, also comprise:
Data update module, the described result data after using form process upgrades described tables of data.
5., for a providing data formatting method for on-line analysing processing system, it is characterized in that, comprising:
Step 302, the different pieces of information in tables of data arranges corresponding format mode;
Step 304, according to the request of client, obtains the result data that described request is corresponding from described tables of data;
Step 306, according to the format mode of described result data, carries out format process to described result data;
Step 308, passes to described client by the described result data after format process;
Wherein, described step 306 comprises:
When the format mode of described result data comprises multiple, in described client, represent region according to described result data, select a kind of from multiple described format mode, and described format mode selectively carries out format to described data processes.
6. the providing data formatting method for on-line analysing processing system according to claim 5, it is characterized in that, described step 302 comprises: in described tables of data, arrange formatting property field, is recorded the format mode of described different pieces of information by described formatting property field;
Before described step 306, also comprise: from described formatting property field, read the format mode of described result data.
7. the providing data formatting method for on-line analysing processing system according to claim 6, it is characterized in that, described step 302 also comprises:
Receive the format mode of the described different pieces of information of correspondence of user's input, and be recorded in described formatting property field.
8. the providing data formatting method for on-line analysing processing system according to claim 5, is characterized in that, also comprise:
Described result data after using form process upgrades described tables of data.
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 CN102866985A (en) | 2013-01-09 |
| CN102866985B true 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) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9853714B2 (en) * | 2013-10-11 | 2017-12-26 | Ge Aviation Systems Llc | Data communications network for an aircraft |
| 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 |
| CN111444251B (en) * | 2020-03-24 | 2023-10-13 | 浪潮通用软件有限公司 | Flexible and efficient dynamic data conversion method |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101158900B (en) * | 2007-11-19 | 2010-09-08 | 北京大学 | A report generation system and method based on template series |
| CN101183371B (en) * | 2007-12-12 | 2010-06-09 | 中兴通讯股份有限公司 | Method for quickly finishing large data-handling and reporting system |
-
2012
- 2012-09-28 CN CN201210371513.4A patent/CN102866985B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102866985A (en) | 2013-01-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Wickham et al. | Reflecting on the strategic use of CAQDAS to manage and report on the qualitative research process | |
| CN103631969B (en) | A kind of generation method and device of report data | |
| CN111813963A (en) | Knowledge graph construction method and device, electronic equipment and storage medium | |
| CN113449187A (en) | Product recommendation method, device and equipment based on double portraits and storage medium | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| CN110765750B (en) | Report data input method and terminal equipment | |
| CN106469140A (en) | A kind of report generating system and its method | |
| CN101859303A (en) | Metadata management method and management system | |
| CN104199938B (en) | Agricultural land method for sending information and system based on RSS | |
| CN102866985B (en) | For data formatter and the method for on-line analysing processing system | |
| CN115408399A (en) | Blood relationship analysis method, device, equipment and storage medium based on SQL script | |
| CN103729713A (en) | Audit result display configuration method and device | |
| US9298686B2 (en) | System and method for simulating discrete financial forecast calculations | |
| CN109710250A (en) | It is a kind of for constructing the visualization engine system and method for user interface | |
| CN108536715B (en) | Preview page generation method, device, equipment and storage medium | |
| CN110414926A (en) | Account management method, device and computer readable storage medium | |
| CN113127574A (en) | Service data display method, system, equipment and medium based on knowledge graph | |
| CN115544183A (en) | Data visualization method and device, computer equipment and storage medium | |
| CN116737708A (en) | Data verification method, device, computer equipment and storage medium | |
| CN113687827B (en) | Data list generation method, device and equipment based on widget and storage medium | |
| CN118445293B (en) | A multi-level data linkage method, device and storage medium in complex business scenarios | |
| CN111553133B (en) | Report generation method and device, electronic equipment and storage medium | |
| CN113687825A (en) | Software module construction method, device, equipment and storage medium | |
| CN107203525A (en) | The treating method and apparatus of database | |
| CN104123138A (en) | Rapid building method for ERP 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 | ||
| 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 |