Abstract: A computer-implemented method for executing a query specification can include evaluating the query specification by a first computing device to identify a candidate expression in the query specification to be executed by a second computing device hosting a source of data specified in the candidate expression. A cost estimate for executing the candidate expression at the first computing device is determined. Whether the cost estimate of executing the candidate expression at the first computing device is greater than a threshold is determined. The candidate expression is replaced with a native query function when the cost estimate of executing the candidate expression at the first computing device is greater than the threshold. The native query function can be executed at the second computing device. It can be determined whether a runtime context is necessary, and if necessary, a context parameter is injected into the native query function.

Abstract: A computer-implemented method for executing a query specification can include evaluating the query specification by a first computing device to identify a candidate expression in the query specification to be executed by a second computing device hosting a source of data specified in the candidate expression. A cost estimate for executing the candidate expression at the first computing device is determined. Whether the cost estimate of executing the candidate expression at the first computing device is greater than a threshold is determined. The candidate expression is replaced with a native query function when the cost estimate of executing the candidate expression at the first computing device is greater than the threshold. The native query function can be executed at the second computing device. It can be determined whether a runtime context is necessary, and if necessary, a context parameter is injected into the native query function.

Abstract: Provided are techniques for generating a relational query. Information is collected from a query specification and a model for an On-Line Analytical Processing (OLAP) query having at least a first expression and a second expression. The collected information is used to generate a relational query to retrieve report data to be used to satisfy the first expression and the second expression.

Abstract: Techniques are disclosed for generating a dimensional query that includes dimensional and relational constructs. A report specification for retrieving data from a dimensional data model is received. The report specification includes the dimensional and relational constructs. The dimensional query is generated from the report specification, based on a predetermined sequence of applying the dimensional and relational constructs.

Abstract: A computer-implemented method for executing a query specification can include evaluating the query specification by a first computing device to identify a candidate expression in the query specification to be executed by a second computing device hosting a source of data specified in the candidate expression. A cost estimate for executing the candidate expression at the first computing device is determined. Whether the cost estimate of executing the candidate expression at the first computing device is greater than a threshold is determined. The candidate expression is replaced with a native query function when the cost estimate of executing the candidate expression at the first computing device is greater than the threshold. The native query function can be executed at the second computing device. It can be determined whether a runtime context is necessary, and if necessary, a context parameter is injected into the native query function.

Abstract: A computer-implemented method for executing a query specification can include evaluating the query specification by a first computing device to identify a candidate expression in the query specification to be executed by a second computing device hosting a source of data specified in the candidate expression. A cost estimate for executing the candidate expression at the first computing device is determined. Whether the cost estimate of executing the candidate expression at the first computing device is greater than a threshold is determined. The candidate expression is replaced with a native query function when the cost estimate of executing the candidate expression at the first computing device is greater than the threshold. The native query function can be executed at the second computing device. It can be determined whether a runtime context is necessary, and if necessary, a context parameter is injected into the native query function.

Abstract: Techniques are described for analyzing and presenting results from a statistical analysis of a selected subset of data processed with statistical analysis techniques together with information from a business intelligence (BI) semantic model. In one example, a method includes receiving an input defining a selected subset of data from a structured representation of a set of data. The method further includes selecting one or more business intelligence factors from a business intelligence model based at least in part on the selected subset of data. The method further includes performing a statistical analysis of the selected subset of data based at least in part on the selected one or more business intelligence factors. The method further includes generating an output representing the statistical analysis of the selected subset of data based at least in part on the selected one or more business intelligence factors.

Abstract: Techniques are described for analyzing and presenting results from a statistical analysis of a selected subset of data processed with statistical analysis techniques together with information from a business intelligence (BI) semantic model. In one example, a method includes receiving an input defining a selected subset of data from a structured representation of a set of data. The method further includes selecting one or more business intelligence factors from a business intelligence model based at least in part on the selected subset of data. The method further includes performing a statistical analysis of the selected subset of data based at least in part on the selected one or more business intelligence factors. The method further includes generating an output representing the statistical analysis of the selected subset of data based at least in part on the selected one or more business intelligence factors.

