CODEWITHSUNDEEP
visual-studiossas
SRS
SRS

Reputation: 449

Using Visual Studio 2013 to analyze a database from sql server analysis services

I have a SQL Server database file in ABF format. I restored the file in sql server using the analysis services connectivity type.Now, I have to use the dimensions, cubes and other stuffs in that file in Visual Studio 2013 and do some analysis. I used the Import from Server (Multidimensional and Data Mining ) option to load the database into the visual studio. Now the project contains cubes,data sources, dimensions, mining structures and roles. I am not sure how exactly I am suppose to use these contents and work on an analysis. Can someone please guide me through the analysis process with respect to this scenario?

FYI, I am using Microsoft's ContosoRetail Database as the ABF file. I tried to deploy the project, without making any change, just to get an idea of what the result will look like. I got 77 errors. I have included a sample screenshot of my project page, after loading the database into the visual studio, below

DEPLOYMENT ERROR

Upvotes: 0

Views: 1945

Answers (1)

Akshay Rane
Akshay Rane

Reputation: 423

Did you restore the ContosoRetailDW database as well?

You need the SQL Server Database which can be downloaded as a backup (.BAK) file from here. Restore this database to your SQL Server Database Engine and after that, go to the screen you shared and click on ContosoRetailDW under Data Sources and get the connection established to the database that you just restored; test it by clicking on Test Connection. Now, you can proceed to deploy your SSAS Project.

You may also find this video useful.

Upvotes: 1

Related Questions