Connect Flexmonster to Pentaho BI Embedded Mondrian

Hi,
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)…
http://localhost:8080/pentaho/Xmla?userid=Admin&password=password
Should this be something else?
Thanks,
Blair

5 answers

Public
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,
Iryna
 

Public
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.
Thanks,
Blair

Public
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.
Regards,
Tanya

Public
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)
 
Thanks,
Blair
 

Public
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.
Regards,
Tanya

Please login or Register to Submit Answer