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

Get Microsoft® SQL Server® 2008 Reporting Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.