CN100587691C - Formatting method of on-line analyzing processing list - Google Patents
Formatting method of on-line analyzing processing list Download PDFInfo
- Publication number
- CN100587691C CN100587691C CN200610145082A CN200610145082A CN100587691C CN 100587691 C CN100587691 C CN 100587691C CN 200610145082 A CN200610145082 A CN 200610145082A CN 200610145082 A CN200610145082 A CN 200610145082A CN 100587691 C CN100587691 C CN 100587691C
- Authority
- CN
- China
- Prior art keywords
- operand
- status condition
- property value
- resolver
- dimension
- 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
Images
Abstract
The invention relates to on-line analytical processing table formatting method. It includes the following steps: setting attribute value and status condition of the formatted operand in on-line analytical processing table by analysis machine; if the operand satisfies status condition, processing formatted display for it by analysis machine. The invention can process formatted display for the cellin the on-line analytical processing table on which while enterprise is analyzing from many angles, it can display cell member and data by formatting method which has simple operation, is convenient for the enterprise to analyze and display the data table, and can increase enterprise global analysis performance.
Description
Technical field
The present invention relates to computer realm, be particularly related to a kind of formatting method of on-line analytical processing form specifically.
Background technology
OLAP (On-Line Analytical Processing, on-line analytical processing) is a kind of software engineering, it make the analyst can be rapidly, consistent, observed information in all its bearings alternatively, to reach the deep purpose of understanding data, these information are directly changed from raw data and are come, and they reflect the truth of enterprise in the mode that the user understands easily.
The most of strategy of OLAP all is relationship type or common data to be carried out multidimensional data store, so that analyze, thereby reaches the purpose of on-line analytical processing.This multidimensional data is counted as a hypercube, and along the direction stored data of each dimension, it allows the user to analyze data along the axis of affairs, has realized the express-analysis of shared multidimensional information.
The principal feature of OLAP is the multi-angle thinking pattern of directly copying the user, sets up the multidimensional data model for the user in advance, and wherein dimension refers to user's analytic angle.For example, the analysis of data is sold in multi-pin, and the time cycle is a dimension, and product category, channel of distribution, geographic distribution, client's realm also are respectively dimensions.In case the multidimensional data modelling is finished, the user can obtain data from each analytic angle apace, also can be dynamically switches between all angles or carries out the multi-angle comprehensive analysis, has great dirigibility.
Along with the application of OLAP form more and more widely, the data volume of storing in this multidimensional form is huge day by day and complicated, when this multidimensional form is applied in the statistics and analysis of enterprise, because the cell in the on-line analytical processing form lacks format expression display packing, only can carry out single multidimensional list data shows, and make enterprise when carrying out the multi-angular analysis data form, can't further operate the multidimensional form, be difficult to member and data in the Cell display emphatically, be unfavorable for that enterprise is better to analyze and video data.
Summary of the invention
The formatting method that the purpose of this invention is to provide a kind of on-line analytical processing form, to overcome in the prior art, because the cell in the on-line analytical processing form lacks the format method for expressing, and make enterprise when carrying out the multi-angular analysis data form, be difficult to member and data in the Cell display emphatically, be unfavorable for that enterprise is better to analyze and the problem of video data form.
For solving the problems of the technologies described above, the present invention puies forward following technical scheme:
A kind of formatting method of on-line analytical processing form comprises step:
A, resolver are provided with in the on-line analytical processing form will carry out the property value of formative operand and the status condition of this operand;
B, when the operand in the form satisfies the status condition of described setting, resolver formats demonstration according to the property value of described setting to the operand that satisfies status condition.
The property value of operand comprises in the described steps A:
At least one item in the background color of operand, the foreground color; And/or
The font of operand, font size, color, whether be shown as at least one in runic, italic, underscore, the rotation.
The status condition of setting operation object is specially in the described steps A:
Resolver is provided with at least one status condition of operand in the form.
Describedly be provided with that at least one status condition of operand is specially in the form:
By using operational symbol, logical expression, at least a mode in the character string connector, grand or Multidimensional Expressions is provided with described status condition.
When by grand when status condition is set, described steps A comprises:
The property value that will carry out formative cell data in the form is set.
When by Multidimensional Expressions status condition being set, described steps A comprises:
The property value of the dimension member of cell correspondence in the form is set, or the property value of the dimension member's of cell correspondence associated members in the form is set, or the property value of any dimension member in the form is set.
Described dimension member's associated members comprise:
Dimension member's father member, or dimension member's fraternal member, or dimension member's root member.
Described steps A also comprises:
The property value of this operand when the resolver setting is not satisfied described status condition when the operand in the on-line analytical processing form.
Described method also comprises:
When the operand in the form did not satisfy the status condition of described setting, resolver formatd demonstration according to the property value of described setting to the operand that does not satisfy status condition.
When the status condition of setting operation object was empty in the described steps A, resolver formatd demonstration according to the property value of described setting to operand.
By above technical scheme provided by the invention as seen, the present invention has following characteristics and advantage:
Because the cell formats in the on-line analytical processing form depends on two factors, the one, the data of itself, the 2nd, the context of cell promptly determines the dimensional information of this cell, therefore any data cells all makes up decision by the dimension member.The present invention can make things convenient for any cell and dimension member arbitrarily in the pro forma interview sheet by setting property value and status condition, and the operand of choosing is formatd demonstration.
The present invention is by using Multidimensional Expressions, can visit any object in the on-line analytical processing form, the expression formula that also can define any complexity is operated the object in the form, use the present invention and can format demonstration the cell in the on-line analytical processing form, thereby make enterprise when carrying out multi-angular analysis on-line analytical processing form, can be by member and the data in the formatting method Cell display, simple to operate, it is more convenient and analyze intuitively and the video data form to be convenient to enterprise, has improved the whole enterprise analytical performance.
Description of drawings
Fig. 1 is the inventive method process flow diagram;
Fig. 2 is the process flow diagram of the preferred embodiment of the present invention;
Fig. 3 is the process flow diagram of another embodiment of the present invention.
Embodiment
Core of the present invention provides a kind of formatting method of on-line analytical processing form, this method is provided with by resolver will carry out the property value of formative operand and the status condition of this operand in the on-line analytical processing form, when the operand in the form satisfies the status condition that is provided with, resolver formats demonstration according to the property value that is provided with to the operand that satisfies status condition, make enterprise when carrying out multi-angular analysis in-line processing form, can analyze more convenient and intuitively and the video data form, help improving the whole enterprise analytical performance.
In order to make those skilled in the art person understand the present invention program better, the present invention is described in further detail below in conjunction with drawings and embodiments.
The user of on-line analytical processing generally is specialty analysis personnel and the management decision personnel in the enterprise, and they are when analyzing the data of professional operation, from the different professional measurement indexs of angle close examination.For example when analyzing sales data, may the generalized time cycle, multiple factors such as product category, channel of distribution, geographic distribution, client's realm consider.These analytic angles can reflect that the angle of each analysis can generate a form by form, and the various combination of each analytic angle can generate different forms.Wherein, dimension is the special angle of people's observed data, is the generic attribute when considering a problem, and community set constitutes a dimension, comprises time dimension and geographical dimension etc.; The level of dimension is certain special angle of people's observed data, can also exist different each of level of detail to describe the aspect, comprise time dimension date, month, season or year etc.; The member of dimension is a value of dimension, is the description of data item position in certain dimension; Tolerance is the value of Multidimensional numerical.
The formatting method flow process of on-line analytical processing form of the present invention is as shown in Figure 1:
Step 101: resolver is provided with the property value and the status condition that will carry out formative operand in the on-line analytical processing form.
Resolver can be resolved the operational order that reads in or write, and according to the result who parses operand is carried out command adapted thereto then and carries out.Wherein, the property value of operand comprises at least one in the background color of operand, the foreground color, and/or the font of operand, font size, color, whether is shown as at least one in runic, italic, underscore, the rotation.
Concrete, resolver can be provided with the property value that will carry out formative cell data in the form, or the property value of the dimension member of cell correspondence in the form is set, or the property value of the dimension member's of cell correspondence associated members in the form is set, or dimension member's property value arbitrarily is set in the form.
Step 102: when the operand in the form satisfied the status condition that is provided with, resolver formatd demonstration according to the property value that is provided with to the operand in the form.
By using operational symbol, logical expression, the status condition of at least a mode setting operation object in the character string connector, grand or Multidimensional Expressions judges that the operand in the form satisfies at least one status condition that is provided with.
Resolver is provided with the property value of this operand when the operand in the form satisfies and do not satisfy the status condition of setting respectively.Concrete, judge when the operand in the form satisfies the status condition that is provided with, according to the property value that satisfies status condition the operand in the form is formatd demonstration; Judge when the operand in the form does not satisfy the status condition that is provided with, the operand in the form is formatd demonstration according to the property value that does not satisfy status condition.When the status condition of the operand that is provided with was sky, resolver directly formatd demonstration to operand according to the property value that is provided with.
Especially, resolver can be used the formatting method that following script structure realizes on-line analytical processing form of the present invention:
[(condition)？](true_statement)[:false_statement]
In above-mentioned script structure, the washability of condition and false_statement can have the format expression way of following three kinds of on-line analytical processing forms:
(true_statement)；
In this expression way, status condition without the setting operation object, the property value that will carry out formative operand in the form at first is set, and promptly the true_statement in the bracket formats demonstration according to the property value that is provided with to whole on-line analytical processing form then accordingly.
(condition)？(true_statement)；
In this expression way, at least one status condition of operand in the form at first is set, it is the condition value in first bracket, the property value that will carry out formative operand in the form is set then, i.e. true_statement in the second lattice bracket, and judge whether the operation subtend in the on-line analytical processing form satisfies this condition value, for the operand that satisfies this value, then the operand of on-line analytical processing form is formatd demonstration accordingly according to the property value that is provided with.
(condition)？(true_statement):(false_statement)；
In this expression way, at least one status condition of operand in the form at first is set, it is the condition value in first bracket, the property value of operand when satisfying this condition value is set respectively in the form then, i.e. true_statement in second bracket, property value with operand when not satisfying this condition value, i.e. false_statement in the 3rd bracket, and judge whether the operand in the on-line analytical processing form satisfies this condition value, to satisfying the operand of this value, according to the true_statement that is provided with it is formatd demonstration, to not satisfying the operand of this value, it is formatd demonstration according to the false_statement that is provided with.
The preferred embodiment flow process of the formatting method of on-line analytical processing form of the present invention is as shown in Figure 2:
Step 201: resolver is provided with at least one status condition of operand in the on-line analytical processing form.
Can be by using operational symbol, logical expression, at least a mode in the character string connector, grand or Multidimensional Expressions is provided with this status condition.
Concrete, can pass through operational symbol (+,-, *, ÷) status condition condition is set, for example (Value-2000)＞0; Can status condition condition be set by logical expression, for example (Value＞2000and Value＜3000); Can status condition condition be set by the character string connection, for example (Time.currentMember.name|| ' year '=' calendar year 2001 '); Can be by the grand status condition condition that is provided with, for example (Value=Null); Also can status condition condition be set by Multidimensional Expressions.
Step 202: resolver is provided with the property value that will carry out formative operand in the on-line analytical processing form.
The property value that will carry out formative cell data in the form can be set, or the property value of the dimension member of cell correspondence in the form is set, or the property value of the dimension member's of cell correspondence associated members in the form is set, or dimension member's property value arbitrarily is set in the form.
Wherein, dimension member's associated members are specially dimension member's father member, dimension member's fraternal member, perhaps dimension member's root member.
Step 203: judge whether the object in the on-line analytical processing form satisfies the status condition that is provided with, if then execution in step 204; Otherwise, execution in step 205.
Step 204: resolver formats demonstration according to the property value that is provided with to the operand in the form, and process ends.
When the operand in the form satisfies the status condition that is provided with, the operand in the form is formatd demonstration according to the property value that is provided with.
The multidimensional form of an on-line analytical processing is as shown in table 1:
Concrete, can be by the grand property value that will carry out formative cell in the table 1 that is provided with, and when this cell satisfies the status condition of setting, according to this property value this cell is shown; For example, (Value＞2000)? (color:red), the numerical value in the cell promptly being set in the table 1 satisfying greater than 2000 o'clock, be red with the data presentation of this cell, and the consumption sum 2180.74 of calendar year 2001 is shown in red accordingly.
Can the property value that will carry out formative certain dimension member in the table 1 be set by Multidimensional Expressions, and when this cell satisfies the status condition of setting, this dimension member be shown according to this property value; For example, (Time.currentMember=Time.[gathers])? (background:Orange), the background color that promptly is provided with in the table 1 to dimension member's cell of " gathering " is a salmon pink.
Can the property value that will carry out formative dimension member's father member in the table 1 be set by Multidimensional Expressions, and when satisfying the status condition of setting for this disconnected Yuan, the father member to this dimension member shows according to this property value; For example, and (Time.currentMember.parent=[Time] .[2001])? (color:Red), the father member's calendar year 2001 of current member among the time member of table 1 and 12 months font color of all sub-members thereof promptly are set for red.
Step 205: the object in the form is not processed process ends simultaneously.
Another embodiment flow process of the formatting method of on-line analytical processing form of the present invention is as shown in Figure 3:
Step 301: resolver is provided with at least one status condition of operand in the on-line analytical processing form.
Can pass through operational symbol (+,-, *, ÷) status condition condition is set, for example (Value-2000)＞0; Can status condition condition be set by logical expression, for example (Value＞2000and Value＜3000); Can status condition condition be set by the character string connection, for example (Time.currentMember.name|| ' year '=' calendar year 2001 '); Can be by the grand status condition condition that is provided with, for example (Value=Null); Also can status condition condition be set by Multidimensional Expressions.
Step 302: resolver is provided with the property value that will carry out formative operand under two kinds of conditions in the on-line analytical processing form respectively.
The property value of this operand when the operand in the form satisfies and do not satisfy the status condition of setting is set respectively.The property value that will carry out formative cell data under two kinds of conditions can be set respectively, or the dimension member's of cell correspondence property value in the form is set respectively under two kinds of conditions, or the dimension member's of cell correspondence associated members' property value in the form is set respectively under two kinds of conditions, or dimension member's property value arbitrarily is set respectively under two kinds of conditions in the form.Wherein, dimension member's associated members are specially dimension member's father member, dimension member's fraternal member, perhaps dimension member's root member.
Concrete, the property value of operand comprises at least one in the background color of operand, the foreground color, and/or the font of operand, font size, color, whether is shown as at least one in runic, italic, underscore, the rotation.
Step 303: judge whether the object in the on-line analytical processing form satisfies the status condition that is provided with, if then execution in step 304; Otherwise, execution in step 305.
Step 304: the property value according to the operand that satisfies condition formats demonstration to this operand, and process ends.
Step 305: the property value according to the operand that does not satisfy condition formats demonstration to this operand, and process ends.
Concrete, the property value of the member of any dimension in the table 1 can be set by Multidimensional Expressions, and when the member of this any dimension satisfies the status condition of setting, according to the state value that satisfies condition that is provided with the member of this any dimension is formatd demonstration, when the member of this any dimension does not satisfy the status condition of setting, the member of this any dimension is formatd demonstration according to the state value that does not satisfy condition that is provided with; For example, (Time.currentMember=Time.[gathers])? (background:Blue): (Color:Red), whether the current member that time dimension in the table 1 promptly is set is " gathering ", if then this dimension member's background color is set to blueness, otherwise this dimension member's numerical value is set to redness.
The property value of any cell in the table 1 can be set by Multidimensional Expressions, and when this cell satisfies the status condition of setting, according to the state value that satisfies condition that is provided with this cell is formatd demonstration, when this cell does not satisfy the status condition of setting, this cell is formatd demonstration according to the state value that does not satisfy condition that is provided with; For example, (Value (Time.currentMember.preMember, [tolerance] .[sales volume])=Null)? (Color:Red): (Color:Green), whether the sales volume that the current member's of time dimension previous member in the table 1 promptly is set is empty, if it is then that the numerical value of this cell is shown in red, otherwise the numerical value of this cell is shown in green.
Though described the present invention by embodiment, those of ordinary skills know, the present invention has many distortion and variation and do not break away from spirit of the present invention, wish that appended claim comprises these distortion and variation and do not break away from spirit of the present invention.
Claims (8)
1, a kind of formatting method of on-line analytical processing form is characterized in that, comprises step:
A, resolver are provided with in the on-line analytical processing form will carry out the property value of formative operand and the status condition of this operand;
B, when the operand in the form satisfies the status condition of described setting, resolver formats demonstration according to the property value of described setting to the operand that satisfies status condition;
The status condition of setting operation object is specially in the described steps A: resolver is provided with at least one status condition of operand in the form;
Describedly be provided with that at least one status condition of operand is specially in the form: by using operational symbol, logical expression, at least a mode in the character string connector, grand or Multidimensional Expressions is provided with described status condition;
Described operand is the cell data.
2, method according to claim 1 is characterized in that, the property value of operand comprises in the described steps A:
At least one item in the background color of operand, the foreground color; And/or
The font of operand, font size, color, whether be shown as at least one in runic, italic, underscore, the rotation.
3, method according to claim 1 is characterized in that, when by grand when status condition is set, described steps A comprises:
The property value that will carry out formative cell data in the form is set.
4, method according to claim 1 is characterized in that, when by Multidimensional Expressions status condition being set, described steps A comprises:
The property value of the dimension member of cell correspondence in the form is set, or the property value of the dimension member's of cell correspondence associated members in the form is set, or the property value of any dimension member in the form is set.
5, method according to claim 4 is characterized in that, described dimension member's associated members comprise:
Dimension member's father member, or dimension member's fraternal member, or dimension member's root member.
6, method according to claim 1 is characterized in that, described steps A also comprises:
The property value of this operand when the resolver setting is not satisfied described status condition when the operand in the on-line analytical processing form.
7, method according to claim 6 is characterized in that, described method also comprises:
When the operand in the form did not satisfy the status condition of described setting, resolver formatd demonstration according to the property value of described setting to the operand that does not satisfy status condition.
8, method according to claim 1 is characterized in that, when the status condition of setting operation object was empty in the described steps A, resolver formatd demonstration according to the property value of described setting to operand.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200610145082A CN100587691C (en) | 2006-12-01 | 2006-12-01 | Formatting method of on-line analyzing processing list |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200610145082A CN100587691C (en) | 2006-12-01 | 2006-12-01 | Formatting method of on-line analyzing processing list |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1949224A CN1949224A (en) | 2007-04-18 |
| CN100587691C true CN100587691C (en) | 2010-02-03 |
Family
ID=38018739
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200610145082A Active CN100587691C (en) | 2006-12-01 | 2006-12-01 | Formatting method of on-line analyzing processing list |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100587691C (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020143B (en) * | 2012-11-21 | 2016-12-21 | 用友网络科技股份有限公司 | The apparatus and method of Merge Cells |
| CN104182218B (en) * | 2014-08-05 | 2015-05-27 | 北京控制工程研究所 | On-board computer time delay command storing and executing method |
-
2006
- 2006-12-01 CN CN200610145082A patent/CN100587691C/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN1949224A (en) | 2007-04-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7415482B2 (en) | XBRL enabler for business documents | |
| US9665555B2 (en) | Data analysis expressions | |
| US9740376B2 (en) | User interface for relating enterprise information with public information using a private user profile and schema | |
| US6651055B1 (en) | OLAP query generation engine | |
| Javed et al. | ExPlates: spatializing interactive analysis to scaffold visual exploration | |
| CN103678468B (en) | The system and method for improved consumption model for profiling | |
| US7797356B2 (en) | Dynamically detecting exceptions based on data changes | |
| WO2007072501A2 (en) | A system and a methodology for providing integrated business performance management platform | |
| US8880459B2 (en) | Navigation across datasets from multiple data sources based on a common reference dimension | |
| US20070277101A1 (en) | System and method for dynamic organization of information sets | |
| JP2005508552A (en) | Memory system for data objects | |
| US9201985B2 (en) | Displaying annotation in multiple visualizations | |
| GB2492438A (en) | System for using a graphical representation to manage record values | |
| US20210224328A1 (en) | Data visualization tool with guided visualization creation and secure publication features, and graphical user interface thereof | |
| Ferrari et al. | Microsoft Excel 2013 Building Data Models with PowerPivot | |
| CN100587691C (en) | Formatting method of on-line analyzing processing list | |
| US11836445B2 (en) | Spreadsheet table transformation | |
| CN202433952U (en) | General network reporting system | |
| US20140344235A1 (en) | Determination of data modification | |
| US20120159302A1 (en) | Cell content scrolling | |
| Petrovski et al. | Visual Data Analysis for EU Public Sector Data usingPython app MyDataApp | |
| Milligan | Learning Tableau 2020: Create effective data visualizations, build interactive visual analytics, and transform your organization | |
| CA2663859C (en) | Apparatus and method for updating a report through view time interaction | |
| Dixon | Excel 2007: Beyond the manual | |
| US20120089593A1 (en) | Query optimization based on reporting specifications |
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 |