CN103678401A - Metadata based report group summarizing method and device - Google Patents

Metadata based report group summarizing method and device Download PDF

Info

Publication number
CN103678401A
CN103678401A CN201210355348.3A CN201210355348A CN103678401A CN 103678401 A CN103678401 A CN 103678401A CN 201210355348 A CN201210355348 A CN 201210355348A CN 103678401 A CN103678401 A CN 103678401A
Authority
CN
China
Prior art keywords
grouping
gather
business object
report messages
groups
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201210355348.3A
Other languages
Chinese (zh)
Inventor
刘兵
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kingdee Software China Co Ltd
Original Assignee
Kingdee Software China Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Kingdee Software China Co Ltd filed Critical Kingdee Software China Co Ltd
Priority to CN201210355348.3A priority Critical patent/CN103678401A/en
Publication of CN103678401A publication Critical patent/CN103678401A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a metadata based report group summarizing method. The method comprises configuring report information corresponding to business objects in reports and configuring group summarizing information for group summarizing of reports according to the report information; converting the configured report information and group summarizing information into corresponding metadata and storing the metadata; during running of the reports, calling the corresponding report information of the business objects according to summarizing conditions selected by users and performing group summarizing on the reports according to the group summarizing information corresponding to the report information. The invention further provides a corresponding device. According to the method and the device, the configured report information and group summarizing information are stored in a metadata mode, so that group condition expansion can be performed according to user needs without correcting scripts and codes when user actual needs are changed, and maintenance costs are reduced.

Description

