Subscribe - It's FREE!!

Stay Connected Here

Stay Updated With Us Here


How to deploy SSAS cube to production server

Share with WhatsApp

Hello friend, in this post I am sharing the information about how to properly deploy the SSAS Cube to the production or client server properly with proper connection and credentials.

In one of my project we had a requirement to create datawarehouse and cube dynamically for each year when data gets archived. The task was not that much easy for me as I was not having any experience of SSAS and all things such as datawarehouse, cube, dimension, fact metrics etc were totally new for me.

But finally we had completed our developement by reading more about SSAS and related things. You can read following related posts which are helpful for such developement.

  1. Copy changed data in table from one database to another in SQL stored procedure.
  2. How to Create New SSAS Cube from existing dynamically in C#.
  3. Process SSAS Cube programmatically in C# using Microsoft.AnalysisServices Dll.

In our environment we were using BIDS (SQL server Business Intelligence Studio) to deploy the cube to the QA environment but using BIDS for deployment on production was not good idea so after reading more about SSAS we found that using "Deployment Wizard" is one of the proper way to deploy the Cube on production.

Using "Deployment wizard" you can choose the objects which needs to be deployed on the server. When you use BIDS for the cube deployment there are chances that you may loss or overwrite some of the objects so you can avoid such problems using "Deployment Wizard".

Let's see using "Deployment Wizard" step by step.

Before using deployment wizard confirm you have the user credentials which has proper permissions to the database and analysis services.

Also you will require build ouput of your Cube project which will produce the files like following.

  • CubeProjectName.asdatabase
  • CubeProjectName.configsettings
  • CubeProjectName.deploymentoptions
  • CubeProjectName.deploymenttargets

Now Open "Deployment Wizard" which is situated in "All Programs" >> "Microsoft SQL Server 2008 R2 >> Analysis Services >> Deployment Wizard.
(I am using SQL Server 2008 R2)

It will open a window like below.

Deployment Wizard for Cube - Step 1

Click on Next, it will show you the window like below where you need to select the ".asdatabase" file.

Deployment Wizard for Cube - Step 2

Once you selected proper ".asdatabase" file, click on "Next", it will open a window like below in which you need to provide target server and cube database name.

Deployment Wizard for Cube - Step 3

After providing target details,clik on "Next", it will open window like below, here you need to select options for partitions and roles, in most cases, default options are suitable.

Deployment Wizard for Cube - Step 4

After selecting the options, click on "Next", it will open window like below, here you need to specify configuration properties and connection string. Read all properties and set the required values. Here too default options are ok if you are not sure about it, in this window it is very important to select the proper data source connection for which you need click the "..." button.

Deployment Wizard for Cube - Step 5

Provide the proper server name and credentials (recommended is to use windows authentication) and click on "Test Connection" >> "OK"> "Next"

Deployment Wizard for Cube - Step 6

Now select the Processing option (you can select Full Processesing here) and click on "Next"

Deployment Wizard for Cube - Step 7

Now confirm the deployment and here you have the option to generate deployment script, check the box if you want it to create and click on "Next"

Deployment Wizard for Cube - Step 8

You will able to see the status in window like below, once deployment completed successfully, you can select the "Next" and then "Finish".

Deployment Wizard for Cube - Step 9

Hope you have liked this post. If have anything positive to add do share it in comment section below. Thanks.

If you enjoyed this post take 5 seconds to share it! Be Socialable. :-)

Share with WhatsApp

Posts To Read Next

Swagger - Powerful Opensource Framework for RESTful API

With a Swagger-enabled API, you get interactive documentation, client SDK generation and discoverability. Swagger Editor allows you to generate code, documentation with ease.

What is Hoisting in JavaScript?

Hoisting in JavaScript, one of the most misunderstood or little understood concept in the JavaScript and remain famous as interview question for JavaScript developers and now also for angular js developer. Lets check out what it means exactly.

Visual Studio Code - Lighweight but powerful source code editor available for Windows, OS X and Linux

Visual Studio Code is a lightweight but powerful source code editor which runs on your desktop and is available for Windows, OS X and Linux. It comes with built-in support for JavaScript, TypeScript and Node.js and has a rich ecosystem of extensions for other languages (C++, C#, Python, PHP) and runtimes.

How to post JSON string as a string in jQuery AJAX

Know how to post JSON String as string to the action method of controller in MVC.

How to call click or any event only once in jQuery

Know how to execute an click event or any event only once for any element in jQuery. Perform action only once and even not required to unbind event.

Your opinion is valuable for us! Comments, suggetions are welcome.

Submit your Email Id to stay updated with us and get notified with our new posts. It's FREE!
Vu 32'' TV Vu 24'' TV
We know this popup is disturbing you!
But We would greatly appreciate if you share us with your friends below!

It will not take more than 2 seconds but will motivate us greatly to write more,share more!