CN104361137A - Device and method for generating data fetching conditions of report form - Google Patents
Device and method for generating data fetching conditions of report form Download PDFInfo
- Publication number
- CN104361137A CN104361137A CN201410757407.9A CN201410757407A CN104361137A CN 104361137 A CN104361137 A CN 104361137A CN 201410757407 A CN201410757407 A CN 201410757407A CN 104361137 A CN104361137 A CN 104361137A
- Authority
- CN
- China
- Prior art keywords
- mapping
- condition
- mdx
- row
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
- G06F16/24573—Query processing with adaptation to user needs using data annotations, e.g. user-defined metadata
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2246—Trees, e.g. B+trees
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
- G06F16/316—Indexing structures
- G06F16/322—Trees
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Library & Information Science (AREA)
- Computational Linguistics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention provides a device for generating data fetching conditions of a report form. The device comprises a data structure storage unit, a mapping region generating unit and a mapping model data structure storage unit, wherein the data structure storage unit is used for displaying the data structure as well as dimensionality, measurement members and a supported dragging function of the data structure, and converting the data structure into the storage unit; the mapping region generating unit is used or establishing mapping of data fetching conditions by dragging the corresponding dimensionality measuring conditions at the right side to generate a mapping and data fetching region; the mapping model data structure storage unit is used for defining a mapping model and a mapping region model on the background of a report form panel and storing mapping information set by the user after generating the mapping region. The invention further provides a method for generating data fetching conditions of the report form. According to the technical scheme adopted by the invention, the condition generation of a multi-object type can be completed by sufficiently utilizing a single-object type based on the existing condition generating mode so as to establish a general and unified generating idea for condition generation with a plurality of objects participating.
Description
Technical field
The present invention relates to technical field of data processing, particularly, relate to a kind of report form figure selection condition generating apparatus and a kind of report form figure selection condition generation method.
Background technology
For current existing demand and foothold above, technical scheme of the present invention proposes a kind of report form figure selection condition generating apparatus based on multidimensional analysis theory.Its feature is:
(1) show with tree structure using user-defined multidimensional analysis models (comprising ranks dimension, tolerance) as condition to be selected, user can with the form pulled, the dimension of multidimensional model and tolerance are arranged on the wardrobe of table sample, row head thus generate ranks condition
(2) by condition being divided into region to the layout of ranks condition, and (dimension measures into the peek MDX statement in this region of generation in order to the notice computing unit when calculating according to area information.
Therefore, need a kind of new condition generation technique, on existing condition generating mode basis, the condition generation that single object type completes multi-object type can be made full use of, set up general, the unified generation thinking of the condition generation that multi-object type participates in.
Summary of the invention
The present invention is just based on the problems referred to above, propose a kind of new condition generation technique, on existing condition generating mode basis, the condition generation that single object type completes multi-object type can be made full use of, set up general, the unified generation thinking of the condition generation that multi-object type participates in.
In view of this, the present invention proposes a kind of report form figure selection condition generating apparatus, comprise: data structure storage unit, for peek based on predefined multidimensional analysis model and data structure, at foreground partition with the drag function of tree display data structure and dimension thereof, tolerance member and support, and data structure is converted to this storage organization, for showing tree structure and storing dynamic area; Mapping area generation unit, for the storage organization of conversion is applied to table sample, by pulling the corresponding dimension condition metric in right side, sets up the mapping of acquisition conditions, generating and mapping peek region; Mapping model data structure storage unit, after generating mapping area, on the backstage of form panel, definition mapping model and mapping area model, store the map information that user is arranged.In this technical scheme, by different set-up modes, different acquisition conditions can be generated, is finally reached through the object that multidimensional analysis models gets report data.
In technique scheme, preferably, described mapping area generation unit, by pulling the corresponding dimension condition metric in right side, is set up the mapping of acquisition conditions, is generated the operation mapping peek region, comprise further: (1) pull row condition to wardrobe; (2) pull row condition to row head; (3) click and generate mapping area.
In technique scheme, preferably, described mapping area generation unit, specifically comprises: intersection region generation module, for setting up multiple intersection region be made up of row, column condition, travels through all index cells; MDX statement generates and preserves module, after having traveled through when all index cells, in each mapping area, preserves the position that row/column condition should occur in MDX inquiry, and generates MDX; Area calculation module, for based on the MDX generated, calculates each intersection region.In this technical scheme, generate report form figure selection condition based on multidimensional technology, and multidimensional peek model is that user can customize, and be the multidimensional analysis models based on business, and when being defined into table sample, being also based on business completely and supporting to pull form, and need not defined formula.
In technique scheme, preferably, described MDX statement generates and preserves module, also for when generating MDX, according to the position of MDX, the dimension member that assembling occurs successively or the tuple by multiple dimension member composition, be set to Hash table form by the mode that ranks condition stores.
In technique scheme, preferably, described MDX statement generates and preserves the operation of CMOS macro cell MDX, comprises further: each the row/column position in (1) circulation row/column set of circumstances; (2) get corresponding member set according to position; (3) whether multielement in set, if it is spells tuple, if not then spelling dimension member.
According to a further aspect of the invention, also proposed a kind of report form figure selection condition generation method, comprise: step 202: based on predefined multidimensional analysis peek model and data structure, at foreground partition with the drag function of tree display data structure and dimension thereof, tolerance member and support, and data structure is converted to this storage organization, for showing tree structure and storing dynamic area; Step 204: the storage organization of conversion is applied to table sample, by pulling the corresponding dimension condition metric in right side, setting up the mapping of acquisition conditions, generating and mapping peek region; Step 206: after generating mapping area, on the backstage of form panel, definition mapping model and mapping area model, store the map information that user is arranged.In this technical scheme, generate report form figure selection condition based on multidimensional technology, and multidimensional peek model is that user can customize, and be the multidimensional analysis models based on business, and when being defined into table sample, being also based on business completely and supporting to pull form, and need not defined formula.
In technique scheme, preferably, described step 204, by pulling the corresponding dimension condition metric in right side, is set up the mapping of acquisition conditions, is generated the operation mapping peek region, comprise further: (1) pull row condition to wardrobe; (2) pull row condition to row head; (3) click and generate mapping area.
In technique scheme, preferably, described step 204, specifically comprises: step 302: set up multiple intersection region be made up of row, column condition, travels through all index cells; Step 304: after all index cells have traveled through, in each mapping area, preserves the position that row/column condition should occur in MDX inquiry, and generates MDX; Step 306: based on the MDX generated, each intersection region is calculated.
In technique scheme, preferably, described step 304, also comprises: when generating MDX, according to the position of MDX, and the dimension member that assembling occurs successively or the tuple by multiple dimension member composition, be set to Hash table form by the mode that ranks condition stores.
In technique scheme, preferably, described step 304 generates the operation of MDX, comprises further: each the row/column position in (1) circulation row/column set of circumstances; (2) get corresponding member set according to position; (3) whether multielement in set, if it is spells tuple, if not then spelling dimension member.
By above technical scheme, on existing condition generating mode basis, the condition generation that single object type completes multi-object type can be made full use of, set up general, the unified generation thinking of the condition generation that multi-object type participates in.
Accompanying drawing explanation
Fig. 1 shows the block diagram of report form figure selection condition generating apparatus according to an embodiment of the invention;
Fig. 2 shows the process flow diagram of report form figure selection condition generation method according to an embodiment of the invention;
Fig. 3 shows the process flow diagram of mapping area generation unit according to an embodiment of the invention;
Fig. 4 show according to an embodiment of the invention based on user at the detail flowchart establishing multidimensional analysis peek model;
Fig. 5 shows the working interface sectional drawing of table sample form and multidimensional acquisition conditions Mapping Design device (peeking before designing) according to an embodiment of the invention;
Fig. 6 shows the process flow diagram generating acquisition conditions mapping area according to an embodiment of the invention;
Fig. 7 shows the working interface sectional drawing of table sample form and multidimensional acquisition conditions Mapping Design device (peeking after designing) according to an embodiment of the invention;
Fig. 8 shows the process flow diagram pulling according to an embodiment of the invention and map event handling;
Fig. 9 shows the process flow diagram of mapping area generating algorithm according to an embodiment of the invention;
Figure 10 shows region according to an embodiment of the invention and calculates the process flow diagram of MDX generative process.
Embodiment
In order to more clearly understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.It should be noted that, when not conflicting, the feature in the embodiment of the application and embodiment can combine mutually.
Set forth a lot of detail in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not by the restriction of following public specific embodiment.
Fig. 1 shows the block diagram of report form figure selection condition generating apparatus according to an embodiment of the invention.
As shown in Figure 1, report form figure selection condition generating apparatus 100 according to an embodiment of the invention, comprise: data structure storage unit 102, for peek based on predefined multidimensional analysis model and data structure, at foreground partition with the drag function of tree display data structure and dimension thereof, tolerance member and support, and data structure is converted to this storage organization, for showing tree structure and storing dynamic area; Mapping area generation unit 104, for the storage organization of conversion is applied to table sample, by pulling the corresponding dimension condition metric in right side, sets up the mapping of acquisition conditions, generating and mapping peek region; Mapping model data structure storage unit 106, after generating mapping area, on the backstage of form panel, definition mapping model and mapping area model, store the map information that user is arranged.In this technical scheme, by different set-up modes, different acquisition conditions can be generated, is finally reached through the object that multidimensional analysis models gets report data.
In technique scheme, preferably, mapping area generation unit 104, by pulling the corresponding dimension condition metric in right side, is set up the mapping of acquisition conditions, is generated the operation mapping peek region, comprise further: (1) pull row condition to wardrobe; (2) pull row condition to row head; (3) click and generate mapping area.
In technique scheme, preferably, mapping area generation unit 104, specifically comprises: intersection region generation module 1042, for setting up multiple intersection region be made up of row, column condition, travels through all index cells; MDX statement generates and preserves module 1044, after having traveled through when all index cells, in each mapping area, preserves the position that row/column condition should occur in MDX inquiry, and generates MDX; Area calculation module 1046, for based on the MDX generated, calculates each intersection region.In this technical scheme, generate report form figure selection condition based on multidimensional technology, and multidimensional peek model is that user can customize, and be the multidimensional analysis models based on business, and when being defined into table sample, being also based on business completely and supporting to pull form, and need not defined formula.
In technique scheme, preferably, MDX statement generates and preserves module 1044, also for when generating MDX, according to the position of MDX, the dimension member that assembling occurs successively or the tuple by multiple dimension member composition, be set to Hash table form by the mode that ranks condition stores.
In technique scheme, preferably, MDX statement generates and preserves the operation that module 1044 generates MDX, comprises further: each the row/column position in (1) circulation row/column set of circumstances; (2) get corresponding member set according to position; (3) whether multielement in set, if it is spells tuple, if not then spelling dimension member.
Fig. 2 shows the process flow diagram of report form figure selection condition generation method according to an embodiment of the invention.
As shown in Figure 2, report form figure selection condition generation method according to an embodiment of the invention, comprise: step 202: based on predefined multidimensional analysis peek model and data structure, at foreground partition with the drag function of tree display data structure and dimension thereof, tolerance member and support, and data structure is converted to this storage organization, for showing tree structure and storing dynamic area; Step 204: the storage organization of conversion is applied to table sample, by pulling the corresponding dimension condition metric in right side, setting up the mapping of acquisition conditions, generating and mapping peek region; Step 206: after generating mapping area, on the backstage of form panel, definition mapping model and mapping area model, store the map information that user is arranged.In this technical scheme, generate report form figure selection condition based on multidimensional technology, and multidimensional peek model is that user can customize, and be the multidimensional analysis models based on business, and when being defined into table sample, being also based on business completely and supporting to pull form, and need not defined formula.
In technique scheme, preferably, step 204, by pulling the corresponding dimension condition metric in right side, is set up the mapping of acquisition conditions, is generated the operation mapping peek region, comprise further: (1) pull row condition to wardrobe; (2) pull row condition to row head; (3) click and generate mapping area.
In technique scheme, preferably, as shown in Figure 3, step 204, specifically comprises: step 302: set up multiple intersection region be made up of row, column condition, travels through all index cells; Step 304: after all index cells have traveled through, in each mapping area, preserves the position that row/column condition should occur in MDX inquiry, and generates MDX; Step 306: based on the MDX generated, each intersection region is calculated.
In technique scheme, preferably, step 304, also comprises: when generating MDX, according to the position of MDX, and the dimension member that assembling occurs successively or the tuple by multiple dimension member composition, be set to Hash table form by the mode that ranks condition stores.
In technique scheme, preferably, step 304 generates the operation of MDX, comprises further: each the row/column position in (1) circulation row/column set of circumstances; (2) get corresponding member set according to position; (3) whether multielement in set, if it is spells tuple, if not then spelling dimension member.
Technical scheme of the present invention, provide a kind of report form figure selection condition generation technique based on multidimensional analysis theory, be applicable to by the dimension in the multidimensional analysis models of service-oriented design and tolerance, by different set-up modes, generate different acquisition conditions, be finally reached through the object that multidimensional analysis models gets report data.
Along with the develop rapidly of enterprise, user, for the acquisition mode of report data, more and more trends towards the data grabber of service-oriented; In existing a lot of form product, all carry out report making at use formula, although simplify the operation of user, also also bring a lot of problem thereupon, such as user is figure selection formula: A6=F (' B6') at certain cell definition.
Single with regard to A6, what this method can not show that A6 gets actually intuitively is any data, if need to understand, that just must understand implication and the literary style specification thereof of function F (x), and for the producer of table sample and the people of those care Data Sources and business implication, the form of business datum formula to be described, understand formula implication and need a very long very obscure learning process, and we will arrange of this sort formula for each fetch unit lattice, workload is very large.
Therefore, if the acquisition conditions of cell between table sample and table can be designed intuitively, enable user directly go to design table sample thus the object reaching peek according to business demand.This is the foothold of technical scheme of the present invention and problem to be solved.
Technical scheme of the present invention is based on user on the basis establishing multidimensional analysis peek model, as shown in Figure 4.
As shown in Figure 4, the acquisition conditions generating apparatus mentioned in technical scheme of the present invention is arranged in Fig. 4 multidimensional analysis condition and is applied to the part that table sample generates peek region, i.e. multidimensional analysis condition is applied to table sample and generates mapping peek region.In order to target described in actualizing technology scheme, show multidimensional model (data structure) and dimension thereof, tolerance member at foreground partition with tree, and support drag function.The condition that the cell of correspondence will fetch data by user, by pulling the corresponding dimension condition metric in right side, sets up the mapping of acquisition conditions, as shown in Figure 5.
Setting up the prerequisite of acquisition conditions, is set up an intersection region be made up of row, column condition, the operation being undertaken as shown in Figure 6 by user.
As Fig. 5 and Fig. 6, for example first index cell (places 3, D arranges), it is ending balance that row in table sample describe, line description is then money-capital, ranks condition (the dimension of multidimensional model is pulled so respectively from right side, condition metric), the final acquisition conditions of index cell be row condition and row condition and, so until user defines all conditional combination modes (with wardrobe, condition on row head and be as the criterion), when user clicks generation mapping area, backstage automatically to merge can be inquired about by a MDX takes out data, the all indexs being in same square areas are a peek region, and generate the peek MDX in this region, as shown in Figure 5, D6, D7, D8 cell, their row condition is identical, and although row condition condition is different, but all come from same dimension: report item, so a peek region can be merged into, disposable peek can be carried out with a MDX statement.As Fig. 7, after preserving mapping area, in fact do two pieces thing: 1. generate mapping area; 2. generate, and record the peek MDX statement of this mapping area.Condition after pulling is highlighted display in table sample.
Data structure: it is as follows that multidimensional model is illustrated in application data structure on tree construction, by user-defined multidimensional model, is converted to this storage organization, stores as tree-like displaying and dynamic area.
the data structure of dimension is as follows:
the data structure of tolerance is as follows:
the data structure of dimension member is as follows:
| Title | Type | Explanation |
| Title | Character | Member Name |
| Display Name | Character | Member's display Name |
| Unique identification | Character | The unique identification of dimension member |
| Affiliated dimension | Character | The unique identification of affiliated dimension |
These 3 kinds of data structures are unified realizes an interface type, is used as the displaying on one tree.
Pull and generate the explanation of mapping area event principle
In Fig. 5, the event capturing schematic diagram that right side operates multidimensional model as shown in Figure 8.
As shown in Figure 8, when user selects a member in the tree node of right side, the type of event can be monitored in backstage, if mouse click event, switch normally on tree node so exactly, if dragging event, then form panel can monitor mouse release event, when dimension or tolerance member are dragged to certain cell in table by user, automatically the word in this cell can be played up the title into dimension member (or tolerance), and do highlighted display.And in the mapping model on backstage, the map information that pulls stored in user (corresponding relation of row condition, row condition and position thereof, position and condition, the dimension member comprised, tolerance etc.).
Mapping model data structure
In the backstage of form panel realizes, we define 2 data models, and for storing a series of information such as the mapping of user's setting, concrete data structure and usage are summarized as follows:
mapping model:
mapping area model:
After user clicks generation mapping area, can do following process for above-mentioned data structure and finally generate mapping area, structure is as Fig. 9, and the logic of process as shown in Figure 9.
Backstage principle, algorithmic descriptions
In the technical program, one of them of two key points is the generation of mapping area, first will generate mapping area different one by one, the ranks condition in resolution areas of then just going generates MDX statement and preserves in the zone, finally goes the calculating carrying out each region.Generate the generation that mapping area the most important thing is mapping area.Therefore, when storing, we apply the algorithm of lower column-generation mapping area:
(1) from left to right, from top to bottom, each index cell of searching loop.
With current criteria cell for benchmark, the all non-index cells of Look-ahead, record position and dimension (tolerance) member are related to mapping model, until can not find forward non-index cell, or the non-index cell found is in other mapping area
(3) record all row conditions of current cell, line number, row dimension;
With current criteria cell for benchmark, upwards search all non-index cells, record position and dimension (tolerance) member are related to mapping model, until upwards can not find non-index cell, or the non-index cell found is in other mapping area
(5) record all row conditions of current cell, row number, row dimension
(6) circulate each mapping area, if this cell and this mapping area neighbour (having the row or column of intersecting), then judge each ranks condition of this cell, if the row dimension set of this cell, the row dimension in the set of row dimension and this region, the set of row dimension is consistent, and unanimously (quantity is identical to measure direction, the dimension comprised is identical), then think that this cell can join in this region, at this moment, by the ranks number of this cell, ranks dimension, ranks dimension member, tolerance member and tolerance direction, fill successively according to the data structure of mapping area model, and expand this region (reproducing mark area starting point), if row dimension, the set of row dimension is inconsistent, or the tolerance inconsistent explanation in direction needs to create new mapping area, then with the ranks number of current cell, ranks dimension, the mapping area that ranks dimension member is new for initial value creates, and join in the mapping area model Hash table of mapping model.
By above-mentioned algorithm, namely complete the generation of mapping area.And the inquiry MDX of mapping area does not also specify.Next step is exactly the MDX of this mapping area will be assembled, to be supplied to computing unit when calculating.
After all index cells have traveled through, in each mapping area, position that row/column condition should occur in MDX inquiry is preserved (in algorithm 3 in capital, the thing part wherein that 5 steps are done), so that when generating MDX, according to its position, assemble the dimension member tuple of multiple dimension member composition (or by) occurred successively, the mode that ranks condition stores is with Hash table form, key is the order occurred, value is then an object, represent all dimension members (or tolerance) that should occur in this order, if single dimension member then directly spells, if multiple, spell tuple.Such as in this mapping area of upper figure, row condition store mode with regard to shape as:
< sequence number 1, dimension member array 1>
< sequence number 2, dimension member array 2>
< sequence number 3, dimension member array 3>
.....
MDX inquiring technology in the multidimensional analysis of herein applying, full name is MultiDimensional Expressions, is the OLAP query language of standard.As SQL query, each MDX inquiry requires request of data (SELECT clause), starting point (FROM clause) and screening (WHERE clause).These key words and other key word provide various instrument, the specific part of the data that are used for extracting from cube.MDX additionally provides reliable collection of functions, is used for operating retrieved data, also has the ability with user-defined function expansion MDX simultaneously.MDX is that multi-dimensional database provides expression formula query grammar, for inquiring about Cube data, and provides many powerful analytic functions, for supporting the olap analysis commonly used
Above mention, ranks condition is stored in mapping area according to sequence of positions, illustrates with Fig. 4, and we wish that the data gone out by multi-dimensional query are also the results that 3 row 1 arrange, and the first row corresponding be exactly the data of money-capital, by that analogy.The MDX that so we are generating just must be combined into shape as following mdx, and the order that dimension member occurs is the sequence of positions according to mapping area:
Select{ [tolerance]. [generation number] } ON COLUMNS,
[dimension 1]. [member 1 of dimension 1],
[dimension 1]. [member 2 of dimension 1],
[dimension 1]. [member 3 of dimension 1]
}ON ROWS
From [multidimensional model]
Where{ [section dimension]. [section dimension member] }, [time dimension]. [2013] } ...
Like this, the data inquired from multidimensional fact table are only the structure of the bivariate table that 3 row 1 arrange.
According to the structure that the ranks condition described in above-mentioned literary composition is preserved, devise the algorithm generating MDX, process flow diagram as shown in Figure 10.
Algorithm core describes (OK, the algorithm of row is identical):
(1) each the row/column position in circulation row/column set of circumstances
(2) get corresponding member set according to position
(3) whether multielement in set, if it is spells tuple, if not then spelling dimension member
As Fig. 8, in each area, all have recorded dimension that this region occurs, tolerance and their member, the information such as the sequence of positions of member when spelling residing for it.According to these, just complete description can go out the MDX statement completely corresponding with the mapping area of table sample, the results set inquired according to this statement just meets the column locations that it should occur in table sample completely.
By above description, by means of technical scheme of the present invention, finally achieve " a kind of report form figure selection condition generating apparatus based on multidimensional analysis theory, its beneficial effect:
(1) support the flexible setting of report form figure selection, and compare formula and semantic model are more partial to the peek Design Mode based on business.Make it can peek and the mode put forth effort on and learn product and peek for business of need not taking time according to business customizing, for the peek of form service definition provides basis;
(2) reduce business personnel and learn the time cost of product and the implementation cost of the personnel of enforcement, make it need not put forth effort on the study realized product function, and more pay attention to the definition to capturing service data area and condition.
Technical scheme of the present invention generates report form figure selection condition based on multidimensional technology, and multidimensional peek model is that user can customize, and be the multidimensional analysis models based on business, and when being defined into table sample, also be based on business completely and support to pull form, and need not defined formula.
More than be described with reference to the accompanying drawings technical scheme of the present invention, considered in correlation technique there is no easy, the unified solution generated for complicated type condition.Existing condition generates the condition generative process that cannot complete complicated type and participate in.Therefore, the present invention proposes a kind of report form figure selection condition generating apparatus and a kind of report form figure selection condition generation method, can on existing condition generating mode basis, make full use of the condition generation that single object type completes multi-object type, set up general, the unified generation thinking of the condition generation that multi-object type participates in.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a report form figure selection condition generating apparatus, is characterized in that, comprising:
Data structure storage unit, for peek based on predefined multidimensional analysis model and data structure, at foreground partition with the drag function of tree display data structure and dimension thereof, tolerance member and support, and data structure is converted to this storage organization, for showing tree structure and storing dynamic area;
Mapping area generation unit, for the storage organization of conversion is applied to table sample, by pulling the corresponding dimension condition metric in right side, sets up the mapping of acquisition conditions, generating and mapping peek region;
Mapping model data structure storage unit, after generating mapping area, on the backstage of form panel, definition mapping model and mapping area model, store the map information that user is arranged.
2. report form figure selection condition generating apparatus according to claim 1, is characterized in that, described mapping area generation unit, by pulling the corresponding dimension condition metric in right side, is set up the mapping of acquisition conditions, generated the operation mapping peek region, comprise further:
(1) pull row condition to wardrobe;
(2) pull row condition to row head;
(3) click and generate mapping area.
3. report form figure selection condition generating apparatus according to claim 1 and 2, is characterized in that, described mapping area generation unit, specifically comprises:
Intersection region generation module, for setting up multiple intersection region be made up of row, column condition, travels through all index cells;
MDX statement generates and preserves module, after having traveled through when all index cells, in each mapping area, preserves the position that row/column condition should occur in MDX inquiry, and generates MDX;
Area calculation module, for based on the MDX generated, calculates each intersection region.
4. report form figure selection condition generating apparatus according to claim 3, it is characterized in that, described MDX statement generates and preserves module, also for when generating MDX, according to the position of MDX, the dimension member that assembling occurs successively or the tuple by multiple dimension member composition, be set to Hash table form by the mode that ranks condition stores.
5. report form figure selection condition generating apparatus according to claim 3, is characterized in that, described MDX statement generates and preserves the operation of CMOS macro cell MDX, comprises further:
(1) each the row/column position in circulation row/column set of circumstances;
(2) get corresponding member set according to position;
(3) whether multielement in set, if it is spells tuple, if not then spelling dimension member.
6. a report form figure selection condition generation method, is characterized in that, comprising:
Step 202: based on predefined multidimensional analysis peek model and data structure, at foreground partition with the drag function of tree display data structure and dimension thereof, tolerance member and support, and data structure is converted to this storage organization, for showing tree structure and storing dynamic area;
Step 204: the storage organization of conversion is applied to table sample, by pulling the corresponding dimension condition metric in right side, setting up the mapping of acquisition conditions, generating and mapping peek region;
Step 206: after generating mapping area, on the backstage of form panel, definition mapping model and mapping area model, store the map information that user is arranged.
7. report form figure selection condition generation method according to claim 6, is characterized in that, described step 204, by pulling the corresponding dimension condition metric in right side, is set up the mapping of acquisition conditions, generated the operation mapping peek region, comprise further:
(1) pull row condition to wardrobe;
(2) pull row condition to row head;
(3) click and generate mapping area.
8. the report form figure selection condition generation method according to claim 6 or 7, it is characterized in that, described step 204, specifically comprises:
Step 302: set up multiple intersection region be made up of row, column condition, travels through all index cells;
Step 304: after all index cells have traveled through, in each mapping area, preserves the position that row/column condition should occur in MDX inquiry, and generates MDX;
Step 306: based on the MDX generated, each intersection region is calculated.
9. report form figure selection condition generation method according to claim 8, it is characterized in that, described step 304, also comprise: when generating MDX, according to the position of MDX, the dimension member that assembling occurs successively or the tuple by multiple dimension member composition, be set to Hash table form by the mode that ranks condition stores.
10. report form figure selection condition generation method according to claim 8, it is characterized in that, described step 304 generates the operation of MDX, comprises further:
(1) each the row/column position in circulation row/column set of circumstances;
(2) get corresponding member set according to position;
(3) whether multielement in set, if it is spells tuple, if not then spelling dimension member.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410757407.9A CN104361137A (en) | 2014-12-10 | 2014-12-10 | Device and method for generating data fetching conditions of report form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410757407.9A CN104361137A (en) | 2014-12-10 | 2014-12-10 | Device and method for generating data fetching conditions of report form |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104361137A true CN104361137A (en) | 2015-02-18 |
Family
ID=52528397
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410757407.9A Pending CN104361137A (en) | 2014-12-10 | 2014-12-10 | Device and method for generating data fetching conditions of report form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104361137A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105404608A (en) * | 2015-10-27 | 2016-03-16 | 中通服公众信息产业股份有限公司 | Formula analysis based complicated index set calculation method and system |
| CN105447098A (en) * | 2015-11-10 | 2016-03-30 | 中国建设银行股份有限公司 | Information inquiring method and apparatus |
| CN107861998A (en) * | 2017-10-19 | 2018-03-30 | 用友网络科技股份有限公司 | Introduction method, device and the computer equipment of business datum |
| CN109189861A (en) * | 2018-06-29 | 2019-01-11 | 深圳市彬讯科技有限公司 | Data stream statistics method, server and storage medium based on index |
| CN109213811A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN109325648A (en) * | 2018-06-29 | 2019-02-12 | 深圳市彬讯科技有限公司 | Multi-dimensional data stream statistics method, server and storage medium based on index |
| CN110633267A (en) * | 2019-09-29 | 2019-12-31 | 山东浪潮通软信息科技有限公司 | Method and system capable of supporting multiple services to perform report function |
| CN111078679A (en) * | 2019-12-23 | 2020-04-28 | 用友网络科技股份有限公司 | Data report generation method and device and computer readable storage medium |
| CN111241091A (en) * | 2019-12-29 | 2020-06-05 | 南京云帐房网络科技有限公司 | Distributed column-type data storage conversion method and system for business report data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1482432A2 (en) * | 2003-05-27 | 2004-12-01 | Cognos Incorporated | System and method of modelling of a multi-dimensional data source in an entity-relationship model |
| CN102841938A (en) * | 2012-08-14 | 2012-12-26 | 北京久其软件股份有限公司 | Method and system for generating parameterized report |
| CN103164222A (en) * | 2013-02-25 | 2013-06-19 | 用友软件股份有限公司 | Multidimensional modeling system and multidimensional modeling method |
| CN103678590A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Report collecting device and report collecting method based on OLAP |
-
2014
- 2014-12-10 CN CN201410757407.9A patent/CN104361137A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1482432A2 (en) * | 2003-05-27 | 2004-12-01 | Cognos Incorporated | System and method of modelling of a multi-dimensional data source in an entity-relationship model |
| CN102841938A (en) * | 2012-08-14 | 2012-12-26 | 北京久其软件股份有限公司 | Method and system for generating parameterized report |
| CN103164222A (en) * | 2013-02-25 | 2013-06-19 | 用友软件股份有限公司 | Multidimensional modeling system and multidimensional modeling method |
| CN103678590A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Report collecting device and report collecting method based on OLAP |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105404608A (en) * | 2015-10-27 | 2016-03-16 | 中通服公众信息产业股份有限公司 | Formula analysis based complicated index set calculation method and system |
| CN105447098A (en) * | 2015-11-10 | 2016-03-30 | 中国建设银行股份有限公司 | Information inquiring method and apparatus |
| CN105447098B (en) * | 2015-11-10 | 2018-12-14 | 中国建设银行股份有限公司 | A kind of information query method and device |
| CN109213811A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN107861998B (en) * | 2017-10-19 | 2020-05-15 | 用友网络科技股份有限公司 | Business data importing method and device and computer equipment |
| CN107861998A (en) * | 2017-10-19 | 2018-03-30 | 用友网络科技股份有限公司 | Introduction method, device and the computer equipment of business datum |
| CN109189861A (en) * | 2018-06-29 | 2019-01-11 | 深圳市彬讯科技有限公司 | Data stream statistics method, server and storage medium based on index |
| CN109325648A (en) * | 2018-06-29 | 2019-02-12 | 深圳市彬讯科技有限公司 | Multi-dimensional data stream statistics method, server and storage medium based on index |
| CN110633267A (en) * | 2019-09-29 | 2019-12-31 | 山东浪潮通软信息科技有限公司 | Method and system capable of supporting multiple services to perform report function |
| CN110633267B (en) * | 2019-09-29 | 2023-09-29 | 浪潮通用软件有限公司 | Method and system capable of supporting multi-service report function |
| CN111078679A (en) * | 2019-12-23 | 2020-04-28 | 用友网络科技股份有限公司 | Data report generation method and device and computer readable storage medium |
| CN111078679B (en) * | 2019-12-23 | 2023-06-16 | 用友网络科技股份有限公司 | Method and device for generating data report and computer readable storage medium |
| CN111241091A (en) * | 2019-12-29 | 2020-06-05 | 南京云帐房网络科技有限公司 | Distributed column-type data storage conversion method and system for business report data |
| CN111241091B (en) * | 2019-12-29 | 2023-05-16 | 云帐房网络科技有限公司 | Distributed column type data storage conversion method and system for business report data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104361137A (en) | Device and method for generating data fetching conditions of report form | |
| Storey et al. | Big data technologies and management: What conceptual modeling can do | |
| Bondarev et al. | Data warehouse on Hadoop platform for decision support systems in education | |
| Adiba et al. | Big data management challenges, approaches, tools and their limitations | |
| Zheng et al. | Research on intelligent product conceptual design based on cognitive process | |
| Todorova et al. | A system supporting qualitative research | |
| Jong et al. | An integrated application for historical knowledge management with mould design navigating process | |
| Andrews et al. | Knowledge discovery through creating formal contexts | |
| Vattam et al. | Semantically annotating research articles for interdisciplinary design | |
| Khalil et al. | New approach for implementing big datamart using NoSQL key-value stores | |
| Ledesma et al. | Educational tool for generation and analysis of multidimensional modeling on data warehouse | |
| JP2002140332A (en) | Feature quantity importance calculation method, and keyword image feature quantity expression database generation and image database retrieval using the same | |
| Lane et al. | Eyeing the patterns: Data visualization using doubly-seriated color heatmaps | |
| Hanssen | Digital Humanities and Theatre Studies: New Perspectives on the Early Reception of Ibsen on the German Stage | |
| Maria Brunetti et al. | User-centered design and evaluation of overview components for semantic data exploration | |
| Lapray et al. | " Bigger Data" Visualization to Visual Analytics: a path to Innovation." Happening, definitely! Misleading, possibly?" A review of some examples applicable to IP Discovery | |
| Zaman et al. | Knowledge Mapping for Research Papers | |
| Loudcher et al. | Olap on complex data: Visualization operator based on correspondence analysis | |
| Wu | Environment for Large Data Processing and Visualization Using MongoDB | |
| Xiao et al. | CKM: a shared visual analytical tool for large-scale analysis of audio-video interviews | |
| Hung et al. | Digital Texts and GIS: The interrogation and coordinated visualization of Classical Chinese texts | |
| Huang | Research on Digital Protection Education of Red Culture Based on Big Data Technology | |
| Kang et al. | News Data Analysis System Based on UML and Computer Aided Technology | |
| Imran et al. | NODW Framework for Data Warehousing-A NoSQL Big Data Perspective | |
| Du et al. | Visual guidance in the exploration of large databases |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant before: UFIDA Software Co., Ltd. |
|
| COR | Change of bibliographic data | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150218 |
|
| RJ01 | Rejection of invention patent application after publication |