WO2011009316A1

WO2011009316A1 - Report form server, method for generating instant report forms and system thereof

Info

Publication number: WO2011009316A1
Application number: PCT/CN2010/072023
Authority: WO
Inventors: 蒋柯
Original assignee: 中兴通讯股份有限公司
Priority date: 2009-07-20
Filing date: 2010-04-21
Publication date: 2011-01-27
Also published as: CN101615205A

Abstract

A method for generating instant report forms is disclosed by the present invention. The method includes: a server end generates report form models and uploads them to a report form server; a client end accesses an instant report form service module in the report form server, customizes instant report forms according to the stored report form model and stores the customized instant report forms in the report form server. A report form server and a system for generating instant report forms are also disclosed by the present invention. The speed of the response to demands can be increased and the usability of report forms can be improved by adopting the present invention.

Description

Server, instant implementation method and system

The present invention relates to a telecom value-added service implementation technology, and in particular, to a report server, an instant report implementation method and system. Background technique

Telecom value-added services, such as MMS services, CRBT services, mobile games and messaging services, are an important utilization point for the telecommunications industry. Effective statistical analysis of all types of data for telecom value-added services will help guide business development, provide service quality, and provide support for decision makers to achieve sustained profit growth. Therefore, it is necessary to collect, sort, integrate and aggregate various types of telecom value-added service data, and then report it to customers. The telecom value-added service processing system that performs these functions is called a business table implementation system, and the service The core of the system implementation system is the collection, sorting, integration, aggregation and display of various types of telecom value-added service data by the report server. As shown in FIG. 1, the report server 10 in the prior art is composed of a report database 11 and a report service module 12. Report data is stored in the report database 11, and the report service module 12 provides all operations for the report, including querying, modifying, and deleting the exported report file. The various reports may be stored in the report database 11 or in the report service module 12. If the report is stored in the report database 11, when the report service module 12 needs to modify the report, the report should be called out from the report database 11 and then modified; if the report is stored in the report service module 12, the report The service module 12 can directly invoke the report to modify it.

In the prior art, the implementation method of the business report is made by the customer, and the service provider (SP, Service Provider) develops according to the requirements, and then delivers the developed report to the customer. The biggest disadvantage of this method is the low response speed and high workload. Flexible report design Sex, customer demand changes can be said to be endless, and SP's development capabilities are limited, coupled with SP's report developers and customers lack communication, so it is easy to cause demand and report results are inconsistent. Summary of the invention

In view of this, the main object of the present invention is to provide a report server and an instant report implementation method and system, which can improve the demand response speed and improve the availability of the report.

In order to achieve the above object, the technical solution of the present invention is achieved as follows:

A report server includes a report database and a report service module, and the report service module includes an instant report service module.

An instant report service module, which provides a report model for custom instant reports for clients, and stores customized real-time reports in a report database or report service module.

An instant method for implementing a table includes:

The server generates a report model, and uploads the generated report model to the report server; the client accesses the report server, customizes the real-time report according to the stored report model, and stores the customized instant report to the report server.

The generating the report model specifically includes: obtaining a data table or a view required for an instant report from a report database of the report server, associating the obtained data table or view, and setting a display format of the field in the data table or the view. .

The customizing the real-time report according to the stored report model, and storing the customized completed instant report to the report server specifically includes:

Set the report type of the instant report;

Select the data table or view to be used for the real-time report from the report model as the data source of the instant report, and select the field in the data source as the field of the instant report;

Set the query conditions for the instant report;

Preview live reports and store them on the report server.

After the query condition of the instant report is set, the method further includes: setting Report style for instant reporting.

Wherein, after storing the customized instant report to the report server, the method further includes:

The client modifies the live reports that are stored in the report server.

The client uses the stored instant report to query the immediate report results.

An instant report implementation system, the system includes a server, a report server, and a client; wherein

The server is used to generate a report model, and upload the generated report model to the report server; the report server is configured to store the report model uploaded by the server and provide a report model for the client;

