SQL Server 2016 Reporting Services Cookbook

Creating a report using Tabular models

As mentioned at the beginning of this chapter, a Tabular model is one of the model types that Analysis Services supports. There are many differences between Multidimensional and Tabular models. Holding data in the memory, simple tabular data structures, simpler design, and a comparatively shorter amount of time to create a model are some of the key differences. Some organizations still prefer the Multidimensional model because it is the richest platform for creating a BI solution, but you can try using a Tabular model because it is less complex and, most importantly, it can be implemented within a shorter time period.

In this recipe, we will look at how to create a simple report connecting with a Tabular model. ...