Export (0) Print
Expand All
7 out of 9 rated this helpful - Rate this topic

Lesson 14: Deploy

SQL Server 2012

In this lesson, you will configure deployment properties; specifying a deployment server instance of Analysis Services running in Tabular mode, and a name for the model you deploy. You will then deploy the model to that instance. After it is deployed, users can connect to the model by using a reporting client application. To learn more, see Tabular Model Solution Deployment (SSAS Tabular).

Estimated time to complete this lesson: 5 minutes

This topic is part of a tabular modeling tutorial, which should be completed in order. Before performing the tasks in this lesson, you should have completed the previous lesson: Lesson 13: Analyze in Excel.

To configure deployment properties

  1. In SQL Server Data Tools, in Solution Explorer, right-click on the Adventure Works Internet Sales Tabular Model project, and then in the context menu, click Properties.

  2. In the AW Internet Sales Tabular Model Property Pages dialog box, under Deployment Server, in the Server property, type the name of an Analysis Services instance running in Tabular mode. This will be the instance your model will be deployed to.

    Important note Important

    You must have Administrator permissions on a remote Analysis Services instance in-order to deploy to it.

  3. Verify the Query Mode property is set to In-Memory.

    Note Note

    The model created by using this tutorial is not supported in DirectQuery mode.

  4. In the Database property, type Adventure Works Internet Sales Model.

  5. In the Cube Name property, type Adventure Works Internet Sales Model.

  6. Verify your selections and then click OK.

To deploy the Adventure Works Internet Sales tabular model

  • In SQL Server Data Tools, click the Build menu, and then click Deploy AW Internet Sales Tabular Model.

    The Deploy dialog box appears and displays the deployment status of the metadata as well as each table included in the model.

Congratulations! You are finished authoring and deploying your first Analysis Services tabular model. This tutorial has helped guide you through completing the most common tasks in creating a tabular model. Now that your Adventure Works Internet Sales Model is deployed, you can use SQL Server Management Studio to manage the model; create process scripts and a backup plan. Users can connect to the model using a reporting client application such as Microsoft Excel or Power View.

To learn more about tabular model properties that support Power View reports, see http://go.microsoft.com/fwlink/?LinkId=220897.

To see a tutorial about how to configure tabular model reporting properties for Power View, see http://go.microsoft.com/fwlink/?LinkId=219995 .

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.