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 ...
Get SQL Server 2016 Reporting Services Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