Client, used to access the report server, customize the real-time report based on the stored report model, and store the customized real-time report to the report server.

The client is further configured to modify an existing report stored in the report server. The client is further configured to query the instant report result by using the stored instant report. It can be seen from the above technical solution that the present invention transfers the customization of the report from the server to the client, and the server only needs to generate the report model, and does not completely complete the development of all the reports. The report model constrains the relationship between various data and The display format, the client in the framework of the report model, according to their own needs to complete the customization of the real-time report. Customized real-time reports are stored in the report server for repeated query by customers. In addition, the client can modify and delete the customized real-time reports, which greatly reduces the workload of the server. It also supports the rapid development of reports and improves the freedom of customers to use the reporting system. DRAWINGS

1 is a schematic structural diagram of a prior art report server; 2 is a schematic structural diagram of a report server according to the present invention;

3 is a schematic flowchart of a method for realizing an instant report according to the present invention;

FIG. 4 is a topological diagram of an application of the real-time report implementation system of the present invention. detailed description

The basic idea of the invention is: to transfer the specific customization work of the report from the server to the client, and the server only provides the report model for the client, and the report model can meet the general report customization requirements of the client. In this article, a client-customized report is called an instant report. In addition, the report server adds an instant report service module that helps clients use the report model to customize real-time reports. In addition, customized, on-the-fly reports can be stored on the report server, and clients can query and manage real-time reports through the Reporting Services module on the report server.

The technical solution of the present invention will be described in detail below with reference to the accompanying drawings.

As shown in FIG. 2, the report server 10 of the present invention includes a report database 11 and a report service module 12.

The report database 11 is used for acquiring and storing report data, and how to obtain and store the report data is not within the scope of implementation of the present invention, so the description is not extended;

The report service module 12 is used to provide the client with all operations for the report, including querying, deleting, exporting files, etc. The report includes a server-customized report and a customized instant report.

The difference between the report server 10 of the present invention and the prior art report server is that the report service module 12 further includes an instant report service module 121, and the instant report service module 121 is configured to provide a customized real-time report report model for the client, and the customized report The instant report is stored in the report database 11 or the report service module 12.

As shown in FIG. 3, the instant table implementation method of the present invention includes the following steps:

Step 301: The server generates a report model, and uploads the generated report model to the report server. The report model is generated by obtaining report data such as various data tables or views that may be needed for the real-time report from the report database of the report server, and associating the data tables or views to form a "star". Or a "mesh"relationship; the second is to set the display format of the fields in the data table or view, for example, the display format of a field can be set to "integer" or "float type".

The association of various data tables or views includes: association of the data table with the data table, association of the data table with the view, and association of the view with the view. Here, a view is composed of data from one or more data tables, which can be understood as a special data table.

In addition, uploading the report model to the report server is as follows: According to the calling mode of the instant report service module, the generated report model can be stored in the report service module as a file, or the generated report model can be used as a data table. The form is stored in the report database.

Step 302: The client accesses the report server, customizes the real-time report according to the stored report model in the report server, and stores the customized real-time report to the report server.

Specifically, the client accesses the real-time report service module of the report server. In the instant report, step 302 can include the following sub-steps:

Step 302a, set the report type of the instant report.

The Real-Time Reporting Services module is available in a variety of report types, from which the client can choose one of the report types as an instant report.

Common report types are: tabular reports, grouped reports, and matrix reports; where, the tabular report is the simplest, generally a table with a fixed number of columns and a dynamic number of rows;

A grouped report is an extension of a tabular report. It also has a fixed number of columns, but the number of rows is grouped by one or more columns, and subtotals and total operations are performed on the grouping columns;

A matrix report is a table with dynamic and dynamic rows.

Step 302b, selecting a data table or a view to be used for the real-time report from the report model The data source for the time report.

According to step 301, if the report model is stored on the report service module, the real-time report service module can directly call the report model; if stored in the report database, the report service module first calls the report database to provide the instant report service. The module is used, and how to call it as an existing technology, and details are not described herein again.

