Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office, Part 1: Creating an Excel PivotTable Report with an OLAP Cube
- Introduction to the Series
- What You Will Need to Complete the Series Tutorials
- Building an Excel PivotTable Report on OLAP Data Source
- Connecting Excel to the OLAP Cube
- Layout and Navigation of the PivotTable Report
- Browsing the Cube
- Drilling to Member Details
- Going Multidimensional
- Next in This Series
Next in This Series
This first tutorial presented an introduction to using Excel PivotTable reports to retrieve and display information from an OLAP cube. We showed the steps needed to define a data source, and to establish a connection to the cube. We exposed the layout of the PivotTable report, and explored the use of the PivotTable toolbar in browsing and reporting on cube data. Finally, we discussed the intersection of dimensions in the PivotTable report axes as a means of making reports truly multidimensional.
The next tutorial deals with the Office PivotTable list capabilities that provide another means of integrating Microsoft Office with the OLAP cube. We'll explore the basics of use and navigation of the various components that comprise list reporting functionality, including Microsoft FrontPage. We'll discuss similarities and differences between the Excel PivotTable report and the Office PivotTable list, and focus on designing a PivotTable list to provide flexibility in information delivery to meet business needs, while controlling the capabilities afforded to the information consumer.