|
|
|
date: Tue, 23 May 2006 05:56:02 -0700,
group: microsoft.public.data.xmlanalysis
back
Re: Read cube from excel by XML For Analysis SDK Web service
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:
> How did you try to call it from Excel?
>
> Thanks,
> Akshai
> --
> Try out the MSDN Forums for Analysis Services at:
> http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1
>
> 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.
>
> "Dario Concilio" wrote in message
> news:78046CA0-5CB9-4B5E-84A7-F429EA061E6D@microsoft.com...
> > 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?
> >
>
>
>
date: Wed, 24 May 2006 00:36:01 -0700
author: Dario Concilio
Re: Read cube from excel by XML For Analysis SDK Web service
> 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
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1
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.
"Dario Concilio" wrote in message
news:D81F09CB-22A2-4F5F-A18B-9A84087BCCC6@microsoft.com...
>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:
>
>> How did you try to call it from Excel?
>>
>> Thanks,
>> Akshai
>> --
>> Try out the MSDN Forums for Analysis Services at:
>> http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1
>>
>> 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.
>>
>> "Dario Concilio" wrote in
>> message
>> news:78046CA0-5CB9-4B5E-84A7-F429EA061E6D@microsoft.com...
>> > 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?
>> >
>>
>>
>>
date: Thu, 25 May 2006 11:39:53 -0700
author: Akshai Mirchandani [MS]
|
|