In practice, the data tables and views are displayed in an interrelated manner in the user interface of the customized instant report. The client only needs to click on the data table or view that he cares about and use it as the data source of the instant report.

In step 302c, the field in the data source is selected as the field of the instant report.

This step can be done by dragging fields from the data source into the rows or columns of the instant report. Step 302d, setting the query condition of the instant report.

The step is specifically as follows: Select some fields in the real-time report as the query condition; in addition, you can also set the value or range of the query condition, and can connect multiple query conditions with the preposition "and" or "or" to form More complex combined query conditions.

Step 302e, setting the report style of the instant report.

The Real-Time Reporting Service Module provides a variety of reporting styles from which the client can choose one of its own interesting reporting styles for instant reporting.

The report style is set to enhance the visual appearance of the instant report, so this step is optional. Step 302f, preview the instant report and store the instant report to the report server.

After completing the settings of steps 302a-302e, the client can invoke the preview function of the instant report service module, and view the real-time report results through the complete real-time report query function provided by the instant report service module. If satisfied, the client can The instant report is stored to the report server; if not, you can return to any of steps 302a~302e to modify the settings.

Among them, viewing the real-time report results means: By entering the query conditions, you can view the real-time reports with specific values for each field. The specific value of each field is stored in the report database. The stored report data is obtained by the report service module from the report database. How to obtain the existing technology is not described here.

In addition, in step 302f, the instant report can be directly stored to the report server without previewing the live report.

Similar to the report model, instant reports can be stored in the report database or in the report service module.

Step 303: The client modifies the instant report stored in the report server.

For the real-time report that has been customized, if it needs to be changed during use, the client can modify the report function according to the report service module, and select the real-time report to be modified, and then link to the real-time report service module, instant report service. The module displays each component of the instant report, and the client can modify the parameters and operations involved in step 102 as needed.

Here, modifying the real-time report can be performed by the client of the customized instant report, or by other clients, as long as the report server has the right to modify the settings of the client.

If the real-time report is stored on the report service module, the real-time report service module can directly call the instant report; if stored in the report database, the report service module is first called from the report database and then used by the real-time report service module.

In addition, clients can delete real-time reports stored in the report server based on actual usage.

In step 304, the client queries the instant report result using the stored instant report.

After the customized instant report is stored in the report server, it can be called by the report service module for other clients to query. Here, the general report can refer to a report customized by the server; the client can specify the client for the instant report, or other clients.

Step 304 is specifically as follows: a client accesses the report service module, and the report service module Select the required real-time report in the access page, and then enter the query condition on the access page of the instant report to view the real-time report result. The specific value in the instant report result comes from the report database.

It can be seen from the above analysis that the present invention can transfer the customization of the real-time report from the service provider to the customer, which can greatly provide the demand response speed. Secondly, the customer can customize the real-time report according to his own needs, and there is no problem of communication between the two parties. , so the availability of instant reports is available.

The implementation method of the instant table is further described in detail below through a specific embodiment. Taking the MMS center business as an example, customers may need to query "business volume", "business flow", "fee", "business time", "business class", "SP", "terminal type", etc. Therefore, this specific embodiment may include the following steps:

Step 401: When generating the report model, the server first obtains the “business fact table”, the “SP attribute table”, and the “terminal type attribute table” from the report database; wherein, the “business fact table” includes the “business occurrence time”, Fields such as "business volume", "business traffic", "cost", "business category", "SP number", "terminal type number"; "SP attribute table" contains "SP number", "SP name", "SP "Class" field; "Terminal type attribute table" contains fields such as "terminal type number" and "terminal type name";

Then associate the "SP attribute table" with the "business fact table" by "SP number", and the "terminal type attribute table" is associated with the "business fact table" by "terminal type number";

Then set the display format of "business volume" to the whole line, and the display format of "business flow" is the display format with the decimal indicator floating point type and "cost" as RMB;

Then upload this generated report model to the report server.

