Lesson 14: Deploy
Applies To: SQL Server 2016
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.
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.
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.
You must have Administrator permissions on a remote Analysis Services instance in-order to deploy to it.
In the Database property, type Adventure Works Internet Sales Model.
In the Cube Name property, type Adventure Works Internet Sales Model.
Verify your selections and then click OK.
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.
When deployment successfully completes, go ahead and click Close.
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 Power View Reporting Properties (SSAS Tabular).