Best practices on on implementing pivot tables on top of Oracle DB with large datasets

Hello Christian,
Thank you for your questions. We have collected all our experience and shared it in the following article - http://www.flexmonster.com/blog/blog-perform-faster/. It is a little bit outdated but the key ideas are still relevant. Speaking about your case, you need to choose between two options.

• First one is the SQL database as a storage (for example your Oracle DB) and our Flexmonster Compressor tool. This tool was specially created by our developers to give the better performance using SQL databases. Please find information about it in our documentation - https://www.flexmonster.com/doc/connecting-to-relational-database/.
• The other option is the OLAP cube and our Flexmonster Accelerator. We recommend such approach when it is not possible to achieve good performance using SQL database and Flexmonster Compressor. Please find more information about the accelerator here - https://www.flexmonster.com/doc/flexmonster-accelerator-introduction/. We have all the documentation of how to use our Flexmonster Accelerator with Microsoft Analysis Services and Pentaho Mondrian available on our website.(https://www.flexmonster.com/doc/getting-started-with-accelerator-ssas/, https://www.flexmonster.com/doc/connecting-to-pentaho-mondrian/)

Please let us know if you have additional questions here.
Best regards,
Dmytro.