Chapter 10

Reporting with Analysis Services

What's in this chapter?

Understanding Analysis Server

Working with Multidimensional Expressions (MDX)

Building queries with the MDX Query Designer

Adding nonadditional measures

When to use the Aggregate function

Creating cube report actions

SQL Server 2012 Analysis Services is used to store and aggregate data. Specifically, it supports decision-support systems, ad hoc reporting, and business data analysis. After it is designed, cube data is easy to navigate to produce complex, business-relevant results for business leaders and information workers.

This chapter introduces some of the basic concepts of OLAP and multidimensional storage systems. You will use the Report Designer to create Multidimensional Expressions (MDX) language queries, both with and without the MDX Graphical Query Builder. You will learn how to build compelling reports using parameters, pivot tables, and KPI indicators in a table or matrix report.

Finally, you will learn to use cube actions and apply best practices and safety checks to your report solutions that use Analysis Services as a data source.

In the following chapter, you will build on this knowledge to create advanced reports that can change their content (rows, columns, and measures) by simply changing report parameter values.

Why Use Analysis Services for Reporting?

Every year at the Professional Association for SQL Server (PASS) Community Summit, I poll the Reporting Services session attendees and ask who ...

Get Professional Microsoft SQL Server 2012 Reporting Services now with O’Reilly online learning.

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