How to apply filters prior to showing data and customize filter dialog
We are currently trialing FlexMonster and so far it has great potentially to replace our SilverLight client. However we are facing two current issues, one of which is a show stopper, the other is purely cosmetics and improving usability. I am sure this is just down to how we are using it so any feedback would be appreciated.
Apply filters to the cube prior to pulling back data.
This is our show stopper. When build a query in the dialog it allows you to provide a field to filter on but does not allow you to apply a filter value prior to pulling back the data. Our cubes contain millions of rows and the current queries take too long to return all the data to make this usable.
I would provide screen shots if could but the GUI will not allow me. Please let me know what we are doing wrong or an alternative approach.
Customize dialog filter
Secondly, we can see that the filter dialog can be stretched but we cannot increase the height. Ideally we would like the dialog to start defaulted to using more of the available screen real estate. I have played with the CSS and I am sure it can be done our side but it seems a lot of effort.
Thank you for interest in our component. Please find our answers below:
1. It seems that
subquery property should resolve the case. It allows pre-filtering the data and not loading unnecessary rows. Please find the article which describes
subquery approach here – https://www.flexmonster.com/blog/how-to-use-subquery-parameter-for-faster-data-loading/. Also, you can find the jsfiddle example here – https://jsfiddle.net/flexmonster/ej8j4jmg/. At the same time, we have the solution of how to increase the loading speed of your data. Please find more information about our accelerator tool here – https://www.flexmonster.com/doc/getting-started-with-accelerator-ssas/.
2. Speaking about increasing the height of fields list, it can be done using
CSS. You can find the example here – http://jsfiddle.net/ydu9z1x8/64/.
Please let us know if everything works fine for you.