SSAS - Excel Connection fails

• Peter Gadsby

  SSCrazy

  Points: 2718

  More actions

  May 7, 2008 at 4:45 am

  #182031

  Hi,

  I'm fairly new to Analysis Services, but I have an issue with connecting to an Analysis Services cube stored in the database.

  When using SSRS model designer I can connect to the cube no problem. But when I try and access the cube in Excel (using the Manage connections). I get the error Cannot connect to server x the server is either not started or busy.

  I have installed the following on the machine that has Excel ...

  http://www.microsoft.com/downloads/details.aspx?FamilyID=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

  http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

  http://www.microsoft.com/downloads/details.aspx?FamilyID=993c0bcf-3bcf-4009-be21-27e85e1857b1&displaylang=en

  Any help, very much appreciated.

  Thanks

  Peter Gadsby

  Peter Gadsby
  Business Intelligence Consultant
  www.hgconsult.co.uk

• Dave Balsillie

  SSCertifiable

  Points: 5589

  More actions

  May 9, 2008 at 11:45 am

  #813270

  Which version of Excel and MSAS are you using?

  For 2003, Data, Import External Data, New Database Query.

  3rd tab (OLAP Cubes).

  Create a data source (use the 9.0 driver for MSAS 2005).

  Follow the prompts.

  Should be ready.

  For 2007 it's:

  Data

  From Other Sources

  From Analysis Services

  etc.

• Peter Gadsby

  SSCrazy

  Points: 2718

  More actions

  June 19, 2009 at 8:01 am

  #1012409

  Thanks Dave, however I've given up with using SSAS it seems that it doesn't really perform well when there is a medium/large amount of data to crunch. I've gone back to using Business Objects...

  Pete

  Peter Gadsby
  Business Intelligence Consultant
  www.hgconsult.co.uk