Using Tabular Models - SQL Server Analysis Services 2012 Cube Development - page 303

Chapter 9. Using Tabular Models
In this chapter, we will cover:
• Creating a Tabular Model
• Working with data sources and loading data
• Modeling the data
• Creating a hierarchy
• Creating a calculated measure
• Creating a calculated column
• Creating a KPI
• Analyzing your model in Excel
• Deploying Tabular Models
• Scripting Tabular Models using XMLA
• Processing Tabular Models
• Partitioning Tabular Models
• Implementing perspectives
• Implementing security in Tabular Models
• Automating Tabular Model processing
Introduction
This chapter covers the concepts of creating SQL Server Analysis Services ( SSAS )
Tabular Models that are included in SQL Server 2012. Tabular Models are the enter-
prise implementation of the xVelocity In-Memory Analytics Engine models that were
introduced with Power Pivot and SQL Server 2008 R2. Often, Tabular Models are the
result of working with Power Pivot models. The Power Pivot and Tabular Models are
built on the same technology. However, there are some features which are not in-
cluded in Power Pivot but are available in Tabular such as DirectQuery, partitions, and
higher-level security. In this chapter, we will focus on building Tabular Models in SSAS
using Visual Studio.
We will be using SQL Server Data Tools ( SSDT ) in this chapter to create our model.
Much of the work that we do in the initial creation of the model can also be done using
Microsoft Excel 2010 or Microsoft Excel 2013 with the Power Pivot add-in. The design
interface is very similar, so you will be able to use much of what you learn here to
create Power Pivot models as well. As a result, I will be calling out those features that