SQL Server Analysis Services 2012 Cube Development Cookbook

Creating a Tabular Model

In this recipe, we will walk through creating a Tabular Model database project using SSDT. As you begin working with Tabular Models, you will see that some of the complexities in setting up a good multidimensional model do not apply. While working with multidimensional models, you typically need all of the data organized and ready for consumption by Analysis Services. However, Tabular Models are much more forgiving. The key design requirement to take into consideration is: What data does the business need? As a result, we will create a model database here and work through model modifications in the following recipes.

Getting ready

Before you create your first Tabular Model database, you must have an installation of Analysis ...