How to Import SSAS Cube From SQL Server Management Studio (SQL Server 2008/2008R2)
Hi Guys,
It happens when your SSAS Cube is already deployed on a server and later you have to fix a defect or bug in SSAS Cube. Now you have two option, first, you have already that Cube which has been deployed on server, in your repository on TFS or SVN and secondly you can connect directly to the SSMS (SQL Server Management Studio) Server where you deployed SSAS Cube.
In this article, I am going to describe option second and I am assuming that somehow we lost SSAS cube from repository and now we have SSAS Cube only on SQL Server. So in order to get the SSAS Cube and fix the defect, we should have the same in SQL Server Visual Studio. Following are the steps explaining the same. Follow the below process and you will get SSAS Cube in your SQL Server Visual Studio:
- Go to Start and Open SQL Server Business Intelligence Development Studio as shown in below snapshot:
2. Click on File --> New --> Project
3. Click on “Import Analysis Services Database” and mention Name, location, Solution Name etc. as per your requirement:
4. Import Analysis Services Database Wizard would get open as shown in following snapshot:
Click on “Next” button.
5.Mention “Server” name and Select the database as shown in the below snapshot and click on “Next” button.
6. Once it’s done as shown below, click on “Finish” button and you are done.
7. Now, you can see your project in solution explorer.