Systems and methods for providing a simplified application programming interface for converting from two-dimensional query languages into multi-dimensional query languages to query multi-dimensional data sources and MDX servers

摘要

Apparatus and methods are provided for querying OLAP data sources and other MDX servers utilizing a two-dimensional query language. Aspects of the apparatus and methods receive a query written in a two-dimensional query language, such as LINQ, convert the query into a query compatible with a multi-dimensional query language, such as MDX, and employ the converted query to query the OLAP data source.

主权项

1. An apparatus configured to retrieve data from an Online Analytical Processing (“OLAP”) data source or MDX servers of other types, wherein said data source has associated meta-data, said apparatus comprising:
a computing device; an application programming interface (“API”) configured to operate within said computing device; said API configured to receive a two-dimensional query written in a two-dimensional query language such that said query includes a sequenced list of requested columns wherein said sequenced list includes a mixed order of measure columns and dimensional columns; said computing device configured to convert said two-dimensional query into a multi-dimensional query which is compatible with a multi-dimensional query language such that said measure columns are separated from said dimensional columns; and, said computing device configured to retrieve data responsive to said multi-dimensional query.