Home > Articles > Data > SQL Server

  • Print
  • + Share This
Like this article? We recommend

Building an Excel PivotTable Report on OLAP Data Source

Office 2000 witnessed the appearance of robust new OLAP reporting features for the desktop user. When a PivotTable report accesses a multidimensional cube, it communicates with the PivotTable Service to return values from an Analysis Server. As the first exercise in this tutorial, we'll create a PivotTable report that accesses the Sales sample cube that comes with Analysis Services. We'll use the PivotTable Wizard found in Excel 2000 in our initial efforts.

The wizard accesses the Microsoft Query application in Excel to build a query file. The file assumes the name of the data source, appending an .oqy extension. Query file creation is a one-time event for any given PivotTable report, and defines the connection between Microsoft Excel and the OLAP cube.

  • + Share This
  • 🔖 Save To Your Account