How to Deploy Multidimensional Data Cube using Visual Studio Business Intelligence Settings

Ahamed Fazil Buhari
Senior Developer
November 20, 2016
Rate this article
[Total: 0    Average: 0/5]

In this article we are going to see, How to deploy Multidimensional Data Cube. This article is continuation of my previous articles, please refer my previous articles to get better knowledge on this. I’ve downloaded the sample Multidimensional Data from the CodePlex. (AdventureWorks Multidimensional Models SQL Server 2012).

1. Open the downloaded zip file and select the Standard folder and extract it.


2. Open up the standard folder and double click on AdventureWorksDW2012Multidimensional-SE, please make sure you have Visual Studio in your machine,


3. We need to select Business Intelligence Settings in our default environment settings.


4. Now we have our cube loaded, so let’s go ahead and check for the Data Source file. Here it is name as Adventure Works DW.ds and double click on that


5. Select the Impersonation Information tab, here we’re going to specify the account that is going to be used to pull the data from our database. I’ve using service account here,


6. Now we’re going to select the AdventureWorksMulidimensional-SE Project and right click on that and then select Process.


7. It would ask for ‘Would you like to build and deploy the project first?’ if we’re loading this cube from somewhere else


8. Now the Process Database window will open and click on Run button.


9. It would take time to run the process, our cube has been deployed once the process is completed successfully.


Happy Coding


Category : Visual Studio

Author Info

Ahamed Fazil Buhari
Senior Developer
Rate this article
[Total: 0    Average: 0/5]
Ahamed is a Senior Developer and he has very good experience in the field of Microsoft Technologies, especially SharePoint 2013, 2016 and O365, Azure, ASP.NET, SQL Server, IIS and client more

Leave a comment