OWC-XML Structure migration issues SQL2005

[Monte]

Hi,

I recently migrated a customer's BI solution from SQL2000 to SQL2005. He
used to access the Analysis Services cubes via pivottable from OWC 9 or 10.

Concerning Cubes, Measures and dimensions he now has the exactly same
structure on SSAS as before on SQL2000.

Now I have about thousands of reports in OWC 9/10 XML format which i have to
migrate to OWC11 to work with SQL2005. I started replacing the version
number, Dataprovider and the new Servername. Now connection can be
established but I only see the reports measures. None of the reports
dimensions (+ structure + filtering) can be seen in the pivottable report.

Is there any documentation on what has changed in the xml format or any
smart way to easy migrate owc9/10 xml-reportdefinition to owc11?

Any help would be really appreciated!

 

[Alvin Bruney [MVP]]

You can possibly find this out by opening a support incident. I don't know
that info offhand, and I have no resource to look at either.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin