Abstract: A computing device outputs a chart matrix defined by associating a first data dimension with a row edge and a second data dimension with a column edge. Members of the first data dimension are displayed as row headers of the chart matrix, and members of the second data dimension are displayed as column headers of the chart matrix. The device outputs charts in matrix cells of the chart matrix defined by intersections of rows defined by the row edge and columns defined by the column edge. The computing device provides user options to perform a drill operation on a selected member displayed in the chart matrix. The computing device outputs, in response to the user input to perform the drill operation, a modified chart matrix displaying related members in at least one of the charts, wherein the related members are related by one hierarchical level from the selected member.

Abstract: A computing device outputs a chart matrix defined by associating a first data dimension with a row edge and a second data dimension with a column edge. Members of the first data dimension are displayed as row headers of the chart matrix, and members of the second data dimension are displayed as column headers of the chart matrix. The device outputs charts in matrix cells of the chart matrix defined by intersections of rows defined by the row edge and columns defined by the column edge. The computing device provides user options to perform a drill operation on a selected member displayed in the chart matrix. The computing device outputs, in response to the user input to perform the drill operation, a modified chart matrix displaying related members in at least one of the charts, wherein the related members are related by one hierarchical level from the selected member.

Abstract: A computing device outputs a chart matrix defined by associating a first data dimension with a row edge and a second data dimension with a column edge. Members of the first data dimension are displayed as row headers of the chart matrix, and members of the second data dimension are displayed as column headers of the chart matrix. The device outputs charts in matrix cells of the chart matrix defined by intersections of rows defined by the row edge and columns defined by the column edge. The computing device provides user options to perform a drill operation on a selected member displayed in the chart matrix. The computing device outputs, in response to the user input to perform the drill operation, a modified chart matrix displaying related members in at least one of the charts, wherein the related members are related by one hierarchical level from the selected member.

Abstract: A computing device outputs a chart matrix defined by associating a first data dimension with a row edge and a second data dimension with a column edge. Members of the first data dimension are displayed as row headers of the chart matrix, and members of the second data dimension are displayed as column headers of the chart matrix. The device outputs charts in matrix cells of the chart matrix defined by intersections of rows defined by the row edge and columns defined by the column edge. The computing device provides user options to perform a drill operation on a selected member displayed in the chart matrix. The computing device outputs, in response to the user input to perform the drill operation, a modified chart matrix displaying related members in at least one of the charts, wherein the related members are related by one hierarchical level from the selected member.

Abstract: A query processing visualization system comprises a visualization module. The visualization module visualizes logging information of query processing events occurring during processing of a client query requesting data from one or more data sources by analyzing the logging information to identify dependency of the query processing events, formatting visual presentation components representing the logging information in a hierarchy to reflect the dependency of the query processing events, and presenting the visual presentation components in the context of the hierarchy of the visual components as formatted.

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.

Abstract: A method receives a query containing at least a statement, and analyzes the statement to determine a query structure of elements forming the statement. The text of the statement is formatted to reflect the query structure. The formatted text is replaced with an equivalent tree of logical blocs representing the statement in a higher level. The representation of one or more of the logical blocks is shortened. A data flow tree of macro operation nodes is generated based on the logical blocks for presentation to a user.

Abstract: A tabular operation provider is provided for processing a data agnostic business intelligence query with relational operations, herein called a relational query against a multidimensional datasource. The tabular operation provider comprises a query interceptor, a query decomposer and a query replacer. The query interceptor detects and intercepts a relational query that is issued against one or more multidimensional data sources. The query decomposer decomposes expressions of the relational query into one multidimensional expression and one or more relational expressions. The query replacer replaces the relational query with a stack of operations expressed by the decomposed multidimensional expressions and/or the relational expressions.

Abstract: A tabular set provider is provided for processing a data agnostic business intelligence query with relational set operations, herein called a relational query against a multidimensional datasource. The tabular set provider comprises a query interceptor, a query decomposer, an OLAP query provider interface, and an operation module. The query interceptor is provided for detecting and intercepting a data agnostic Business intelligence query that has relational set operations that is issued against one or more multidimensional data sources. The query decomposer is provided for decomposing the operands of the set operation in the input query into one or more sub-queries. The OLAP query provider interface is provided for sending the OLAP supported sub-queries to an OLAP query provider and receiving results. The operation module is provided for using set operation functionality provided by a relational query provider that performs the set operations locally on the results of the OLAP data extraction.

Abstract: A query processing coordination planning unit coordinates a query processing to obtain requested data from one or more data sources. The query processing coordination planning unit comprises a request preparation coordinator and a request execution coordinator. The request planning unit invokes one or more query operation providers in a conditional query processing sequence for translating a logical representation of the user request into a physical representation of a user request, and generates an execution plan expressed by the physical representation of a user request. The request execution coordinator executes the physical representation of the user request in accordance with the execution plan using the query operation providers.

