asked on September 19, 2017
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 .
Please help.
Cheers.
⋅ September 20, 2017
Hello, Akash,
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.
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.
Regards,
Tanya
⋅ September 20, 2017
Hi Tanya
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?
Regards.
⋅ September 21, 2017
Hi!
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/
Regards,
Tanya
⋅ September 23, 2017
Hi Tanya
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.
Thanks.
⋅ September 25, 2017
Hello Akash,
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.
Best regards,
Dmytro.
