IP Library Granted Patent US 8,112,385
Granted Patent B2
US 8,112,385 · App. 11/473,916 · Granted Feb 7, 2012

Ready to render business intelligence result sets

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,112,385
App. No.
11/473,916
Granted
Feb 7, 2012
Kind
B2
Abstract

A query that is based on a predefined format of an arbitrary query language is received. A data analyzing component performs the query to obtain a query result. The query result and a report layout specification are provided from the data analyzing component to a data processing component, the data processing component being on a computer. The data processing component associates the query result with at least one element of the report layout specification to generate an association. The query result is provided from the data processing component through an interface based on the report layout specification without reliance on the type of the arbitrary query language to a rendering component. The report layout specification is provided from the data analyzing component to the rendering component to render the query result in a report according to the association without reliance on the type of the arbitrary query language.

Claims (29)

1. A method comprising:

receiving a query that is based on a predefined format of an arbitrary query language;

performing, with a data analyzing component, the query to obtain a query result;

providing the query result and a report layout specification from the data analyzing component to a data processing component, the data processing component being on a computer;

associating, with the data processing component, the query result with at least one element of the report layout specification to generate an association;

providing the query result from the data processing component through an interface based on the report layout specification without reliance on the type of the arbitrary query language to a rendering component; and

providing the report layout specification from the data analyzing component to the rendering component to render the query result in a report according to the association without reliance on the type of the arbitrary query language,

wherein a report specified in the report layout specification is one of a chart, a detailed list report type that is tabular with each row including a detailed fact value that corresponds to a combination of non-fact columns in each row, a grouped summary report type that is tabular with at least one grouping column and at least one fact column, a grouped detail list report type that includes detail and summary fact values, a cross tab report that includes a set of members along a row and column axis, and a master detail report that associates rows within a report with other reports including parallel detail information.

2. The method of claim 1 , further comprising providing a master data set with respect to each report specified in the report layout specification, the master dataset providing access to a dataset informational object and a partial dataset data retrieval object.

3. The method of claim 1 , wherein a cell of a cross tab in the cross tab report includes a data value corresponding to an intersection of members from the set of members.

4. A computer readable memory having computer executable instructions stored therein, wherein the computer executable instructions when executed on a computer cause the computer to:

receive a query that is based on a predefined format of an arbitrary query language;

perform, with a data analyzing component, the query to obtain a query result;

provide the query result and a report layout specification from the data analyzing component to a data processing component, the data processing component being on the computer;

associate, with the data processing component, the query result with at least one element of the report layout specification to generate an association;

provide the query result from the data processing component through an interface based on the report layout specification without reliance on the type of the arbitrary query language to a rendering component; and

provide the report layout specification from the data analyzing component to the rendering component to render the query result in a report according to the association without reliance on the type of the arbitrary query language,

wherein a report specified in the report layout specification is one of a chart, a detailed list report type that is tabular with each row including a detailed fact value that corresponds to a combination of non-fact columns in each row, a grouped summary report type that is tabular with at least one grouping column and at least one fact column, a grouped detail list report type that includes detail and summary fact values, a cross tab report that includes a set of members along a row and column axis, and a master detail report that associates rows within a report with other reports including parallel detail information.

5. The computer readable memory of claim 4 , wherein the computer is further caused to provide a master data set with respect to each report specified in the report layout specification, the master dataset providing access to a dataset informational object and a partial dataset data retrieval object.

6. The computer readable memory of claim 4 , wherein a cell of a cross tab in the cross tab report includes a data value corresponding to an intersection of members from the set of members.

7. A method comprising:

receiving a query that is based on a predefined format of an arbitrary query language;

performing the query to obtain a query result;

providing the query result and a report layout specification to a computer;

associating, with the computer, the query result with at least one element of the report layout specification to generate an association;

providing the query result through an interface based on the report layout specification without reliance on the type of the arbitrary query language; and

rendering the query result in a report according to the association without reliance on the type of the arbitrary query language,

wherein a report specified in the report layout specification is one of a chart, a detailed list report type that is tabular with each row including a detailed fact value that corresponds to a combination of non-fact columns in each row, a grouped summary report type that is tabular with at least one grouping column and at least one fact column, a grouped detail list report type that includes detail and summary fact values, a cross tab report that includes a set of members along a row and column axis, and a master detail report that associates rows within a report with other reports including parallel detail information.

8. The method of claim 7 , further comprising providing a master data set with respect to each report specified in the report layout specification, the master dataset providing access to a dataset informational object and a partial dataset data retrieval object.

Assignments (4)
CERTIFICATE OF AMALGAMATION Recorded Aug 15, 2008
From: COGNOS INCORPORATED
To: COGNOS ULC
Reel/Frame 021387/0813 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 15, 2008
From: COGNOS ULC
To: IBM INTERNATIONAL GROUP BV
Reel/Frame 021387/0837 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 15, 2008
From: IBM INTERNATIONAL GROUP BV
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 021398/0001 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 11, 2006
From: AZIZI, SOUFIANE; CUSHING, DAVID
To: COGNOS INCORPORATED
Reel/Frame 018378/0746 →