Step 402: The client accesses the report server, and selects the type of the real-time report as "table report"; and then views the instant report from the report model. The optional data sources are "business fact table", "SP attribute table", and "terminal type". "Property table", select "business fact table" and "SP attribute table" as the data source of the instant report; Then drag the "business volume", "business traffic" and "cost" of the "business fact table", and

"SP attribute table," "SP name" and "SP level" fields as columns of the instant report, drag

The "Business Time" field of the "Business Fact Table" is used as the line of the instant report;

Then set the query conditions of the real-time report: Select "business occurrence time" as the query condition, and set the value range from 2009-01-01 to 2009-06-30, also select "SP name" as the query condition, and set Value = "ZTE", and use "and" to connect these two query conditions;

Then select one of the report styles for the instant report in the optional report style; finally preview the live report and store the live report to the report server.

At this point, the customization of the instant table has been completed.

After that, if a client wants to query the real-time report result according to the instant report, first access the report service module, select the required real-time report in the access page, and then input the query condition and its value on the access page of the instant report. Scope, you can query the real-time report results.

To implement the above method, the present invention provides an instant report implementation system. As shown in FIG. 4, the system includes a server 20, a report server 10, and a client 30, where

The server 20 is configured to generate a report model, and upload the generated report model to the report server 10;

The report server 10 is configured to store a report model uploaded by the server 20 and provide a report model for the client 30;

The client 30 is configured to access the report server 10, customize the real-time report according to the stored report model in the report server 10, and store the customized instant report to the report server 10.

Specifically, the client accesses the instant report service module 121 of the report server 10, which is stored immediately.

The client 30 is further configured to modify the stored real-time report in the report server 10; The client is also used to query the instant report result using the stored instant report. Here, the client can be used not only for clients that customize real-time reports, but also for other clients.

As shown in FIG. 4, the customized real-time report is implemented by the operation interface of the customized instant report provided by the client 30 in the real-time report service module 121; other operations such as querying the report for the real-time report or the ordinary report are accessed by the client 30. The report service module 12 implements, if the report is stored in the report database 11, the report service module 12 first retrieves the report from the report database 11, and then returns a report to the client 30, wherein the report is a real report result, in the report Each field has a specific value.

The above is only the preferred embodiment of the present invention and is not intended to limit the scope of the present invention. Those skilled in the art should be able to think that the report model can also add functions such as name internationalization and query condition restriction for each view or field. When the customer uses the real-time report service module to customize the real-time report, the steps can be appropriately increased or decreased to meet the requirements. The special needs of customers, real-time reports can add user rights management, to restrict the access rights of customers to access data, and to access the rights of others to customize reports, and other equivalent changes or replacements according to the technical solutions and concepts of the present invention should belong to The scope of protection of the present invention.

Claims

Claim

A report server, comprising a report database and a report service module, wherein the report service module includes an instant report service module,

2. An instant report implementation method, characterized in that the method comprises:

The real-time report implementation method according to claim 2, wherein the generating the report model specifically comprises: obtaining a data table or a view required for an instant report from a report database of a report server, and obtaining the obtained data table Or view to associate, and set the display format of the fields in the data table or view.

The real-time report implementation method according to claim 2, wherein the customizing the real-time report according to the stored report model, and storing the customized real-time report to the report server comprises:

Set the report type of the instant report;

Set the query conditions for the instant report;

Preview live reports and store them on the report server.

The real-time report implementation method according to claim 4, wherein after setting the query condition of the instant report, the method further comprises: setting a report style of the real-time report.

The method for realizing the real-time report according to claim 2, wherein after the customized completed real-time report is stored in the report server, the method further includes: The client modifies the live reports that are stored in the report server.

The method for realizing the real-time report according to claim 2 or 6, wherein after the customized instant report is stored in the report server, the method further comprises:

8. An instant report implementation system, the system comprising: a server, a report server, and a client; wherein

The real-time report implementation system according to claim 8, wherein the client is further configured to modify an existing report stored in the report server.

The real-time report implementation system according to claim 8 or 9, wherein the client is further configured to query the real-time report result by using the stored instant report.