WO2012051773A1

WO2012051773A1 - Method for filtering and analyzing data set of report and device for processing report

Info

Publication number: WO2012051773A1
Application number: PCT/CN2010/080238
Authority: WO
Inventors: 李冰
Original assignee: 中兴通讯股份有限公司
Priority date: 2010-10-18
Filing date: 2010-12-24
Publication date: 2012-04-26
Also published as: CN101957811A

Abstract

A method for filtering and analyzing a data set of a report and a device for processing the report. The method involves: obtaining a data set of an original column at the time of designing a page of a report (S110); selecting adjusting or filtering the data set (S120); setting restricted conditions of the adjusting or filtering (S130); adjusting or filtering the data set based on the selection and the restricted conditions corresponding to the selection (S140). The method and device can filter or adjust the result of the data set at the time of a report page designing process, achieving the purpose of deleting junk data or analyzing the data set of the report, accordingly reducing operational quantity of data processing equipments, consumption of equipments resources and relieving equipments of load.

Description

Data set filtering analysis method and report processing device of report

The present invention relates to a telecom value-added service implementation technology, and in particular, to a data set filtering analysis method and a report processing device for a report. Background technique

Reporting is the basic measure and approach for enterprise management. It is the basic business requirement of the enterprise. It is also the basis for implementing BI (Business Intelligence) strategy. It can provide insight into the operation of the enterprise and is a powerful driving force for enterprise development. Especially for telecommunication services, in addition to reflecting the operation of the entire system, the report is more important to provide decision support, which helps guide business development and improve service quality.

In telecom value-added services, reports are basically "page + data set" mode. In the prior art, the report design tool only provides a page frame, such as header, report format, etc., almost all data processing parts are placed. In the part of the data set. This requires writing a Query stored procedure for each page. For example, Table 1 is the SP downlink service success report.

The MMSC is a Multimedia Message Service; the VASPID is a value-added service provider identifier of the SP (Service Provider).

For example, Provincial A and Provincial B have different requirements. The provincial A ^ 艮 table shows records with a downlink business success rate greater than 80%, and the provincial B · ^ 艮 table shows records with a downlink business success rate greater than 85%. Therefore, for the same report data source (report data after statistics) view, you need two query stored procedures. If there are a lot of personalization requirements, developers need to make a large and comprehensive query, or need to develop a large number of patches to solve the needs of different customers after the project is implemented, and increase the work. The amount also increases the load on data processing devices (such as computers).

In addition, the current report display and data analysis are two parts, for example, Table 1: The provincial A requires a success rate of 80%. For the non-compliant vasp, the required value of the successful number is required to be analyzed. Multiply the number by 80% to get it, or need another analysis system to get this value, increase the amount of data processing equipment (such as computers, servers, etc.), consume a lot of equipment resources and increase the load on the equipment. Summary of the invention

The main object of the present invention is to provide a data set filtering analysis method and a report processing device for a report, so as to reduce the amount of calculation of the data processing device, reduce the consumption of device resources, and reduce the load on the device.

The technical solution adopted by the present invention to solve the technical problems thereof is:

A data set filtering analysis method for a report, comprising:

Obtain the data set of the original column when designing the page of the report;

Selecting to adjust or filter the data set;

Setting the restriction condition of the adjustment or the restriction condition of the filtering;

The data set is adjusted or filtered according to the selection and the constraint conditions corresponding to the selection.

Preferably, before acquiring the data set of the original column, the method further comprises: setting frame fixing information of the report.

Preferably, after adjusting or filtering the data set according to the selection and the constraint condition corresponding to the selection, the method further includes:

Set the column information that needs to be displayed on the page of the report.

Preferably, the selecting, adjusting, or filtering the data set specifically includes: determining whether the data set of the original column needs to be filtered or adjusted, and determining whether the data set of the original column needs to be filtered or needs to be adjusted. . Preferably, the adjusting or filtering the data set according to the selecting and the restriction condition corresponding to the selecting comprises: separating data that does not meet the filtering restriction condition according to the adjusted constraint condition.

The invention also provides a report processing device, comprising:

a data collection unit, configured to: when the page of the report is designed, obtain a data selection unit of the original column, configured to select to adjust or filter the data set;

