[go: up one dir, main page]

CN102789486A - Formula manipulation device and formula manipulation method for data analysis system - Google Patents

Formula manipulation device and formula manipulation method for data analysis system Download PDF

Info

Publication number
CN102789486A
CN102789486A CN2012102239253A CN201210223925A CN102789486A CN 102789486 A CN102789486 A CN 102789486A CN 2012102239253 A CN2012102239253 A CN 2012102239253A CN 201210223925 A CN201210223925 A CN 201210223925A CN 102789486 A CN102789486 A CN 102789486A
Authority
CN
China
Prior art keywords
formula
data
script
formula script
row
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.)
Pending
Application number
CN2012102239253A
Other languages
Chinese (zh)
Inventor
王宇光
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yonyou Software Co Ltd
Original Assignee
Yonyou Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Yonyou Software Co Ltd filed Critical Yonyou Software Co Ltd
Priority to CN2012102239253A priority Critical patent/CN102789486A/en
Publication of CN102789486A publication Critical patent/CN102789486A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides a formula manipulation device for a data analysis system, which comprises a device for setting a formula script in a data table, a device for calculating according to data in the formula script to obtain a sequence tag, and a device for executing the formula script and filling an execution result into a unit or a region corresponding to the sequence tag. The invention also provides a formula manipulation method for the data analysis system. By the technical scheme adopted by the invention, the flexible customization of the data analyzed out from the data analysis system can be implemented.

Description

