Method and system for implementing statistical forms customization

Abstract

The invention discloses a method for realizing statistical report customization. The method comprises the following steps: step one, obtaining original business data in an IPTV (Internet Protocol TV) system, and forming a data warehouse after processing; step two: receiving visit of users to the data warehouse through a visualization interface; and step three: linking the parameter information set by the user and the data warehouse, so as to produce data warehouse inquiry statement needed by a report and carry out inquiry, and obtaining result report. The invention further discloses a system for realizing statistical report customization, and the system comprises a data loading module, a data warehouse module, a business logic module, a report customization module, and a report display and output module. The invention shields an underlying data structures in the prior operation database, so that when carrying out data inquiry, a user does not need to understand the underlying data structure of the system. The invention ensures that the user can conduct customization to report theme, element and display mode through the visualization interface, and report documents can be simply and quickly generated.

Description

technical field [0001] The present invention relates to the field of IPTV (Internet Protocol Television, Internet TV) system operation, in particular to a method and system for realizing customization of statistical reports. Background technique [0002] The statistical report of the IPTV system refers to the result document formed after the summary and analysis of the business data generated during the operation of the IPTV system. These documents usually need to be submitted to the management personnel intuitively in the form of charts, etc., so as to understand the operation of the entire system in a timely manner. situation and provide decision support. For example, it is possible to make statistics on the VOD (Video On Demand, video on demand) viewing status of all users in a certain live network site within a day, so as to distinguish popular programs and unpopular programs in the resources operated by the current IPTV system, and then according to the established The...

AI Technical Summary

Problems solved by technology

[0004] In the prior art, the process of obtaining a statistical report for a certain type of business information is that the system manager first puts forward the requirements, defines the elements and specific display methods that the required report should contain, and then, due to the existing operation database records of the enterprise To extract useful data information, it is necessary to understand the underlying data structure of the system, which requires the participation of technical personnel. After receiving the statistical requirements, the professional technical personnel will connect to the operation database server to perform operations one by one. Obtain the query results of each type of information, and then manually classify and organize according to statistical requirements, and then fill the data

Images