Do you know if it's possible to expose an MDX or similar interface to MonetDB for a BI purpose?
I see many references to being able to define your own language, so I wonder if this has been done. I don't see anything explicit when looking through the site.
I ask because many popular visualization and reporting tools can natively generate MDX queries.
It can be done through Mondrian OLAP. See mondrian-rest [0] for an example implementation.
Cool! Thanks.
I had heard of Mondrian, but didn't think to check from that end if it could use MonetDB as a back end.
Re:MonetDB – Column-store database
by gijzelaerr on Tuesday June 14, 2016 @04:37AM
(#11900632)
SQLAlchemy dialect maintainer here. I'm happy to hear somebody is using it, I've been working on it for a while but in the last 2 years I only received one bug report. And I don't think that is because the code is flawless.
We were using it as part of a custom BI tool for portfolio risk analysis. The data was mastered in postgresql and loaded into MonetDB for OLAP stuff.
The developers are pretty responsive to questions and bug reports.