The formula manipulation device and the formula manipulation method that are used for data analysis system
Technical field
The present invention relates to the data analysis technique field, in particular to a kind of formula manipulation device and a kind of formula manipulation method that is used for data analysis system that is used for data analysis system.
Background technology
Present Intellectual analysis system; Analysis Service engine (OLAP) through powerful is analyzed data; Analysis engine itself also has formula (function) treating apparatus; Analysis engine finally forms the data that the user wants through parsing, the execution to formula, and shows the user to data with various forms at presentation layer.Yet prior art exists following problem to solve:
1. for some achievement data that analyzes, if the user wants that reprocessing is handled to achievement data, and these data are data that certain professional meaning is arranged, and how just can obtain these data.
2. if the user wants the data that analyze are increased ranks flexibly, the raw column data that increases newly is again that certain business rule is arranged, and how these data are obtained, and obtains how about to store and show the user after the data.
3. when data volume was too big, if the user wants the data apportion demonstration to analyzing, and how apportion realized that reprocessing is handled to achievement data after showing.
Above problem all is that traditional BI analytic system can't satisfy these requirements of client owing to the user has the requirement of flexible customization to produce the Intellectual analysis system when showing data.
Therefore, need a kind of data analysis technique, can realize the data that flexible customization analyzes in data analysis system.
Summary of the invention
To the problems referred to above, the invention provides a kind of data analysis technique, can realize the data that flexible customization analyzes in data analysis system.
According to an aspect of the present invention, proposed a kind of formula manipulation device that is used for data analysis system, having comprised: the device that the formula script is set in data form; Obtain the device of sequence identifier by the data computation in the said formula script; Carry out said formula script, execution result is filled into the device in said sequence identifier corresponding cells or zone.
In this technical scheme, the position in expansion index cell that drills through along with the member in the multidimensional data form or zone is constantly to change, and therefore need identify the position in index cell or zone through sequence identifier exactly.Sequence identifier is unique by the ranks dimension decision of the data in the formula script, therefore can the data that calculate be filled into exactly the position in index cell or zone according to sequence identifier.
Preferably, the said device that the formula script is set in data form comprises: according to the row or the automatic device that generates said formula script of the data in the row at selected said unit or place, zone.
In this technical scheme, index cell or zone according to selected can obtain ranks cross-dimension member automatically, generate the formula script automatically, and be convenient, fast.
Preferably, the said device that the formula script is set in data form also comprises: import the parameter of needs, generate the device of said formula script according to said parameter; Said parameter comprises: cube, index, member.
In this technical scheme, the function of self-defined formula script is provided, can the multidimensional formula that expand according to service needed be generated self-defined formula script.
Preferably, also comprise: the device that in said data form, adds self-defined row or row.The said device that the formula script is set in data form also comprises: the device of defined formula script in the unit of said self-defined row or row or zone.The said device that obtains sequence identifier by the data computation in the said formula script comprises: the device that calculates said sequence identifier in the unit or the zone of said self-defined row or row according to the data in the said formula script and said formula script.
In this technical scheme, support to add self-defined ranks.Add the computing method that change sequence identifier behind the self-defined ranks, still can obtain the pairing accurate position of formula script.
Preferably, also comprise: said data form is split the device of showing.The then said device that obtains sequence identifier by the data computation in the said formula script also comprises: the offset that causes according to the data in the said formula script and said fractionation calculates the device of said sequence identifier.
In this technical scheme, support the multidimensional data form is split displaying.Split and show that the back calculates sequence identifier according to offset, still can obtain the pairing accurate position of formula script.
The present invention also proposes a kind of formula manipulation method that is used for data analysis system, comprising: the formula script is set in data form; Data computation by in the said formula script obtains sequence identifier; Carry out said formula script, execution result is filled into said sequence identifier corresponding cells or zone.
In this technical scheme, the position in expansion index cell that drills through along with the member in the multidimensional data form or zone is constantly to change, and therefore need identify the position in index cell or zone through sequence identifier exactly.Sequence identifier is unique by the ranks dimension decision of the data in the formula script, therefore can the data that calculate be filled into exactly the position in index cell or zone according to sequence identifier.
Preferably, the said step that the formula script is set in data form comprises: row or the data in the row according to selected said unit or place, zone generate said formula script automatically.
In this technical scheme, index cell or zone according to selected can obtain ranks cross-dimension member automatically, generate the formula script automatically, and be convenient, fast.
Preferably, the said step that the formula script is set in data form also comprises: the parameter of input needs generates said formula script according to said parameter; Said parameter comprises: cube, index, member.
In this technical scheme, the function of self-defined formula script is provided, can the multidimensional formula that expand according to service needed be generated self-defined formula script.
Preferably, also comprise: in said data form, add self-defined row or row.The said step that the formula script is set in data form also comprises: defined formula script in the unit of said self-defined row or row or zone.The said step that obtains sequence identifier by the data computation in the said formula script comprises: calculate said sequence identifier according to data in the said formula script and said formula script in the unit or the zone of said self-defined row or row.
In this technical scheme, support to add self-defined ranks.Add the computing method that change sequence identifier behind the self-defined ranks, still can obtain the pairing accurate position of formula script.
Preferably, also comprise before the step of sequence identifier said obtaining: said data form is split show by the data computation in the said formula script.The then said step that obtains sequence identifier by the data computation in the said formula script also comprises: the offset that causes according to the data in the said formula script and said fractionation calculates said sequence identifier.
In this technical scheme, support the multidimensional data form is split displaying.Split and show that the back calculates sequence identifier according to offset, still can obtain the pairing accurate position of formula script.
Through technique scheme, can realize the data that flexible customization analyzes in data analysis system.
Description of drawings
Fig. 1 shows the block diagram of the formula manipulation device that is used for data analysis system according to an embodiment of the invention;
Fig. 2 shows the process flow diagram of the formula manipulation method that is used for data analysis system according to an embodiment of the invention;
Fig. 3 shows the block diagram of the formula manipulation device that is used for data analysis system according to another embodiment of the present invention.
Fig. 4 is the schematic diagram of middle data layout device embodiment illustrated in fig. 3;
Fig. 5 is the synoptic diagram of middle data form embodiment illustrated in fig. 3;
Fig. 6 is the schematic diagram of middle script model adaptive device embodiment illustrated in fig. 3;
Fig. 7 is the schematic diagram of middle script executing apparatus embodiment illustrated in fig. 3.
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.
A lot of details have been set forth in the following description so that make much of the present invention; But; The present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention does not receive the restriction of following disclosed specific embodiment.
Below in conjunction with accompanying drawing and embodiment the present invention is further specified.Need to prove that under the situation of not conflicting, the application's embodiment and the characteristic among the embodiment can make up each other.
Fig. 1 shows the block diagram of the formula manipulation device that is used for data analysis system according to an embodiment of the invention.
As shown in Figure 1, the formula manipulation device 100 that is used for data analysis system according to an embodiment of the invention comprises: the formula script is provided with unit 102, and the formula script is set in data form; Sequence identifier acquiring unit 104 obtains sequence identifier by the data computation in the formula script; Performance element 106 is carried out the formula script, and execution result is filled into sequence identifier corresponding cells or zone.
In this technical scheme, the position in expansion index cell that drills through along with the member in the multidimensional data form or zone is constantly to change, and therefore need identify the position in index cell or zone through sequence identifier exactly.Sequence identifier is unique by the ranks dimension decision of the data in the formula script, therefore can the data that calculate be filled into exactly the position in index cell or zone according to sequence identifier.
Preferably, the formula script is provided with unit 102 and comprises: the formula script generates subelement 1022 automatically, generates the formula script automatically according to the row at selected unit or place, zone or the data in the row.
In this technical scheme, index cell or zone according to selected can obtain ranks cross-dimension member automatically, generate the formula script automatically, and be convenient, fast.
Preferably, the formula script is provided with unit 102 and also comprises: the self-defined subelement 1024 of formula script, according to the parameter generation formula script of input; Parameter comprises: cube, index, member.
In this technical scheme, the function of self-defined formula script is provided, can the multidimensional formula that expand according to service needed be generated self-defined formula script.
Preferably, also comprise: self-defined ranks subelement 108, add self-defined row or row in data form; The formula script is provided with unit 102 and also is used for unit or zone defined formula script at self-defined row or row.Sequence identifier acquiring unit 104 comprises: self-defined ranks sequence identifier computation subunit 1042 calculates sequence identifier according to data in the formula script and formula script in the unit or the zone of self-defined row or row.
In this technical scheme, support to add self-defined ranks.Add the computing method that change sequence identifier behind the self-defined ranks, still can obtain the pairing accurate position of formula script.
Preferably, also comprise: split display unit 110, data form is split show.Then sequence identifier acquiring unit 104 also comprises: split sequence identifier computation subunit 1044, calculate sequence identifier according to data in the formula script and the offset that fractionation causes.
In this technical scheme, support the multidimensional data form is split displaying.Split and show that the back calculates sequence identifier according to offset, still can obtain the pairing accurate position of formula script.
Fig. 2 shows the process flow diagram of the formula manipulation method that is used for data analysis system according to an embodiment of the invention.
As shown in Figure 2, the formula manipulation method that is used for data analysis system according to an embodiment of the invention comprises: step 202 is provided with the formula script in data form; Step 204 obtains sequence identifier by the data computation in the formula script; Step 206 is carried out the formula script, and execution result is filled into sequence identifier corresponding cells or zone.
In this technical scheme, the position in expansion index cell that drills through along with the member in the multidimensional data form or zone is constantly to change, and therefore need identify the position in index cell or zone through sequence identifier exactly.Sequence identifier is unique by the ranks dimension decision of the data in the formula script, therefore can the data that calculate be filled into exactly the position in index cell or zone according to sequence identifier.
Preferably, step 202 comprises: generate the formula script automatically according to the row at selected unit or place, zone or the data in the row.
In this technical scheme, index cell or zone according to selected can obtain ranks cross-dimension member automatically, generate the formula script automatically, and be convenient, fast.
Preferably, step 202 also comprises: the parameter of input needs generates the formula script according to parameter; Parameter comprises: cube, index, member.
In this technical scheme, the function of self-defined formula script is provided, can the multidimensional formula that expand according to service needed be generated self-defined formula script.
Preferably, also comprise: in data form, add self-defined row or row.Step 202 also comprises: defined formula script in the unit of self-defined row or row or zone.Step 204 also comprises: calculate sequence identifier according to data in the formula script and formula script in the unit or the zone of self-defined row or row.
In this technical scheme, support to add self-defined ranks.Add the computing method that change sequence identifier behind the self-defined ranks, still can obtain the pairing accurate position of formula script.
Preferably, also comprise before the step 204: data form is split show.Then step 204 also comprises: calculate sequence identifier according to data in the formula script and the offset that fractionation causes.
In this technical scheme, support the multidimensional data form is split displaying.Split and show that the back calculates sequence identifier according to offset, still can obtain the pairing accurate position of formula script.
Below in conjunction with Fig. 3 to Fig. 7 explanation formula manipulation device that is used for data analysis system according to another embodiment of the present invention.
Referring to Fig. 3, the formula manipulation device that is used for data analysis system among this embodiment comprises: formula script generating apparatus 302, script model adaptive device 304, script driven resolver 306, script executing apparatus 308.
On the data basis that the analysis engine analysis shows, need reach the customization of data to some data definition formula script.At first, through formula script generating apparatus 302 defined formula script on unit that needs customization data or zone.
Formula script generating apparatus 302 comprises formula script automatically generating device 3022; Formula script automatically generating device 3022 provides the automatic generation of formula script; According to the index zone of selecting; Utilize data layout device 402 to find the pairing ranks cross-dimension of index member, generate the formula script automatically.Convenience and ease for use when formula script automatically generating device 3022 can improve the generation of formula script generate the formula script of wanting fast.
The principle of work of data layout device 402 can be referring to Fig. 4.
Multidimensional data layout device 402 is used for the multidimensional data display area is split, and concerns between the record data.
Multidimensional data layout device 402 can split into the N sub regions to the zone that multidimensional data is showed; Each subregion splits the zone of embarking on journey, column region, index zone again; The data of a plurality of dimensions can be placed in the row and column zone, and each subregion can write down between this area data and concern.
Data display each member of multidimensional data display area all is to correspond to a cell location; The data of each index are corresponding is to intersect the position of unique decision index by the ranks dimension; But the corresponding position of index is constantly changing again, and this just needs the sign that can calculate this unique position of index, and this sign is just represented this index; The multidimensional formula just is stored on this sign, so that the data that calculate can be filled into corresponding index.
The unique identification computing method that index is corresponding: ranks all agree to have a plurality of dimensions; The index sign is to be stitched together the row axle of cube with the ranks member that the row axle intersects; The sign of forming unique this index of decision, no matter the position variation how of index, but this sign can not change.
Data relationship container 404 is used to write down unique identification and the index location relation that index generates.
Be the instance of a formula script below, can be referring to data form shown in Figure 5.
CubeValue (' the food selling analysis. sales analysis ', ' [product]. [Drink] ', ' [Measures]. [sales volume] ', ' [time]. [1999] ', ' [shops]. [Canada] ')
The data that this formula is got are: 1999 time, the Canada of shops, product Drink, the data of index sales volume.
The unique identification that calculates this formula is: [time] .1999 [shops] .Canada [product] Drink [Measure]. the expansion that sales volume, this sign can not drill through along with the member and changing.
The computing method of this sign: move the width in row axle zone from this cell position is parallel to row axle zone, whenever move a unit value once, take out a unique identification of this position, row axial all identify us and be decided to be line identifier; From the parallel height of this cell position to mobile row axle zone, row axle zone, whenever move a unit value once, take out a unique identification of this position, we are decided to be the row sign to be listed as axial all signs
The sign of the sign+column direction of the sign=line direction of index is so we calculate sign=[time] .1999 [shops] .Canada [product] Drink [Measure] of this index. sales volume.
Formula script generating apparatus 302 also comprises the self-defined device 3024 of formula script.According to the needs of business, can expand many multidimensional formula, such as having the formula of getting the achievement data formula, getting member's data, the data formula of getting the member of a delegation index etc.Be put into the self-defined device of formula script 3024 the insides to these formula of expanding out.We just can generate the formula that professional meaning is arranged with the self-defined device 3024 of formula script.
As above the multidimensional formula in the example: CubeValue (' the food selling analysis. sales analysis ', ' [product]. [Drink] ', ' [Measures]. [sales volume] ', ' [time]. [1999] ', ' [shops]. [Canada] ')
Select this multidimensional formula of CubeValue: different formulas has different guide interfaces, selects the formula parameters needed successively according to guide interface: cube, index, member will generate self-defining formula.
The formula script is supported the arithmetic between the formula, so long as the data of wanting can easily realize through powerful formula script.
Script model adaptive device 304 utilizes data layout device 402 to calculate the corresponding storage sequence sign of formula script that formula script generating apparatus 302 generates; Store the formula script in the model into; So that when the formula script executing, can be filled into corresponding index location to result calculated; Like self-defined ranks 604, split and show ranks 606, fixed cell or zone 608, multidimensional data zone 610, referring to Fig. 6.Formula script storage sequence does not rely on the unit or the regional location at index place, because the position of index is in dynamic change.
Remove the formula script of adaptive different storage sequences through script model adaptive device 304, unified formula script access interface externally is provided, hide the complicated business logic of formula script, need not be concerned about the concrete business of formula script when making external operation.
Also support self-defining ranks in the various dimensions data area, self-defining ranks can not calculate formula script storage sequence sign, but through the self-defined ranks relative position storage of member, this position is also in the dynamic change of member's drilling operation.The position of the self-defined ranks of member is constantly changing, but the relative position of formula script in making ranks by oneself is constant, just can calculate the actual storage sign of multidimensional formula through relative position.
For example: there is the individual row of making by oneself in member's [time] .1999 bottom, and data layout device 402 can be each actual position that calculates [time] .1999 member of carrying out.The present position of [time] .1999 is A8, and multidimensional formula script is C3 in the position of self-defined row, and the real position of multidimensional formula script should be (8+3) this position of D 11=A+ (C-A) so.The position of [time] .1999 can change at any time, but the relative position of formula script is indeclinable forever, just can calculate the actual stored sequence identifier of formula script through relative position.
The zone that the multidimensional data display area is showed can be showed by apportion, split displaying according to certain member exactly, and the number of times that splits is unfixed.This also causes formula storage sequence complexity of calculation, and script model adaptive device 304 can reach the correspondence of formula storage sequence and actual position through migration technology.
Script driven resolver 306 be used in batches the formula script is carried out the grammer verification, parse the parameter in the formula script.The wherein legitimacy of parameter is mainly checked out in the verification of formula script grammer, and whether grammer meets script rule etc., guarantees that the formula script can normally carry out.This device can resolve to a syntax tree with the formula script, resolves successively according to the structure of parameter object in tree.
For example formula: CubeValue (' the food selling analysis. sales analysis ', ' [product]. [Drink] ', ' [Measures]. [sales volume] '; ' [time]. [1998] '; ' [shops]. [Canada] ')+CubeValue (' the food selling analysis. sales analysis ', ' [product]. [Drink] ', ' [Measures]. [sales volume] '; ' [time]. [1999] ', ' [shops]. [Canada] ').
Parse the parameter in the formula script: cube--the food selling analysis. sales analysis, member--[product]. [Drink], member--[time]. [1998], index--[Measures]. and [sales volume], functional symbol-'+', cube--the food selling analysis. sales analysis, member--[product]. [Drink], member--[time]. [1999], index--[Measures]. [sales volume].
The formula script argument that script executing apparatus 308 parses according to script driven resolver 306; Assemble actuating logic in batches; Transfer to olap analysis service-Engine 310 and carry out the formula script; The data of execution place, find the corresponding position of formula script according to data layout device 402, be filled into control to data.
Script executing apparatus 308 can convert multidimensional formula script to multidimensional analysis script that real class is carried out, and principle can be referring to Fig. 7.
Multidimensional formula script: CubeValue (' food selling analysis. sales analysis ', ' [product]. [Drink] ', ' [Measures]. [sales volume] ', ' [time]. [1998] ', ' [shops]. [Canada] ') for example
Olap analysis service-Engine conversion back script: select Crossjoin ([product]. [Drink], [product]. [Food] }, [Measures]. [sales volume] }) ON COLUMNS,
Crossjoin ([time]. [1999], [time]. [1998] }, [shops]. [Canada], [shops]. [USA] }) ON ROWS from [sales analysis].
Above embodiment is directed against customization property than higher analysis exhibition method; A kind of dynamic multidimensional formula script service processing system and device of Intellectual analysis are provided; Can satisfy the user and when analyzing data, data customized requirement flexibly; Can well solve customization than the multidimensional form higher, that call format is complicated, have higher commercial value.
To sum up, can realize the data that flexible customization analyzes according to the present invention in data analysis system.
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 formula manipulation device that is used for data analysis system is characterized in that, comprising:
The device of formula script is set in data form;
Obtain the device of sequence identifier by the data computation in the said formula script;
Carry out said formula script, execution result is filled into the device in said sequence identifier corresponding cells or zone.
2. the formula manipulation device that is used for data analysis system according to claim 1 is characterized in that, the said device that the formula script is set in data form comprises:
Row or the automatic device that generates said formula script of the data in the row according to selected said unit or place, zone.
3. the formula manipulation device that is used for data analysis system according to claim 1 is characterized in that, the said device that the formula script is set in data form also comprises:
The parameter that input needs generates the device of said formula script according to said parameter;
Said parameter comprises: cube, index, member.
4. according to claim 2 or the 3 described formula manipulation devices that are used for data analysis system, it is characterized in that, also comprise:
In said data form, add the device of self-defined row or row;
The said device that the formula script is set in data form also comprises: the device of defined formula script in the unit of said self-defined row or row or zone;
The said device that obtains sequence identifier by the data computation in the said formula script comprises:
The device that calculates said sequence identifier in the unit or the zone of said self-defined row or row according to the data in the said formula script and said formula script.
5. according to claim 2 or the 3 described formula manipulation devices that are used for data analysis system, it is characterized in that, also comprise:
Said data form is split the device of showing;
The then said device that obtains sequence identifier by the data computation in the said formula script also comprises:
The offset that causes according to the data in the said formula script and said fractionation calculates the device of said sequence identifier.
6. a formula manipulation method that is used for data analysis system is characterized in that, comprising:
The formula script is set in data form;
Data computation by in the said formula script obtains sequence identifier;
Carry out said formula script, execution result is filled into said sequence identifier corresponding cells or zone.
7. the formula manipulation method that is used for data analysis system according to claim 6 is characterized in that, the said step that the formula script is set in data form comprises:
Row or the data in the row according to selected said unit or place, zone generate said formula script automatically.
8. the formula manipulation method that is used for data analysis system according to claim 6 is characterized in that, the said step that the formula script is set in data form also comprises:
The parameter that input needs generates said formula script according to said parameter;
Said parameter comprises: cube, index, member.
9. according to claim 7 or the 8 described formula manipulation methods that are used for data analysis system, it is characterized in that, also comprise:
In said data form, add self-defined row or row;
The said step that the formula script is set in data form also comprises: defined formula script in the unit of said self-defined row or row or zone;
The said step that obtains sequence identifier by the data computation in the said formula script comprises:
Calculate said sequence identifier according to data in the said formula script and said formula script in the unit or the zone of said self-defined row or row.
10. according to claim 7 or the 8 described formula manipulation methods that are used for data analysis system, it is characterized in that, also comprise before the step of sequence identifier said obtaining by the data computation in the said formula script:
Said data form is split displaying;
The then said step that obtains sequence identifier by the data computation in the said formula script also comprises:
The offset that causes according to the data in the said formula script and said fractionation calculates said sequence identifier.
CN2012102239253A 2012-06-28 2012-06-28 Formula manipulation device and formula manipulation method for data analysis system Pending CN102789486A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2012102239253A CN102789486A (en) 2012-06-28 2012-06-28 Formula manipulation device and formula manipulation method for data analysis system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2012102239253A CN102789486A (en) 2012-06-28 2012-06-28 Formula manipulation device and formula manipulation method for data analysis system

