Regarding connection of flexmonster with MySQL
Suppose i have data around 150GB in mysql how can i connect it to flexmonster (considering i have a premium account :P).
Also can i provide data to flexmonster via API .
Thank you for the interest on our component. Flexmonster is a client-side solution which stores all the data in the browser. Here is why the amount of data you mentioned exceeds the browser capabilities. Our recommended approach is to try pre-filtering of the data on the server side and then passing it to the component. For more details please refer to the following article: How to achieve the best performance.
As about how to connect your data to Flexmonster, you can connect to MySQL database via our special server-side compression tool called Flexmonster Data Compressor. It is available for different technologies. Please find the list of technologies and setup tutorials in our documentation. After compressing the data can be added to Flexmonster while initialization or via API calls.
Let me know if you have any other questions.
Can the problem be solved, if we connect to flexmonster with mondrain cubes?
We can form the cube from the db using schema workbench, Will the flexmonster work then?
Yes, sure, I think it’s a good solution in your case.
Please find how to work with Mondrian here: http://www.flexmonster.com/doc/connecting-to-pentaho-mondrian/
I have successfully connected flexmonster to mondrain cube.
Can you please help me able to understand how can I ‘expand all’ columns and rows in flexmonster pivot table, I used custom view for it, but it didn’t expand all the rows and columns.
Need urgent help.
It is nice to hear that you have successfully connected your Mondrian cube to the Flexmonster component. When you need need to expand all the nodes selected in rows and columns please use
expandAllData() API call. You can find more information about it in our documentation –http://www.flexmonster.com/api/expandalldata/.
Please let us know if everything works fine for you.