How to Import SSAS Cube From SQL Server Management Studio (SQL Server 2008/2008R2)
Image From Google/Microsoft

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:

  1. 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.





要查看或添加评论,请登录

Ajay Kumar的更多文章

  • Azure Data Lake Storage: The Ultimate Solution for Big Data Storage and Analytics

    Azure Data Lake Storage: The Ultimate Solution for Big Data Storage and Analytics

    As organizations generate more data, the need for scalable and flexible storage solutions becomes more pressing. Azure…

  • Power BI Best Practices

    Power BI Best Practices

    Dear all Power BI Users, In our day to day work we do design reports/share and publish them. No matter what, we always…

  • The valued competencies of Microsoft Power BI tool

    The valued competencies of Microsoft Power BI tool

    Power BI is a cloud-based business analytic solution, which is used to analyze data from a wide range of data sources…

  • Top 11 Best Practices of Power BI

    Top 11 Best Practices of Power BI

    Hello Power BI Users! Today, in this article, I am going to discuss about top 11 best practices in Power BI. I hope you…

    1 条评论
  • Power BI Data Gateway

    Power BI Data Gateway

    Hello Power BI Users, Lately, I came across a questions ..

  • Export Data From Power BI Dataset

    Export Data From Power BI Dataset

    Dear All, Most of times, I came across a question that how to extract any number of rows data from Power BI dataset…

    1 条评论
  • Power BI - Auto Recovery

    Power BI - Auto Recovery

    Many times, it happens that a Power BI user is working on a Power BI report/file and suddenly system crashed out or…

    1 条评论
  • Why Power BI Premium?

    Why Power BI Premium?

    Microsoft introduced Power BI in late 2013 as a separate software and since then it's continuously growing and now it's…

  • #1 Data Visualization & Analytics Tool

    #1 Data Visualization & Analytics Tool

    Good news for all Power BI Developers/Users. Once again, #Gartner named, Power BI as #1 Data Visualization & Analytics…

  • History of Ms Power BI

    History of Ms Power BI

    Everyone of us who all are working on Ms Power BI, must have idea about Power BI and what does it do but only few are…

社区洞察

其他会员也浏览了