Based on metadata, realize the method and apparatus that form grouping gathers
Technical field
The present invention relates to Computer Applied Technology field, specially refer to and a kind ofly based on metadata, realize the method and apparatus that form grouping gathers.
Background technology
At present, when form is divided into groups to gather, common adopted method is following three kinds:
One, provide fixing grouping to gather function, each standalone module is provided with to the grouping combined data for data query, and by standalone module, carry out separately data query and complete grouping and gather.Adopt in this way, because it does not support to divide according to user's needs the expansion of set condition, when user need to have change a little time, will bring high maintenance cost.
Two, provide selectable grouping to gather function, pass through query option, can select to divide into groups to gather with preset a certain combination condition, its implementation is substantially also hard coded, although this method has been done abundant analysis to user's demand, the packet options that the also exhaustive frequent use of several users maybe may be used, equally does not support to divide according to user's needs the expansion of set condition yet, thereby make maintenance cost high, rate of code reuse is low.
Summary of the invention
Fundamental purpose of the present invention realizes based on metadata the method and apparatus that form grouping gathers for providing a kind of, is intended to realize when supporting to divide the expansion of set condition according to user's needs, reduces maintenance cost.
The invention provides and a kind ofly based on metadata, realize the method that form grouping gathers, comprising:
The report messages that configuration is corresponding with business object in form, and according to described report messages, be configured for the grouping summary information that form is divided into groups to gather;
Configured described report messages and described grouping summary information are converted into corresponding metadata, and store described metadata;
When form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object, and according to grouping summary information corresponding to described report messages, form is divided into groups to gather.
Preferably, the described configuration report messages corresponding with business object in form comprises:
According to the information of business object in form, obtain the incidence relation of data source and this business object of described business object, and required aggregate type when configuration divides into groups to gather to form according to this incidence relation;
According to described aggregate type, configure described aggregate type corresponding gather field information.
Preferably, describedly according to report messages, be configured for the grouping summary information that form is divided into groups to gather and comprise:
Required aggregate type is corresponding when form is divided into groups to gather gathers field information, the grouping summary information for form is divided into groups to gather while being configured in form operation; Described grouping summary information comprise grouping while gathering for generating the filtered fields set of filtercondition, the grouping that shows hidden columns set of fields and be used to indicate the foundation that grouping gathers according to row set.
Preferably, described when form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object, and according to grouping summary information corresponding to described report messages, form is divided into groups to gather and comprise:
When form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object;
According to described condition and the described report messages of gathering, obtain described grouping according in row set with described in gather grouping foundation corresponding to condition, and in described demonstration hidden columns set of fields, select corresponding display column field according to described grouping foundation, form combined data;
Described report messages and described combined data are merged, form is divided into groups to gather, for the form after grouping is gathered, to user, present.
Preferably, described, when form moves, according to the user-selected condition that gathers, after calling report messages corresponding to corresponding business object, also comprise:
Judge the field that whether comprises business object attribute in described report messages, if so, obtain the data source of described business object, rebuild the incidence relation of this business object and corresponding data source.
The present invention also provides a kind of and realizes based on metadata the device that form grouping gathers, and comprising:
Configuration module, for configuring the report messages corresponding with the business object of form, and is configured for the grouping summary information that form is divided into groups to gather according to described report messages;
Transform and memory module, for configured described report messages and described grouping summary information are converted into corresponding metadata, and store described metadata;
Grouping summarizing module, for when form moves, according to the user-selected condition that gathers, calls report messages corresponding to corresponding business object, and according to grouping summary information corresponding to described report messages, form is divided into groups to gather.
Preferably, described configuration module comprises:
The first dispensing unit, for according to the information of form business object, obtains the incidence relation of data source and this business object of described business object, and required aggregate type when configuration divides into groups to gather to form according to this incidence relation;
The second dispensing unit, for according to described aggregate type, configure described aggregate type corresponding gather field information.
Preferably, described configuration module also comprises:
The 3rd dispensing unit, for aggregate type required when form divide into groups to gather corresponding gather field information, the grouping summary information for form is divided into groups to gather when being configured in form and moving; Described grouping summary information comprise grouping while gathering for generating the filtered fields set of filtercondition, the grouping that shows hidden columns set of fields and be used to indicate the foundation that grouping gathers according to row set.
Preferably, described grouping summarizing module comprises:
Call unit, for when form moves, according to the user-selected condition that gathers, calls report messages corresponding to corresponding business object;
Acquiring unit, for gathering condition and described report messages described in basis, obtain described grouping according in row set with described in gather grouping foundation corresponding to condition;
Selected cell, for selecting corresponding display column field according to described grouping foundation in described demonstration hidden columns set of fields, forms combined data;
Merge and gather unit, for described report messages and described combined data are merged, form is divided into groups to gather, for the form after grouping is gathered, to user, present.
Preferably, described grouping summarizing module also comprises:
Judging unit, for judging whether described data message comprises the field of business object attribute;
Reconstruction unit, for obtaining the data source of described business object, rebuilds the incidence relation of this business object and corresponding data source.
The present invention is by the configuration report messages corresponding with business object in form, and according to report messages, is configured for the grouping summary information that form is divided into groups to gather; Then configured report messages and grouping summary information are converted into corresponding metadata, and store described metadata; When form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object, and according to grouping summary information corresponding to report messages, form is divided into groups to gather, owing to adopting the mode of metadata to store configured table information and grouping summary information, when user's actual need has change, do not need to revise script and code, just can realize the expansion that divides set condition according to user's needs, thereby reduce maintenance cost.
Accompanying drawing explanation
Fig. 1 the present invention is based on the schematic flow sheet that metadata realizes method one embodiment that form grouping gathers;
Fig. 2 the present invention is based on the schematic flow sheet that metadata realizes configuration data information in the method that form grouping gathers;
Fig. 3 the present invention is based on the schematic flow sheet that metadata realizes configuration packet summary information in the method that form grouping gathers;
Fig. 4 the present invention is based on metadata to realize the schematic flow sheet that in the method that form grouping gathers, form is divided into groups to gather;
Fig. 5 the present invention is based on the schematic flow sheet that metadata realizes the another embodiment of method that form grouping gathers;
Fig. 6 the present invention is based on the structural representation that metadata realizes device one embodiment that form grouping gathers;
Fig. 7 the present invention is based on the structural representation that metadata realizes configuration module the first embodiment in the device that form grouping gathers;
Fig. 8 the present invention is based on the structural representation that metadata realizes configuration module the second embodiment in the device that form grouping gathers;
Fig. 9 the present invention is based on the structural representation that metadata realizes the summarizing module of dividing into groups in the device that form grouping gathers;
Figure 10 the present invention is based on the structural representation that metadata realizes the another embodiment of device that form grouping gathers.
The realization of the object of the invention, functional characteristics and advantage, in connection with embodiment, are described further with reference to accompanying drawing.
Embodiment
Should be appreciated that specific embodiment described herein, only in order to explain the present invention, is not intended to limit the present invention.
With reference to Fig. 1, Fig. 1 is that Fig. 1 the present invention is based on the schematic flow sheet that metadata realizes method one embodiment that form grouping gathers.
What the present embodiment provided realizes based on metadata the method that form grouping gathers, and comprising:
Step S10, the report messages that configuration is corresponding with business object in form, and according to report messages, be configured for the grouping summary information that form is divided into groups to gather;
When needs divide into groups to gather to form, and the data result after gathering is to current to user, first, need to be according to all business objects in this form, corresponding report messages when the configuration form corresponding with it gathers, then according to the report messages of configuration, further configuration according to business objects all in this form generate, for can obtain and gather the grouping summary information that form is divided into groups to gather when form is divided into groups to gather.
Step S20, is converted into corresponding metadata by configured report messages and grouping summary information, and storing metadata;
Metadata is a kind of XML structure that meets specific specifications, is the structural data about data, is used for describing and the coded data of specified data, can provide standard, general description benchmark and way for the digital information unit of various forms and resource collection.Corresponding report messages when having configured the form corresponding with all business objects in form and gather, and further configured for can obtain and gather the grouping summary information that form is divided into groups to gather when form is divided into groups to gather after according to this report messages, configured report messages and grouping summary information are separately converted to corresponding metadata, be about to the data in report messages and grouping summary information, be assembled into the entity that is mutually related to picture, then the metadata after transforming is stored by structural data, for after form operation, it is carried out to Dynamic Packet while gathering, call corresponding metadata.
Step S30, when form moves, according to the user-selected condition that gathers, calls report messages corresponding to corresponding business object, and according to grouping summary information corresponding to report messages, form is divided into groups to gather.
To be converted into after corresponding metadata storage according to the report messages of business object configurations all in form and grouping summary information, when form moves, while needing this form to divide into groups to gather, according to the user-selected condition that gathers that is used to indicate generating report forms data, call report messages corresponding to corresponding business object, and according to this report messages further by the grouping summary information corresponding with it, form is divided into groups to gather, thereby the form after being convenient to the grouping to gather presents to user.
The embodiment of the present invention, by the configuration report messages corresponding with business object in form, and is configured for the grouping summary information that form is divided into groups to gather according to report messages; Then configured report messages and grouping summary information are converted into corresponding metadata, and store described metadata; When form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object, and according to grouping summary information corresponding to report messages, form is divided into groups to gather, owing to adopting the mode of metadata to store configured table information and grouping summary information, when user's actual need has change, do not need to revise script and code, just can realize the expansion that divides set condition according to user's needs, thereby reduce maintenance cost.
With reference to Fig. 2, Fig. 2 the present invention is based on the schematic flow sheet that metadata realizes configuration data information in the method that form grouping gathers.
In the above-described embodiments, step S10 comprises:
Step S11, according to the information of business object in form, obtains the incidence relation of data source and this business object of business object, and required aggregate type when configuration divides into groups to gather to form according to this incidence relation;
In the present embodiment, corresponding report messages when the form corresponding with it configuring according to all business objects in this form gathers, comprises aggregate type required when form is divided into groups to gather and corresponding with this aggregate type field information that gathers.
During report messages corresponding to business object in configuration in form, first according to the information of all business objects in form, obtain the data source of corresponding business object, and further obtain the incidence relation between data source and corresponding business object, then according to accessed incidence relation, configure aggregate type required when form is divided into groups to gather.
Step S12, according to aggregate type, what configuration aggregate type was corresponding gathers field information.
After having configured aggregate type required when form is divided into groups to gather, according to configured aggregate type, further configure all corresponding field informations that gathers of aggregate type, this gathers field information for all fields that need to user present associated with each aggregate type.
With reference to Fig. 3, Fig. 3 the present invention is based on the schematic flow sheet that metadata realizes configuration packet summary information in the method that form grouping gathers.
In the above-described embodiments, step S10 also comprises:
Step S13, required aggregate type is corresponding when form is divided into groups to gather gathers field information, the grouping summary information for form is divided into groups to gather while being configured in form operation.
According to the information of all business objects in form, aggregate type required when form is divided into groups to gather and all corresponding gathering after field information of aggregate type have been configured, according to this, gather field information, the grouping summary information for form is divided into groups to gather while being configured in form operation.The grouping summary information that the present embodiment proposes comprises filtered fields set, shows that hidden columns set of fields and grouping are according to information such as row set, wherein, filtered fields set has comprised when form is divided into groups to gather for generating all filtered fields of filtercondition, show that hidden columns set of fields has comprised the visible field information of institute's energy, the set of grouping foundation row is used to indicate the foundation that can gather for the grouping of selecting while dividing into groups to gather.
According to the information of business object in form, obtain the incidence relation of data source and this business object of business object, and required aggregate type and corresponding the gathering after field information of aggregate type when configuration divide into groups to gather to form according to this incidence relation, according to this, gather field information grouping summary information for form is divided into groups to gather when being configured in form and moving; And due to configured aggregate type, gather field information and grouping summary information all in the mode of metadata, store, like this, when form is divided into groups to gather, just may be easily according to user's needs, call stored metadata, complete the grouping of form is gathered, thereby further guaranteed not need to revise script and code, just can realize the expansion that divides set condition according to user's needs.
With reference to Fig. 4, Fig. 4 the present invention is based on metadata to realize the schematic flow sheet that in the method that form grouping gathers, form is divided into groups to gather.
In the above-described embodiments, step S30 comprises:
Step S31, when form moves, according to the user-selected condition that gathers, calls report messages corresponding to corresponding business object;
When form moves, form is divided into groups to gather, and the report data after gathering is to current to user, according to the user-selected condition that gathers, be user-selected need to, to which aggregate type of which business object in form and these business objects and the corresponding condition that gathers field information thereof, in stored metadata, call the report messages corresponding to the business object of selecting with user of configuration.
Step S32, according to the condition of gathering and report messages, obtains grouping according to the grouping foundation corresponding with the condition of gathering in row set, and according to select corresponding display column field in showing hidden columns set of fields, forms combined data according to dividing into groups;
According to the user-selected condition that gathers and report messages corresponding to business object that call, obtain grouping according to the grouping foundation corresponding with the condition of gathering in row set, and in showing hidden columns set of fields, select the field information of corresponding display column field according to this grouping foundation, and by pre-set algorithm, according to the incidence relation between grouping foundation and the field information corresponding with it, grouping foundation and corresponding field information are carried out to correspondence and combination, thereby form combined data.
Step S33, merges report messages and combined data, and form is divided into groups to gather, and for the form after grouping is gathered, to user, presents.
When calling the report messages corresponding to the business object of selecting with user of configuration, and grouping foundation and the field information corresponding with it are carried out to corresponding and combination and after forming combined data, report messages and combined data are merged, thereby completed, statistical tables and reports are divided into groups to gather.Then, report messages in data after merging is sorted according to grouping foundation, and be stored in internal memory, and when representing the data of the form after grouping gathers to user, need to carry out to combined data the format of extensions and footings, being to user now, just can present the data layout with extensions and footings like this.
When form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object; Then obtain grouping according to the grouping foundation corresponding with the condition of gathering in row set, and according to select corresponding display column field in showing hidden columns set of fields, form combined data according to dividing into groups; Finally report messages and combined data are merged, complete form is divided into groups to gather, for the form after grouping is gathered, to user, present, this just, when having realized and realizing easily by metadata the grouping of form is gathered, has further reduced maintenance cost.
With reference to Fig. 5, Fig. 5 the present invention is based on the schematic flow sheet that metadata realizes the another embodiment of method that form grouping gathers.
Based on above-described embodiment, after execution step S31, step S30 also comprises:
Step S34, judges the field that whether comprises business object attribute in report messages; If so, perform step S341;
Step S341, obtains the data source of business object, rebuilds the incidence relation of this business object and corresponding data source.
When form moves, according to the user-selected condition that gathers, call report messages corresponding to the business object of selecting with user of configuration in stored metadata after, the field that whether comprises business object attribute in the report messages that needs judgement to be called, as comprise, need to obtain the data source of this business object, and rebuild the incidence relation of this business object and corresponding data source, because the field of business object attribute is all the grouping field of user oneself expansion, this is not present in report messages, so, need to analyze the metadata of this Related fields, and obtain the data source of the business object corresponding with it, rebuild the incidence relation of this business object and corresponding data source.
With reference to Fig. 6, Fig. 6 the present invention is based on the structural representation that metadata realizes device one embodiment that form grouping gathers.
What the present embodiment provided realizes based on metadata the device that form grouping gathers, and comprising:
Configuration module 10, for configuring the report messages corresponding with the business object of form, and is configured for the grouping summary information that form is divided into groups to gather according to report messages;
Transform and memory module 20, for configured report messages and grouping summary information are converted into corresponding metadata, and storing metadata;
Grouping summarizing module 30, for when form moves, according to the user-selected condition that gathers, calls report messages corresponding to corresponding business object, and according to grouping summary information corresponding to report messages, form is divided into groups to gather.
When needs divide into groups to gather to form, and the data result after gathering is to current to user, first, configuration module 10 need to be according to all business objects in this form, corresponding report messages when the configuration form corresponding with it gathers, then according to the report messages of configuration, further configuration according to business objects all in this form generate, for can obtain and gather the grouping summary information that form is divided into groups to gather when form is divided into groups to gather.
Corresponding report messages when having configured the form corresponding with all business objects in form and gather, and further configured for can obtain and gather the grouping summary information that form is divided into groups to gather when form is divided into groups to gather after according to this report messages, by conversion and memory module 20, configured report messages and grouping summary information are separately converted to corresponding metadata, be about to the data in report messages and grouping summary information, be assembled into the entity that is mutually related to picture, then the metadata after transforming is stored by structural data, for after form operation, it is carried out to Dynamic Packet while gathering, call corresponding metadata.
To be converted into after corresponding metadata storage according to the report messages of business object configurations all in form and grouping summary information, when form moves, while needing this form to divide into groups to gather, grouping summarizing module 30 is according to the user-selected condition that gathers that is used to indicate generating report forms data, call report messages corresponding to corresponding business object, and according to this report messages further by the grouping summary information corresponding with it, form is divided into groups to gather, thereby the form after being convenient to the grouping to gather presents to user.
The embodiment of the present invention, by the configuration report messages corresponding with business object in form, and is configured for the grouping summary information that form is divided into groups to gather according to report messages; Then configured report messages and grouping summary information are converted into corresponding metadata, and store described metadata; When form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object, and according to grouping summary information corresponding to report messages, form is divided into groups to gather, owing to adopting the mode of metadata to store configured table information and grouping summary information, when user's actual need has change, do not need to revise script and code, just can realize the expansion that divides set condition according to user's needs, thereby reduce maintenance cost.
With reference to Fig. 7, Fig. 7 the present invention is based on the structural representation that metadata realizes configuration module the first embodiment in the device that form grouping gathers.
In the above-described embodiments, configuration module 10 comprises:
The first dispensing unit 11, for according to the information of form business object, obtains the incidence relation of data source and this business object of business object, and required aggregate type when configuration divides into groups to gather to form according to this incidence relation;
The second dispensing unit 12, for according to aggregate type, configuration aggregate type is corresponding gathers field information.
In the present embodiment, corresponding report messages when the form corresponding with it configuring according to all business objects in this form gathers, comprises aggregate type required when form is divided into groups to gather and corresponding with this aggregate type field information that gathers.
During report messages corresponding to business object in configuration in form, first by the first dispensing unit 11, according to the information of all business objects in form, obtain the data source of corresponding business object, and further obtain the incidence relation between data source and corresponding business object, then according to accessed incidence relation, configure aggregate type required when form is divided into groups to gather.
After having configured aggregate type required when form is divided into groups to gather, by the second dispensing unit 12, according to configured aggregate type, further configure all corresponding field informations that gathers of aggregate type, this gathers field information for all fields that need to user present associated with each aggregate type.
With reference to Fig. 8, Fig. 8 the present invention is based on the structural representation that metadata realizes configuration module the second embodiment in the device that form grouping gathers.
In the above-described embodiments, configuration module 10 also comprises:
The 3rd dispensing unit 13, for aggregate type required when form divide into groups to gather corresponding gather field information, the grouping summary information for form is divided into groups to gather when being configured in form and moving.
According to the information of all business objects in form, aggregate type required when form is divided into groups to gather and all corresponding gathering after field information of aggregate type have been configured, by the 3rd dispensing unit 13, according to this, gather field information, the grouping summary information for form is divided into groups to gather while being configured in form operation.The grouping summary information that the present embodiment proposes comprises filtered fields set, shows that hidden columns set of fields and grouping are according to information such as row set, wherein, filtered fields set has comprised when form is divided into groups to gather for generating all filtered fields of filtercondition, show that hidden columns set of fields has comprised the visible field information of institute's energy, the set of grouping foundation row is used to indicate the foundation that can gather for the grouping of selecting while dividing into groups to gather.
According to the information of business object in form, obtain the incidence relation of data source and this business object of business object, and required aggregate type and corresponding the gathering after field information of aggregate type when configuration divide into groups to gather to form according to this incidence relation, according to this, gather field information grouping summary information for form is divided into groups to gather when being configured in form and moving; And due to configured aggregate type, gather field information and grouping summary information all in the mode of metadata, store, like this, when form is divided into groups to gather, just may be easily according to user's needs, call stored metadata, complete the grouping of form is gathered, thereby further guaranteed not need to revise script and code, just can realize the expansion that divides set condition according to user's needs.
With reference to Fig. 9, Fig. 9 the present invention is based on the structural representation that metadata realizes the summarizing module of dividing into groups in the device that form grouping gathers.
In the above-described embodiments, grouping summarizing module 30 comprises:
Call unit 31, for when form moves, according to the user-selected condition that gathers, calls report messages corresponding to corresponding business object;
Acquiring unit 32, for according to gathering condition and described report messages, obtains grouping according to the grouping foundation corresponding with the condition of gathering in row set;
Selected cell 33, for selecting corresponding display column field according to grouping foundation in demonstration hidden columns set of fields, forms combined data;
Merge and gather unit 34, for report messages and combined data are merged, form is divided into groups to gather, for the form after grouping is gathered, to user, present.
When form moves, form is divided into groups to gather, and the report data after gathering is to current to user, according to the user-selected condition that gathers, be user-selected need to, to which aggregate type of which business object in form and these business objects and the corresponding condition that gathers field information thereof, by call unit 31, in stored metadata, call the report messages corresponding to the business object of selecting with user of configuration.
According to the user-selected condition that gathers and report messages corresponding to business object that call, acquiring unit 32 obtains grouping according to the grouping foundation corresponding with the condition of gathering in row set, and by selected cell 33, according to this grouping foundation, in showing hidden columns set of fields, select the field information of corresponding display column field, and by pre-set algorithm, according to the incidence relation between grouping foundation and the field information corresponding with it, grouping foundation and corresponding field information are carried out to correspondence and combination, thereby form combined data.
When calling the report messages corresponding to the business object of selecting with user of configuration, and grouping foundation and the field information corresponding with it are carried out to corresponding and combination and after forming combined data, by merging and gather unit 34, report messages and combined data are merged, thereby completed, statistical tables and reports are divided into groups to gather.Then, report messages in data after merging is sorted according to grouping foundation, and be stored in internal memory, and when representing the data of the form after grouping gathers to user, need to carry out to combined data the format of extensions and footings, being to user now, just can present the data layout with extensions and footings like this.
When form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object; Then obtain grouping according to the grouping foundation corresponding with the condition of gathering in row set, and according to select corresponding display column field in showing hidden columns set of fields, form combined data according to dividing into groups; Finally report messages and combined data are merged, complete form is divided into groups to gather, for the form after grouping is gathered, to user, present, this just, when having realized and realizing easily by metadata the grouping of form is gathered, has further reduced maintenance cost.
With reference to Figure 10, Figure 10 the present invention is based on the structural representation that metadata realizes the another embodiment of device that form grouping gathers.
Based on above-described embodiment, grouping summarizing module 30 also comprises:
Judging unit 35, judges the field that whether comprises business object attribute in data message;
Reconstruction unit 36, for obtaining the data source of business object, rebuilds the incidence relation of this business object and corresponding data source.
When form moves, according to the user-selected condition that gathers, call report messages corresponding to the business object of selecting with user of configuration in stored metadata after, the field that whether comprises business object attribute in the report messages that judging unit 35 needs judgement to be called, as comprise, reconstruction unit 36 need to obtain the data source of this business object, and rebuild the incidence relation of this business object and corresponding data source, because the field of business object attribute is all the grouping field of user oneself expansion, this is not present in report messages, so, need to analyze the metadata of this Related fields, and z obtains the data source of the business object corresponding with it, rebuild the incidence relation of this business object and corresponding data source.
The foregoing is only the preferred embodiments of the present invention; not thereby limit the scope of the claims of the present invention; every equivalent structure or conversion of equivalent flow process that utilizes instructions of the present invention and accompanying drawing content to do; or be directly or indirectly used in other relevant technical fields, be all in like manner included in scope of patent protection of the present invention.

