O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required