Read cube from excel by XML For Analysis SDK Web service

Read cube from excel by XML For Analysis SDK Web service

Post by RGFyaW8gQ2 » Wed, 24 May 2006 21:56:02


Hi all,
I configured correctly this web service, when I try to call it by IE I
receive correct message. But when I try to call it from excel it gives me
"server error".

For this test I used driver OLAP 8.0 for create a pivot table from excel.

Have you got any idea?
 
 
 

Read cube from excel by XML For Analysis SDK Web service

Post by Akshai Mir » Thu, 25 May 2006 02:59:13

How did you try to call it from Excel?

Thanks,
Akshai
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

 
 
 

Read cube from excel by XML For Analysis SDK Web service

Post by RGFyaW8gQ2 » Thu, 25 May 2006 16:36:01

I tryed to create a data source in excel.

Starting from Data menu, select "table pivot" etc.., select external data,
then presso "extract data" button, go to OLAP cube, select new data source,
after create your connection to cube
1. Name of connection
2. Driver for OLAP (choose 8.0 version, if you haven't got it update MDAC)
3. and then press connect button >
NOW when you must setup the new connection, you can choose some ways.

first: using direct connection to cube instance >
-choose analysis server radio button
-server will setup with host name
-and nothing other
second: using a cube file
-choose cube file radio button
-then select cube file (cube files can be created from excel by pivot
table)
third: using connection to web service XML
-choose analysis server radio button
-for server field setup url of webservice
(for example: http://localhost/xmla/msxisapi.dll)
-"theoretically" you should be gotten the cubes equally
BUT apper "Server error"!!!

SOB....

"Akshai Mirchandani [MS]" ha scritto:
 
 
 

Read cube from excel by XML For Analysis SDK Web service

Post by Akshai Mir » Sat, 27 May 2006 03:39:53

> third: using connection to web service XML

What exactly is this? Are you using some Excel addin to connect to web
services? Because normally Excel doesn't have the functionality you mention
in step 3 to connect to a web service.

Have you verified that the XMLA sample applications work properly against
your XMLA provider?

Thanks,
Akshai
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.