Retrieving Data

PivotTable® Service can be used by a client application to connect to any of the following data sources:

• An OLAP server running Microsoft® SQL Server™ OLAP Services.
• A relational database. (PivotTable Service provides a multidimensional view of the data.)
• A local cube file.

To browse and analyze the data, you can use a multidimensional expressions (MDX) query that represents the dataset you want to retrieve from the database or cube.

Each MDX query is executed using the appropriate interfaces in the OLE DB Command object and results in the creation of either a Dataset object or a flattened rowset. For more information about rowsets, see the OLE DB documentation. For more information about MDX queries, see Building an MDX Query.

SQL statements upon local cubes are not supported.