And a condition setting unit, configured to set the restricted condition of the adjustment or the restricted condition of the filtering; and the operation execution unit is configured to perform an adjustment or filtering operation on the data set according to the selection and the constraint condition corresponding to the selection.

Preferably, the device further includes:

A report setting unit, configured to set frame fixing information of the report.

Preferably, the device further includes:

A page setting unit, configured to set column information to be displayed on a page of the report.

Preferably, the selecting unit is further configured to determine whether the data set of the original column needs to be filtered or adjusted, and determine whether the data set of the original column needs to be filtered or needs to be adjusted.

Preferably, the operation execution unit is further configured to separate data that does not meet the adjusted constraint condition according to the adjusted constraint condition, or filter out the constraint condition that does not meet the filtering according to the filtering constraint condition. The data.

The technical solution of the present invention has the following beneficial effects: The data set filtering analysis method and the report processing device of the report provided by the present invention can filter or adjust the data set result when the report page is designed, realize the deletion of the garbage data or implement the report. The purpose of the data set analysis is to reduce the amount of computation of the data processing device, reduce the consumption of device resources, and reduce the load on the device. DRAWINGS

FIG. 1 is a flowchart of a method according to an embodiment of the present invention;

2 is another flowchart of a method according to an embodiment of the present invention;

3 is a schematic structural diagram of a report processing device according to an embodiment of the present invention;

FIG. 4 is another schematic structural diagram of a report processing device according to an embodiment of the present invention. detailed description

The present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

An embodiment of the present invention provides a data set filtering analysis method for a report. As shown in FIG. 1, the method includes:

S110. Obtain a data set of the original column when designing the page of the report.

S120. Select to adjust or filter the data set.

S130. Set the restriction condition of the adjustment or the restriction condition of the filtering.

S140. Perform adjustment or filtering operations on the data set according to the selection and the constraint condition corresponding to the selection.

In addition, in a further embodiment, before S110, the method further includes: setting frame fixing information of the report.

In addition, in a further embodiment, after S140, the method further includes: setting column information that the page of the report needs to display.

According to Figure 1, it can be seen that the design of the entire report includes the acquisition of the data set and the production of the page.

Dataset acquisition: Connect the original data source. Take the MMS report as an example. The original data source is the original OT (initial termination) bill. The statistical storage process performs statistical processing on the data of the original OT bill to obtain the data required by the report page, that is, the report data source, and stores it in different In the table. The data displayed by the final corresponding page is obtained by creating a view. The query stored procedure is to obtain the data set of the report page by querying the view.

Page creation: Using the page creation tool, the framework of the report page is created, including the fixed information such as the report name and the header; at the same time, the page creation tool is used to connect to the database required by the report, and the stored data set is obtained by querying the stored procedure, and the data is obtained. Sets are processed, integrated, and integrated with the page framework.

Finally, the data of the report page (including the header, etc.) and the data of the report can be deployed in different databases, or they can be combined and connected through a proprietary report review tool, such as ZTE's OMMP (Operation and Maintenance Management) platform. The two parts of the data, you can get the final complete report. In addition, the reporting tool can also be used as a report browser to connect the above data, which can be easily tampering with the page and displayed in real time on the OMMP platform. Therefore, when the demand changes, it can respond quickly, without changing the background database.

The method provided by the above embodiment transfers part of the data processing from the data set to the page design stage, and also adds the function of report analysis. Therefore, it is necessary to adjust or filter the dataset of the original column during the design of the report page, such as: setting the filtering constraints or adjusting the constraints, and reprocessing the dataset during page design to make the future The report is based on a new data set, thereby reducing the amount of computation of the data processing device, reducing the consumption of device resources and reducing the load on the device.

Another more specific embodiment of the method is provided below. As shown in FIG. 2, the method includes: S201: setting a report frame fixed information;

Set some report name, parameters and other fixed information mainly through server, computer, etc. S202. Obtain a data set of the original column.

The server, the computer, and the like connect the database in which the report data is located through the report tool (that is, the report data source), and the data set of the original column can be obtained by calling the query stored procedure.

