摘要 |
A tabular operation provider system and method of providing support for operations not supported by an OLAP source is provided. The system comprises a query interceptor for intercepting a BI query, a query decomposer for extracting into sub-queries the operands of set operations not supported by an OLAP source from the query, an OLAP query provider interface for sending the OLAP supported sub-queries to an OLAP query provider and receiving results, and an operation module for receiving set operation functionality from a relation query provider and performing the se t operation locally on the results of the OLAP data extraction. The method comprises the steps of intercepting a intercepting a BI query, extracting operands into sub-queries , sending the OLAP supported sub-queries to an OLAP query provider, and performing the s et operation on results received from the OLAP query provider using services provided by a relational query provider. The operands are extracted from the set of operations in the BI query.
|