Home > Articles > Data > SQL Server

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

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.

  • + Share This
  • 🔖 Save To Your Account