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 processing a multidimensional query. For each multidimensional expression in the multidimensional query, the multidimensional expression is evaluated to generate a representation that includes an evaluation context, a degeneration status, and condensed value storage that does not store data that would be replicated due to degeneration, and the representation is stored.

Abstract: Provided are techniques for processing a multidimensional query. For each multidimensional expression in the multidimensional query, the multidimensional expression is evaluated to generate a representation that includes an evaluation context, a degeneration status, and condensed value storage that does not store data that would be replicated due to degeneration, and the representation is stored.

Abstract: An illustrative embodiment provides a computer-implemented process for semantic verification of multidimensional data sources that receives a trusted output from a trusted multidimensional expression engine, receives an un-trusted output from an un-trusted data source and determines whether a query produces a correct semantic result, wherein the correct semantic result is within a predetermined tolerance. Responsive to a determination that the query does not produce a semantically correct result, identifies queries having semantically incorrect results to form a local subset, notifies a query planner of semantically incorrect queries and determines whether to process queries locally. Responsive to a determination to not process queries locally, creates a set of simplified multidimensional expression queries for remote execution.

Abstract: Provided are techniques for improving a test suite. A list of tests in a test suite is created, sorted in order of increasing run time, wherein multiple tests having a same run time are sorted in order of decreasing code block coverage. For each test on the list, it is determined whether the test covers one or more code blocks not already covered by at least one previously processed test. In response to determining that the test does cover one or more code blocks not already covered by the at least one previously processed test, the test is added to an optimized test suite. The optimized test suite is stored.

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 processing a multidimensional query. For each multidimensional expression in the multidimensional query, the multidimensional expression is evaluated to generate a representation that includes an evaluation context, a degeneration status, and condensed value storage that does not store data that would be replicated due to degeneration, and the representation is stored.

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 processing a multidimensional query. For each multidimensional expression in the multidimensional query, the multidimensional expression is evaluated to generate a representation that includes an evaluation context, a degeneration status, and condensed value storage that does not store data that would be replicated due to degeneration, and the representation is stored.

Abstract: A secure caching system and caching method include receiving a user request for data, the request containing a security context, and searching a cache for the requested data based on the user request and the received security context. If the requested data is found in cache, returning the cached data in response to the user request. If the requested data is not found in cache, obtaining the requested data from a data source, storing the obtained data in the cache and associating the obtained data with the security context, and returning the requested data in response to the user request. The search for the requested data can include searching for a security list that has the security context as a key, the security list including an address in the cache of the requested data.

Abstract: A secure caching system and caching method include receiving a user request for data, the request containing a security context, and searching a cache for the requested data based on the user request and the received security context. If the requested data is found in cache, returning the cached data in response to the user request. If the requested data is not found in cache, obtaining the requested data from a data source, storing the obtained data in the cache and associating the obtained data with the security context, and returning the requested data in response to the user request. The search for the requested data can include searching for a security list that has the security context as a key, the security list including an address in the cache of the requested data.

Abstract: An illustrative embodiment provides a computer-implemented process for semantic verification of multidimensional data sources that receives a trusted output from a trusted multidimensional expression engine, receives an un-trusted output from an un-trusted data source and determines whether a query produces a correct semantic result, wherein the correct semantic result is within a predetermined tolerance. Responsive to a determination that the query does not produce a semantically correct result, identifies queries having semantically incorrect results to form a local subset, notifies a query planner of semantically incorrect queries and determines whether to process queries locally. Responsive to a determination to not process queries locally, creates a set of simplified multidimensional expression queries for remote execution.