I've been experimenting with DuckDB using modified Mondrian OLAP engine and it looks very promising so far, performance wise.
A questions I have to author, or anyone using: Is there a easy way to transfer whole Postgres DB into DuckDB so I can do some tests with actual client data? I could export each table by hand and reimport it, but that is kind of painful.
We still use MDX. Did some testing with DAX, but I don't believe its step in the right direction. As for tools, we mostly use in-house tools build either on Mondrian or connecting to MS Analysis Services trough XMLA - depending on the use case.
Related question; does anyone use JVM-based OLAP that is not based on Mondrian (https://github.com/pentaho/mondrian) but still supports MDX queries? We've been looking for alternatives for a while.
A questions I have to author, or anyone using: Is there a easy way to transfer whole Postgres DB into DuckDB so I can do some tests with actual client data? I could export each table by hand and reimport it, but that is kind of painful.