Publications (1)

Publication Number Publication Date
CN102789486A true CN102789486A (en) 2012-11-21

Family

ID=47154889

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2012102239253A Pending CN102789486A (en) 2012-06-28 2012-06-28 Formula manipulation device and formula manipulation method for data analysis system

Country Status (1)

Country Link
CN (1) CN102789486A (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103646316A (en) * 2013-12-18 2014-03-19 世纪禾光科技发展(北京)有限责任公司 Distributed financial computing formula processing method
CN105630761A (en) * 2016-03-04 2016-06-01 中国建设银行股份有限公司 Method and device for manipulating formulas
CN118569223A (en) * 2024-07-31 2024-08-30 北京久其软件股份有限公司 Multi-dimensional table generation method and device and computer equipment
CN118734821A (en) * 2024-08-30 2024-10-01 西安葡萄城软件有限公司 A method and device for dynamically refreshing a report

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101246471A (en) * 2008-02-26 2008-08-20 山东中创软件工程股份有限公司 Irregular complex report forms creating method
CN101556579A (en) * 2009-05-08 2009-10-14 用友软件股份有限公司 Formula processing system used for dynamic report areas and method thereof
CN101673276A (en) * 2009-09-22 2010-03-17 山东中创软件工程股份有限公司 Method and device for dynamically generating data template
CN102222105A (en) * 2011-06-23 2011-10-19 公安部交通管理科学研究所 Method for generating real-time statistical report

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101246471A (en) * 2008-02-26 2008-08-20 山东中创软件工程股份有限公司 Irregular complex report forms creating method
CN101556579A (en) * 2009-05-08 2009-10-14 用友软件股份有限公司 Formula processing system used for dynamic report areas and method thereof
CN101673276A (en) * 2009-09-22 2010-03-17 山东中创软件工程股份有限公司 Method and device for dynamically generating data template
CN102222105A (en) * 2011-06-23 2011-10-19 公安部交通管理科学研究所 Method for generating real-time statistical report

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103646316A (en) * 2013-12-18 2014-03-19 世纪禾光科技发展(北京)有限责任公司 Distributed financial computing formula processing method
CN105630761A (en) * 2016-03-04 2016-06-01 中国建设银行股份有限公司 Method and device for manipulating formulas
CN105630761B (en) * 2016-03-04 2019-03-12 中国建设银行股份有限公司 Formula processing method and device
CN118569223A (en) * 2024-07-31 2024-08-30 北京久其软件股份有限公司 Multi-dimensional table generation method and device and computer equipment
CN118569223B (en) * 2024-07-31 2024-10-22 北京久其软件股份有限公司 Multi-dimensional table generation method and device and computer equipment
CN118734821A (en) * 2024-08-30 2024-10-01 西安葡萄城软件有限公司 A method and device for dynamically refreshing a report
CN118734821B (en) * 2024-08-30 2025-01-03 西安葡萄城软件有限公司 Report dynamic refreshing method and device

Similar Documents

Publication Publication Date Title
Kumar et al. TimeTree: a resource for timelines, timetrees, and divergence times
CN106886418B (en) HTML interface control label
CN103064689A (en) Implementation method and system for dynamically generating report pages
CN102521416B (en) Data correlation query method and data correlation query device
CN102609256B (en) A kind of Dynamic Graph table generating method based on webpage
CN105677353A (en) Feature extraction method and machine learning method and device thereof
CN105493032A (en) Cross-device user interface selection
CN103733191A (en) Automatic generation of trend charts
CN104714949A (en) Method for customizing report dynamically
CN104063361A (en) Report design method and system
CN102789486A (en) Formula manipulation device and formula manipulation method for data analysis system
CN109426415B (en) Method and device for generating cascade selector
US11270483B1 (en) Unified multi-view data visualization
CN107941256A (en) A kind of numerical value personalized indication method of high precision measuring instrument
CN103945444A (en) Scenario generation device and scenario generation method
CN102508822A (en) Thai display method, device and system
CN102129468B (en) Method for displaying customizable cluster state
CN110515609A (en) Using generation method, device, equipment and storage medium
RU2014106227A (en) EASY TWO-DIMENSIONAL VIDEO DATABASE NAVIGATION
CN103885956A (en) Method and equipment for generating reports
CN106372200A (en) Method and device for displaying picture resources
CN106445888B (en) Method and device for making artistic words
KR100902193B1 (en) Report generation system, method and system for providing customized report on search results, and storage media
CN109597845B (en) Report configuration method, report configuration device, computer equipment and storage medium
CN109144624A (en) Method, storage medium, equipment and the system of not contour list are shown in IOS

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20121121