Chapter 11. Retrieving Data from Analysis Services

In this chapter, you will learn how to:

  • Create a perspective and access a cube using a perspective.

  • Create MDX queries.

  • Create an Excel 2007 PivotTable report using data from Analysis Services.

  • Use an Excel 2007 PivotTable report to execute actions, view KPIs, and drill to detail.

  • Create a SQL Server Reporting Services report using data from Analysis Services.

Your cube contains many dimensions and measures from several subject areas: sales, finance, production, and inventory. It can serve as a source of information for multiple workgroups or departments across your organization. Although this centralization is beneficial for users, application developers, and IT administrators, it might be difficult ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.