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 have to make with reports generated with Multidimensional models in the following set of recipes.
Getting ready
We have mainly been using the WideWorldImporters database to make demos and create our sample reports, but for this section, we will use...
