CN102799652B - Multidimensional data presentation device and multidimensional data presentation method - Google Patents
Multidimensional data presentation device and multidimensional data presentation method Download PDFInfo
- Publication number
- CN102799652B CN102799652B CN201210224948.6A CN201210224948A CN102799652B CN 102799652 B CN102799652 B CN 102799652B CN 201210224948 A CN201210224948 A CN 201210224948A CN 102799652 B CN102799652 B CN 102799652B
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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 perspective table of multi-dimensional query results set, form is relatively fixing, Query Result is fixed as a two-dimentional form by most BA manufacturer, such as the perspective table in the Excel of Microsoft, can carry out unfolded operation to form, but there is no the more interactive operation for form, but client needed be not the form of a format specification, in the form that they need, express more content, 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 arranges module, for the cell in perspective table arranges data model, and storage is positioned at null quantity and the null content before or after described cell in described data model; Null processing module while comprising described particular cell, according to described data model, was inserted null by described null quantity, and is filled described null according to described null content user in the data line of choosing before or after described data line.In this technical scheme, by inserting null and fill required content in perspective table in null, representing of perspective table is no longer a fixing table, can in table, insert arbitrarily null, in null, can preserve text, formula etc., table more flexible alternately, can meet user's demand better.
Preferably, described data model arranges module and also changes at described perspective table, while making the content of described cell move to other cells, described data model is arranged to described other cells.In this technical scheme, keep the corresponding relation of original cell and content constant, can not affect the execution efficiency of original perspective table, other that also can not affect perspective table played up regular execution.
Preferably, described null content comprises formula, and described null processing module, according to described formula, is shown relevant tables of data value and calculates from described perspective, and result of calculation is filled in described null.In this technical scheme, can be in null charging formula, then by the result presentation calculating according to formula out, make the ways of presentation of perspective table more various, meet better user's demand.
Preferably, also store the title of described cell in described data model, described null processing module, according to the title of all cells in described data line, inquires the described data model corresponding to described cell.In this technical scheme, in this technical scheme, by the title data model of query unit lattice more easily of cell.
Preferably, described particular cell is the cell in first row in described perspective table.In this technical scheme, the unified cell adopting in first row, inquires about convenient.
The present invention also provides a kind of multidimensional data exhibiting method, comprising: step 202, and for the cell in perspective table arranges data model, and storage is positioned at null quantity and the null content before or after described cell in described data model; Step 204 while comprising described particular cell, according to described data model, was inserted null by described null quantity, and is filled described null according to described null content user in the data line of choosing before or after described data line.In this technical scheme, by inserting null and fill required content in perspective table in null, representing of perspective table is no longer a fixing table, can in table, insert arbitrarily null, in null, can preserve text, formula etc., table more flexible alternately, can meet user's demand better; And owing to just inserting null in perspective table, do not do other change, so can not affect the execution efficiency of original perspective table, other that also can not affect perspective table played up regular execution.
Preferably, described multidimensional data exhibiting method also comprises: change at described perspective table, while making the content of described cell move to other cells, described data model is arranged to described other cells.In this technical scheme, keep the corresponding relation of original cell and content constant, can not affect the execution efficiency of original perspective table, other that also can not affect perspective table played up regular execution.
Preferably, described null content comprises formula, and described step 204 comprises: according to described formula, show relevant tables of data value and calculate from described perspective, result of calculation is filled in described null.In this technical scheme, can be in null charging formula, then by the result presentation calculating according to formula out, make the ways of presentation of perspective table more various, meet better user's demand.
Preferably, also store the title of described cell in described data model, described step 204 also comprises: according to the title of all cells in described data line, inquire the described data model corresponding to described cell.In this technical scheme, by the title data model of query unit lattice more easily of cell.
Preferably, described particular cell is the cell in first row in described perspective table.In this technical scheme, the unified cell adopting in first row, inquires about convenient.
In sum, by the present invention, in perspective table, choose certain a line, can before and after current line, insert null.Can add content in null, formula etc., choose certain member of the first row in perspective table, can insert null in this member's front and back.The null of adding can be carried out along with member the operations such as unfolded.Add after null, can edit null cell, content can be preserved, such as adding at null place formula; Perspective table is no longer a table that has fixed sturcture, can change flexibly as required; Improve the dirigibility of perspective table, met client's individual demand; By inserting null and fill required content in perspective table in null, representing of perspective table is no longer a fixing table, can in table, insert arbitrarily null, in null, can preserve text, formula etc., table more flexible alternately, can meet user's demand better; And can not affect the execution efficiency of original perspective table, other that also can not affect perspective table played up regular execution.
Brief description of the drawings
Fig. 1 is according to the block diagram of the multidimensional data demonstration device of the embodiment of the present invention;
Fig. 2 is according to the process flow diagram of the multidimensional data exhibiting method of the embodiment of the present invention;
Fig. 3 is according to the process flow diagram of the insertion of the null information storage of the embodiment of the present invention and mentioned null cell;
Fig. 4 is according to the process flow diagram of playing up of the mentioned null cell information of the embodiment of the present invention;
Fig. 5 to Fig. 7 is the design sketch that represents according to the perspective table of the embodiment of the present invention.
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.
As shown in Figure 1, the invention provides a kind of multidimensional data demonstration device 100, comprise: data model arranges module 102, for the cell in perspective table arranges data model, and storage is positioned at null quantity and the null content before or after cell in data model; Null processing module 104 while comprising particular cell, according to data model, was inserted null by null quantity, and is filled null according to null content user in the data line of choosing before or after data line.In this technical scheme, by inserting null and fill required content in perspective table in null, representing of perspective table is no longer a fixing table, can in table, insert arbitrarily null, in null, can preserve text, formula etc., table more flexible alternately, can meet user's demand better.
Preferably, data model arranges module 102 and also changes at perspective table, while making the content of cell move to other cells, data model is arranged to other cells.In this technical scheme, keep the corresponding relation of original cell and content constant, can not affect the execution efficiency of original perspective table, other that also can not affect perspective table played up regular execution.
Preferably, null content comprises formula, and null processing module 104, according to formula, is shown relevant tables of data value and calculates from perspective, and result of calculation is filled in null.In this technical scheme, can be in null charging formula, then by the result presentation calculating according to formula out, make the ways of presentation of perspective table more various, meet better user's demand.
Preferably, go back the title of storage unit lattice in data model, null processing module 104, according to the title of all cells in data line, inquires the data model corresponding to cell.In this technical scheme, in this technical scheme, by the title data model of query unit lattice more easily of cell.
Preferably, particular cell is the cell in first row in perspective table.In this technical scheme, the unified cell adopting in first row, inquires 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 perspective table arranges data model, and storage is positioned at null quantity and the null content before or after cell in data model; Step 204 while comprising particular cell, according to data model, was inserted null by null quantity, and is filled null according to null content user in the data line of choosing before or after data line.In this technical scheme, by inserting null and fill required content in perspective table in null, representing of perspective table is no longer a fixing table, can in table, insert arbitrarily null, in null, can preserve text, formula etc., table more flexible alternately, can meet user's demand better; And owing to just inserting null in perspective table, do not do other change, so can not affect the execution efficiency of original perspective table, other that also can not affect perspective table played up regular execution.
Preferably, multidimensional data exhibiting method also comprises: change at perspective table, while making the content of cell move to other cells, data model is arranged to other cells.In this technical scheme, keep the corresponding relation of original cell and content constant, can not affect the execution efficiency of original perspective table, other that also can not affect perspective table played up regular execution.
Preferably, null content comprises formula, and step 204 comprises: according to formula, show relevant tables of data value and calculate from perspective, result of calculation is filled in null.In this technical scheme, can be in null charging formula, then by the result presentation calculating according to formula out, make the ways of presentation of perspective table more various, meet better user's demand.
Preferably, go back the title of storage unit lattice in data model, step 204 also comprises: according to the title of all cells in data line, inquire the data model corresponding to cell.In this technical scheme, by the title data model of query unit lattice more easily of cell.
Preferably, particular cell is the cell in first row in perspective table.In this technical scheme, the unified cell adopting in first row, inquires about convenient.
According to the present invention, in perspective table mutual, add after ' interpolation null ' operation, should not have influence on representing of original perspective table data content, can not affect the efficiency of its execution.
Carry out and add after null operation, the region of original perspective table can change, and recalculating see-through area is a problem that will solve.After interpolation null, null inner storag information plays up.
What perspective table represented is multi-dimensional query result, and Query Result is a two-dimentional object array, and in array, each is to liking a multidimensional member.The processing procedure of adding null can be divided into: " storage of null information ", " insertion of mentioned null cell ", " playing up of mentioned null cell information ".
The first step, introduces " storage of null information ", and it is upper that null extend information is stored in current member, and before and after being divided into, two parts extend information can be inserted null before current member or below.In extended model, storing the line number of inserting null, the content of edit of preserving in null, formula etc.
Second step, introduces " insertion of mentioned null cell ", and the null of insertion will and be hidden along with perspective telogenesis person's unfolded operation demonstration, and the status of each mentioned null cell is equal to member.So the first step of processing procedure is concentrated and is inserted null member at Query Result.
The logical process flow process of the first step and second step as shown in Figure 3, comprising:
Step 302, the execution result set of perspective table is designated as PivotCell[M] [N], the perspective table unit lattice array of the capable N row of M.
Step 304, getting perspective table unit lattice is PivotCell[X] [0].Travel through line by line first perspective table unit lattice, cell, takes out the unique name that identifies this cell, according to this title, in extended model, find its corresponding extend information, in extend information, storing the null quantity that this cell will insert forward backward, the storage content in null.Record the null quantity that this cell inserts forward backward, be designated as preNum, afterNum.AfterNum wherein will be served as a loop variable storage, in order to merging with the null number inserting forward of next cell.Calculating the null number that will insert forward at this element lattice place, is the afterNum sum when time preNum of circulation and circulation last time.
Step 306 according to null quantity, is inserted full line mentioned null cell in perspective table unit lattice array, and the null of record insertion and the corresponding relation of affiliated cell.
Step 308, recalculates the area information of perspective table.Owing to having inserted, empty cell is capable, and the line number of array increases, so need to recalculate the area information of perspective table.
Step 310, has obtained adding the perspective table unit array of mentioned null cell.
The 3rd is ' playing up of dummy cell ', and by the content of storing in mentioned null cell, formula etc. are presented in perspective table.Its logical flow chart as shown in Figure 4, comprising:
Step 402, according to the perspective table unit lattice array of returning, travels through each perspective table unit lattice one by one.
Step 404, judges whether to have added extended model according to the unique name of cell, if so, enters step 406, if not, returns to step 402.
Step 406 is taken out and is inserted forward null unit information, and plays up one by one null unit from extended model.
Step 408 is taken out and is entered backward null unit information, and plays up one by one null unit from extended model.
Step 410, records extended area and current member's corresponding relation.After cell has been played up, need to record extended area and current member's corresponding relation, because perspective table is after unfolded operates, this relation meeting dynamic change, so will record.
Based on above disposal route, with example, each step is described in detail below:
As shown in Figure 5, on member ' Drink ', add backward a null, on ' Food ', add forward a null.Line by line scan, in the time scanning member ' Food ', should before it, insert two nulls.Record the corresponding relation of member and null, null and affiliated member's thereof line number, in Fig. 4, this situation corresponding relation is:
2 3
4 5
After array all scans, whole table has added two line space row.
Then as shown in Figure 5, insert formula, word at null place.
As in null inediting content: " beverage adds up to: ", insert formula at second cell place.No matter perspective table is done to which kind of operation, will show null canned data before " Food " member, the content of null is stored in member's extended model.
After perspective table is operated, can play up perspective table.In the time being rendered into ' Food ' member, find that it has added null, from extended model, take out the storage information of null:
Beverage adds up to: formula
The information content is shown in corresponding cell, as shown in Figure 6.
If ' Food ' member is provided with rear extended area, equally also need to play up, as shown in Figure 7.After having played up, record play up region with corresponding member's corresponding relation.As follows in its corresponding relation of this example:
Represent this member with ' Food ' member's key assignments, its key assignments is: [product] .[Food], as shown in the table:
In sum, by the present invention, in perspective table, choose certain a line, can before and after current line, insert null.Can add content in null, formula etc., choose certain member of the first row in perspective table, can insert null in this member's front and back.The null of adding can be carried out along with member the operations such as unfolded.Add after null, can edit null cell, content can be preserved, such as adding at null place formula; Perspective table is no longer a table that has fixed sturcture, can change flexibly as required; Improve the dirigibility of perspective table, met client's individual demand; By inserting null and fill required content in perspective table in null, representing of perspective table is no longer a fixing table, can in table, insert arbitrarily null, in null, can preserve text, formula etc., table more flexible alternately, can meet user's demand better; And can not affect the execution efficiency of original perspective table, other that also can not affect perspective table played up regular execution.
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 of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (10)
1. a multidimensional data demonstration device, is characterized in that, comprising:
Data model arranges module, and for the cell in perspective table arranges data model, and storage is positioned at null quantity and the null content before or after described cell in described data model;
Null processing module while comprising particular cell, according to described data model, was inserted null by described null quantity, and is filled described null according to described null content user in the data line of choosing before or after described data line.
2. multidimensional data demonstration device according to claim 1, it is characterized in that, described data model arranges module and also changes at described perspective table, while making the content of described cell move to other cells, described data model is arranged to described other cells.
3. multidimensional data demonstration device according to claim 1, it is characterized in that, described null content comprises formula, and described null processing module is according to described formula, show relevant tables of data value and calculate from described perspective, result of calculation is filled in described null.
4. multidimensional data demonstration device according to claim 1, it is characterized in that, in described data model, also store the title of described cell, described null processing module, according to the title of all cells in described data line, inquires the described data model corresponding to described cell.
5. according to the multidimensional data demonstration device described in any one in claim 1 to 4, it is characterized in that, described particular cell is the cell in first row in described perspective table.
6. a multidimensional data exhibiting method, is characterized in that, comprising:
Step 202, for the cell in perspective table arranges data model, and storage is positioned at null quantity and the null content before or after described cell in described data model;
Step 204 while comprising particular cell, according to described data model, was inserted null by described null quantity, and is filled described null according to described null content user in the data line of choosing before or after described data line.
7. multidimensional data exhibiting method according to claim 6, is characterized in that, also comprises:
Change at described perspective table, while making the content of described cell move to other cells, described data model is arranged to described other cells.
8. multidimensional data exhibiting method according to claim 6, is characterized in that, described null content comprises formula, and described step 204 comprises:
According to described formula, show relevant tables of data value and calculate from described perspective, result of calculation is filled in described null.
9. multidimensional data exhibiting method according to claim 6, is characterized in that, also stores the title of described cell in described data model, and described step 204 also comprises:
According to the title of all cells in described data line, inquire the described data model corresponding to described cell.
10. according to the multidimensional data exhibiting method described in any one in claim 6 to 9, it is characterized in that, described particular cell is the cell in first row in described 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 CN102799652A (en) | 2012-11-28 |
CN102799652B true 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) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US11222171B2 (en) * | 2017-02-17 | 2022-01-11 | Microsoft Technology Licensing, Llc | Enhanced pivot table creation and interaction |
CN112784557B (en) * | 2019-11-08 | 2023-06-30 | 珠海金山办公软件有限公司 | Method and device for determining pivot table |
Citations (2)
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 |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9275031B2 (en) * | 2009-10-09 | 2016-03-01 | Microsoft Technology Licensing, Llc | Data analysis expressions |
-
2012
- 2012-06-29 CN CN201210224948.6A patent/CN102799652B/en active Active
Patent Citations (2)
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 |
Also Published As
Publication number | Publication date |
---|---|
CN102799652A (en) | 2012-11-28 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10761686B2 (en) | Techniques for generating electronic menu graphical user interface layouts for use in connection with electronic devices | |
US8279241B2 (en) | Zooming graphical user interface | |
CN103020025B (en) | Technology for the automatic animation of document content | |
US20060143020A1 (en) | Device capable of easily creating and editing a content which can be viewed in three dimensional way | |
CN100595758C (en) | Storing method and system of playing map and obtaining method and system of playing map | |
CN106503059B (en) | Displayed page method for pushing and device | |
CN105302550A (en) | Method and system for converting page into layout data stream file | |
CN102902545B (en) | Markup language element is decomposed for animation | |
CN106652005A (en) | Virtual home scene 3D designer and virtual home scene 3D design system | |
WO2006042048A3 (en) | Volume body renderer | |
CN106610785A (en) | Commodity object list information processing method and apparatus | |
EP2747072B1 (en) | Image processing device, image processing method, and image file data structure | |
CN105117021A (en) | Virtual reality content generation method and playing device | |
de Léon | The cognitive biographies of things | |
EP2747033A1 (en) | Information processing device, information processing method, and data structure of content file | |
CN102799652B (en) | Multidimensional data presentation device and multidimensional data presentation method | |
CA2501501A1 (en) | System and a method for presenting related items to a user | |
CN103885962A (en) | Picture processing method and server | |
CN106874477A (en) | The shared tutoring system of one kind composition material and its composition material sharing method | |
JP2015056022A (en) | Production distribution system based on nutritional viewpoint, production distribution method, and program for production distribution system | |
CN109151547B (en) | Carousel method, carousel device, terminal and storage medium | |
US9002782B2 (en) | Hyper-lattice model for optimized sequencing of online analytical processing (OLAP) operations on data warehouses | |
CN108021599B (en) | Method and device for providing page version header | |
CN109189777A (en) | A kind of method, device and equipment stored and inquire multidimensional information | |
CN112434030B (en) | Tree structure data-based high-performance list implementation method and equipment |
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. |