Data access method and device of business report, computer equipment and storage medium

Abstract

The invention relates to a service report access method and device, computer equipment, a storage medium and a computer program product. The method comprises the following steps: acquiring a plurality of access formulas corresponding to an access request; wherein each access formula comprises a plurality of formula parameters. And based on the target collection category corresponding to each formula parameter, collecting and combining the plurality of formula parameters to obtain a plurality of classification access conditions. Obtaining at least one target access formula corresponding to each classification access condition from the plurality of access formulas; and based on the formula parameters included in each classification access condition, determining a target data packet corresponding to the corresponding classification access condition. For each classification access condition, according to a corresponding target access formula, access is carried out from the corresponding target data packet, and service data corresponding to each target access formula is obtained; and taking out the business data to form a business report. Therefore, the access efficiency of the business report is greatly improved.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular to a method, device, computer equipment, storage medium and computer program product for obtaining business reports. Background technique [0002] With the development of big data technology, when processing data, it is often necessary to obtain massive data from the database. For example, in the process of generating business reports, a large amount of business data needs to be obtained from the database. Among them, the cells of the business report involve a large number of defined access formulas, and the access work of the business report needs to be completed through a large number of access formulas. [0003] In the traditional solution, the parameter conditions of the same access formula in the large number of access formulas for business reports are often combined, and the maximum condition is used to obtain the business detailed data package, and then eac...

AI Technical Summary

Problems solved by technology

[0004] However, merging the parameter conditions in the same access formula will lead to a larger range of access, making the obtained data package too large, making it difficult to ensure the accuracy of the access, and the performance loss when a single access formula calculates the access based on the data packet serious

Therefore, there is a problem of low efficiency in accessing business reports

Images