S203. Select whether it is necessary to filter or adjust the data set of the original column; 5204. If it is not required to filter and adjust the data set of the original column, use a server, a computer, etc. to directly design a normal report page by using a report tool; otherwise, go to S205;

5205. Select to filter or adjust the data set.

The filtering and adjustment are two-choice, filtering to delete the garbage data, and adjusting the analysis of the report data.

5206. Set the adjustment condition or the filtering restriction condition to correspond to a filtering condition or an adjustment condition;

Here, in addition to setting a simple restriction on the data set of the original column, you can also set a constraint that contains the expression value of the original column. If it is a constraint that contains the expression value of the original column, the original column A controllable column called this expression. An expression can only set one controllable column.

5207. Perform different operations for different selections of S205; that is, perform adjustment or filtering operations on the data set according to the selection and the constraint condition corresponding to the selection.

If S203 selects the filtering operation, the data set is selected according to the filtering restriction condition set by S206, and the data meeting the restriction condition can be retained as it is, and the data that does not meet the restriction condition is deleted, thereby realizing the garbage data cleaning. Compared with the data modification in the storage process in the prior art, the threshold of the garbage data in the embodiment of the present invention can be easily changed, and only the S206 can be modified, so that the change of the demand can be quickly and conveniently responded to.

If the adjustment operation is selected in S203, the data that does not meet the adjustment restriction condition is separated according to the adjustment condition set by S206, and the value of the original column is adjusted according to the adjustment restriction condition to satisfy the adjustment restriction condition, so that A new column. After adjustment, the new column and the original column can coexist, as long as the two original columns are copied, and one is used to adjust the new 歹'J after adjustment, one can remain as it is. After the adjustment, the new column is the same as the original column, and can be used as the data column (including the original column and the adjusted new column) displayed on the table. The difference is: the original column and the statistics using the original column are displayed on the page, and the default adjusted data is highlighted. It is also possible to select different display styles. As with the above filtering operations, the adjustment constraints are also easy to modify, eliminating the need for background database operations.

S208. Set column information that needs to be displayed on the page of the report;

The column information includes column names, value fields, and the like.

The method provided by this embodiment moves part of the data processing from the data set to the page design stage, and also adds the function of report analysis. Therefore, in the design of the report page, the data set of the original column needs to be adjusted or filtered, such as: setting the filtering restriction or the adjustment restriction condition, reprocessing the data set during the page design, and making the future report Based on a new data set, the amount of computation of the data processing device is reduced, the consumption of device resources is reduced, and the load on the device is reduced.

The embodiment of the invention further provides a report processing device, which is a device that can perform data processing, such as a server and a computer. As shown in Figure 3, the device includes:

a data set obtaining unit 410, configured to acquire a data set of the original column when designing the page of the report;

The selecting unit 420 is configured to select to adjust or filter the data set. In this embodiment, specifically, the selecting unit 420 is configured to determine whether the data set of the original column needs to be filtered or adjusted, and Determine if the data set of the original column needs to be filtered or needs to be adjusted.

a condition setting unit 430, configured to set a restriction condition of the adjustment or a restriction condition of filtering;

The operation execution unit 440 is configured to perform an adjustment or filtering operation on the data set according to the selection and the constraint condition corresponding to the selection. In this embodiment, more specifically, the operation execution unit 440 is configured to separate data that does not meet the adjusted constraint condition according to the adjusted constraint condition. In a further embodiment, as shown in FIG. 4, the device further includes:

The report setting unit 450 is configured to set frame fixing information of the report.

In a further embodiment, the device further includes:

The page setting unit 460 is configured to set column information that needs to be displayed on the page of the report. The device provided by this embodiment transfers part of the data processing from the data set to the page design stage, and also adds the function of report analysis. Therefore, in the design of the report page, the data set of the original column needs to be adjusted or filtered, such as: setting the filtering restriction or the adjustment restriction condition, reprocessing the data set during the page design, and making the future report Based on a new data set, the amount of computation of the data processing device is reduced, the consumption of device resources is reduced, and the load on the device is reduced.

Application examples of the above methods and apparatus are provided below.

