CN102799652A - Multidimensional data presentation device and multidimensional data presentation method - Google Patents
Multidimensional data presentation device and multidimensional data presentation method Download PDFInfo
- Publication number
- CN102799652A CN102799652A CN2012102249486A CN201210224948A CN102799652A CN 102799652 A CN102799652 A CN 102799652A CN 2012102249486 A CN2012102249486 A CN 2012102249486A CN 201210224948 A CN201210224948 A CN 201210224948A CN 102799652 A CN102799652 A CN 102799652A
- Authority
- CN
- China
- Prior art keywords
- null
- cell
- data
- data model
- perspective
- 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
Abstract
The invention provides a multidimensional data presentation device, comprising a data model setting module and a blink line processing module, wherein the data model setting module is used for setting a data model for a table cell in a pivot table and storing the number and content of blank lines which are arranged before and/or behind the cell table in the data model, and the blank line processing module is used for inserting the blank lines according to the number of the blank lines before and behind a data line when the data line selected by a user comprises a specific cell table and filling the blank lines according to the content of the blank lines. The invention also provides a multidimensional data presentation method. By adopting the multidimensional data presentation device and the multidimensional data presentation method which are disclosed by the invention, the pivot table can be presented more flexibly, and the customer requirements can be met better.
Description
Technical field
The present invention relates to field of computer technology, in particular to a kind of multidimensional data demonstration device and a kind of multidimensional data exhibiting method.
Background technology
For the ways of presentation of multi-dimensional query results set perspective table, the form relative fixed, most BA manufacturer is fixed as a two-dimension table with Query Result; Such as the perspective table among the Excel of Microsoft; Can carry out unfolded operation to form, but not have more to be directed against the interactive operation of form, but the client needed be not the form of a format specification; Express more contents in the form that they need, to meet its personalized demand.
Therefore, need a kind of new perspective table to represent scheme, can make representing of perspective table more flexible, meet customer need better.
Summary of the invention
Technical matters to be solved by this invention is, a kind of multidimensional data demonstration device is provided, and can make representing of perspective table more flexible, meets customer need better.
In view of this; The invention provides a kind of multidimensional data demonstration device; Comprise: data model is provided with module, and for the cell in the perspective table is provided with data model, and storage is positioned at before the said cell and/or null quantity afterwards and null content in said data model; The null processing module when in the data line that the user chooses, comprising said particular cell, according to said data model, is inserted null by said null quantity, and is filled said null according to said null content before said data line and/or afterwards.In this technical scheme; Through in the perspective table, inserting null and in null, filling required content, representing of perspective table no longer is a fixing table, can in table, insert null arbitrarily; In null, can preserve text; Formula etc., table more flexible alternately can be satisfied user's demand better.
Preferably, said data model is provided with module and also changes at said perspective table, when making the content of said cell move to other cells, said data model is provided with to said other cells.In this technical scheme, keep the corresponding relation of original cell and content constant, can not influence the execution efficient of original perspective table, other that also can not influence the perspective table played up the execution of rule.
Preferably, said null content comprises formula, and said null processing module is according to said formula, and the tables of data value of closing from said perspective epiphase is also calculated, and result of calculation is filled in the said null.In this technical scheme, can be in null charging formula, will show according to the result that formula calculates again, make that the ways of presentation of perspective table is more various, satisfy user's demand better.
Preferably, also store the title of said cell in the said data model, said null processing module inquires the said data model corresponding to said cell according to the title of all cells in the said data line.In this technical scheme, in this technical scheme, the title through cell is the data model of query unit lattice more easily.
Preferably, said particular cell is the cell in first row in the said perspective table.In this technical scheme, the unified cell that adopts in first row is inquired about convenient.
The present invention also provides a kind of multidimensional data exhibiting method, comprising: step 202, and for the cell in the perspective table is provided with data model, and storage is positioned at before the said cell and/or null quantity afterwards and null content in said data model; Step 204 when in the data line that the user chooses, comprising said particular cell, according to said data model, is inserted null by said null quantity, and is filled said null according to said null content before said data line and/or afterwards.In this technical scheme; Through in the perspective table, inserting null and in null, filling required content, representing of perspective table no longer is a fixing table, can in table, insert null arbitrarily; In null, can preserve text; Formula etc., table more flexible alternately can be satisfied user's demand better; And owing to just in the perspective table, insert null, do not do other change, so can not influence the execution efficient of original perspective table, other that also can not influence the perspective table played up regular execution.
Preferably, described multidimensional data exhibiting method also comprises: change at said perspective table, when making the content of said cell move to other cells, said data model is provided with to said other cells.In this technical scheme, keep the corresponding relation of original cell and content constant, can not influence the execution efficient of original perspective table, other that also can not influence the perspective table played up the execution of rule.
Preferably, said null content comprises formula, and said step 204 comprises: according to said formula, the tables of data value of closing from said perspective epiphase is also calculated, and result of calculation is filled in the said null.In this technical scheme, can be in null charging formula, will show according to the result that formula calculates again, make that the ways of presentation of perspective table is more various, satisfy user's demand better.
Preferably, also store the title of said cell in the said data model, said step 204 also comprises: according to the title of all cells in the said data line, inquire the said data model corresponding to said cell.In this technical scheme, the title through cell is the data model of query unit lattice more easily.
Preferably, said particular cell is the cell in first row in the said perspective table.In this technical scheme, the unified cell that adopts in first row is inquired about convenient.
In sum,, in the perspective table, choose certain delegation, can before and after current line, insert null through the present invention.Can add content in null, formula etc., certain member who chooses first in the perspective table to be listed as can insert null in this member's front and back.The null of adding can be carried out operations such as unfolded along with the member.After adding null, can edit the null cell, content can be preserved, such as adding formula at the null place; The perspective table no longer is a table that fixed sturcture is arranged, and can change flexibly as required; Improve the dirigibility of perspective table, satisfied client's individual demand; Through in the perspective table, inserting null and in null, filling required content, representing of perspective table no longer is a fixing table, can in table, insert null arbitrarily; In null, can preserve text; Formula etc., table more flexible alternately can be satisfied user's demand better; And can not influence the execution efficient of original perspective table, other that also can not influence the perspective table played up the execution of rule.
Description of drawings
Fig. 1 is the block diagram according to the multidimensional data demonstration device of the embodiment of the invention;
Fig. 2 is the process flow diagram according to the multidimensional data exhibiting method of the embodiment of the invention;
Fig. 3 is the process flow diagram according to the insertion of the null information stores of the embodiment of the invention and mentioned null cell;
Fig. 4 is the process flow diagram of playing up according to the mentioned null cell information of the embodiment of the invention;
Fig. 5 to Fig. 7 is the design sketch that represents according to the perspective table of the embodiment of the invention.
Embodiment
In order more to be expressly understood above-mentioned purpose of the present invention, feature and advantage, the present invention is further described in detail below in conjunction with accompanying drawing and embodiment.
Set forth a lot of details in the following description so that make much of 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 disclosed specific embodiment.
As shown in Figure 1; The invention provides a kind of multidimensional data demonstration device 100; Comprise: data model is provided with module 102, and for the cell in the perspective table is provided with data model, and storage is positioned at before the cell and/or null quantity afterwards and null content in data model; Null processing module 104 when in the data line that the user chooses, comprising particular cell, according to data model, is inserted null by null quantity, and is filled null according to the null content before data line and/or afterwards.In this technical scheme; Through in the perspective table, inserting null and in null, filling required content, representing of perspective table no longer is a fixing table, can in table, insert null arbitrarily; In null, can preserve text; Formula etc., table more flexible alternately can be satisfied user's demand better.
Preferably, data model is provided with module 102 and also changes at the perspective table, when making the content of cell move to other cells, data model is provided with to other cells.In this technical scheme, keep the corresponding relation of original cell and content constant, can not influence the execution efficient of original perspective table, other that also can not influence the perspective table played up the execution of rule.
Preferably, the null content comprises formula, and null processing module 104 is according to formula, and the tables of data value of closing from the perspective epiphase is also calculated, and result of calculation is filled in the null.In this technical scheme, can be in null charging formula, will show according to the result that formula calculates again, make that the ways of presentation of perspective table is more various, satisfy user's demand better.
Preferably, go back the title of storage unit lattice in the data model, null processing module 104 inquires the data model corresponding to cell according to the title of all cells in the data line.In this technical scheme, in this technical scheme, the title through cell is the data model of query unit lattice more easily.
Preferably, particular cell is the cell in first row in the perspective table.In this technical scheme, the unified cell that adopts in first row is inquired about convenient.
As shown in Figure 2, the present invention also provides a kind of multidimensional data exhibiting method, comprising: step 202, and for the cell in the perspective table is provided with data model, and storage is positioned at before the cell and/or null quantity afterwards and null content in data model; Step 204 when in the data line that the user chooses, comprising particular cell, according to data model, is inserted null by null quantity, and is filled null according to the null content before data line and/or afterwards.In this technical scheme; Through in the perspective table, inserting null and in null, filling required content, representing of perspective table no longer is a fixing table, can in table, insert null arbitrarily; In null, can preserve text; Formula etc., table more flexible alternately can be satisfied user's demand better; And owing to just in the perspective table, insert null, do not do other change, so can not influence the execution efficient of original perspective table, other that also can not influence the perspective table played up regular execution.
Preferably, multidimensional data exhibiting method also comprises: change at the perspective table, when making the content of cell move to other cells, data model is provided with to other cells.In this technical scheme, keep the corresponding relation of original cell and content constant, can not influence the execution efficient of original perspective table, other that also can not influence the perspective table played up the execution of rule.
Preferably, the null content comprises formula, and step 204 comprises: according to formula, the tables of data value of closing from the perspective epiphase is also calculated, and result of calculation is filled in the null.In this technical scheme, can be in null charging formula, will show according to the result that formula calculates again, make that the ways of presentation of perspective table is more various, satisfy user's demand better.
Preferably, go back the title of storage unit lattice in the data model, step 204 also comprises: according to the title of all cells in the data line, inquire the data model corresponding to cell.In this technical scheme, the title through cell is the data model of query unit lattice more easily.
Preferably, particular cell is the cell in first row in the perspective table.In this technical scheme, the unified cell that adopts in first row is inquired about convenient.
According to the present invention, after mutual middle adding ' interpolation null ' operation of perspective table, should not have influence on representing of original perspective table data content, can not influence the efficient of its execution.
After carrying out the operation of interpolation null, the zone of original perspective table can change, and recomputating see-through area is a problem that will solve.The null inner storag information plays up after the interpolation null.
That the perspective table represents is the multi-dimensional query result, and Query Result is the object array of a two dimension, and each is to liking a multidimensional member in the array.The processing procedure of adding null can be divided into: " null information stores ", " insertion of mentioned null cell ", " playing up of mentioned null cell information ".
The first step is introduced " null information stores ", and the null extend information is stored on the current member, two parts extend information before and after being divided into, can be in current member front or the back insert null.Storing the line number of inserting null in the extended model, the content of edit of preserving in the null, formula etc.
Second step, to introduce " insertion of mentioned null cell ", the null of insertion will show along with perspective telogenesis person's unfolded operation and hide, and the status of each mentioned null cell is equal to the member.So the first step of processing procedure is concentrated at Query Result and is inserted the null member.
The logical process flow process in the first step and second step is as shown in Figure 3, comprising:
The 3rd one is ' playing up of dummy cell ', and with the content of being stored in the mentioned null cell, formula etc. are presented in the perspective table.Its logical flow chart is as shown in Figure 4, comprising:
Based on above disposal route, with instance each step is carried out detailed explanation below:
As shown in Figure 5, on member ' Drink ', add a null backward, add a null on ' Food ' forward.Line by line scan, when scanning member ' Food ', should before it, insert two nulls.The corresponding relation of record member and null, null and affiliated member's thereof row number, this situation corresponding relation is among Fig. 4:
2 3
4 5
After array all scanned, whole table had added two line space row.
As shown in Figure 5 then, insert formula, literal at the null place.
As in null inediting content: " beverage adds up to: ", insert formula at second cell place.No matter which kind of operation the perspective table is done, " Food " member front will show the null canned data, and the content stores of null is in last member's extended model.
After the perspective table operated, can play up the perspective table.When being rendered into ' Food ' member, find that it has added null, from extended model, take out the canned data of null:
Beverage adds up to: formula
The information content is shown in the units corresponding lattice, as shown in Figure 6.
If ' Food ' member is provided with the back extended area, equally also need play up, as shown in Figure 7.After playing up completion, write down play up the zone with corresponding member's corresponding relation.Following like its corresponding relation of this example:
Key assignments with ' Food ' member is represented this member, and its key assignments is: [product]. and [Food], as shown in the table:
In sum,, in the perspective table, choose certain delegation, can before and after current line, insert null through the present invention.Can add content in null, formula etc., certain member who chooses first in the perspective table to be listed as can insert null in this member's front and back.The null of adding can be carried out operations such as unfolded along with the member.After adding null, can edit the null cell, content can be preserved, such as adding formula at the null place; The perspective table no longer is a table that fixed sturcture is arranged, and can change flexibly as required; Improve the dirigibility of perspective table, satisfied client's individual demand; Through in the perspective table, inserting null and in null, filling required content, representing of perspective table no longer is a fixing table, can in table, insert null arbitrarily; In null, can preserve text; Formula etc., table more flexible alternately can be satisfied user's demand better; And can not influence the execution efficient of original perspective table, other that also can not influence the perspective table played up the execution of rule.
The above is merely the preferred embodiments of the present invention, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.All within spirit of the present invention and principle, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a multidimensional data demonstration device is characterized in that, comprising:
Data model is provided with module, and for the cell in the perspective table is provided with data model, and storage is positioned at before the said cell and/or null quantity afterwards and null content in said data model;
The null processing module when in the data line that the user chooses, comprising said particular cell, according to said data model, is inserted null by said null quantity, and is filled said null according to said null content before said data line and/or afterwards.
2. multidimensional data demonstration device according to claim 1; It is characterized in that; Said data model is provided with module and also changes at said perspective table, when making the content of said cell move to other cells, said data model is provided with to said other cells.
3. multidimensional data demonstration device according to claim 1; It is characterized in that said null content comprises formula, said null processing module is according to said formula; The tables of data value of closing from said perspective epiphase is also calculated, and result of calculation is filled in the said null.
4. multidimensional data demonstration device according to claim 1; It is characterized in that; Also store the title of said cell in the said data model, said null processing module inquires the said data model corresponding to said cell according to the title of all cells in the said data line.
5. according to each described multidimensional data demonstration device in the claim 1 to 4, it is characterized in that said particular cell is the cell in first row in the said perspective table.
6. a multidimensional data exhibiting method is characterized in that, comprising:
Step 202, for the cell in the perspective table is provided with data model, and storage is positioned at before the said cell and/or null quantity afterwards and null content in said data model;
Step 204 when in the data line that the user chooses, comprising said particular cell, according to said data model, is inserted null by said null quantity, and is filled said null according to said null content before said data line and/or afterwards.
7. multidimensional data exhibiting method according to claim 6 is characterized in that, also comprises:
Change at said perspective table, when making the content of said cell move to other cells, said data model is provided with to said other cells.
8. multidimensional data exhibiting method according to claim 6 is characterized in that, said null content comprises formula, and said step 204 comprises:
According to said formula, the tables of data value of closing from said perspective epiphase is also calculated, and result of calculation is filled in the said null.
9. multidimensional data exhibiting method according to claim 6 is characterized in that, also stores the title of said cell in the said data model, and said step 204 also comprises:
According to the title of all cells in the said data line, inquire said data model corresponding to said cell.
10. according to each described multidimensional data exhibiting method in the claim 6 to 9, it is characterized in that said particular cell is the cell in first row in the said perspective table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210224948.6A CN102799652B (en) | 2012-06-29 | 2012-06-29 | Multidimensional data presentation device and multidimensional data presentation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210224948.6A CN102799652B (en) | 2012-06-29 | 2012-06-29 | Multidimensional data presentation device and multidimensional data presentation method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102799652A true CN102799652A (en) | 2012-11-28 |
| CN102799652B CN102799652B (en) | 2014-11-12 |
Family
ID=47198762
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210224948.6A Active CN102799652B (en) | 2012-06-29 | 2012-06-29 | Multidimensional data presentation device and multidimensional data presentation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102799652B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110300966A (en) * | 2017-02-17 | 2019-10-01 | 微软技术许可有限责任公司 | The creation and interaction of the PivotTables of enhancing |
| CN112784557A (en) * | 2019-11-08 | 2021-05-11 | 珠海金山办公软件有限公司 | Method and device for determining pivot table |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101071414A (en) * | 2007-06-15 | 2007-11-14 | 珠海金山软件股份有限公司 | Device and method for automatically detecting and tracking data change |
| CN101271447A (en) * | 2007-11-23 | 2008-09-24 | 金蝶软件（中国）有限公司 | Method and system for completing report forms analysis |
| US20110087954A1 (en) * | 2009-10-09 | 2011-04-14 | Microsoft Corporation | Data analysis expressions |
-
2012
- 2012-06-29 CN CN201210224948.6A patent/CN102799652B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101071414A (en) * | 2007-06-15 | 2007-11-14 | 珠海金山软件股份有限公司 | Device and method for automatically detecting and tracking data change |
| CN101271447A (en) * | 2007-11-23 | 2008-09-24 | 金蝶软件（中国）有限公司 | Method and system for completing report forms analysis |
| US20110087954A1 (en) * | 2009-10-09 | 2011-04-14 | Microsoft Corporation | Data analysis expressions |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110300966A (en) * | 2017-02-17 | 2019-10-01 | 微软技术许可有限责任公司 | The creation and interaction of the PivotTables of enhancing |
| CN110300966B (en) * | 2017-02-17 | 2023-05-30 | 微软技术许可有限责任公司 | Enhanced pivot table creation and interaction |
| CN112784557A (en) * | 2019-11-08 | 2021-05-11 | 珠海金山办公软件有限公司 | Method and device for determining pivot table |
| CN112784557B (en) * | 2019-11-08 | 2023-06-30 | 珠海金山办公软件有限公司 | Method and device for determining pivot table |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102799652B (en) | 2014-11-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Tsai et al. | Using a multiple-GA method to solve the batch picking problem: considering travel distance and order due time | |
| CN100595758C (en) | Storing method and system of playing map and obtaining method and system of playing map | |
| JP2004164823A5 (en) | ||
| CN106503059B (en) | Displayed page method for pushing and device | |
| CN102902545B (en) | Markup language element is decomposed for animation | |
| de Léon | The cognitive biographies of things | |
| EP1677264A3 (en) | Gaming machine and game system | |
| EP2747072B1 (en) | Image processing device, image processing method, and image file data structure | |
| JP2004178604A5 (en) | ||
| CA2501501A1 (en) | System and a method for presenting related items to a user | |
| EP2747033A1 (en) | Information processing device, information processing method, and data structure of content file | |
| CN104392474A (en) | Method and device for generating and displaying animation | |
| CN102799652B (en) | Multidimensional data presentation device and multidimensional data presentation method | |
| CN104462080B (en) | The index structure creation method and system of statistics are grouped for retrieval result | |
| CN203841344U (en) | Bookshelf for library | |
| CN103365947A (en) | Social network service system and image display method | |
| CN106874477A (en) | The shared tutoring system of one kind composition material and its composition material sharing method | |
| CN109151547B (en) | Carousel method, carousel device, terminal and storage medium | |
| RU2014106227A (en) | EASY TWO-DIMENSIONAL VIDEO DATABASE NAVIGATION | |
| CN109189777A (en) | A kind of method, device and equipment stored and inquire multidimensional information | |
| CN104380268B (en) | Information processing system, information processing unit, information terminal device and information processing method | |
| JP2014059758A5 (en) | ||
| CN102722543A (en) | Method for storing files | |
| CN102789486A (en) | Formula manipulation device and formula manipulation method for data analysis system | |
| Cmentowski et al. | Toward a taxonomy of inventory systems for virtual reality games |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee |
Owner name: YONYOU NETWORK TECHNOLOGY CO., LTD. Free format text: FORMER NAME: UFIDA SOFTWARE CO., LTD. |
|
| CP03 | Change of name, title or address |
Address after: 100094 Haidian District North Road, Beijing, No. 68 Patentee after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Patentee before: UFIDA Software Co., Ltd. |