Patent ID: 10621205

Abstract:
In the Business Intelligence (BI) realm, ad hoc reporting refers to relatively fast on-the-fly building of computer data reports in real-time. A process for pre-report execution based on an anticipated ad hoc reporting request is provided. This process predicts an ad hoc reporting request to generate an ad hoc report will be received from a user. Based on the ad hoc reporting request being predicted, and prior to receiving the ad hoc reporting request, the process dynamically generates and executes code to execute a query(ies) and acquires pre-request execution report data from execution of the query(ies). The ad hoc reporting request is received from the user, and based on receiving the ad hoc reporting request, the process identifies pre-request execution report data acquired prior to receiving the ad hoc reporting requests and generates the ad hoc report using the pre-request execution report data.