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

Top 10 Visual Studio things which can boost developers coding speed

Visual Studio 2012 provides some coding features by which you can code faster if use them properly. This post will cover top 10 things among them to boost your development speed.

Visual Studio 2008 Shell and TFS integration

Visual Studio 2008 Shell and TFS integration is the problem for all newbies of BIDS and TFS. Here is the solution.

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.

Assembla - Free and private repository to manage your source code online with SVN subversion hosting

With Assembla you can share source code with others online. Free & Private source code repository with SVN Subversion, Git & Perforce Hosting.

Best CSS Gradient background generator tools online

Here are some best CSS gradient background code generator online tools using which you can create a cross browser css code for gradient backgrounds.

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!
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!