This demo shows how to create an Excel 2010 PivotTable using an SQL Server 2008 R2 Analysis Services cube. The PivotTable will support interactive filtering with a slicer and incorporate calculations from the cube.
Creating an Excel 2010 PivotTable Using a SQL Server 2008 R2 Analysis Services Cube:
This demo shows how to develop a simple SQL Server 2008 R2 Reporting Services report using Analysis Services cube. The demo will show how to develop an MDX query with the graphical designer, and how to incorporate formatting properties from the cube in a report.
Developing a Simple SQL Server 2008 R2 Reporting Services Report with an Analysis Services Cube: