CN105095249A - Method generating multi-dimension report form - Google Patents
Method generating multi-dimension report form Download PDFInfo
- Publication number
- CN105095249A CN105095249A CN201410185949.3A CN201410185949A CN105095249A CN 105095249 A CN105095249 A CN 105095249A CN 201410185949 A CN201410185949 A CN 201410185949A CN 105095249 A CN105095249 A CN 105095249A
- Authority
- CN
- China
- Prior art keywords
- field
- data
- content
- database
- data content
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method generating a multi-dimension report form. The method comprises the following steps of setting a multi-dimension report form structure and editing header contents, binding each unit of the report form with database fields and adding logical relationship limit to the database fields, checking body data content corresponding to each database field and linked data content corresponding to related database fields in the database, based on the header structure and the header content, filling the checked body data content and linked data content into the corresponding units to generate the multi-dimension report form. Multi-form data can be flexibly displayed via the multi-dimension report form and specific fields can be dug and displayed in a layering form; user operation can be modularized for multi-time use, so user operation steps can be reduced; and usability and practicality of self-defined report can be improved.
Description
Technical field
The present invention relates to develop computer software field, relate to a kind of method generating multi-dimensional report specifically.
Background technology
Form can help accessed enterprise, formatted data, and data message is presented to user in safe and reliable mode.Utilize the function of computer processing data and interface to generate, show form, its principal feature is Data Dynamic, form variation, and realizes being separated completely of report data and statement form.
But for existing report-building tool, when generating report forms, be limited to the database table structure of database, cannot the data content being filled into form unit be set flexibly, generally simply can only enumerate the data content of one or more source table, multilist data can not be shown flexibly.
And mostly report-building tool screening data content, sort, gathering etc. is when arranging, only provide the method for user oneself input database query statement of allowing, and the query sentence of database realized corresponding to these functions is more more complicated than general inquiry statement, unprofessional user is difficult to grasp, the ease for use of software is reduced greatly.
Simultaneously, data content is existed to the field of hierarchical relationship, such as department name field, may some department be wherein the subdivision of another department, user needs to fill form unit successively according to the level of department, form total separation structure, this needs to carry out data mining to only field, and then classification is shown in multiple form unit.Existing report tool is not supported to show with corresponding the excavation of the hierarchical relationship in only field.
Therefore, for the problems referred to above, need a kind of new report form generation method to excavate more flexibly and display data content.
Summary of the invention
The form generated for existing report-building tool can not excavate and the problem of display data content flexibly, and the invention provides a kind of method generating multi-dimensional report, described method comprises following steps:
Step one, arranges the structure of multi-dimensional report to be generated, edits the gauge outfit content of described form;
Step 2, binds unit each in described form and Database field, and adds logical relation restriction to described Database field, in order to associate the Database field thus the data dimension increasing this unit that comprise respective logic connection;
Step 3, inquires about the associated data content that ontology data content corresponding to each described Database field is corresponding with the Database field associated in a database;
Step 4, based on the structure of described form, described gauge outfit content by described ontology data content and described associated data fills in the unit of correspondence, thus generate multi-dimensional report.
According to one embodiment of present invention, in described step 2, multiple described Database field is added and mutually patrols according to one embodiment of present invention, in described step 2, the Database field added after logical relation restriction comprises set membership and excavates field, and described set membership is excavated field and comprised identification field, content field, father's identification field, sub-identification field.
According to one embodiment of present invention, excavate by limiting described set membership the dimension that the excavating depth of field determines the Database field of the association based on paternal or subsystem logical relation.
According to one embodiment of present invention, inquire about set membership in a database and excavate the ontology data content corresponding to field and the additional data content excavating the respective dimensions corresponding to field based on described excavating depth inquiry set membership, and described ontology data content and described additional data content are filled in corresponding unit.
According to one embodiment of present invention, described step 2 also comprises adds data screening condition setting and/or data exhibiting setting to described unit, and described data exhibiting arranges and comprises lifting/lowering sequence spread configuration, cell gathering setting; Described data exhibiting arranges and also comprises data mining setting, for determining the data exhibiting mode of described unit to additional data content perhaps described in described ontology data.
According to one embodiment of present invention, described logical relation limits, described data screening condition setting to utilize term restriction statement to add, and completes described step 3 based on described logical relation restriction, described data screening condition setting.
According to one embodiment of present invention, described method also comprises step 5, and this step comprises:
According to the data that described content lifting/lowering sequence spread configuration sorts in described unit;
Assemble the unit arranging and search and specify overbunching according to described cell, travel through all cells that described unit comprises, adjacent same value cell is merged;
Stratification is set according to described data mining and shows described ontology data content and described additional data content, the logical relation between reflection data content.
According to one embodiment of present invention, described method also comprises step 6, sets up self-defining Report Operations flow template and store described Report Operations flow template based on the operating process information in the generative process of described form.
According to one embodiment of present invention, described operating process packets of information arranges containing described gauge outfit content, the structure of described form, described data screening condition setting, described data exhibiting, is bundled in Database field on described unit or set membership excavates field, the logical relation be added on described Database field limits.
Compared with prior art, tool of the present invention has the following advantages:
1, the multi-dimensional report generated according to the method for the invention can show multilist data flexibly;
2, the multi-dimensional report generated according to the method for the invention can carry out data mining and stratification display to specific fields, has stronger data exhibiting ability;
3, according to the method for the invention by user operation templating repeatedly to utilize, reduce user operation step, improve the ease for use of self-defined report, practicality.
Other features and advantages of the present invention will be set forth in the following description, and, partly become apparent from instructions, or understand by implementing the present invention.Object of the present invention and other advantages realize by step specifically noted in instructions, claims and accompanying drawing and obtain.
Accompanying drawing explanation
Accompanying drawing is used to provide a further understanding of the present invention, and forms a part for instructions, with embodiments of the invention jointly for explaining the present invention, is not construed as limiting the invention.In the accompanying drawings:
Fig. 1 is the process flow diagram according to one embodiment of the invention generating report forms;
Fig. 2 is top-of-form set software effect sectional drawing according to an embodiment of the invention;
Fig. 3 be merge according to an embodiment of the invention, the software effect sectional drawing of split cell;
Fig. 4 is the software effect sectional drawing of binding data storehouse field according to an embodiment of the invention;
Fig. 5 binds set membership to excavate the software effect sectional drawing that arrives of field according to an embodiment of the invention;
Fig. 6 is the software effect sectional drawing of data exhibiting setting according to an embodiment of the invention;
Fig. 7 is the software effect sectional drawing of data screening condition setting according to an embodiment of the invention;
Fig. 8 is the multi-dimensional report effect sectional drawing generated according to one embodiment of the invention;
Fig. 9 is the software effect sectional drawing of Report Operations flow template loading according to an embodiment of the invention, deletion, preservation.
Embodiment
Describe embodiments of the present invention in detail below with reference to drawings and Examples, to the present invention, how application technology means solve technical matters whereby, and the implementation procedure reaching technique effect can fully understand and implement according to this.It should be noted that, only otherwise form conflict, each embodiment in the present invention and each feature in each embodiment can be combined with each other, and the technical scheme formed is all within protection scope of the present invention.
In addition, can perform in the computer system of such as one group of computer executable instructions in the step shown in the process flow diagram of accompanying drawing, and, although show logical order in flow charts, but in some cases, can be different from the step shown or described by order execution herein.
The flow process of generating report forms is exactly excavate field to Database field corresponding to the different units binding of form and set membership according to one embodiment of present invention, and utilize conditional statement interpolation logical relation restriction and data screening condition setting to link multilist and data screening, and self-defined to the content of gauge outfit.Generate corresponding query sentence of database to perform according to these settings, the data result that acquisition returns also is filled in form, then carry out lifting sequence and cell aggregation operator to form, realizes the generation of final form.
Fig. 1 is the process flow diagram generating multi-dimensional report according to one embodiment of the invention.As shown in Figure 1, first carry out step S120, the structure of multi-dimensional report to be generated is set, the gauge outfit content of editor's form.This step comprises merging and the fractionation of cell, the report heading etc. needed for structure.
Then carry out step S131, unit each in form and Database field are bound.According to one embodiment of the invention, can multilist field bind in this step, the data content corresponding to Database field being namely tied to form unit can from multiple different sources table.Field binding by the selected form unit that will be tied to, and then selects the table of the source corresponding to data that will bind and Database field to realize.
In step S132, add logical relation to Database field to limit, be used for associating the Database field thus the data dimension increasing this unit that comprise respective logic connection, the Database field comprising respective logic connection by association can reach the data shown in multiple source in same unit, associate the object represented.Meanwhile, in step S132, add mutual logical relation to disparate databases field and limit, the interpolation that logical relation limits is realized by term restriction statement, in order to determine the logical relation between the data content that each Database field is corresponding.The different source table making to be presented in form can be interrelated, thus display data content more flexibly.
The Database field added after logical relation restriction comprises set membership and excavates field.Set membership is excavated field and is comprised identification field, content field, father's identification field and sub-identification field.Wherein, content field is the Database field corresponding with ontology data content, and father's identification field, sub-identification field are the field of reflection set membership, and identification field is the identification field that set membership excavates field.
Corresponding data content is existed to the Database field of set membership, obtain ontology data content by given content field, by specifying two fields of reflection set membership, and identification field, obtain the set membership between different pieces of information in this field.Obtain binding the hierarchical relationship between the data content corresponding to field by set membership field, then by identification field by set membership and binding field each row of data one_to_one corresponding.
In step s 141, unit and set membership are excavated field to bind.Then in step S142, excavate by limiting set membership the dimension that the excavating depth of field determines the additional database field based on paternal or subsystem logical relation.Excavating depth, namely obtains what father/subobject of binding field.
In step S133, data screening condition setting is carried out to form unit.The setting of data screening condition, as the interpolation that the logical relation in step S132 limits, is all realized by conditional statement.
In step S150, add data exhibiting arrange form unit, data exhibiting arranges and comprises lifting/lowering sequence spread configuration, cell gathering setting.
In step S160, inquire about ontology data content corresponding to each Database field associated data content corresponding with the Database field associated in a database based on data screening condition setting;
In step S170, based on gauge head structure, gauge outfit content by the ontology data content that inquires and associated data fills in the unit of correspondence, thus generate multi-dimensional report.
In the case, ontology data content is incessantly had in form unit, also comprise with ontology data in have the associated data content of certain logical communication link, thus reach the object representing multi-source table data content in same unit, and because associated data content is that ontology data content prolongs life based on certain logical relation, based on this, the data mining ability of form is embodied.Limiting by changing the logical relation of adding on Database field, comprising the associated data fills of Different Logic contact the most at last in form unit, thus reaching the function of autotelic data mining.
For the unit having bound set membership excavation field, first, in step S160, inquire about each set membership in a database and excavate the ontology data content corresponding to field and inquire about based on excavating depth the additional data content that each set membership excavates the respective dimensions corresponding to field; Then in step 170, described ontology data content and described additional data content are filled in corresponding described unit.
According to one embodiment of the invention, also to arrange according to data exhibiting for the unit of padding data content and data exhibiting is carried out to data in unit.First in step S181, according to the data that described content lifting/lowering sequence spread configuration sorts in described unit; Then in step S182, assemble the unit arranging and search and specify overbunching according to described cell, travel through all cells that described unit comprises, adjacent same value cell is merged.
System after completing data exhibiting step in step S190 generating report forms.The form generated can printout in step S191.
According to method of the present invention, without the need to the setting of the screening of the binding and data content that are realized multilist field by input database query statement, sequence, gathering.For each unit of form, ascending order/descending that its content shows can be specified, and whether the cell span of identical value be become a cell; The restriction that can be worth specific data content is with filtering data; Can gauge outfit ranks size and content be set voluntarily, and merging and the fractionation of cell can be carried out.
Meanwhile, in step S150, data exhibiting arranges and also comprises data mining and arrange, for the data exhibiting mode of determining unit to perhaps additional data content in ontology data.The ways of presentation that can arrange the form comprising multilist data comparatively is neatly set by data exhibiting, data mining and stratification display is carried out to specific fields, thus better realizes data exhibiting function.
Excavate the unit of field for for having bound set membership, data mining is arranged for determining that form unit excavates the data exhibiting mode of perhaps additional data content in ontology data corresponding to field to set membership.Arrange based on data mining, unit carrys out stratification display set membership with multiple row and excavates data content corresponding to field, the set membership between reflection data content.
According to one embodiment of the invention, system can be set up self-defining Report Operations flow template and store described Report Operations flow template based on the operating process information in the generative process of form.Report Operations procedure information comprises gauge outfit content, the structure of form, data screening condition setting, data exhibiting are arranged, be bundled in the Database field on different units or set membership excavates field, the logical relation be added on Database field limits.These information reconfigure generate corresponding Report Operations flow template and be stored in corresponding database by system, realize persistence, repeatedly to use, thus simplify the operation steps of user.
Therefore in the present embodiment before beginning step S120, also first to carry out step S110, judgement is newly-built Report Operations flow template or uses the Report Operations flow template preserved, if the result judged is New Report template, then carry out step S120, if the result judged uses the Report Operations flow template preserved, then call Report Operations flow template, and come by reading Report Operations flow template or skipped some step in ensuing report generation process, thus simplify the generative process of form.
Next described in detail specific implementation process and the implementation result of one embodiment of the invention by multiple software effect sectional drawing.To generate the oil-gas possibility information report of different stage geological type, edit the gauge outfit content of form first as shown in Figure 2 and structure of report is set as shown in Figure 3.Vibrational power flow is merging and the fractionation of cell, can merge after choosing multiple cell, can split after choosing the cell accounting for multirow or multiple row.
Then different Database fields is bound to different unit.In the present embodiment, the data structure of binding field comprises several part below: field is bound to which row of form, and whether whether field information, sort to Query Result, assemble Query Result, the priority level of sequence.Different row are bound to the operation of disparate databases field by the object of the data structure of a newly-built binding field, and fill which row and field information that field is bound to form.
As shown in Figure 4, in the present embodiment, the process of binding data storehouse field first selectes a certain row of form, then the database source table needing binding is chosen, finally select Database field, complete the correspondence binding of row and Database field, the Database field information of having bound can be stored in corresponding data structure by this operation.
Next bind set membership as shown in Figure 5 and excavate field.Binding set membership excavates field needs appointment 4 fields, front 2 fields (father's identification field, sub-identification field) are the field of reflection set membership, and latter two field (identification field, content field) is identification field and the binding field itself of binding field.Obtain binding the hierarchical relationship contained by field between content by set membership field, then by identification field by set membership and binding field each row of data one_to_one corresponding.
Such as, set two fields of set membership as father ID, ID, setting identification field and content field are ID, NAME.Just can obtain the father and son's hierarchical relationship between different I D according to father ID, ID like this, then according to ID, NAME two fields by ID and NAME correspondence, just can obtain the father and son's hierarchical relationship between different N AME.
In the present embodiment, set membership excavates field needs appointment 4 fields to derive from two tables, and a table records set membership specially, comprises father's identification field and sub-identification field, and this shows the set membership contained between all identification fields; Another table records data specially, comprises identification field and content field.The father and son's hierarchical relationship between different identification field just can be obtained like this according to father's identification field, sub-identification field, then according to identification field and content field two fields by identification field and content field correspondence, just can obtain father and son's hierarchical relationship of different content interfield.
In the present embodiment, the data structure that set membership excavates field comprises several part below: field is bound to which row of form, excavating depth, father's identification field, sub-identification field, identification field and content field, the data record that father's identification field, sub-identification field, identification field and content field are all in a database, whether Query Result is sorted, whether Query Result is assembled, the priority level of sequence.Binding set membership excavates the operation of field by the object of the data structure of newly-built set membership excavation field, and fills following a few partial information: field is bound to which row of form, father's identification field, sub-identification field, identification field and content field.After specifying 4 fields, then provide excavating depth, namely obtain what father of binding data storehouse field.In the present embodiment, acquiescence 0 is binding fields itself, and 1 is the one-level parent object binding field, and 2 is the parent object of parent object, by that analogy.Supplementary excavating depth is excavated in field data structure objects to the set membership set up before by this operation.
Next as shown in Figure 6 field is excavated to the Database field bound and set membership and carry out data display setting.It comprises lifting/lowering sequence and arranges and assemble setting.It is that data according to row sort to form that lifting/lowering sequence is arranged, and lifting/lowering sequence arranges and comprises priority and arrange, and when namely multiple row adopt lifting/lowering sequence simultaneously, compares successively decide order by the priority height of row.Assembling setting refers to after generating report forms, if the cell content adjacent in often arranging of form is identical, is then merged into a cell.This operation lifting/lowering sequence and gathering information can be stored into corresponding binding field or set membership is excavated in field data structure.
Carry out data screening condition setting and/or add logical relation to Database field limiting by term restriction statement as shown in Figure 7.In the present embodiment, conditional statement adopts " where " statement." where " statement qualifications arranges and comprises 2 kinds, the first be comprise two fields WITH statement " where Table A. field 1=shows B. field 2 ", build statement by specifying Table A, field 1, table B, field 2.The second is the WITH statement " where Table A field 1 judges symbol judgment value " comprising a field, crosses appointment Table A, field 1, judges that symbol, judgment value build statement.
" where " qualifications data structure comprises following components: left side field information, right side field information, judges symbol, judgment value.For the first operation, selected two fields can be filled into left side field information, in the field information of right side; For the second operation, selected field can be filled in the field information of left side, judgements be accorded with (=, >, <, >=, <=) and judgment value filling is entered.
After being more than provided with, finally carry out generating report forms.First gauge outfit content and structure of report are stored in the data structure of gauge outfit data by system, and the data structure of gauge outfit data comprises following components: OK, row, row size, row size, content.When creating form, user face is directly to inputting gauge outfit content in form, and these contents and place ranks, shared ranks number all can be stored in gauge outfit content data structure.Then inquire about data corresponding to father's identification field, sub-identification field, identification field and content field in a database, and be filled into the data content portion of the data structure representing set membership excavation field.
Next, system can build the Structured Query Language (SQL) (StructuredQueryLanguage of generating report forms, be called for short SQL) statement, " select " part of statement comprises the field name of each binding field and affiliated table name claims, and each set membership excavates the identification field title of field and affiliated table name claims, form be " table name. field name "; The database table of " from " part corresponding to them; " where " part is statement contained in " where " qualifications data structure, and many WITH statements are connected by " and ".
In the present embodiment, suppose that binding field comprises two objects, first object field information is Table A, field 1, and lifting/lowering sequence information is ascending order, and whether assemble is yes, and lifting sequence priority is 0; Second object field information is table B, field 2, and lifting/lowering sequence information is descending, and whether assemble is no, and lifting sequence priority is 1;
And suppose that set membership is excavated field and comprised an object, excavating depth is 2, father's identification field is table C, field 3, sub-identification field is table D, field 4, identification field is table E, field 5, and content field is table F, field 6, and lifting/lowering sequence information is ascending order, whether gathering is yes, and lifting sequence priority is 2;
Also suppose that " where " qualifications comprises two objects, first left field of object is table G, field 7, and right field is table H, field 8; Second left field of object is Table I, field 9, and differentiate that symbol is >=, discriminant value is 100.
The SQL statement so generated is select Table A. field 1, table B. field 2, table E. field 5from Table A, table B, table Ewhere shows G. field 7=and shows H. field 8and Table I. and field 9>=100.
System performs the query statement of generation in a database and returns results collection, reads outcome record one by one, is then filled in the row of binding corresponding to field.Field is excavated for set membership, after obtaining the value (this record value assignment to variable value) of the outcome record of identification field, according to excavating depth, (default is n), in father's identification field, sub-identification field, need to carry out n time and travel through the ident value finding the n level parent object of this value.Its concrete implementation method is: in sub-identification field, searching value is the row of value, obtain its line number and (suppose that line number is a), then obtaining line number in father's identification field is the record value of the row of a, and by this record value assignment to value, now the value of value is the ident value of one-level parent object.Next repeat aforesaid operations with this new value, after carrying out n operation, just obtain the ident value of n level parent object.Then in identification field, content field, according to n level parent object ident value, obtain the value of the content field corresponding to ident value, this value is filled in form and binds in the row of set membership excavation corresponding to field.
Query Result such as corresponding to the table E. field 5 obtained in above-mentioned statement, asks for the content of its 2 grades of parent objects.
Its process is: before setting up SQL statement, first inquires set membership in a database and excavates data corresponding to 4 fields that field comprises, and by data stuffing to representing that set membership is excavated in the data content portion of the data structure of field.Namely in the above example, use a statement in advance: " select shows C. field 3; table D. field 4; table E. field 5, shows F. field 6from and shows C, table D; table E; table F " inquires about database, and is filled into by result data in set membership excavation field data structure objects, and all records that these 4 fields are corresponding in a database store.Then utilize the data that these store, carry out the content calculating 2 grades of parent objects.
In Query Result for above-mentioned SQL statement, a Query Result record (remembering that its value is ID1) corresponding to table E. field 5, first in the table C. field 3 representing set membership, during table D. field 4 records, find the identification field of 2 grades of parent objects corresponding to ID1, method is that searching value is the record of ID1 in table D. field 4 records, if the value of m record is ID1, then in table C. field 3, obtain the value (remembering that its value is ID2) of m record, then represent that the ID of 1 grade of parent object of ID1 is ID2; Then in table D. field 4 records, searching value is the record of ID2, and such as the value of the n-th record is ID2, and in table C. field 3, then obtain the value (remembering that its value is ID3) of the n-th record, then the identification field of 2 grades of parent objects of ID1 is ID3.
Finally find out the contents value that identification field is the object of ID3 again, then obtain the contents value of 2 grades of parent objects of ID1.Concrete operations are in the table E. field 5 representing mark and content relation, during table F. field 6 records, seek table E. field 5 and record the record that intermediate value is ID3, if the value of a kth record is ID3, then in table F. field 6, obtain the value of a kth record, be such as " xxx " that then the contents value of these 2 grades of parent objects corresponding to Query Result record is " xxx ".
Next, system excavates lifting/lowering sequence information contained in field and Sort Priority according to binding field and set membership, sorts to report data part.The determining method of the sequencing between two row is according to priority just, compares the value of the row of specifying lifting sequence successively, then goes and the exchange of going.The implementation method of assembling is the row to specifying overbunching, travels through its row, and is merged by adjacent same value cell.So far, as shown in Figure 8, final form has generated complete and has shown.
As shown in Figure 9, user-defined form can save as template to use from now on.Template storage is divided into 2 kinds of situations, the first is after generating report forms, now gauge outfit content and structure of report, binding field, set membership are excavated data (do not comprise set membership and excavate in field the data division stored contained by field, calculate during this portions per generating report forms temporarily) in four kinds of data structures corresponding to field, ' where ' qualifications stored in database.The second is non-generating report forms, and the report heading content of now first user being filled and structure of report are stored in the data structure of gauge outfit data, then perform the step in the first situation.
Although the embodiment disclosed by the present invention is as above, the embodiment that described content just adopts for the ease of understanding the present invention, and be not used to limit the present invention.The method of the invention also can have other various embodiments; when not deviating from essence of the present invention; those of ordinary skill in the art are when making various corresponding change and distortion according to the present invention, but these change accordingly and are out of shape the protection domain that all should belong to claim of the present invention.
Claims (10)
1. generate a method for multi-dimensional report, it is characterized in that, described method comprises following steps:
Step one, arranges the structure of multi-dimensional report to be generated, edits the gauge outfit content of described form;
Step 2, binds unit each in described form and Database field, and adds logical relation restriction to described Database field, in order to associate the Database field thus the data dimension increasing this unit that comprise respective logic connection;
Step 3, inquires about the associated data content that ontology data content corresponding to each described Database field is corresponding with the Database field associated in a database;
Step 4, based on the structure of described form, described gauge outfit content by described ontology data content and described associated data fills in the unit of correspondence, thus generate multi-dimensional report.
2. the method for claim 1, is characterized in that, in described step 2, adds mutual logical relation limit, in order to determine the logical relation between the data content that each Database field is corresponding multiple described Database field.
3. the method for claim 1, it is characterized in that, in described step 2, the Database field added after logical relation restriction comprises set membership and excavates field, and described set membership is excavated field and comprised identification field, content field, father's identification field, sub-identification field.
4. method as claimed in claim 3, is characterized in that, the excavating depth excavating field by limiting described set membership determines the dimension of the Database field of the association based on paternal or subsystem logical relation.
5. method as claimed in claim 4, it is characterized in that, inquire about set membership in a database and excavate the ontology data content corresponding to field and the additional data content excavating the respective dimensions corresponding to field based on described excavating depth inquiry set membership, and described ontology data content and described additional data content are filled in corresponding unit.
6. the method according to any one of claim 1-5, it is characterized in that, described step 2 also comprises adds data screening condition setting and/or data exhibiting setting to described unit, and described data exhibiting arranges and comprises lifting/lowering sequence spread configuration, cell gathering setting; Described data exhibiting arranges and also comprises data mining setting, for determining the data exhibiting mode of described unit to additional data content perhaps described in described ontology data.
7. method as claimed in claim 6, is characterized in that, described logical relation limits, described data screening condition setting to utilize term restriction statement to add, and completes described step 3 based on described logical relation restriction, described data screening condition setting.
8. method as claimed in claim 7, it is characterized in that, described method also comprises step 5, and this step comprises:
According to the data that described content lifting/lowering sequence spread configuration sorts in described unit;
Assemble the unit arranging and search and specify overbunching according to described cell, travel through all cells that described unit comprises, adjacent same value cell is merged;
Stratification is set according to described data mining and shows described ontology data content and described additional data content, the logical relation between reflection data content.
9. method as claimed in claim 8, it is characterized in that, described method also comprises step 6, sets up self-defining Report Operations flow template and store described Report Operations flow template based on the operating process information in the generative process of described form.
10. method as claimed in claim 9, it is characterized in that, described operating process packets of information is arranged containing described gauge outfit content, the structure of described form, described data screening condition setting, described data exhibiting, be bundled in Database field on described unit or set membership excavates field, the logical relation be added on described Database field limits.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410185949.3A CN105095249B (en) | 2014-05-05 | 2014-05-05 | A method of generating multi-dimensional report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410185949.3A CN105095249B (en) | 2014-05-05 | 2014-05-05 | A method of generating multi-dimensional report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105095249A true CN105095249A (en) | 2015-11-25 |
| CN105095249B CN105095249B (en) | 2018-12-21 |
Family
ID=54575707
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410185949.3A Active CN105095249B (en) | 2014-05-05 | 2014-05-05 | A method of generating multi-dimensional report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105095249B (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106294301A (en) * | 2016-08-09 | 2017-01-04 | 广州唯品会信息科技有限公司 | Report form generation method and device |
| CN106407171A (en) * | 2016-11-03 | 2017-02-15 | 华能澜沧江水电股份有限公司 | System and method for generating safety monitoring custom report based on tree structure |
| CN106933906A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The querying method and device of data multidimensional degree |
| CN107704523A (en) * | 2017-09-11 | 2018-02-16 | 阿里巴巴集团控股有限公司 | Data multidimensional display control method, device and system |
| CN109213811A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN109213979A (en) * | 2017-07-03 | 2019-01-15 | 珠海金山办公软件有限公司 | Method, apparatus, electronic equipment and the storage medium that electrical form is screened |
| CN109213776A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN110019309A (en) * | 2017-12-29 | 2019-07-16 | 北京小度信息科技有限公司 | Data access method, device, electronic equipment and computer readable storage medium |
| CN110532254A (en) * | 2018-05-25 | 2019-12-03 | 杭州海康威视数字技术股份有限公司 | The method and apparatus of fused data table |
| CN112506942A (en) * | 2020-10-29 | 2021-03-16 | 望海康信(北京)科技股份公司 | Data combination query method, system and corresponding equipment and storage medium |
| CN113032633A (en) * | 2021-04-15 | 2021-06-25 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| CN114780084A (en) * | 2022-06-22 | 2022-07-22 | 成都七柱智慧科技有限公司 | Configuration software for collaborative design of multiple types of interactive interfaces |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020169777A1 (en) * | 2001-03-15 | 2002-11-14 | Liviu Balajel | Database architecture and method |
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| CN101901211A (en) * | 2010-07-06 | 2010-12-01 | 北京科技大学 | Processing method of report form |
| CN102436498A (en) * | 2011-11-14 | 2012-05-02 | 深圳市华力特电气股份有限公司 | Report form generating method and relative device |
-
2014
- 2014-05-05 CN CN201410185949.3A patent/CN105095249B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020169777A1 (en) * | 2001-03-15 | 2002-11-14 | Liviu Balajel | Database architecture and method |
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| CN101901211A (en) * | 2010-07-06 | 2010-12-01 | 北京科技大学 | Processing method of report form |
| CN102436498A (en) * | 2011-11-14 | 2012-05-02 | 深圳市华力特电气股份有限公司 | Report form generating method and relative device |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106933906B (en) * | 2015-12-31 | 2020-05-22 | 北京国双科技有限公司 | Data multi-dimensional query method and device |
| CN106933906A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The querying method and device of data multidimensional degree |
| CN106294301A (en) * | 2016-08-09 | 2017-01-04 | 广州唯品会信息科技有限公司 | Report form generation method and device |
| CN106294301B (en) * | 2016-08-09 | 2020-10-13 | 广州品唯软件有限公司 | Report generation method and device |
| CN106407171A (en) * | 2016-11-03 | 2017-02-15 | 华能澜沧江水电股份有限公司 | System and method for generating safety monitoring custom report based on tree structure |
| CN106407171B (en) * | 2016-11-03 | 2023-09-26 | 华能澜沧江水电股份有限公司 | Tree structure-based security monitoring custom report generation system and method |
| CN109213811A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN109213776A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN109213776B (en) * | 2017-06-30 | 2021-08-06 | 北京神州泰岳软件股份有限公司 | Report form display method and device |
| CN109213979A (en) * | 2017-07-03 | 2019-01-15 | 珠海金山办公软件有限公司 | Method, apparatus, electronic equipment and the storage medium that electrical form is screened |
| CN109213979B (en) * | 2017-07-03 | 2022-05-06 | 珠海金山办公软件有限公司 | Method and device for screening electronic forms, electronic equipment and storage medium |
| CN107704523A (en) * | 2017-09-11 | 2018-02-16 | 阿里巴巴集团控股有限公司 | Data multidimensional display control method, device and system |
| CN110019309A (en) * | 2017-12-29 | 2019-07-16 | 北京小度信息科技有限公司 | Data access method, device, electronic equipment and computer readable storage medium |
| CN110532254A (en) * | 2018-05-25 | 2019-12-03 | 杭州海康威视数字技术股份有限公司 | The method and apparatus of fused data table |
| CN109271411B (en) * | 2018-09-28 | 2023-08-29 | 中国平安财产保险股份有限公司 | Report generation method, report generation device, computer equipment and storage medium |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN109408535B (en) * | 2018-09-28 | 2024-04-09 | 中国平安财产保险股份有限公司 | Large data volume matching method, device, computer equipment and storage medium |
| CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN112506942A (en) * | 2020-10-29 | 2021-03-16 | 望海康信(北京)科技股份公司 | Data combination query method, system and corresponding equipment and storage medium |
| CN113032633B (en) * | 2021-04-15 | 2022-03-08 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| CN113032633A (en) * | 2021-04-15 | 2021-06-25 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| CN114780084B (en) * | 2022-06-22 | 2022-08-30 | 成都七柱智慧科技有限公司 | Configuration system for collaborative multi-type interactive interface design |
| CN114780084A (en) * | 2022-06-22 | 2022-07-22 | 成都七柱智慧科技有限公司 | Configuration software for collaborative design of multiple types of interactive interfaces |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105095249B (en) | 2018-12-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105095249A (en) | Method generating multi-dimension report form | |
| CN102968436B (en) | Chart is recommended | |
| CN106599039B (en) | Statistical representation method supporting free combination nesting of relational database data | |
| US8756260B2 (en) | System for organizing computer data | |
| JP5241738B2 (en) | Method and apparatus for building tree structure data from tables | |
| US20120078940A1 (en) | Analysis of object structures such as benefits and provider contracts | |
| CN109635162A (en) | A kind of data processing system and method | |
| CN105243108A (en) | XBRL based intelligent reporting platform system | |
| CN111145855A (en) | Automatic generation method and system for clinical PDF report | |
| KR20060015527A (en) | Database device, database search device, and method thereof | |
| CN108197187A (en) | Optimization method, device, storage medium and the computer equipment of query statement | |
| CN113254543A (en) | Digital-analog separation system and method based on BIM model | |
| CN111078094A (en) | Distributed machine learning visualization device | |
| CN106095961A (en) | Table display processing method and device | |
| CN106503040A (en) | It is suitable for KV data bases and its creation method of SQL query method | |
| CN109033523A (en) | A kind of Assembly process specification generation System and method for based on three-dimensional CAD model | |
| CN105373659A (en) | High-speed train design index generation method and device | |
| US20130283233A1 (en) | Multi-engine executable data-flow editor and translator | |
| JP4116601B2 (en) | Taxonomy display device, taxonomy display method, and taxonomy display program | |
| CN109947705A (en) | A kind of access System and method for of petroleum works data | |
| CN104408101A (en) | Whole-process Web information extraction integration method | |
| Franke et al. | Damast: A Visual Analysis Approach for Religious History Research. | |
| Lacaze et al. | DREAM & TEAM: a tool and a notation supporting exploration of options and traceability of choices for safety critical interactive systems | |
| US9053149B2 (en) | Method and system to provide composite view of components | |
| JP2008146300A (en) | Information processor, information processing method and program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |