Report penetration device and report penetration method for online analytical processing system

Abstract

The invention provides a report penetration device and a report penetration method for an online analytical processing system. The device comprises an information transmitting module, an information merging module and a data query module, wherein the information transmitting module transmits context filtering information of a source list to a target list; the information merging module merges the context filtering information of the source list in context filtering information of the target list; and the data query module performs data query and displays the result data according to the context filtering information of the target list. According to the device, the context filtering information of the source list and the target list is combined, and the dimensionality information of the source list and the target list is actually and comprehensively considered, so that the penetrated data has significance.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a report penetration device for an online analysis and processing system and a report penetration method for an online analysis and processing system. Background technique [0002] Enterprises will produce various reports with different business meanings and different dimensions of information in the daily operation process. These reports reflect the operating conditions of the enterprise from different angles and levels, and usually there is a certain relationship between these different reports. In order to facilitate comprehensive analysis of the company's operating conditions, the company urgently needs to link these related reports together. [0003] The conventional method to solve this problem is to establish the connection relationship between different reports. When an enterprise is operating on a certain table, by establishing a table connection, it is easy ...

AI Technical Summary

Problems solved by technology

However, these two methods have shortcomings. The first method simply shows the data of the target table, and the penetration has no business meaning

Although the second method achieves dynamic penetration, there must be relevant dimension information between the source table and the target table to achieve penetration, which cannot satisfy the dynamic penetration between arbitrary reports.

Images