O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

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

Creating a report using Multidimensional models

As you know, SQL Server Analysis Services provides three database model types for implementing a database for BI: Multidimensional, Tabular, and PowerPivot. Multidimensional is the oldest and richest platform that has all the required functionalities, whereas Tabular is less complex but not as rich as Multidimensional. PowerPivot is simpler than both Multidimensional and Tabular, but provides sufficient functionalities to business users to create their own models. Let's start with the Multidimensional model and look at how Reporting Services works with it.

In this recipe, we will discuss how to create a standard report using the Multidimensional model. We will discuss some of the considerations you ...

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