OLAP Cube deployment issues
connection, cube, olap, sql, ssas
Solution
you need to deploy the cube to a SSAS instance. See here I have the SQL Server instance and the SSAS instance (check the icon to see the difference):
you can check if you have it running on the services:
if you dont have it, yo ucan install from the sql server installation CD
Problem
I'm really new to this, so I am probably making a simple mistake. I need to make an OLAP cube using a remote database. After I set up the dimensions and measures and create the cube, I can not get the cube to launch to the local server. I keep getting the error, "The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server." However, the local SQL server is running(from as far as I can tell), and I have no idea on how to go about fixing this. I've tried replacing "localhost" with "." and the IP, but that hasn't worked either. Here's the guide I was following: http://www.mssqltips.com/sqlservertip/1532/build-a-cube-from-an-existing-data-source-using-sql-server-analysis-services/ Maybe the SQL Server isn't really running? How can I check? Or am I skipping over something important when I try to process the cube?