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


Ahamed Fazil Buhari
SharePoint Developer
Published On :   20 Nov 2016
Visit Count
Today :  1    Total :   1937
Plan, Migrate, Secure, Report
SharePoint & Office 365 Tool. Simple & Easy to Use. 15-Day Trial!

Sharegate: Kick-Ass Tool
Think Your SharePoint & Office 365 Are Secure ? Find Out Now!


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.

clip_image002

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

clip_image004

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

clip_image006

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

clip_image008

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,

clip_image010

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

clip_image012

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

clip_image014

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

clip_image015

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

clip_image017

Happy Coding

Ahamed

SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Categories

Protect Your SharePoint