asked on April 4, 2018
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
⋅ 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
⋅ 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
⋅ 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
⋅ 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
⋅ 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
