dbTalk Databases Forums  

AS OLAP Cubes - http access through Excel

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss AS OLAP Cubes - http access through Excel in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default AS OLAP Cubes - http access through Excel - 06-27-2006 , 10:44 AM






Hi,

I am using the HTTP access for querying Analysis Services 2005 from
Excel.
http://myServer/myInstance/msmdpump.dll

It works fine and I can get the Pivot Controls in Excel.
The only issue is that with a few dimensions, when I want to
drag'n'drop them into the Pivot Table, it returns an error:

"Either a connection cannot be made to the server or Analysis Server is
not running on the computer specified".

Any idea?

Thanks

Chris


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.