Claims (10)

1. based on metadata, realize the method that form grouping gathers, it is characterized in that, comprising:
The report messages that configuration is corresponding with business object in form, and according to described report messages, be configured for the grouping summary information that form is divided into groups to gather;
Configured described report messages and described grouping summary information are converted into corresponding metadata, and store described metadata;
When form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object, and according to grouping summary information corresponding to described report messages, form is divided into groups to gather.
2. method according to claim 1, is characterized in that, the described configuration report messages corresponding with business object in form comprises:
According to the information of business object in form, obtain the incidence relation of data source and this business object of described business object, and required aggregate type when configuration divides into groups to gather to form according to this incidence relation;
According to described aggregate type, configure described aggregate type corresponding gather field information.
3. method according to claim 2, is characterized in that, describedly according to report messages, is configured for the grouping summary information that form is divided into groups to gather and comprises:
Required aggregate type is corresponding when form is divided into groups to gather gathers field information, the grouping summary information for form is divided into groups to gather while being configured in form operation; Described grouping summary information comprise grouping while gathering for generating the filtered fields set of filtercondition, the grouping that shows hidden columns set of fields and be used to indicate the foundation that grouping gathers according to row set.
4. according to the method in any one of claims 1 to 3, it is characterized in that, it is described when form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object, and according to grouping summary information corresponding to described report messages, form divided into groups to gather and comprise:
When form moves, according to the user-selected condition that gathers, call report messages corresponding to corresponding business object;
According to described condition and the described report messages of gathering, obtain described grouping according in row set with described in gather grouping foundation corresponding to condition, and in described demonstration hidden columns set of fields, select corresponding display column field according to described grouping foundation, form combined data;
Described report messages and described combined data are merged, form is divided into groups to gather, for the form after grouping is gathered, to user, present.
5. method according to claim 4, is characterized in that, described, when form moves, according to the user-selected condition that gathers, after calling report messages corresponding to corresponding business object, also comprises:
Judge the field that whether comprises business object attribute in described report messages, if so, obtain the data source of described business object, rebuild the incidence relation of this business object and corresponding data source.
6. based on metadata, realize the device that form grouping gathers, it is characterized in that, comprising:
Configuration module, for configuring the report messages corresponding with the business object of form, and is configured for the grouping summary information that form is divided into groups to gather according to described report messages;
Transform and memory module, for configured described report messages and described grouping summary information are converted into corresponding metadata, and store described metadata;
Grouping summarizing module, for when form moves, according to the user-selected condition that gathers, calls report messages corresponding to corresponding business object, and according to grouping summary information corresponding to described report messages, form is divided into groups to gather.
7. device according to claim 6, is characterized in that, described configuration module comprises:
The first dispensing unit, for according to the information of form business object, obtains the incidence relation of data source and this business object of described business object, and required aggregate type when configuration divides into groups to gather to form according to this incidence relation;
The second dispensing unit, for according to described aggregate type, configure described aggregate type corresponding gather field information.
8. device according to claim 7, is characterized in that, described configuration module also comprises:
The 3rd dispensing unit, for aggregate type required when form divide into groups to gather corresponding gather field information, the grouping summary information for form is divided into groups to gather when being configured in form and moving; Described grouping summary information comprise grouping while gathering for generating the filtered fields set of filtercondition, the grouping that shows hidden columns set of fields and be used to indicate the foundation that grouping gathers according to row set.
9. according to the device described in any one in claim 6 to 8, it is characterized in that, described grouping summarizing module comprises:
Call unit, for when form moves, according to the user-selected condition that gathers, calls report messages corresponding to corresponding business object;
Acquiring unit, for gathering condition and described report messages described in basis, obtain described grouping according in row set with described in gather grouping foundation corresponding to condition;
Selected cell, for selecting corresponding display column field according to described grouping foundation in described demonstration hidden columns set of fields, forms combined data;
Merge and gather unit, for described report messages and described combined data are merged, form is divided into groups to gather, for the form after grouping is gathered, to user, present.
10. device according to claim 9, is characterized in that, described grouping summarizing module also comprises:
Judging unit, for judging whether described data message comprises the field of business object attribute;
Reconstruction unit, for obtaining the data source of described business object, rebuilds the incidence relation of this business object and corresponding data source.
CN201210355348.3A 2012-09-21 2012-09-21 Metadata based report group summarizing method and device Pending CN103678401A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201210355348.3A CN103678401A (en) 2012-09-21 2012-09-21 Metadata based report group summarizing method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201210355348.3A CN103678401A (en) 2012-09-21 2012-09-21 Metadata based report group summarizing method and device

