Populate OWC PivotTable with Xml Data and save data

[Kannan]

Hello everyone,
I am attempting the following tasks in an ASP.NET-->Office 2003-->Web
Service setup and wanted to know if this is possible?

1. Display an OWC PivotTable with Xml returned from webservice as a
data source. (the webservice gets data from an OLAP cube and returns
as Xml)

2. The user might then go and change a few numbers in the sheet and
then would try to do a save. It then calls another webmethod which
would save the data back to the OLAP cube.

I know that we can specify "MS Persist" to the Pivot Table for task
#1. Is this the only way to set the datasource of a Pivot Table to
Xml?

Also, is task 2 possible?

Thanks in advance...

Kannan

 

[Chris Harrington]

Hi Kannan,

You can certainly take data out of Analysis Services as XML (using XML
for Analysis) and pass it through an XSLT to put it in the OWC XML
format - I have used this approach sucessfully. However, the writeback
is more challenging - I don't think XML/A supports write-back yet.

Chris