CN102279951A - Report information processing method and system - Google Patents
Report information processing method and system Download PDFInfo
- Publication number
- CN102279951A CN102279951A CN2011102351371A CN201110235137A CN102279951A CN 102279951 A CN102279951 A CN 102279951A CN 2011102351371 A CN2011102351371 A CN 2011102351371A CN 201110235137 A CN201110235137 A CN 201110235137A CN 102279951 A CN102279951 A CN 102279951A
- Authority
- CN
- China
- Prior art keywords
- report
- item
- data
- information
- style
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a report information processing method and a report information processing system. The method comprises the following steps that: a report information processing system receives a report processing request transmitted by a user, wherein the report processing request carries requested report names and requested report time; the report information processing system queries report styles corresponding to the report names and the report time from a stored report style, wherein the report style comprises item names and item position information; the report information processing system queries data items corresponding to the item names from the stored report historical data; and the report information processing system generates a report according to the item names, the item position information and the data items. According to the report information processing method and the report information processing system, historical report information can be conveniently and efficiently processed.
Description
Technical field
The present invention relates to data processing technique, relate in particular to a kind of report messages disposal route and system.
Background technology
In financial industry, all need to generate large batch of data sheet every day and and carry out a large amount of history report inquiries.In the prior art, use the BW financial statement module of SAP business management software to carry out report form processing usually.
In BW financial statement module, report name in the report query request that gets access to user's input is extracted the report style corresponding with this report name, and according to the content that is comprised in this report style from advance the storage accounting data read corresponding data, and it is loaded in the report style, generate corresponding report.That is, in BW financial statement module, only can generate form according to current report style and the report data of being stored.So, when the user needs the query history form, need the report style of data to be loaded to be switched to the history report pattern that will inquire about, load related data at this history report pattern more afterwards, thereby the efficient that makes history report inquire about is extremely low by manually-operated.
Summary of the invention
At above-mentioned defective, the invention provides a kind of report messages disposal route and system, in order to realize convenience, history report information processing efficiently.
According to an aspect of the present invention, provide a kind of report messages disposal route, it is characterized in that, comprising:
The report messages disposal system receives the report form processing request that the user sends, and carries the report name of request to some extent and the form time of being asked in the described report form processing request;
Described report messages disposal system is inquired about from the report style of having stored and described report name and corresponding report style of described form time, and wherein said report style comprises project name and item location information;
Described report messages disposal system is inquired about the data item corresponding with described project name from the form historical data of having stored;
Described report messages disposal system generates form according to described project name, described item location information and described data item.
According to a further aspect in the invention, also provide a kind of report messages disposal system, comprising:
The report messages processing module is used to receive the report form processing request that the user sends, and carries the report name of request to some extent and the form time of being asked in the described report form processing request; Inquiry and described report name and corresponding report style of described form time from the report style of having stored, wherein said report style comprises project name and item location information; The inquiry data item corresponding from the form historical data of having stored with described project name; Generate form and displaying according to described project name, described item location information and described data item;
The report data memory module is used to store report style and form historical data.
According to report messages disposal route of the present invention and system, because after the report messages disposal system receives the report form processing request of carrying report name of asking to some extent and the form time of being asked of user's transmission, inquiry and described report name and corresponding report style of described form time from the report style of having stored, the inquiry data item corresponding from the form historical data of having stored with described project name; And according to described project name, described item location information and described data item generation form and displaying, so can be according to user's report form processing request report style and data reproduction history report according to random time, can make things convenient for, realize efficiently the history report inquiry and show.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art, to do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the schematic flow sheet of report messages disposal route of the present invention.
Fig. 2 is the report messages disposal system Organization Chart that is used to realize report messages disposal route of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the invention, the technical scheme in the embodiment of the invention is clearly and completely described, obviously, described embodiment only is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills belong to the scope of protection of the invention not making the every other embodiment that is obtained under the creative work prerequisite.
Fig. 1 is the schematic flow sheet of report messages disposal route of the present invention.As shown in Figure 1, this report messages disposal route may further comprise the steps:
Step S101, the report messages disposal system receives the report form processing request that the user sends, and carries the report name of request to some extent and the form time of being asked in the described report form processing request;
Step S102, described report messages disposal system is inquired about from the report style of having stored and described report name and corresponding report style of described form time, and wherein said report style comprises project name and item location information;
Step S103, described report messages disposal system is inquired about the data item corresponding with described project name from the form historical data of having stored;
Step S104, described report messages disposal system generates form according to described project name, described item location information and described data item.
Fig. 2 is the report messages disposal system Organization Chart that is used to realize report messages disposal route of the present invention.Below in conjunction with Fig. 2 above-mentioned steps S101～S104 is elaborated.
As shown in Figure 2, this report messages disposal system comprises report data memory module, report data processing module and report messages processing module.Wherein, the report data memory module comprises the historical submodule of report item, accounting data storehouse, the historical submodule of report item attaching relation, form historical data base and the historical submodule of report style.Particularly, each report item and its applicable time corresponding stored in the historical submodule of report item.Preferably, store the information such as attribute, record entry title, account form and debt-credit volume sign of user-defined report item in the historical submodule of report item with time slide fastener form.Wherein, be meant corresponding to same report item with time slide fastener form storage, dynamically put down in writing the variation that it took place according to the historical time order, for example for project A, record " on January 1st, 2009; item attribute changes to Y by X " and " on January 1st, 2010, item attribute changes to Z by Y " etc.Preferably, also store user-defined project and section's purpose attaching relation in the historical submodule of report item attaching relation, for example have two subjects, " subject 101 " and " subject 102 " for project " cash " with time slide fastener form; The accounting data storehouse is used to preserve the account historical data of enterprise, is generally the general ledger data, promptly comprises the subject level combined data of statistics date, account mechanism, Currency Type, beginning balance, current period amount and ending balance; Store the table entry that user-defined every form is showed with time slide fastener form in the historical submodule of report style, write down the information such as position in title, sequence number and the form of each project; The data item corresponding to projects that obtains is handled in storage in the form historical data base through the report data processing module, information such as writing time, Currency Type, mechanism, project and remaining sum for example, it can preserve the historical data of suitable granularity according to user's request, for example for preserving the historical data in 5 years.
The report messages processing module supports the mode of time slide fastener to show report style, i.e. the report name that can be asked in the human-computer interaction interface input of report messages processing module of user and the form time of being asked.When the report messages processing module receive user input carry the report form processing request of report name and form time the time, the report style that report name is identical and the form time is identical that acquisition time and user ask from the historical submodule of report style, and according to the report item of being showed in the report style that is obtained reading corresponding data item from the form historical data base.The report messages processing module is loaded on the report style that is obtained by the data item correspondence that will be read, and can generate the appointment form of the fixed time that the user asks, and this form is showed to the user.
In report messages disposal system shown in Figure 2, the report data memory module for example realizes storage by arbitrary database platform; The report data processing module is for example realized by ETL script, database store process or other third party's programmable software of data warehouse; The report messages processing module is for example realized by report tools such as Brio, BO or other crystal report instruments.
Report messages disposal route according to the foregoing description, because after the report messages disposal system receives the report form processing request of carrying report name of asking to some extent and the form time of being asked of user's transmission, inquiry and described report name and corresponding report style of described form time from the report style of having stored, the inquiry data item corresponding from the form historical data of having stored with described project name; And according to described project name, described item location information and described data item generation form and displaying, so can be according to user's report form processing request report style and data reproduction history report according to random time, can make things convenient for, realize efficiently the history report inquiry and show.
The report messages disposal route of the foregoing description is particularly useful for carrying out the history report data query in enormous quantities of multimachine structure (for example being mechanism of hundreds of family), Multiple Currencies (for example being tens of Currency Types), and the efficient of its report query and displaying is high.And, because report data is separated storage with report style, adopt the processing mode of loose coupling, make the complexity that has also reduced the data computation project at the needs of the frequent adjustment of satisfying report style simultaneously, strengthen the form flexibility ratio greatly, improved the expansion capacity of system.
Further, in the report messages disposal route of the foregoing description, described report messages disposal system also comprised inquire about the data item corresponding with described project name from the form historical data of having stored before:
Described report messages disposal system is obtained report item information respectively, is belonged to the subject information of report item and the subject combined data corresponding with described subject information;
Described report messages disposal system generates data item and the storage corresponding with described report item according to described report item information, the subject information that belongs to report item and the subject combined data corresponding with described subject information.
Particularly, the report data processing module for example generates the data item that is used for being stored in the form historical data base in the following manner.The report data processing module be used for from the historical submodule of report item read report item attribute, from report item attaching relation history module, read the subject that belongs to this project, and from the accounting data storehouse, read the subject level combined data corresponding with each subject, and the subject level combined data that read is merged and calculate according to the account form in the attribute of report item, generate the data item corresponding with project, and with store data items to the form historical data base.
According to the report messages disposal route of the foregoing description, can generate the data item corresponding automatically by obtaining subject combined data, and pre-defined report item information and belong to the subject information of report item in advance with described report item.And when needing to adjust, only need adjust report item information and/or pairing subject information can realize to the content structure of composition data item.
Further, in the report messages disposal route of the foregoing description, described report style, described report item information and the subject information stores that belongs to report item are in the database table of described report messages disposal system.
Report messages disposal route according to the foregoing description, since with report style, report item information and the subject information stores that belongs to report item in database table, it uses more flexible with respect to the mode with stored in file format, and search efficiency is higher.
The present invention also provides a kind of report messages disposal system, and its concrete structure as shown in Figure 2.This report messages disposal system comprises:
The report messages processing module is used to receive the report form processing request that the user sends, and carries the report name of request to some extent and the form time of being asked in the described report form processing request; Inquiry and described report name and corresponding report style of described form time from the report style of having stored, wherein said report style comprises project name and item location information; The inquiry data item corresponding from the form historical data of having stored with described project name; Generate form according to described project name, described item location information and described data item;
The report data memory module is used to store report style and form historical data, and promptly the report data memory module for example comprises the historical submodule of the report style that is used to store report style and is used to store the form historical data base of form historical data.
The report messages disposal system of the foregoing description is carried out form and is showed that the flow process of handling is identical with the report messages disposal route of the foregoing description, so locate to repeat no more.
Report messages disposal system according to the foregoing description, because after the report form processing request of the form time that receives the report name of carrying request to some extent of user's transmission and asked, inquiry and described report name and corresponding report style of described form time from the report style of having stored, the inquiry data item corresponding from the form historical data of having stored with described project name; And according to described project name, described item location information and described data item generation form and displaying, so can be according to user's report form processing request report style and data reproduction history report according to random time, can make things convenient for, realize efficiently the history report inquiry and show.
The report messages disposal system of the foregoing description is particularly useful for carrying out the history report data query in enormous quantities of multimachine structure (for example being mechanism of hundreds of family), Multiple Currencies (for example being tens of Currency Types), and the efficient of its report query and displaying is high.And, because report data is separated storage with report style, adopt the processing mode of loose coupling, make the complexity that has also reduced the data computation project at the needs of the frequent adjustment of satisfying report style simultaneously, strengthen the form flexibility ratio greatly, improved the expansion capacity of system.
Further, in the report messages disposal system of the foregoing description, described report data memory module also is used to store report item information, belongs to the subject information of report item and the subject combined data corresponding with described subject information; Correspondingly, also comprise:
The report data processing module is used for obtaining respectively described report data memory module and also is used to store report item information, belongs to the subject information of report item and the subject combined data corresponding with described subject information; Generate data item and the storage corresponding according to described report item information, the subject information that belongs to report item and the subject combined data corresponding with described report item with described subject information.
Particularly, the report data memory module for example also comprises the historical submodule of the report item that is used to store report item information, is used for store home in the historical submodule of the report item attaching relation of the subject information of report item be used to store the accounting data storehouse of subject combined data.
According to the report messages disposal system of the foregoing description, can generate the data item corresponding automatically by obtaining subject combined data, and pre-defined report item information and belong to the subject information of report item in advance with described report item.And when needing to adjust, only need adjust report item information and/or pairing subject information can realize to the content structure of composition data item.
Further, in the report messages disposal system of the foregoing description, described report data memory module is with described report style, described report item information and the described form storage that belongs to the subject information of report item with the time slide fastener.
Report messages disposal system according to the foregoing description, because form storage report style with the time slide fastener, report item information and the subject information that belongs to report item, promptly put down in writing report style, report item information reaches the time that changes over time with the subject information that belongs to report item, so according to temporal information to report style, when report item information is inquired about with the subject information that belongs to report item, can obtain true report style at any historical time, report item information and the subject information that belongs to report item have realized the history report reproduction very easily.
Further, in the report messages disposal system of the foregoing description, described report data memory module comprises the subject database of information table that is respectively applied for storage described report style, described report item information and belongs to report item.Be that the historical submodule of report item is the report item history lists, the historical submodule of report item attaching relation is a report item attaching relation history lists, and the historical submodule of report style is the report style history lists.
Report messages disposal system according to the foregoing description, since with report style, report item information and the subject information stores that belongs to report item in database table, it uses more flexible with respect to the mode with stored in file format, and search efficiency is higher.
Further, in the report messages disposal system of the foregoing description, described data item comprises time, Currency Type, mechanism, project name and remaining sum.
It should be noted that at last: above embodiment only in order to technical scheme of the present invention to be described, is not intended to limit; Although with reference to previous embodiment the present invention is had been described in detail, those of ordinary skill in the art is to be understood that: it still can be made amendment to the technical scheme that aforementioned each embodiment put down in writing, and perhaps part technical characterictic wherein is equal to replacement; And these modifications or replacement do not make the essence of appropriate technical solution break away from the spirit and scope of various embodiments of the present invention technical scheme.
Claims (10)
1. a report messages disposal route is characterized in that, comprising:
The report messages disposal system receives the report form processing request that the user sends, and carries the report name of request to some extent and the form time of being asked in the described report form processing request;
Described report messages disposal system is inquired about from the report style of having stored and described report name and corresponding report style of described form time, and wherein said report style comprises project name and item location information;
Described report messages disposal system is inquired about the data item corresponding with described project name from the form historical data of having stored;
Described report messages disposal system generates form according to described project name, described item location information and described data item.
2. report messages disposal route according to claim 1 is characterized in that, described report messages disposal system also comprised inquire about the data item corresponding with described project name from the form historical data of having stored before:
Described report messages disposal system is obtained report item information respectively, is belonged to the subject information of report item and the subject combined data corresponding with described subject information;
Described report messages disposal system generates data item and the storage corresponding with described report item according to described report item information, the subject information that belongs to report item and the subject combined data corresponding with described subject information.
3. report messages disposal route according to claim 2 is characterized in that, described report style, described report item information and the subject information that belongs to report item are stored in the described report messages disposal system with the form of time slide fastener.
4. according to claim 2 or 3 described report messages disposal routes, it is characterized in that described report style, described report item information and the subject information stores that belongs to report item are in the database table of described report messages disposal system.
5. according to the arbitrary described report messages disposal route of claim 1 to 3, it is characterized in that described data item comprises time, Currency Type, mechanism, project name and remaining sum.
6. a report messages disposal system is characterized in that, comprising:
The report messages processing module is used to receive the report form processing request that the user sends, and carries the report name of request to some extent and the form time of being asked in the described report form processing request; Inquiry and described report name and corresponding report style of described form time from the report style of having stored, wherein said report style comprises project name and item location information; The inquiry data item corresponding from the form historical data of having stored with described project name; Generate form and displaying according to described project name, described item location information and described data item;
The report data memory module is used to store report style and form historical data.
7. report messages disposal system according to claim 6 is characterized in that, described report data memory module also is used to store report item information, belongs to the subject information of report item and the subject combined data corresponding with described subject information; Correspondingly, also comprise:
The report data processing module is used for obtaining respectively described report data memory module and also is used to store report item information, belongs to the subject information of report item and the subject combined data corresponding with described subject information; Generate data item and the storage corresponding according to described report item information, the subject information that belongs to report item and the subject combined data corresponding with described report item with described subject information.
8. report messages disposal system according to claim 7 is characterized in that, described report data memory module is with described report style, described report item information and the described form storage that belongs to the subject information of report item with the time slide fastener.
9. according to claim 7 or 8 described report messages disposal systems, it is characterized in that described report data memory module comprises the subject database of information table that is respectively applied for storage described report style, described report item information and belongs to report item.
10. according to the arbitrary described report messages disposal system of claim 6 to 8, it is characterized in that described data item comprises time, Currency Type, mechanism, project name and remaining sum.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011102351371A CN102279951A (en) | 2011-08-16 | 2011-08-16 | Report information processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011102351371A CN102279951A (en) | 2011-08-16 | 2011-08-16 | Report information processing method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102279951A true CN102279951A (en) | 2011-12-14 |
Family
ID=45105384
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011102351371A Pending CN102279951A (en) | 2011-08-16 | 2011-08-16 | Report information processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102279951A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810187A (en) * | 2012-11-08 | 2014-05-21 | 天津市国瑞数码安全系统有限公司 | Method for dynamically back-tracing historical query based on basic data of filing system |
| CN105389366A (en) * | 2015-11-10 | 2016-03-09 | 中国建设银行股份有限公司 | Method and system for querying report form of large data volume |
| CN106227748A (en) * | 2016-07-14 | 2016-12-14 | 上海超橙科技有限公司 | A kind of information generating method and equipment |
| CN106649226A (en) * | 2015-10-29 | 2017-05-10 | 北京国双科技有限公司 | Report generation method and device |
| CN107111650A (en) * | 2015-02-05 | 2017-08-29 | 歌乐株式会社 | Information processing system and information processor |
| CN110764984A (en) * | 2019-09-30 | 2020-02-07 | 上海游族信息技术有限公司 | Pressurizing data multiplexing method for server performance pressure test |
| CN111090974A (en) * | 2019-12-27 | 2020-05-01 | 中国银行股份有限公司 | Report generation method, device and equipment |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101751436A (en) * | 2008-12-19 | 2010-06-23 | 中国移动通信集团山东有限公司 | Method and system for generating reports |
-
2011
- 2011-08-16 CN CN2011102351371A patent/CN102279951A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101751436A (en) * | 2008-12-19 | 2010-06-23 | 中国移动通信集团山东有限公司 | Method and system for generating reports |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810187A (en) * | 2012-11-08 | 2014-05-21 | 天津市国瑞数码安全系统有限公司 | Method for dynamically back-tracing historical query based on basic data of filing system |
| CN107111650A (en) * | 2015-02-05 | 2017-08-29 | 歌乐株式会社 | Information processing system and information processor |
| CN107111650B (en) * | 2015-02-05 | 2021-04-27 | 歌乐株式会社 | Information processing system and information processing apparatus |
| CN106649226A (en) * | 2015-10-29 | 2017-05-10 | 北京国双科技有限公司 | Report generation method and device |
| CN105389366A (en) * | 2015-11-10 | 2016-03-09 | 中国建设银行股份有限公司 | Method and system for querying report form of large data volume |
| CN105389366B (en) * | 2015-11-10 | 2019-07-09 | 中国建设银行股份有限公司 | A kind of big data quantity report form inquiring method and system |
| CN106227748A (en) * | 2016-07-14 | 2016-12-14 | 上海超橙科技有限公司 | A kind of information generating method and equipment |
| CN110764984A (en) * | 2019-09-30 | 2020-02-07 | 上海游族信息技术有限公司 | Pressurizing data multiplexing method for server performance pressure test |
| CN111090974A (en) * | 2019-12-27 | 2020-05-01 | 中国银行股份有限公司 | Report generation method, device and equipment |
| CN111090974B (en) * | 2019-12-27 | 2023-10-24 | 中国银行股份有限公司 | Report generation method, device and equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102279951A (en) | Report information processing method and system | |
| US9170999B2 (en) | Method, system, and program product for transferring document attributes | |
| US7457807B2 (en) | Data migration and analysis | |
| US5781911A (en) | Integrated system and method of data warehousing and delivery | |
| CN102609488B (en) | Client, data query method of client, server and data query system | |
| CN101655871A (en) | Method and device for storing and inquiring data | |
| US20080320060A1 (en) | Systems And Methods For Partitioning Data On Multiple Servers | |
| US9152998B2 (en) | Investor relations systems and methods | |
| CN101504672A (en) | Method and system for dynamically configuring physical data table | |
| WO2014137413A1 (en) | Systems and methods for interest-driven distributed data server systems | |
| CN101739452A (en) | Data exchange interface and realizing method thereof | |
| US20090144314A1 (en) | System and method for dynamically configuring a multi-model node table | |
| CN105164673A (en) | Query integration across databases and file systems | |
| CN102193990A (en) | Pattern database and realization method thereof | |
| CN102779138A (en) | Hard disk access method of real time data | |
| CN102902763A (en) | Method and device for relating and retrieving information processing data and processing information tasks | |
| CN105787058A (en) | User label system and data pushing system based on same | |
| CN101093482A (en) | Method for storing and retrieving mass information | |
| CN103246549A (en) | Method and system for data transfer | |
| CN101706818A (en) | Report dynamic filtering method and device | |
| US6957234B1 (en) | System and method for retrieving data from a database using a data management system | |
| WO2015171916A1 (en) | System and method for managing data transactions between applications | |
| CN101645062B (en) | Report form generation method and system | |
| CN103092916B (en) | The method and apparatus of amendment data structure | |
| CN103605797A (en) | Data storage and inquiry devices and data storage and inquiry methods |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20111214 |