Publications (1)

Publication Number Publication Date
CN103678401A true CN103678401A (en) 2014-03-26

Family

ID=50315982

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201210355348.3A Pending CN103678401A (en) 2012-09-21 2012-09-21 Metadata based report group summarizing method and device

Country Status (1)

Country Link
CN (1) CN103678401A (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109543169A (en) * 2018-11-26 2019-03-29 成都四方伟业软件股份有限公司 Report processing method and device
CN110879807A (en) * 2018-09-06 2020-03-13 Sap欧洲公司 File format for quickly and efficiently accessing data
CN113095054A (en) * 2021-05-08 2021-07-09 国网信息通信产业集团有限公司 Method and device for generating detailed summary report based on divide-and-conquer algorithm
CN113421036A (en) * 2021-08-23 2021-09-21 北京国电通网络技术有限公司 Information display method and device, electronic equipment and computer readable medium
CN116483872A (en) * 2023-06-20 2023-07-25 合肥青谷信息科技有限公司 Complex data processing method and device and electronic equipment

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1877563A (en) * 2006-07-06 2006-12-13 北京北大方正电子有限公司 Report form defining method and system
CN102508850A (en) * 2011-09-29 2012-06-20 用友软件股份有限公司 Form data processing device and form data processing method
CN102521414A (en) * 2011-12-28 2012-06-27 畅捷通信息技术股份有限公司 Data drilling device and data drilling method

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1877563A (en) * 2006-07-06 2006-12-13 北京北大方正电子有限公司 Report form defining method and system
CN102508850A (en) * 2011-09-29 2012-06-20 用友软件股份有限公司 Form data processing device and form data processing method
CN102521414A (en) * 2011-12-28 2012-06-27 畅捷通信息技术股份有限公司 Data drilling device and data drilling method

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110879807A (en) * 2018-09-06 2020-03-13 Sap欧洲公司 File format for quickly and efficiently accessing data
CN110879807B (en) * 2018-09-06 2023-07-21 Sap欧洲公司 File format for quick and efficient access to data
CN109543169A (en) * 2018-11-26 2019-03-29 成都四方伟业软件股份有限公司 Report processing method and device
CN113095054A (en) * 2021-05-08 2021-07-09 国网信息通信产业集团有限公司 Method and device for generating detailed summary report based on divide-and-conquer algorithm
CN113095054B (en) * 2021-05-08 2023-11-10 国网信息通信产业集团有限公司 Method and device for generating detailed summary report based on divide-and-conquer algorithm
CN113421036A (en) * 2021-08-23 2021-09-21 北京国电通网络技术有限公司 Information display method and device, electronic equipment and computer readable medium
CN113421036B (en) * 2021-08-23 2021-11-12 北京国电通网络技术有限公司 Information display method and device, electronic equipment and computer readable medium
CN116483872A (en) * 2023-06-20 2023-07-25 合肥青谷信息科技有限公司 Complex data processing method and device and electronic equipment
CN116483872B (en) * 2023-06-20 2023-09-12 合肥青谷信息科技有限公司 Complex data processing method and device and electronic equipment

Similar Documents

Publication Publication Date Title
CN103678401A (en) Metadata based report group summarizing method and device
CN104063361B (en) Report design method and Report Form Design system
US9183561B2 (en) Automatic generation of trend charts
CN107229474B (en) Method and device for rapidly configuring Java interface and chart service based on visual interface
CN110647512B (en) Data storage and analysis method, device, equipment and readable medium
CN108280022A (en) Performance monitoring method and device
CN105389184B (en) The configuration method and device of Product Interface information
CN103412749A (en) Relational database based code generation method and code generator
CN108829381A (en) Data visualization method and device
US20110138236A1 (en) Apparatus and method for providing visual interface for information of error generated in multithread testing
CN110502491A (en) A kind of Log Collect System and its data transmission method, device
CN107766043A (en) A kind of realization method and system based on large-size screen monitors data visualization
CN112632136A (en) Data statistical analysis method and device, electronic equipment and storage medium
CN104679391B (en) The icon display method and device of intelligent watch
CN103257959A (en) Method and device for generating spreadsheet report
CN109885301B (en) Method, device, storage medium and equipment for generating scalable vector graphics
CN104301788A (en) Method and device for providing video interaction
CN103246606A (en) Method and system for testing performances of ESB (enterprises service bus) platform
CN103200338A (en) Telephone traffic statistic method
CN109408502A (en) A kind of data standard processing method, device and its storage medium
CN111414361A (en) Label data storage method, device, equipment and readable storage medium
CN108572817B (en) Method, apparatus and medium for dynamic resource configuration based on business modeling
CN106446027A (en) Information recommendation method and apparatus
CN103347079A (en) Method and mobile device for schedule event synchronization
CN104407783A (en) Interface information modularization display method and system

Legal Events

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

Application publication date: 20140326