Abstract: A suppression provider comprises a query preparation unit and a query execution unit. The query preparation unit analyzes a request from a client for data to obtain suppression criteria from an edge suppression specification in the request, and saving the suppression criteria in a query plan generated. The query execution unit receives execution result data including values, each associated with one or more edge values, determines if each value is to be suppressed based on the suppression criteria, and identifies one or more edge values to be suppressed when an edge value has only values that are determined to be suppressed. Thus, the suppression provider suppresses values and/or edge values identified to be suppressed in a resultant report.

Abstract: A query processing visualization system comprises a visualization module. The visualization module visualizes logging information of query processing events occurring during processing of a client query requesting data from one or more data sources by analyzing the logging information to identify dependency of the query processing events, formatting visual presentation components representing the logging information in a hierarchy to reflect the dependency of the query processing events, and presenting the visual presentation components in the context of the hierarchy of the visual components as formatted.

Abstract: A coordination planner is suitably used for a query framework system for processing a user request for data from one or more data sources. The query framework system comprises multiple query processing components including a set of query operation providers, each being capable of providing a specific query operation. The coordination planner prepares a user request for execution by translating a logical representation of the user request into a physical representation of the user request using the query operation providers, and executes the physical representation of the user request to obtain a result data stream using the query operation providers.

Abstract: A query processing coordination planning unit coordinates a query processing to obtain requested data from one or more data sources. The query processing coordination planning unit comprises a request preparation coordinator and a request execution coordinator. The request planning unit invokes one or more query operation providers in a conditional query processing sequence for translating a logical representation of the user request into a physical representation of a user request, and generates an execution plan expressed by the physical representation of a user request. The request execution coordinator executes the physical representation of the user request in accordance with the execution plan using the query operation providers.

Abstract: A report specification for defining a report and a system and method of producing a report output from a report definition are provided. The report specification comprises a data selection specification for defining one or more sets of data that are to be reported against and a layout specification for defining how the data is to be structured and rendered. The layout specification including elements that are typically defined in a query. The system comprises a report engine for decomposing a report definition into a layout definition and a query set component, a query engine for processing a query results definition of the query set to produce query results to be rendered, and a rendering engine for creating the final report by using the query results and the layout definition.

Abstract: A tabular set provider is provided for processing a data agnostic business intelligence query with relational set operations, herein called a relational query against a multidimensional datasource. The tabular set provider comprises a query interceptor, a query decomposer, an OLAP query provider interface, and an operation module. The query interceptor is provided for detecting and intercepting a data agnostic Business intelligence query that has relational set operations that is issued against one or more multidimensional data sources. The query decomposer is provided for decomposing the operands of the set operation in the input query into one or more sub-queries. The OLAP query provider interface is provided for sending the OLAP supported sub-queries to an OLAP query provider and receiving results. The operation module is provided for using set operation functionality provided by a relational query provider that performs the set operations locally on the results of the OLAP data extraction.

Abstract: A tabular operation provider is provided for processing a data agnostic business intelligence query with relational operations, herein called a relational query against a multidimensional datasource. The tabular operation provider comprises a query interceptor, a query decomposer and a query replacer. The query interceptor detects and intercepts a relational query that is issued against one or more multidimensional data sources. The query decomposer decomposes expressions of the relational query into one multidimensional expression and one or more relational expressions. The query replacer replaces the relational query with a stack of operations expressed by the decomposed multidimensional expressions and/or the relational expressions.

Abstract: A method of providing metadata and data based on an arbitrary request for information, relative to a original report layout specification, in such a manner that a software process can render the results of the request for information using only the original report layout specification and the results of the proposed method without any knowledge of the underlying data source or the request posed to retrieve data is provided Also provided is a method that for each report specified in an original report layout specification a master dataset is returned that provides access to a dataset informational object and a partial dataset data retrieval object.

Abstract: A data source agnostic query system and method are provided. The system comprises a query set component for defining data to be retrieved from a data source. The method comprises the step of decomposing a data source agnostic query into sub-queries. The step of decomposing includes the steps of identifying the underlying data source specific planners that are involved in the preparation of the data source agnostic query and preparing the sub-queries corresponding to each planner.

Abstract: A coordination planner is suitably used for a query framework system for processing a user request for data from one or more data sources. The query framework system comprises multiple query processing components including a set of query operation providers, each being capable of providing a specific query operation. The coordination planner prepares a user request for execution by translating a logical representation of the user request into a physical representation of the user request using the query operation providers, and executes the physical representation of the user request to obtain a result data stream using the query operation providers.