We have a web application that connects to MSAS Olap cubes via Microsoft Office Web Componntes, we are looking to migrate to flexmonster. Currently i’m using flexmonster 2.3 and it’s connected to MSAS via proxies, but flexmonster have worst loading times compared to Microsoft Web Components.
Is there any way to improve performance ?
Is it necessary to have Flexmonster Accelerator running with the proxies to perform well ?
I’m having this issue while trying to connect with flexmonster accelerator.
Also the user in the MSAS connection string it’s different from the one in the image.
Thank you for reaching out to us.
According to the screenshot, it seems the authentication is not configured correctly and the user that you are trying to connect with is not granted the necessary permissions. Please see our configuring authentication process tutorial for guidance.
We kindly recommend using Flexmonster Accelerator for achieving better performance.
When working with OLAP cubes, a browser component communicates with the server via the XMLA protocol. The XMLA protocol is heavy and exchanges a lot of excessive information – it takes too much time and memory to load and process the data.
Flexmonster Accelerator for Microsoft Analysis Services cubes is a special server-side proxy that increases data loading speeds from the server to the customer’s browser and at the same time reducing the load on the browser memory.
Also, please consider trying the latest version from our website since improvements have been made regarding performance.
Let us know if this helps.