O'Reilly logo

SQL Server MVP Deep Dives Vol. 2 by Kimberly Tripp, Paul Randal, Paul Nielsen, Brad McGehee, Greg Low, Louis Davidson, Kalen Delaney

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 45. Creating SSRS reports from SSAS

Robert Cain

Many developers, be they .NET developers, database developers, or business intelligence developers, have become accustomed to using SQL Server Reporting Services (SSRS) to create professional-looking reports, using relational databases of all kinds as their data source.

The real power of Reporting Services is unleashed when SQL Server Analysis Services (SSAS) is used as a data source. Reports that show aggregations at the highest level, yet still allow users to drill down to the detail level, can be quickly and easily generated. Many developers have shied away from Analysis Services, assuming they had to learn MDX (Multi-Dimensional Expressions, the SQL-like language used to query an ...

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