SharePoint Pals
 | Sign In
How to Deploy Multidimensional Data Cube using Visual Studio Business Intelligence Settings
by Ahamed Fazil Buhari 20 Nov 2016
SharePoint Developer
Today  :   13     Total  :    544

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


blog comments powered by Disqus

SharePoint Pals

SharePoint Pals, a community portal for SharePoint developers, Administrators and End Users. Let's join hands and share the point together.
Read this on mobile


Angular Js Training In Chennai
Advanced Angular Js training with real world developer scenarios
Angular Js, Web Api and Ionic for .Net Developers
All in one client side application development for .Net developers
Angular Js For SharePoint Developers
Get ready for the future. Its no more just C#

Get Connected

SharePoint Resources

SharePoint 2013 and 2010 Web Parts
Free Web Parts with Source Code for SharePoint Community

SharePoint 2013 Books and Tutorials
Collection of free SharePoint 2013 books and tutorials (eBooks, pdfs)

Supported By

Contribute your article and be eligible for a one month Free Subscription for Plural Sight. The Author of the most popular New Article (published in the previous month) will be awarded with a Free One month Plural Sight Subscription. Article can be sent to in a word document.

Related Resources

Recent Tweets

Twitter November 21, 21:08
Implementing Multi-Threading with MaxDegreeOfParallelism in SharePoint using CSOM – An Insight -

Twitter November 21, 12:48
Configure Windows Firewall for SQL Server Analysis Service (SSAS) -

Twitter November 21, 12:46
Implementing Multi-Threading in SharePoint To Upload Files using CSOM C# – An Insight -

Twitter November 20, 21:48
How to Get the Client Context Using App Access token, by passing Client ID using CSOM in SharePoint Office 365 -

Twitter November 18, 21:30
How to Enable Auto Approval For Permission Requests in Community Site Template – Office 2013 using Client Side Object Model (CSOM) C#

Follow us @SharePointPals
Note: For Customization and Configuration, CheckOutRecent Tweets Documentation