I need to add OLAP report support into my existing spring boot web application. I have come across multiple BI tools like BIRT, JasperServer Report and Saiku but for all of them, I have to use an a...

I have been struggling to get aggregation tables to work. Here is what my fact table looks like: employment_date_id dimension1_id dimension2_id dimension3_id dimension4 dimension5 measure1 measure...

Are there any performance advantages in using a ROLAP server such as Mondrian on top of a MySQL database, as opposed to simply querying the MySQL database? I am asking this in the context in which...