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

aggregate push-down

oc asked on September 11, 2019

I wonder if flexmonster can limit the amount of data, that users can load into their browser (for usability reasons), and give a warning message in that case. 
Does flexmonster push aggregations (count/sum …) and filters down to the datasource? If yes, for what datasources would that be possible? (elasticsearch,sql?)
Thank you very much!

1 answer

Vera Didenko Vera Didenko Flexmonster September 12, 2019

Thank you for writing to us.
1. We would like to explain that Flexmonster doesn’t provide an option for limiting the incoming data set in case the client’s browser doesn’t have enough resources.
Our team kindly suggests setting a custom data size limit on your side.
2. If we understood you correctly, you would like to know if filtering data and aggregations are handled purely by Flexmonster or if filtering and aggregations are performed on the server-side and the result is sent to Flexmonster.
In the case of CSV, JSON, and SQL data sources, you have to load all data before component starts displaying any report. Aggregations and filtering for such data sources is done by Flexmonster.
In the case of Elasticsearch and Cubes (for example, MS Analysis Server), Flexmonster can handle much larger data because not all data is loaded into the browser at once.
You have the ability to load just part of the data necessary for the specified report. Every time a filter is applied or specific aggregations are requested, Flexmonster sends a request to the server-side (to Elasticsearch or MS Analysis Server), the requested calculations are performed and the result is sent back to Flexmonster to be displayed on the grid or chart.
Please let us know if you have any questions.
Best Regards,

Please login or Register to Submit Answer