search

pentaho / mondrian

Mondrian is an Online Analytical Processing (OLAP) server that enables business users to analyze large quantities of data in real-time.
http://mondrian.pentaho.com/
Other
1.14k stars 724 forks source link

Problem with XMLA connection from Excel #1179

Open muhmud opened 4 years ago

muhmud commented 4 years ago

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 commented 4 years ago

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

muhmud commented 4 years ago

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 commented 4 years ago

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 jgreenberg@onpointglobal.com Thank you.

lupingqiu commented 1 year ago

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