CN104424250A - Method and device for generating data report - Google Patents
Method and device for generating data report Download PDFInfo
- Publication number
- CN104424250A CN104424250A CN201310381429.5A CN201310381429A CN104424250A CN 104424250 A CN104424250 A CN 104424250A CN 201310381429 A CN201310381429 A CN 201310381429A CN 104424250 A CN104424250 A CN 104424250A
- Authority
- CN
- China
- Prior art keywords
- kpi
- information
- cell
- identification information
- data sheet
- 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
- 238000000034 method Methods 0.000 title claims abstract description 40
- 230000015572 biosynthetic process Effects 0.000 claims description 7
- 208000018910 keratinopathic ichthyosis Diseases 0.000 abstract description 106
- 238000012545 processing Methods 0.000 abstract description 6
- 230000008569 process Effects 0.000 description 23
- 238000010586 diagram Methods 0.000 description 7
- 238000004590 computer program Methods 0.000 description 5
- 230000008859 change Effects 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 241000931705 Cicada Species 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000001747 exhibiting effect Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2264—Multidimensional index structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the technical field of data processing, and discloses a method and a device for generating a data report. According to the method, when multiple objects are required to be generated to correspond to the data reports of different key performance indicators (KPI), each object corresponds to each KPI, object identification information and corresponding KPI identification information intersect to form cells, and the time slot information is set in the cells in a two-dimensional table consisting of the object identification information and the KPI identification information, so that the data report in which multiple objects correspond to different KPIs is generated. Therefore, problems of long time consumption and low efficiency in generation of the data report in the prior art are solved.
Description
Technical field
The present invention relates to technical field of data processing, particularly a kind of generation method of data sheet and device.
Background technology
Along with the development that computer technology is maked rapid progress, IT application in enterprises becomes the inexorable trend of Enterprise progress, and people use computing machine to carry out the analysis and treament of various data more and more, thus provides data supporting for the decision-making of enterprise.The fundamental purpose of form is by data, utilizes systematized arrangement, according to different demands, so that the mode understood presents.Form is as part indispensable in modern enterprise application system, experienced by a revolutionary change, automatically generate from the early stage system made by hand till now, from carrying out the decision data analysis till now of basic mathematical statistics, form, as the most important approach of the data exhibiting in infosystem, plays huge effect.
In enterprise's application scenarios, such as, in wireless network maintenance process, relevant staff needs to obtain multiple object, at the appointed time identical or different in section KPI(Key Performance Indicator, KPI Key Performance Indicator) data sheet (such as, the cutting off rate trend analysis form of the some or multiple object in certain period, the Analysis of Causes on Dropped Call form of the some or multiple object in certain period), thus, be optimized targetedly, therefore, along with popularizing of network, in performance report management system, generate data sheet and just become more and more important.
In prior art, in the generative process of data sheet, " object id information ", " KPI identification information ", " time parameter " these three parameters present respectively by three TAB tabs in the terminal, user is when arranging these three parameters, need to switch in these three TAB tabs, then, arrange in these three TAB tabs respectively, as shown in Figure 1, but, because said method is when generating data sheet each time, if there is multiple object, for any two different objects, the identical KPI parameter in corresponding same time section can only be generated, can not for different objects, generate the different K PI in corresponding different time sections.
Such as, the object id information arranged in " object id information " TAB tab is RNC(RadioNetwork Controller, radio network controller) 403, RNC404, the KPI identification information arranged in " KPI identification information " TAB tab is cutting off rate, call drop reason, the time arranged in " time parameter " TAB tab is 2013-7-312:00-24:00,2013-7-412:00-24:00, then the data sheet generated comprises following content:
The cutting off rate trend of RNC403 within this time period of 2013-7-312:00-24:00, call drop reason trend, the cutting off rate trend of RNC404 within this time period of 2013-7-312:00-24:00, call drop reason trend, the cutting off rate trend of RNC403 within this time period of 2013-7-412:00-24:00, call drop reason trend, the cutting off rate trend of RNC404 within this time period of 2013-7-412:00-24:00, call drop reason trend.To only generate the call drop reason trend of RNC403 within this time period of 2013-7-412:00-24:00, the cutting off rate trend of RNC404 within this time period of 2013-7-312:00-24:00, then twice data sheet generating run be to carry out, the call drop reason trend of RNC403 within this time period of 2013-7-412:00-24:00, the cutting off rate trend of RNC404 within this time period of 2013-7-312:00-24:00 only could be generated.
Above-mentioned just to generate the data sheet of two objects KPI corresponding different respectively, in actual applications, generate the data sheet of multiple object KPI corresponding different respectively possibly, at this moment, the interface shown in Fig. 1 will be used to carry out repeatedly the generating run of data sheet, the data sheet of the respectively corresponding different KPI of multiple object could be generated, therefore, there is data sheet generative process longer, problem that efficiency is lower consuming time.
In prior art, generate the data sheet of multiple object KPI corresponding different respectively, a data sheet generating run to be performed respectively for each object, that is, perform repeatedly data sheet generating run, the data sheet of multiple object KPI corresponding different respectively could be generated, and in the embodiment of the present invention, when needing the data sheet generating multiple object KPI corresponding different respectively, for each KPI that each object is corresponding, only need in the bivariate table formed in object id information and KPI identification information, setup times segment information in this object id information and corresponding KPI identification information intersect the cell that formed, then, the disposable data sheet that just can generate multiple object KPI corresponding different respectively, therefore, solve in prior art generate data sheet time exist consuming time longer, the problem that efficiency is lower.
Summary of the invention
The embodiment of the present invention provides a kind of generation method and device of data sheet, in order to solve consuming time longer, the problem that efficiency is lower that exist when generating data sheet in prior art.
First aspect, provides a kind of generation method of data sheet, comprising:
After receiving the request of data sheet optimum configurations, at least one object id information and at least one KPI Key Performance Indicator KPI identification information are presented with the form of bivariate table;
Determine in the bivariate table presented, selected intersect by object id information and KPI identification information the cell formed;
For selected each cell, perform respectively:
Presentative time input template control in this cell, and obtain the time period information arranged in the time input template control that this presents;
Obtain the object that the object id information of this cell of formation is corresponding, in the time period information obtained, form the KPI data that the KPI identification information of this cell is corresponding;
The object id information corresponding based on the KPI data obtained, time period information, this cell and KPI identification information, generate should cell data sheet.
In conjunction with first aspect, in the implementation that the first is possible, at least one object id information and at least one KPI identification information are presented with the form of bivariate table, specifically comprise:
At least one object id information described is presented with horizontal tabulation, at least one KPI identification information described is presented with vertical tabulation; Or
At least one object id information described is presented with vertical tabulation, at least one KPI identification information described is presented with horizontal tabulation.
In conjunction with first aspect, or the first possible implementation of first aspect, in the implementation that the second is possible, presentative time input template control in this cell, specifically comprises:
With highlighted fashion presentative time input template control in this cell; Or, with dynamic-form presentative time input template control in this cell.
In conjunction with first aspect, or the implementation that the first to the second of first aspect is possible, in the implementation that the third is possible, the form of described data sheet is Excel form, or is Text form, or is Word form.
In conjunction with first aspect, or first of first aspect to the third possible implementation, in the 4th kind of possible implementation, after generation data sheet, also comprises:
With short message way, or instant message mode, or lettergram mode sends for notifying that user successfully generates the notification message of data sheet to user.
Second aspect, provides a kind of generating apparatus of data sheet, comprising:
Display unit, after receiving the request of data sheet optimum configurations, presents at least one object id information and at least one KPI Key Performance Indicator KPI identification information with the form of bivariate table;
Determining unit, for determining in the bivariate table presented, selected intersects by object id information and KPI identification information the cell formed; For selected each cell, perform respectively: presentative time input template control in this cell, and obtain the time period information arranged in the time input template control that this presents; Obtain the object that the object id information of this cell of formation is corresponding, in the time period information obtained, form the KPI data that the KPI identification information of this cell is corresponding; The object id information corresponding based on the KPI data obtained, time period information, this cell and KPI identification information, generate should cell data sheet.
In conjunction with second aspect, in the implementation that the first is possible, described display unit specifically for:
At least one object id information described is presented with horizontal tabulation, at least one KPI identification information described is presented with vertical tabulation; Or
At least one object id information described is presented with vertical tabulation, at least one KPI identification information described is presented with horizontal tabulation.
In conjunction with second aspect, or the first possible implementation of second aspect, in the implementation that the second is possible, described determining unit specifically for: with highlighted fashion presentative time input template control in this cell; Or, with dynamic-form presentative time input template control in this cell.
In conjunction with second aspect, or the implementation that the first to the second of second aspect is possible, in the implementation that the third is possible, the form of the data sheet that described determining unit generates is Excel form, or is Text form, or is Word form.
In conjunction with second aspect, or first of second aspect to the third possible implementation, in the 4th kind of possible implementation, also comprises: notification unit, described notification unit specifically for:
With short message way, or instant message mode, or lettergram mode sends for notifying that user successfully generates the notification message of data sheet to user.
Accompanying drawing explanation
Fig. 1 is the schematic diagram that in prior art, data sheet generates;
Fig. 2 is the detail flowchart of the generation of data sheet in the embodiment of the present invention;
Fig. 3 A is the first embodiment generating data sheet in the embodiment of the present invention;
Fig. 3 B is the second embodiment generating data sheet in the embodiment of the present invention;
Fig. 3 C is the 3rd embodiment generating data sheet in the embodiment of the present invention;
Fig. 3 D is the 4th embodiment generating data sheet in the embodiment of the present invention;
Fig. 4 A is the 5th embodiment generating data sheet in the embodiment of the present invention;
Fig. 4 B is the 6th embodiment generating data sheet in the embodiment of the present invention;
Fig. 5 A is the 7th embodiment generating data sheet in the embodiment of the present invention;
Fig. 5 B is the 8th embodiment generating data sheet in the embodiment of the present invention;
Fig. 6 is the 9th embodiment generating data sheet in the embodiment of the present invention;
Fig. 7 is the schematic diagram generating data sheet device in the embodiment of the present invention.
Embodiment
In order to solve consuming time longer, the problem that efficiency is lower that exist when generating data sheet, in the embodiment of the present invention, proposing a kind of generation method of data sheet, effectively can avoid longer, problem that efficiency is lower consuming time.
For making the object of the embodiment of the present invention, technical scheme and advantage clearly, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Term "and/or" herein, being only a kind of incidence relation describing affiliated partner, can there are three kinds of relations in expression, and such as, A and/or B, can represent: individualism A, exists A and B simultaneously, these three kinds of situations of individualism B.In addition, character "/" herein, general expression forward-backward correlation is to the relation liking a kind of "or".
Below in conjunction with accompanying drawing, the preferred embodiment of the present invention is described in detail.
Consult shown in Fig. 2, in the embodiment of the present invention, the detailed process generating data sheet is as follows:
Step 200: after receiving the request of data sheet optimum configurations, at least one object id information and at least one KPI Key Performance Indicator KPI identification information are presented with the form of bivariate table;
Step 210: determine in the bivariate table presented, selected intersects by object id information and KPI identification information the cell formed; Wherein, for selected each cell, perform respectively:
Step 220: presentative time input template control in this cell, and obtain the time period information arranged in the time input template control that this presents;
Step 230: obtain the object that the object id information of this cell of formation is corresponding, form the KPI data that the KPI identification information of this cell is corresponding in the time period information obtained;
Step 240: the object id information corresponding based on the KPI data obtained, time period information, this cell and KPI identification information, generates should cell data sheet.
In the embodiment of the present invention, at least one object id information and at least one KPI identification information are had multiple in the mode that the form of bivariate table carries out presenting, optionally, at least one object id information is presented with horizontal tabulation, at least one KPI identification information is presented with vertical tabulation; Or, at least one object id information is presented with vertical tabulation, at least one KPI identification information is presented with horizontal tabulation.
That is, if with horizontal tabulation composition horizontal ordinate, vertical tabulation composition ordinate is example, Ke Yiwei, and object id information is horizontal ordinate, and KPI identification information is ordinate; Also can be that object id information is ordinate, KPI identification information be horizontal ordinate.
In this cell, the mode of presentative time input template control has multiple, such as, with highlighted fashion presentative time input template control in this cell; Again such as, in this cell with dynamic-form presentative time input template control.
In the embodiment of the present invention, the time period information arranged in time input template control of acquisition can be that user inputs, and also can be the time period that other cells that user copies have been arranged, also have other modes, describe in detail no longer one by one at this.
In the embodiment of the present invention, the form of the data sheet of generation has multiple, optionally, can be Excel form, or can be Text form, or can also be Word form.
Further, in order to the message generating data sheet is notified related personnel in time, in the embodiment of the present invention, after generation data sheet, also comprise:
With short message way, or instant message mode, or lettergram mode sends for notifying that user successfully generates the notification message of data sheet to user.
In order to understand the embodiment of the present invention better, below providing embody rule scene, for the generative process of data sheet, making and describing in further detail:
Consult shown in Fig. 3 A, embodiment one is the data sheet generating all KPIs of all objects at the appointed time in section:
Embodiment one:
Step 300: after receiving the request of data sheet optimum configurations, at least one object id information and at least one KPI Key Performance Indicator KPI identification information are presented with the form of bivariate table
Step 310: determine that the object id information that selected cell lattice are corresponding is all objects, corresponding KPI identification information is all KPI;
Step 320: setup times section is 2013-3-17-2013-3-23 in the time input template control that this cell presents;
Step 330: obtain the data that each KPI of each object is corresponding;
Step 340: the KPI data of acquisition, time period information, object id information and KPI identification information, generates should cell data sheet.
In actual applications, also disposable of possibility needs the data of the at the appointed time interior single KPI obtaining single object, and generative process and the embodiment one of data sheet are similar, as shown in Figure 3 B, no longer describe in detail at this.
In actual applications, also disposable of possibility needs the data of the at the appointed time interior corresponding all KPI obtaining single object, and generative process and the embodiment one of data sheet are similar, as shown in Figure 3 C, no longer describe in detail at this.
In actual applications, also disposable of possibility needs the data of the at the appointed time interior corresponding single KPI obtaining all objects, and generative process and the embodiment one of data sheet are similar, as shown in Figure 3 D, no longer describe in detail at this.
Consult shown in Fig. 4 A, embodiment one is the data sheet generating three KPIs of single object at the appointed time in section:
Embodiment two:
Step 400: after receiving the request of data sheet optimum configurations, at least one object id information and at least one KPI Key Performance Indicator KPI identification information are presented with the form of bivariate table;
Step 410: determine that selected cell lattice have three, wherein, the object id information that each cell is corresponding is identical, and corresponding KPI identification information is different;
In this step, the object id information that three cells are corresponding is BSC01, and corresponding KPI identification information is respectively Accessibility, Retainability, Mobility.
Step 420: in three cells setup times section respectively;
In this step, due to the cell that BSC01 and Retainability determines, with due to time period of setting identical, therefore, the time period arranged in the cell that BSC01 and Retainability is determined, copy in the time input template control that cell that BSC01 and Mobility determine presents.
Step 430: the data obtaining Accessibility, Retainability, Mobility of BSC01 respectively;
Step 440: the KPI data of acquisition, time period information, BSC01, and Accessibility, Retainability, Mobility, generates data sheet.
In actual applications, also disposable of possibility needs the data of the at the appointed time interior single KPI obtaining multiple object, and generative process and the embodiment two of data sheet are similar, as shown in Figure 4 B, no longer describe in detail at this.
Consult shown in Fig. 5 A, embodiment one is the data sheet generating the corresponding different K PI of the difference of multiple object at the appointed time in section:
Embodiment three:
Step 500: after receiving the request of data sheet optimum configurations, at least one object id information and at least one KPI Key Performance Indicator KPI identification information are presented with the form of bivariate table;
Step 510: determine that selected cell lattice have four, wherein, four cells are divided into two groups, and the object id information often organizing cell corresponding is identical, and corresponding KPI identification information is different;
In this step, the object id information that first group of cell is corresponding is BSC01, and corresponding KPI identification information is respectively Retainability, Resource; The object id information that second group of cell is corresponding is BSC03, and corresponding KPI identification information is respectively Retainability, Mobility.
Step 520: in three cells setup times section respectively;
Step 530: the data obtaining Retainability, Resource of BSC01 respectively, and the data of Retainability, Mobility of BSC03;
Step 540: the KPI data of acquisition, time period information, BSC01, BSC03, and Resource, Retainability, Mobility, generates data sheet.
In actual applications, disposable to obtain multiple object at the appointed time in the data of KPI time, also the KPI that each object of possibility is corresponding is all identical, now, if after determining the cell corresponding to an object, receive the instruction selecting identical KPI identification information again, just determine that KPI identifies identical respective cells.
Such as, consult shown in Fig. 5 B, when the KPI selecting BSC01 corresponding, when receiving the instruction selecting identical KPI identification information, also choose the cell of KPI corresponding to Retainability, Resource, Mobility that BSC03 is corresponding, the instruction of the identical KPI identification information of concrete selection, can be present the option determining to select identical KPI identification information user at interface, user, when selected, just can determine to receive the instruction selecting identical KPI identification information.
In actual applications, likely object id information or KPI identification information quantity more, at the cell that each object id information is corresponding, and/or cell corresponding to each KPI identification information is set to drop-down list, corresponding KPI identification information or corresponding object id information is selected, specifically as shown in Figure 6 in drop-down list.
Based on technique scheme, consult shown in Fig. 7, in the embodiment of the present invention, the generating apparatus of data sheet comprises display unit 70 and determining unit 71, wherein,
Display unit 70, after receiving the request of data sheet optimum configurations, presents at least one object id information and at least one KPI Key Performance Indicator KPI identification information with the form of bivariate table;
Determining unit 71, for determining in the bivariate table presented, selected intersects by object id information and KPI identification information the cell formed; For selected each cell, perform respectively: presentative time input template control in this cell, and obtain the time period information arranged in the time input template control that this presents; Obtain the object that the object id information of this cell of formation is corresponding, in the time period information obtained, form the KPI data that the KPI identification information of this cell is corresponding; The object id information corresponding based on the KPI data obtained, time period information, this cell and KPI identification information, generate should cell data sheet.
Preferably, in the embodiment of the present invention, display unit 70 specifically for: at least one object id information is presented with horizontal tabulation, at least one KPI identification information is presented with vertical tabulation; Or, at least one object id information is presented with vertical tabulation, at least one KPI identification information is presented with horizontal tabulation.
Preferably, in the embodiment of the present invention, determining unit 71 specifically for: with highlighted fashion presentative time input template control in this cell; Or, with dynamic-form presentative time input template control in this cell.
Preferably, in the embodiment of the present invention, the form of the data sheet that determining unit 71 generates is Excel form, or is Text form, or is Word form.
Further, in the embodiment of the present invention, also comprise: notification unit 72, notification unit 72 specifically for:
With short message way, or instant message mode, or lettergram mode sends for notifying that user successfully generates the notification message of data sheet to user.
In sum, in order to solve consuming time longer, the problem that efficiency is lower that exist when generating data sheet, in the embodiment of the present invention, a kind of generation method of data sheet is proposed, after receiving the request of data sheet optimum configurations, at least one object id information and at least one KPI Key Performance Indicator KPI identification information are presented with the form of bivariate table, determine in the bivariate table presented, selected intersect by object id information and KPI identification information the cell formed, for selected each cell, perform respectively: presentative time input template control in this cell, and obtain the time period information inputted in the time input template control that this presents, obtain the object that the object id information of this cell of formation is corresponding, in the time period information obtained, form the KPI data that the KPI identification information of this cell is corresponding, based on the KPI data obtained, time period information, the object id information that this cell is corresponding and KPI identification information, generate should cell data sheet, like this, when needing the data sheet generating multiple object KPI corresponding different respectively, for each KPI that each object is corresponding, only need in the bivariate table formed in object id information and KPI identification information, setup times segment information in this object id information and corresponding KPI identification information intersect the cell that formed, then, the disposable data sheet that just can generate multiple object KPI corresponding different respectively, therefore, solve in prior art generate data sheet time exist consuming time longer, the problem that efficiency is lower.
The present invention describes with reference to according to the process flow diagram of the method for the embodiment of the present invention, equipment (system) and computer program and/or block scheme.Should understand can by the combination of the flow process in each flow process in computer program instructions realization flow figure and/or block scheme and/or square frame and process flow diagram and/or block scheme and/or square frame.These computer program instructions can being provided to the processor of multi-purpose computer, special purpose computer, Embedded Processor or other programmable data processing device to produce a machine, making the instruction performed by the processor of computing machine or other programmable data processing device produce device for realizing the function in process flow diagram flow process or multiple flow process and/or block scheme square frame or multiple square frame.
These computer program instructions also can be stored in can in the computer-readable memory that works in a specific way of vectoring computer or other programmable data processing device, the instruction making to be stored in this computer-readable memory produces the manufacture comprising command device, and this command device realizes the function in process flow diagram flow process or multiple flow process and/or block scheme square frame or multiple square frame.
These computer program instructions also can be loaded in computing machine or other programmable data processing device, make on computing machine or other programmable device, to perform sequence of operations step to produce computer implemented process, thus the instruction performed on computing machine or other programmable device is provided for the step of the function realized in process flow diagram flow process or multiple flow process and/or block scheme square frame or multiple square frame.
Although describe the above embodiment of the present invention, those skilled in the art once obtain the basic creative concept of cicada, then can make other change and amendment to these embodiments.So claims are intended to be interpreted as comprising above-described embodiment and falling into all changes and the amendment of the scope of the invention.
Obviously, those skilled in the art can carry out various change and modification to the embodiment of the present invention and not depart from the spirit and scope of the embodiment of the present invention.Like this, if these amendments of the embodiment of the present invention and modification belong within the scope of the claims in the present invention and equivalent technologies thereof, then the present invention is also intended to comprise these change and modification.
Claims (10)
1. a generation method for data sheet, is characterized in that, comprising:
After receiving the request of data sheet optimum configurations, at least one object id information and at least one KPI Key Performance Indicator KPI identification information are presented with the form of bivariate table;
Determine in the bivariate table presented, selected intersect by object id information and KPI identification information the cell formed;
For selected each cell, perform respectively:
Presentative time input template control in this cell, and obtain the time period information arranged in the time input template control that this presents;
Obtain the object that the object id information of this cell of formation is corresponding, in the time period information obtained, form the KPI data that the KPI identification information of this cell is corresponding;
The object id information corresponding based on the KPI data obtained, time period information, this cell and KPI identification information, generate should cell data sheet.
2. the method for claim 1, is characterized in that, at least one object id information and at least one KPI identification information is presented with the form of bivariate table, specifically comprises:
At least one object id information described is presented with horizontal tabulation, at least one KPI identification information described is presented with vertical tabulation; Or
At least one object id information described is presented with vertical tabulation, at least one KPI identification information described is presented with horizontal tabulation.
3. method as claimed in claim 1 or 2, it is characterized in that, presentative time input template control in this cell, specifically comprises:
With highlighted fashion presentative time input template control in this cell; Or, with dynamic-form presentative time input template control in this cell.
4. the method as described in any one of claim 1-3, is characterized in that, the form of described data sheet is Excel form, or is Text form, or is Word form.
5. the method as described in any one of claim 1-4, is characterized in that, after generation data sheet, also comprises:
With short message way, or instant message mode, or lettergram mode sends for notifying that user successfully generates the notification message of data sheet to user.
6. a generating apparatus for data sheet, is characterized in that, comprising:
Display unit, after receiving the request of data sheet optimum configurations, presents at least one object id information and at least one KPI Key Performance Indicator KPI identification information with the form of bivariate table;
Determining unit, for determining in the bivariate table presented, selected intersects by object id information and KPI identification information the cell formed; For selected each cell, perform respectively: presentative time input template control in this cell, and obtain the time period information arranged in the time input template control that this presents; Obtain the object that the object id information of this cell of formation is corresponding, in the time period information obtained, form the KPI data that the KPI identification information of this cell is corresponding; The object id information corresponding based on the KPI data obtained, time period information, this cell and KPI identification information, generate should cell data sheet.
7. device as claimed in claim 6, is characterized in that, described display unit specifically for:
At least one object id information described is presented with horizontal tabulation, at least one KPI identification information described is presented with vertical tabulation; Or
At least one object id information described is presented with vertical tabulation, at least one KPI identification information described is presented with horizontal tabulation.
8. device as claimed in claims 6 or 7, is characterized in that, described determining unit specifically for: with highlighted fashion presentative time input template control in this cell; Or, with dynamic-form presentative time input template control in this cell.
9. the device as described in any one of claim 6-8, is characterized in that, the form of the data sheet that described determining unit generates is Excel form, or is Text form, or is Word form.
10. the device as described in any one of claim 6-9, is characterized in that, also comprises: notification unit, described notification unit specifically for:
With short message way, or instant message mode, or lettergram mode sends for notifying that user successfully generates the notification message of data sheet to user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310381429.5A CN104424250B (en) | 2013-08-28 | 2013-08-28 | The generation method and device of a kind of data sheet |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310381429.5A CN104424250B (en) | 2013-08-28 | 2013-08-28 | The generation method and device of a kind of data sheet |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104424250A true CN104424250A (en) | 2015-03-18 |
| CN104424250B CN104424250B (en) | 2018-03-02 |
Family
ID=52973237
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310381429.5A Active CN104424250B (en) | 2013-08-28 | 2013-08-28 | The generation method and device of a kind of data sheet |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104424250B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243490A (en) * | 2015-10-12 | 2016-01-13 | 湖南快乐阳光互动娱乐传媒有限公司 | KPI statistical system and KPI statistical method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060041539A1 (en) * | 2004-06-14 | 2006-02-23 | Matchett Douglas K | Method and apparatus for organizing, visualizing and using measured or modeled system statistics |
| CN101957849A (en) * | 2010-09-21 | 2011-01-26 | 用友软件股份有限公司 | Static statement generation method and device |
| CN102982084A (en) * | 2011-11-01 | 2013-03-20 | 微软公司 | Multi-dimentional data report |
-
2013
- 2013-08-28 CN CN201310381429.5A patent/CN104424250B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060041539A1 (en) * | 2004-06-14 | 2006-02-23 | Matchett Douglas K | Method and apparatus for organizing, visualizing and using measured or modeled system statistics |
| CN101957849A (en) * | 2010-09-21 | 2011-01-26 | 用友软件股份有限公司 | Static statement generation method and device |
| CN102982084A (en) * | 2011-11-01 | 2013-03-20 | 微软公司 | Multi-dimentional data report |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243490A (en) * | 2015-10-12 | 2016-01-13 | 湖南快乐阳光互动娱乐传媒有限公司 | KPI statistical system and KPI statistical method |
| CN105243490B (en) * | 2015-10-12 | 2018-12-25 | 湖南快乐阳光互动娱乐传媒有限公司 | A kind of statistical system and method based on git software |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104424250B (en) | 2018-03-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103617486A (en) | Method and system for conducting dynamic graphical monitoring on complex service processes | |
| Akanmu et al. | Auto-generated site layout: an integrated approach to real-time sensing of temporary facilities in infrastructure projects | |
| CN105745585B (en) | Unload human-computer interaction task | |
| CN105426244B (en) | Application process management method and application process managing device | |
| EP3159146A1 (en) | 3d printing system, method for producing 3d printed object, information processing device, method for generating shrink-resistant structure in 3d object, and program for generating shrink-resistant structure in 3d printed object | |
| CN104978114A (en) | Method and device for displaying chart | |
| CN109459933A (en) | A kind of Markov jump system control method based on asynchronous mode observer | |
| CN105843523A (en) | Information processing method and apparatus | |
| JP2019021014A (en) | System and method for monitoring progress/operation | |
| CN109508843A (en) | A kind of intelligent Service implementation method and device | |
| CN104272267A (en) | Method for monitoring resources in computing device, and computing device | |
| CN104424250A (en) | Method and device for generating data report | |
| US9665668B2 (en) | Configuring a dispatching rule for execution in a simulation | |
| US20220277268A1 (en) | Project management apparatus, project management method, and recording medium | |
| WO2017098618A1 (en) | Display method, display program, and display control device | |
| Chavada et al. | A framework for construction workspace management: a serious game engine approach | |
| CN108089080B (en) | Power distribution network planning monitoring system | |
| CN103813354A (en) | Method and device for evaluating performance of terminal | |
| JP5582212B2 (en) | System construction support apparatus, program for causing a computer to function as this system construction support apparatus, and computer-readable recording medium recording this program | |
| JP2011008581A (en) | System construction support device, program for making computer function as the same device, and computer-readable recording medium recorded with the same program | |
| CN112764357A (en) | Engineering machinery simulation method, device, equipment and storage medium | |
| WO2019111580A1 (en) | Scheduling device, scheduling method, and storage medium | |
| CN103544250A (en) | Method and device for analyzing data | |
| US9912541B2 (en) | Network management apparatus, line condition improvement method, and non-transitory computer readable medium storing program | |
| CN109710395A (en) | Parameter optimization control method, device and distributed computing system |
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 | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20191230 Address after: 271000 Spring Rain Software Park, Taishan District, Tai'an City, Shandong Province, 1-4 floors Patentee after: Taishan Information Technology Co.,Ltd. Address before: 510000 unit 2414-2416, building, No. five, No. 371, Tianhe District, Guangdong, China Patentee before: GUANGDONG GAOHANG INTELLECTUAL PROPERTY OPERATION Co.,Ltd. Effective date of registration: 20191230 Address after: 510000 unit 2414-2416, building, No. five, No. 371, Tianhe District, Guangdong, China Patentee after: GUANGDONG GAOHANG INTELLECTUAL PROPERTY OPERATION Co.,Ltd. Address before: 518129 Bantian HUAWEI headquarters office building, Longgang District, Guangdong, Shenzhen Patentee before: HUAWEI TECHNOLOGIES Co.,Ltd. |
|
| TR01 | Transfer of patent right | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A Method and Device for Generating Data Reports Effective date of registration: 20231019 Granted publication date: 20180302 Pledgee: Taian Taishan Caiyuan Investment Group Co.,Ltd. Pledgor: Taishan Information Technology Co.,Ltd. Registration number: Y2023980061603 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right |