🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Connect Flexmonster to Pentaho BI Embedded Mondrian

Blair asked on April 4, 2018

I have been trying to connect flexmonster to the xmla interface of the mondrian server embedded within Pentaho BI 8.0.
I can confirm the interface works as I have connected to it from other clients.
Flexmonster keeps telling me the url is incorrect and I have hit a brick wall.
Is the proxy url (assuming localhost is ip and credentials are correct)…
Should this be something else?

5 answers

Iryna Kulchytska Iryna Kulchytska Flexmonster April 5, 2018

Hi Blair,
Thank you for posting your question here.
Your proxyUrl looks correct. Could you please provide us with the exact error or message you see?
Also, I need to ask you to check if CORS is enabled. Please check the following thread on our forum related to CORS for your case https://www.flexmonster.com/question/stream-error-occurred-while-loading-httplocalhost8080pentahoxmla/
Please let me know if CORS was the reason of the issue.
Kind regards,

Blair April 11, 2018

Hi Iryna,
We have added CORS to the web.xml file and the error still occurs. 
This does not seem to be the solution.
I do not get a stream error like the thread you posted I get what you can see in the image I attached.

Tanya Gryshko Tanya Gryshko Flexmonster April 11, 2018

Hello, Blair,
Thanks for your update!
Could you please check whether you have any errors in the browser’s console?
If yes, we kindly ask you to share them with us.
Waiting for your reply.

Blair April 20, 2018

Hi Tanya,
Sorry for the late reply.
The error I get in the console for Safari is
Preflight response is not successful
The error I get in chromes console is
Response for preflight is invalid (redirect)

Tanya Gryshko Tanya Gryshko Flexmonster April 20, 2018

Hello, Blair,
Thank you for sharing your errors with us.
Our team wants to suggest you an alternative approach. Configuring connection via XMLA protocol can be tricky. Also, it’s no secret that the XMLA protocol takes too much time and memory to load and process the data. We suggest trying Flexmonster Accelerator for Pentaho Mondrian cubes. This is a special server-side proxy that helps you to increase data loading speed from server to customer’s browser because it uses direct requests from the Component to a server.
Flexmonster Accelerator is much easier to configure. Please follow this tutorial: https://www.flexmonster.com/doc/getting-started-with-accelerator-mondrian/
Please share your feedback with us.

Please login or Register to Submit Answer