SQL Server MVP Deep Dives, Volume 2
by Brad McGehee, Louis Davidson, Greg Low, Kimberly Tripp, Paul S. Randal, Kalen Delaney, Paul Nielsen
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access