The model of the report is as follows: the sp downlink service success report in Table 1 and the MMS center SP in Table 2 deliver the success rate report:

You need to collect statistics on the total number of VASP downlink services, the number of successes, and the success rate. Query stored procedures resulting data set is mmscname, vaspid ^ aonum _¾ aosuccnum (field names are in the database). The correspondence with the report column is shown in Table 2.

Statistical requirements: Table 2, only shows the statistics of the vasp with a downlink success rate greater than or equal to 90%. Interest.

Table 3 shows all the vasps, but for records with a success rate of less than 90%, if the success rate meets the requirements, the number of successes needs to be increased.

The implementation process of report two:

Design the fixed information of the report framework, name "MMS center SP delivery success report"; obtain the original data set by querying the stored procedure: mmscname, vaspid, aonum, aosuccnum.

The report condition success rate is greater than or equal to 90%, that is, aosuccnum/aonum>=0.9, which is a constraint for expressions. You can choose aosuccnum or aonum as a controllable column. Choose aosuccnum here. Because J3⁄4歹¹ J mmscname, vaspid, aonum are performed according to the normal design, no modification is made; 歹aosuccnum selects the filtering operation, and sets the filtering restriction condition: aosuccnum/aonum>=0.9. Complete the processing of the original data set to J3⁄4.

Then set the column information displayed on the page: MMSC, VASPID, total number of downlink services, number of downlink services, and success rate of downlink services. This completes the filtering design of Report 2.

The implementation process of Table 3:

Restriction aosuccnum/ aonum>=0.9, the requirement is to check the number of successes that need to be increased. Here, only aosuccnum can be selected as the controllable column.

Copy aosuccnum bad ¹ J, wherein a pair of aosuccnum, ¹ J modified bad name: alter- aosuccnum; ¹ J ^alter- aosuccnum of bad adjustment operation selection; setting adjustment constraints: aosuccnum / aonum> = 0.9; and setting the column Use the display style of the statistics item to the column. So far, I have adjusted the new column.

Then display the information displayed on the page: MMSC, VASPID, total number of downlink services, downlink The number of successful services, the number of successful adjustments, the number of successes, and the success rate of downlink services, where the number of successful downlink services and the number of successful successes correspond to aosuccnum and adjusted aosuccnum of the original data set, respectively. That is, alter- aosuccnum.

It can be seen intuitively through Report 3 that the success rate is 90% of the indicator value and the number of successes that need to be improved.

The above is only the preferred embodiment of the present invention, and is not intended to limit the present invention. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the protection of the present invention. Within the scope.

Claims

Claim

A data set filtering analysis method for a report, the method comprising: obtaining a data set of an original column when designing a page of the report;

Selecting to adjust or filter the data set;

2. The method of claim 1 wherein, prior to obtaining the data set of the original column, the method further comprises:

Set the frame fixing information for the report.

3. The method according to claim 2, wherein after the adjusting or filtering the data set according to the selection and the corresponding constraint condition, the method further comprises:

The method according to claim 1, 2 or 3, wherein the selecting or adjusting the data set comprises: determining whether the data set of the original column needs to be filtered or adjusted, and Determine if the data set of the original column needs to be filtered or needs to be adjusted.

The method according to claim 1, 2 or 3, wherein the adjusting or filtering the data set according to the selection and the constraint condition corresponding to the selecting comprises: adjusting according to the limitation Conditions separate data that does not meet the constraints of the adjustment, or press

A report processing device, wherein the device comprises:

a data set obtaining unit, configured to acquire data of an original column when designing a page of the report a selecting unit, configured to select to adjust or filter the data set;

The device according to claim 6, wherein the device further comprises: a report setting unit, configured to set frame fixed information of the report.

The device according to claim 7, wherein the device further comprises: a page setting unit, configured to set column information that the page of the report needs to display.

The device according to claim 6, 7 or 8, wherein the selecting unit is further configured to determine whether the data set of the original column needs to be filtered or adjusted, and determine a data set of the original column. Whether it needs to be filtered or needs to be adjusted.

The apparatus according to claim 6, 7 or 8, wherein the operation executing unit is further configured to separate data that does not meet the adjusted restriction condition according to the adjusted restriction condition.