You can pass SQL queries to an OLAP server by using PivotTable® Service. PivotTable Service is an in-process desktop OLAP server designed to provide online and offline data analysis and online access to OLAP data. PivotTable Service functions as a client of Microsoft® SQL Server™ OLAP Services.
SQL queries can be passed to PivotTable Service using either of the following data connectivity tools:
OLE DB for OLAP extends OLE DB to include objects specific to multidimensional data. ADO MD extends ADO in the same fashion.
You can also use certain data definition language (DDL) statements to create local cubes and calculated members.
For more information, see PivotTable Service.