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