International Business Machines Corporation

Sap Ag

Cognos, Inc.

Michael E Styles

Mohsen Rais-Ghasem

Henk Cazemier

Marius Cosma

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.

Enabling business intelligence applications to query semantic models

A mechanism for summary filter transformation is provided. The mechanism comprises a summary filter analysis module for analyzing a multidimensional query that is not supported by a target database system, and a summary filter transformation module for transforming the multidimensional query into a semantically equivalent query that is supported by the target database system.

Summary filter transformation

A mechanism is provided for transforming an original database query into a supported database query that can be fully computed by a target database. The original database query comprising a select list including a plurality of expressions, the plurality of expressions having a control break. The plurality of expressions includes an expression that cannot be directly computed by the target database. The mechanism constructs a derived table from the unsupported database query comprising constructing a new select list of the derived table, traversing the plurality of expressions of the select list of the unsupported database query, and adding a GROUP BY expression to the derived table based on the new select list of the derived table. The mechanism constructs the supported database query using the unsupported database query and the derived table.

Query transformation

A mechanism for structured query language tagging is provided. The mechanism comprises a parsing unit for parsing a structured query language string into components, an analysis unit for analyzing the components and applying associated tags to the components, and a string generation unit for concatenating the components with associated tags into a new string.

A system for transforming client/server aggregates is provided. The system comprises a client/server analysis component for analyzing one or more queries that are not supported by a target database system, and a client/server transformation component for transforming the one or more queries into semantically equivalent queries that are supported by the target database system.

System and method of client server aggregate transformation

A parallel detail join system for processing a many-to-one-to-many relationship is provided. The system comprises a parallel detail analysis module for detecting a many-to-one-to-many relationship among elements, and a parallel detail transformation module for generating a SQL: 1999 statement to handle the many-to-one-to-many relationship.

Growing community of inventors

Osgoode, Canada

Michael E Styles