SSAS Tabular Model Deployment

Tweet about this on TwitterShare on LinkedInShare on Google+Share on Facebook

I recently defined deployment of SSAS tabular model for one of the projects I am working on. Here it goes.

Deployment Procedure

As development team won’t have any access to other environments like Test or PROD, all the deployable will be handed over to DBA team who can then make the deployment with the procedure described below.

For the sake of simplicity, the deployment folder is named as SSASDeploymentFolder here. This is symbolic and in real case it would be somewhere in the shared drive and will be accessible by both DBA and development team.

Deployment files

The development team will generate all the deployment files required to make the deployment. This can be done by accessing the TFS and opening tabular project in SSDT and then build the project. After successful build all the files will be available in the bin folder of the project.

Right click on the project opened in SSDT and then click Build. Following screenshot illustrates how to build the project:

File Deployment

After successful build you will find the required files in the bin folder as below:

bin folder

Development team will copy these files below to the SSASDeploymentFolder and inform the DBA team with necessary process flow.

Model.asdatabase
Model.deploymentoptions
Model.deploymenttargets

Note: The name Model is default name. This can be replaced with the project name. But it is important that all three files need to have same name with corresponding extensions and need to be placed at same folder.

Deployment Steps

Microsoft Ships a deployment wizard to deploy SSAS tabular model. This can be found in the following folder (in a 32-bit system):

C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Microsoft.AnalysisServices.Deployment.exe

This wizard takes input file and makes the deployment in the target environment with necessary configuration options as illustrated below.

Start the wizard

You can double click above mentioned exe file or start it through start menu. It can be found under Microsoft SQL Server 2012 > Analysis Services > Deployment Wizard

start wizard

analysis service deployment wizard

Choose the input file copied to the deployment folder: Model.asdatabase

analysis service database

Specify the target (SSAS Tabular server) where the deployment will be made. Also specify the name of the AS database. Note that name of the database may or may not same as the name of the tabular model. The name of the model (cube) has been specified while development in SSDT.

installing target

Specify the deployment for partitions and roles. Choose the options as in the screenshot below:

deployment for partitions and roles

Specify the Configuration options for the tabular model (cube).

Configuration options for the tabular model

You need to change the connection string for the data source of the cube. In this case it is the data warehouse. Also specify the account using which it will connect to the data source. The screenshot illustrates.

connect datasource

Select full processing option.

select processing options

Final Step in wizard. DO NOT tick for the create deployment script.

If you tick, it would only generate a xml file scripting all the tabular model with the deployment options. This file can later be executed through management studio to make the deployment.

onfirm deployment

deploying database

The deployment will run for a while – It depends on how much data is processing from the source. After it completes click Next and then Finish.

deploying database

deployment complete

Verify using Management studio that your deployment is successful and as expected.

verify deployment

In your case you may need to change some or all the configuration options. Let me know your thoughts…

About Sumit Mund

Sumit Mund is a big data analytics consultant with about a decade of industry experience. At Mund Consulting Ltd, he is a director and acts as the lead consultant. He is an expert in machine learning, predictive analytics, Apache Spark, Python, C#, R, and Scala; Sumit has an active interest in Artificial Intelligence. He has extensive experience working with most of Microsoft Data Analytics tools and Big Data platforms like HDInsight. He is a Certified Developer on Apache Spark and also Microsoft Certified Solution Expert (MCSE in Business Intelligence). Sumit regularly engages on social media platforms through his tweets, blogs, and LinkedIn profile, and often gives talks at industry conferences and local user group meetings.

One thought on “SSAS Tabular Model Deployment

  1. Hi, Thanks for sharing detailed step by step approach. I tried using sane but can’t change data source. When I click on eclipse button ,it through an error. Something like some component missing . I have installed SP3 but issue still persist. Please share some thoughts. Thanks in advance

Leave a Reply

Your email address will not be published. Required fields are marked *


+ 5 = twelve