Problem with XMLA connection from Excel

[muhmud]

When I try to connect to Mondrian using the connection for Analysis Services, or the latest version of the OLEDB Provider for Analysis Services, I get the following error:

The xsd:schema element at line 9, column 312 (namespace http://www.w3.org/2001/XMLSchema) cannot appear under Envelope/Body/ExecuteResponse/return/root

However, according to this blog post, there are a number of other errors that would occur after this was addressed, and there's details of the exact code changes that would need to be made to fix this issue and the others.

Would be it possible to somehow get this merged in so that someone can choose the flavour of XMLA they want and then make direct connections to Mondrian from Excel? I suspect there would be a large user base that would benefit from this kind of feature.

[SergeiSemenkov]

Hi!
Try to use RanetMondrian. It's Mondrian branch that is specially designed to support Excel and ADOMD.Net clients.

[muhmud]

Thanks for the link!

I actually solved this by using XSLT to modify the request/responses to match what Mondrian/Excel expect. Works great, even with the latest Excel 365, and I can still use the official Mondrian releases.

[greenbergjosh]

Muhmud, I did not see a way to contact you. I would love to hear about how you used XSLT. Would you be willing to correspond directly? My direct email is [email protected]
Thank you.

[lupingqiu]

Do you fix it? I get the same error info.