Abstract: Techniques are described for modeling information from a data source. In one example, a method includes receiving a data set. The method further includes defining at least one generic domain that provides a group of default concepts. The method further includes receiving a selection of an indication of at least one domain extension that extends the group of default concepts provided by the at least one generic domain, wherein the at least one domain extension includes concepts for a specific industry. The method further includes generating based on the data set and a combination of the at least one generic domain and the at least one domain extension, a model and a domain.

Abstract: Techniques are described for modeling information from a data source. In one example, a method includes receiving a data set. The method further includes defining at least one generic domain that provides a group of default concepts. The method further includes receiving a selection of an indication of at least one domain extension that extends the group of default concepts provided by the at least one generic domain, wherein the at least one domain extension includes concepts for a specific industry. The method further includes generating based on the data set and a combination attic at least one generic domain and the at least one domain extension, a model and a domain.

Abstract: An enterprise business intelligence system includes a data access service. In one example, a method comprises receiving, with a data access service, a query and a report specification from an application, wherein the data access service is positioned between the application and a data source; creating a run tree that comprises a sequence of executable decoration nodes; executing the query on the data source, thereby providing a query result set comprising query results drawn from the data source that are responsive to the query; and executing the sequence of decoration nodes on the query result set. The decoration nodes modify the query result set, thereby producing a decorated result set based on the query result set and the decoration nodes. Producing the decorated result set comprises associating members or values in the query results with corresponding positions or calculated members in the report specification.

Abstract: An enterprise business intelligence system includes a data access service. In one example, a method comprises receiving, with a data access service, a query and a report specification from an application, wherein the data access service is positioned between the application and a data source; creating a run tree that comprises a sequence of executable decoration nodes; executing the query on the data source, thereby providing a query result set comprising query results drawn from the data source that are responsive to the query; and executing the sequence of decoration nodes on the query result set. The decoration nodes modify the query result set, thereby producing a decorated result set based on the query result set and the decoration nodes. Producing the decorated result set comprises associating members or values in the query results with corresponding positions or calculated members in the report specification.

Abstract: Provided are techniques for generating a relational query. Information is collected from a query specification and a model for an On-Line Analytical Processing (OLAP) query having at least a first expression and a second expression. The collected information is used to generate a relational query to retrieve report data to be used to satisfy the first expression and the second expression.

Abstract: An enterprise business intelligence system includes a data access service. In one example, a method comprises receiving, with a data access service, a query and a report specification from an application, wherein the data access service is positioned between the application and a data source; creating a run tree that comprises a sequence of executable decoration nodes; executing the query on the data source, thereby providing a query result set comprising query results drawn from the data source that are responsive to the query; and executing the sequence of decoration nodes on the query result set. The decoration nodes modify the query result set, thereby producing a decorated result set based on the query result set and the decoration nodes. Producing the decorated result set comprises associating members or values in the query results with corresponding positions or calculated members in the report specification.

Abstract: An enterprise business intelligence system includes a data access service. In one example, a method comprises receiving, with a data access service, a query and a report specification from an application, wherein the data access service is positioned between the application and a data source; creating a run tree that comprises a sequence of executable decoration nodes; executing the query on the data source, thereby providing a query result set comprising query results drawn from the data source that are responsive to the query; and executing the sequence of decoration nodes on the query result set. The decoration nodes modify the query result set, thereby producing a decorated result set based on the query result set and the decoration nodes. Producing the decorated result set comprises associating members or values in the query results with corresponding positions or calculated members in the report specification.

Abstract: Systems, methods and articles of manufacture are disclosed for generating an online analytical processing (OLAP) query. A report specification may be received against the OLAP system. The report specification may include relational constructs. An application may apply constructs in the OLAP query according to a mapping and in a specific order. Consequently, the semantics of the report specification may be preserved.

Abstract: A computer readable storage medium includes executable instructions to receive context information specifying dimensional criteria defining a first value in a first data source. A context transfer to a second value in a second data source is generated based upon the dimensional criteria. The context transfer is performed in accordance with a translation model with a translation map for mapping between multiple data sources. The second value is supplied.

Abstract: A computer implemented method for mapping data from one presentation to another includes capturing and transmitting the context of an original report based on an originating data source such that it preserves the organization of the query and variable levels of context “fidelity”. The context of the originating report is translated in terms of the originating data source to a target context for presentation of a target report based on a target data source. The translation of different mapping scenarios is controlled in accordance with a translation model with a translation map.