Dodi82 Dodi82 - 1 month ago 15
SQL Question

Data Warehouse with SQL Server 2012 Management Studio

I am working on a project to create a data warehouse. I have installed SQL Server 2012 Management Studio for this purpose. However, When I showed the software to my tutor, he said that there is no Data warehouse folder within the Object Explorer. He thought Microsoft provided special management studio to support Business Intelligence i.e. for Data warehouse like Oracle and their enterprise version.
Is there any special editions Microsoft providing for Data Warehouse other than the one I have? And if there is any, where would I find it?

Answer

There are several moving pieces. First you need to ensure that the SQL Server that your connecting to has SQL Server Analysis Services (SSAS) installed and running. Second, when you attach to the server, you need to connect to Analysis Services rather than a Database Engine

I cannot recall from memory, but a possible third issue is that you did not choose the Analysis Services components when you installed SSMS, but I think they get installed by default if I recall.

Comments