O'Reilly logo

Microsoft® SQL Server® 2008 Reporting Services Step by Step by Stacia Misner

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 7. Using Analysis Services as a Data Source

After completing this chapter, you will be able to:

  • Create an Analysis Services data source.

  • Use the MDX query designer to develop an MDX query.

  • Use extended field properties for an Analysis Services dataset.

  • Display server aggregates in a data region.

  • Define parameters in the MDX query designer.

When you have a large database to query or your reports contain complex calculations that are difficult to perform by using relational queries, you can move your data into an online analytical processing (OLAP) database managed by Analysis Services. An OLAP database is characterized by a multidimensional data structure known as a cube, which provides fast responses to queries and includes spreadsheet-style ...

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