Deployment of a business intelligence (BI) meta model and a BI report specification for use in presenting data mining and predictive insights using BI tools
First Claim
1. A computer system for processing Business Intelligence (BI) reports, comprising:
- a processor; and
storage coupled to the processor, wherein the storage stores a computer program, and wherein the computer program is executable by the processor to perform operations, the operations comprising;
using a database, coupled to the computer system, to generate information for consumption by a BI tool by;
creating a description of data in one or more data tables, stored in the database, that identifies each column in each of the one or more data tables, wherein each column has multiple values;
using the description of the data in the one or more data tables to create a new table, stored in the database, that includes a row for each value of the multiple values for each column in each of the one or more data tables and new columns for statistics about the data in the one or more data tables;
generating BI meta information based on the description of the data in the one or more data tables and based on a schema and data of the new table that describes the columns for the statistics;
generating a BI report specification that describes how a first BI report is to be rendered based on the schema and the data of the new table by describing a layout of data in the columns in each of the one or more data tables and in the columns for the statistics;
deploying the BI meta information and the BI report specification to a BI server for use in generating the first BI report using the BI tool at the BI server;
in response to a request for the first BI report,generating the first BI report dynamically with the BI tool at the BI server that dynamically invokes a stored procedure, stored in the database, with one or more parameters and that uses the BI meta information and the BI report specification to provide the statistics about the data in the one or more data tables; and
displaying one or more graphs for the first BI report in a second screen;
in response to another request for the first BI report after data in the one or more data tables has changed,using the new table to generate new BI meta information and a new BI report specification for use in generating a new BI report dynamically; and
displaying one or more graphs for the new BI report in a second screen;
in response to a request for a second BI report,using the new table to generate new BI meta information and another new BI report specification for use in generating a second BI report dynamically; and
displaying one or more different graphs for the second BI report in a third screen.
1 Assignment
0 Petitions
Accused Products
Abstract
A Business Intelligence (BI) meta model template is selected based on one or more meta model object types in a model structure. A BI meta model is generated from the selected BI meta model template. One or more BI report specification templates are selected based on a mining model type. A BI report specification is generated from the selected one or more BI report specification templates, a schema of the model structure, and content of the model structure. The BI meta model and the BI report specification are deployed to a BI server for use in generating a BI report using a BI tool at the BI server. In response to a user request for a BI report, the BI report is generated with a BI tool at the BI server that uses the BI meta model and the BI report specification.
-
Citations
14 Claims
-
1. A computer system for processing Business Intelligence (BI) reports, comprising:
-
a processor; and storage coupled to the processor, wherein the storage stores a computer program, and wherein the computer program is executable by the processor to perform operations, the operations comprising; using a database, coupled to the computer system, to generate information for consumption by a BI tool by; creating a description of data in one or more data tables, stored in the database, that identifies each column in each of the one or more data tables, wherein each column has multiple values; using the description of the data in the one or more data tables to create a new table, stored in the database, that includes a row for each value of the multiple values for each column in each of the one or more data tables and new columns for statistics about the data in the one or more data tables; generating BI meta information based on the description of the data in the one or more data tables and based on a schema and data of the new table that describes the columns for the statistics; generating a BI report specification that describes how a first BI report is to be rendered based on the schema and the data of the new table by describing a layout of data in the columns in each of the one or more data tables and in the columns for the statistics; deploying the BI meta information and the BI report specification to a BI server for use in generating the first BI report using the BI tool at the BI server; in response to a request for the first BI report, generating the first BI report dynamically with the BI tool at the BI server that dynamically invokes a stored procedure, stored in the database, with one or more parameters and that uses the BI meta information and the BI report specification to provide the statistics about the data in the one or more data tables; and displaying one or more graphs for the first BI report in a second screen; in response to another request for the first BI report after data in the one or more data tables has changed, using the new table to generate new BI meta information and a new BI report specification for use in generating a new BI report dynamically; and displaying one or more graphs for the new BI report in a second screen; in response to a request for a second BI report, using the new table to generate new BI meta information and another new BI report specification for use in generating a second BI report dynamically; and displaying one or more different graphs for the second BI report in a third screen. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer program product for processing Business Intelligence (BI) reports, the computer program product comprising:
-
a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code, when executed by a processor of a computer system, configured to; use a database to generate information for consumption by a BI tool by; creating a description of data in one or more data tables, stored in the database, that identifies each column in each of the one or more data tables, wherein each column has multiple values; using the description of the data in the one or more data tables to create a new table, stored in the database, that includes a row for each value of the multiple values for each column in each of the one or more data tables and new columns for statistics about the data in the one or more data tables; generating BI meta information based on the description of the data in the one or more data tables and based on a schema and data of the new table that describes the columns for the statistics; generating a BI report specification that describes how a first BI report is to be rendered based on the schema and the data of the new table by describing a layout of data in the columns in each of the one or more data tables and in the columns for the statistics; deploying the BI meta information and the BI report specification to a BI server for use in generating the first BI report using the BI tool at the BI server; in response to a request for the first BI report, generating the first BI report dynamically with the BI tool at the BI server that dynamically invokes a stored procedure stored, in the database, with one or more parameters and that uses the BI meta information and the BI report specification to provide the statistics about the data in the one or more data tables; and displaying one or more graphs for the first BI report in a second screen; in response to another request for the first BI report after data in the one or more data tables has changed, using the new table to generate new BI meta information and a new BI report specification for use in generating a new BI report dynamically; and displaying one or more graphs for the new BI report in a second screen; in response to a request for a second BI report, using the new table to generate new BI meta information and another new BI report specification for use in generating a second BI report dynamically; and displaying one or more different graphs for the second BI report in a third screen. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
Specification