# US 2014/0156643 A1 · Enabling business intelligence applications to query semantic models

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2014/0156643 A1
- Document ID: US20140156643A1
- Status: Published application
- Kind: A1
- Application number: 13/705,030
- Filed: 2012-12-04
- Published: 2014-06-05
- Earliest claimed: 2012-12-04
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Mohsen Rais-Ghasem; Michael E. Styles
- Web page: https://patentgrep.com/patent/US20140156643A1

## CPC

- G06F 16/245: Query processing
- G06F 16/3344: {using natural language analysis}
- G06F 16/9038: Presentation of query results
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Provided are a computer implemented method, computer program product, and system for generating a combined report. One or more queries are constructed using a Business Intelligence (BI) metadata model and one or more query declarations. The one or more queries are executed on a semantic model to obtain one or more semantic result sets. One or more data source result sets are received from one or more data sources. The one or more semantic result sets and the one or more data source result sets are combined to construct one or more combined result sets. The one or more combined result sets are rendered to form a combined report.

## Claims

### Claim at position 1

1-6. (canceled)

### Claim 7

A computer program product, the computer program product comprising:
a computer readable storage medium having computer readable program code embodied therein, wherein the computer readable program code, when executed by at least one processor of a computer, is configured to perform:
constructing, with a processor of a computer, one or more queries using a Business Intelligence (BI) metadata model and one or more query declarations;
executing the one or more queries on a semantic model to obtain one or more semantic result sets;
receiving one or more data source result sets from one or more data sources;
combining the one or more semantic result sets and the one or more data source result sets to construct one or more combined result sets; and
rendering the one or more combined result sets to form a combined report.

### Claim 8 (depends on 7)

The computer program product of claim 7, wherein the computer readable program code, when executed by the at least one processor of the computer, is configured to perform:
generating the BI metadata model by executing transformations that transform concepts in a semantic model to Business Intelligence (BI) metadata constructs.

### Claim 9 (depends on 8)

The computer program product of claim 8, wherein the computer readable program code, when executed by the at least one processor of the computer, is configured to perform:
retrieving a report specification that includes one or more layout declarations, and
rendering the one or more combined result sets based on the one or more layout declarations.

### Claim 10 (depends on 7)

The computer program product of claim 7, wherein the semantic model comprises a Web Ontology Language (OWL) model.

### Claim 11 (depends on 7)

The computer program product of claim 7, wherein a semantic engine executes the one or more queries on the semantic model to obtain the one or more semantic result sets.

### Claim 12 (depends on 7)

The computer program product of claim 7, wherein the computer readable program code, when executed by the at least one processor of the computer, is configured to perform:
retrieving a report specification that includes the one or more query declarations.

### Claim 13

A computer system, comprising:
at least one processor; and
a storage device coupled to the processor, wherein the storage device has stored thereon a program, and wherein the at least one processor is configured to execute instructions of the program to perform operations, wherein the operations comprise:
constructing, with a processor of a computer, one or more queries using a Business Intelligence (BI) metadata model and one or more query declarations;
executing the one or more queries on a semantic model to obtain one or more semantic result sets;
receiving one or more data source result sets from one or more data sources;
combining the one or more semantic result sets and the one or more data source result sets to construct one or more combined result sets; and
rendering the one or more combined result sets to form a combined report.

### Claim 14 (depends on 13)

The computer system of claim 13, wherein the operations further comprise:
generating the BI metadata model by executing transformations that transform concepts in a semantic model to Business Intelligence (BI) metadata constructs.

### Claim 15 (depends on 14)

The computer system of claim 14, wherein the operations further comprise:
retrieving a report specification that includes one or more layout declarations, and
rendering the one or more combined result sets based on the one or more layout declarations.

### Claim 16 (depends on 13)

The computer system of claim 13, wherein a semantic model comprises a Web Ontology Language (OWL) model.

### Claim 17 (depends on 13)

The computer system of claim 13, wherein a semantic engine executes the one or more queries on the semantic model to obtain the one or more semantic result sets.

### Claim 18 (depends on 13)

The computer system of claim 13, wherein the operations further comprise:
retrieving a report specification that includes the one or more query declarations.