Flexmonster Data Speed Accelerator For OLAP Cubes: We Show Multidimensional Data 10 Times Faster!

Antonina Krus posted on November 25th, 2015

Everyone who has ever worked with multidimensional databases analysis has most probably faced with the problem finding a suitable component that not only performs all required functions but also executes them fast. Flexmonster solved this problem and created Flexmonster Data Speed Accelerator for OLAP cubes – a special server-side proxy that helps you to increase data loading speed from server to customer’s browser tenfold.

Working with OLAP cubes, a browser component is communicating with the server via XMLA protocol. It’s no secret that the XMLA protocol is heavy and exchanges a lot of excessive information. Thus, it takes too much time and memory to load and process the data.


What we did? – We removed XMLA protocol and use direct requests from the Component to a server.


In this way we came up with two solutions for main problems that all who work with big databases have somehow faced:

  • We made big data transfer from server to browser enormously fast.

Our tool allows you to transfer large multidimensional data  in super easy and fast way. Reporting becomes more enjoyable and prompt for your end users.

  • We greatly reduced the load on a browser memory.

Using our new proxy, the data that Component receives from the server is already compressed in more than  ten times!


How does it work?



1) You install a Flexmonster Data Speed Accelerator application directly on the client’s server.

2) It communicates with a cube directly using more inherent technology that significantly accelerates the process. Everything depends on the power of your server.

  • Browser sends request to proxy (e.g., http://myserver/proxyurl:port);
  • Proxy script reads the request and creates query to the cube ;
  • Cube returns resulted dataset to the proxy.


3) Proxy reads this result and composes response to the customer’s browser.

4) Browser displays received information.


Moreover, this instrument improves the security of your data sources. When you run Flexmonster on your server, you can completely prevent the external access to your cube and work with your data only via the proxy tool. All you need is to provide access to this proxy.


Download 2.2 version of Flexmonster Component.

Recent Posts