Hi,

I've set up the XMLA 1.1 beta on IIS and was wondering if there's any
way to now get the SOAP responses into Excel? The users here really
need a way to connect to Analysis Services through firewalls and this
seemed like a good way of doing it. Any help would be greatly
appreciated.

Thanks in advance,

Martin

"Martin B" <martin_bissell2001 (AT) yahoo (DOT) co.uk> wrote

If your goal is to connect from Excel to Analysis Services through
firewalls - then you will be better off by using HTTP connectivity feature
of Analysis Services. It will work with Excel PivotTables as well as with
any Excel Add-In product.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote


Hi Martin, Digital Aspects (my employer) has a provider which works
with Excel pivot tables and Excel Add-ins but uses XMLA. It works
through firewalls and may be what you are looking for. It is also
efficient on bandwidth as it works with HTTP compression. A free
evaluation is available here

http://www.digitalaspects.com/xmlatoodbo.php

HTH

Robin

rgrosset (AT) hotmail (DOT) com wrote in message news:<cdb1af98.0310100232.9b7ce04 (AT) posting (DOT) google.com>...
Thanks for your replies!

I'll try out both methods. I like the idea of conserving bandwidth as
some of our users will be using dial-up lines at times.

Martin

Hi Martin,

Check out my XMLA blog articles at
http://www.activeinterface.com/thinolap/thinolap.asp. I demonstrate how to
transform XML/A result sets into Excel sheets (and also into PowerPoint).
You could adopt my approach into an Excel VBA as well.

Chris

"Martin B" <martin_bissell2001 (AT) yahoo (DOT) co.uk> wrote

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote

Where can I can information on the HTTP connectivity feature of Analysis Services?

http://support.microsoft.com/?kbid=279489
http://msdn.microsoft.com/library/de...l_datapump.asp

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================