O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Deploying models from SSDT

The prior recipes in Chapter 7, Enterprise Design and Features, that deal with SQL Server Data Tools (SSDT), create a workspace database on a tabular server. This is used by SSDT as a temporary database (or model) for display and as a database that Excel can use (when you choose to analyze the data in Excel through SSDT). When SSDT is closed, the database is lost.

In order to persist the database, so that it is constantly available to end users, it must be deployed to an SSAS (tabular) server.

Getting ready

This recipe continues from the Creating perspectives recipe in Chapter 7, Enterprise Design and Features.

How to do it…

Let's start by examining the deployment properties for our project:

  1. Confirm the deployment options ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required