Model driven reporting
AssigneeDigital.ai Software, Inc.
InventorsRahul Kapoor, Gaurav Rewari, Sadanand Sahasrabudhe
Life of this patent
Estimating the term…
Abstract
Approaches for a model-driven tool-agnostic reporting approach are provided. In one example, a report request is received from a business intelligence reporting application, from which a graphical template and query template are created, wherein the graphical template comprises the visual presentation of data responsive to the request and the query template specifies how the data responsive to the request is to be computed. The report created by the approaches described herein is compatible with multiple business intelligence reporting applications.
Claims12
A method for generating a model driven Business Intelligence (BI) report that is compatible with a Business Intelligence (BI) tool, the method comprising:
- providing a data discovery interface, wherein the data discovery interface is connected to at least one data source, and wherein a data model of the at least one data source is described in metadata;
- receiving a request to create a business intelligence tool agnostic report in a declarative format executable by the BI tool for analytics based on a data discovery request;
- analyzing the data discovery request in conjunction with the data model to determine an equivalent query that would return same results as the data discovery request;
- creating a query template based on the equivalent query and the data model;
- creating a graphical template associated with the query template built on a metadata;
- associating the query template with the graphical template to create a report template, wherein the query template and the graphical template are in a business intelligence tool-agnostic format, wherein the graphical template defines visual presentation aspects of the business intelligence tool agnostic report and the query template defines computation aspects of the business intelligence tool agnostic report, and wherein presentation aspects of the business intelligence tool agnostic report are separated from the computation aspects by separation of the graphical template from the and query template;
- converting the report template using an automated code-generation process to the business intelligence tool agnostic report compatible with a specific target business intelligence tool by substituting target presentation elements for source presentation elements in the graphical template;
- executing the query template against data sources specified in the query template when executing the business intelligence tool agnostic report in the BI tool;
- and
- populating the business intelligence tool agnostic report with data from the data sources specified in the query template according to the visual presentation aspects specified in the graphical template.
A non-transitory computer-readable storage medium storing one or more sequences of instructions for generating a model driven Business Intelligence (BI) report that is compatible with a Business Intelligence (BI) tool, which when executed by one or more processors, causes:
- providing a data discovery interface, wherein the data discovery interface is connected to at least one data source, and wherein a data model of the at least one data source is described in metadata;
- receiving a request to create a business intelligence tool agnostic report in a declarative format executable by the BI tool for analytics based on a data discovery request;
- analyzing the data discovery request in conjunction with the data model to determine an equivalent query that would return same results as the data discovery request;
- creating a query template based on the equivalent query and the data model;
- creating a graphical template associated with the query template built on a metadata;
- associating the query template with the graphical template to create a report template, wherein the query template and the graphical template are in a business intelligence tool-agnostic format, wherein the graphical template defines visual presentation aspects of the business intelligence tool agnostic report and the query template defines computation aspects of the business intelligence tool agnostic report, and wherein presentation aspects of the business intelligence tool agnostic report are separated from the computation aspects by separation of the graphical template from the and query template;
- converting the report template using an automated code-generation process to the business intelligence tool agnostic report compatible with a specific target business intelligence tool by substituting target presentation elements for source presentation elements in the graphical template;
- executing the query template against data sources specified in the query template when executing the business intelligence tool agnostic report in the BI tool;
- and
- populating the business intelligence tool agnostic report with data from the data sources specified in the query template according to the visual presentation aspects specified in the graphical template.
Dependencies are inferred from the claim text.