asked on April 10, 2023
Hello dear,
We'd like to consider Flexmonster application to our analysis server.
We have a large oracle database to analyze.
The issue is that we have a oracle database which has around 50 tables.
And each tables has at least 400,000 rows. (some of has 3,000,000 rows)
So I found the article about "Flexmonster Data Speed Accelerator".
https://www.flexmonster.com/doc/flexmonster-accelerator-introduction/
(If I use Flexmonster dataserver, it takes 4 hours to load one table.)
How can I install and test it?
(I'm just using free trial version to check it is fit on us or not.)
Thanks for your support.
Sincerely.
⋅ April 10, 2023
Oh, I found another article
https://www.flexmonster.com/doc/getting-started-with-accelerator-ssas/
I'm trying to use ubuntu standalone server without internet network (private network)
Is it possible to use it?
⋅ April 11, 2023
Hello, Jang!
Thank you for contacting us.
Kindly note that Flexmonster Accelerator is designed to work with Microsoft Analysis Services only.
Our team would like to know if you are using the flat table view or aggregating the data with classic/compact. This information would greatly help us to come up with more case-specific advice for you.
Looking forward to hearing from you.
Regards,
Solomiia
⋅ April 27, 2023
Hello, Jang!
Hope you are doing well.
Our team is wondering if you had some time to look through our previous response. Could you please provide us with the details about your grid view?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ May 4, 2023
Hello, Jang!
Hope you are having a great week.
Just checking in to ask if you could provide us with the details about your grid view, so we'll be able to further investigate the case.
Looking forward to hearing your feedback.
Kind regards,
Solomiia
⋅ May 10, 2023
Hello,
Sorry for late response.
We're still checking flexmonster solution.
Is there any way to combine multiple databases?
I found an article following and it seems like not supporting.
https://www.flexmonster.com/question/combine-datasources/
I'm using ubuntu server with Oracle database .
Thank you for your support always.
⋅ May 11, 2023
Hello, Jang!
Thank you for getting back to us.
It is true that Flexmonster works with one data source at a time. We kindly suggest combining data sources before applying them to Flexmonster. Another possible approach is to combine the data from different tables with one SQL query using Flexmonster Data Server.
We still need the details about your use case we were asking for in previous messages to provide you with more accurate suggestions.
Looking forward to hearing from you.
Regards,
Solomiia
⋅ May 12, 2023
Dear Solomiia,
I'd like to ask some more question.
In this article, flexmonster is not support exporting grid data in programilcally.
https://www.flexmonster.com/question/how-can-i-get-the-grid-data-of-the-current-report/
--> I'd like to get grid data and put data to another pivot table.
I have an example of requiremnet.
Could you please send E-mail to me?
I'll reply you a example excel data.
Because of our company policy, i can not upload file this web site directly.
E-mail : XXXXX
Thanks.
Jang.
⋅ May 15, 2023
Hello, Jang!
Thank you for your question.
Could you please explain in more detail:
This information would help us greatly in providing you with more suitable suggestions.
Our representative will contact you soon via email soon so you can share your requirements with us.
Looking forward to hearing from you.
Regards,
Solomiia
⋅ May 19, 2023
Dear Solomiia,
Oh, I resolved the problem what I asked.
Now I'm testing flexmonster, but it has been expired.
Our company has quite complex process to buy flexmonster,
So may I extend tiral version? (max 1 month more)
My key is : XXXX-XXXX-XXXX-XXXX
Thanks.
Jang.
⋅ May 19, 2023
Hello, Jang!
Thank you for your feedback.
We are glad to hear that everything works well now.
Your Sales team manager will contact you with a new trial key soon.
Do not hesitate to contact us in case of any other questions.
Kind regards,
Solomiia
⋅ May 22, 2023
Dear Solomiia,
Could you please tell me sales team manager contact point?
Or could you please send him/her to contact me?
Thanks.
⋅ May 22, 2023
Hello, Jiang!
Thank you for reaching out to us.
The email with a new trial key should already be in your inbox. Could you please confirm that you received our letter?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ May 22, 2023
Dear Solomiia,
I have another question.
I do have a huge database with around 50 oracle db tables.
I ran flexmonster-data-server and it works with 1 or 2 tables.
Because db table has many data, flexmonster-data-server load data 4 hours.
Question is if I ran flexmonster-data-server, there is no more memory.
Is there any good solution?
No more available memory, so ubuntu server is super slow.
# free -m
total used free shared buff/cache available
Mem: 193376 192000 672 120 703 104
Swap: 62498 62498 0
Thanks.
⋅ May 23, 2023
Hello, Jang!
Thank you for your question.
Kindly note that Flexmonster Data Server loads all requested data from the database to your RAM. It tends to use 200-300% of the initial data size to perform all necessary operations on the data.
So, we can suggest the following possible solutions for the described case:
Hope it helps.
Feel free to contact us if any further questions arise.
Kind regards,
Solomiia
⋅ May 23, 2023
Dear Solomiia,
My server is 192GB ram memory, it can not be extended.
Could you please tell me details about 2nd way?
Thanks.
⋅ May 24, 2023
Hello, Jang!
Thank you for your swift response.
Kindly note that by writing more specific SQL queries, we mean prefiltering data in the SQL query before it goes to Flexmonster Data Server, for example:
- instead of writing SELECT *, only necessary fields can be specified;
- prefilter data by retrieving information for a specific period of time, such as the last month or year.
Hope it helps.Feel free to ask if you have any further questions.
Kind regards,
Solomiia
