Hi guys!
I have been trying MonetDB and it's awesome.
I tried to connect MonetDB to Mondrian using olap4j. I managed to establish the connection using the MonetDB JDBC, but I have a problem: There are no errors, but it presents the wrong results. Every MDX query returns the right tables, but with all values "zeroed", something like this:
------------------------ Unit Sales ========== 0 ------------------------
I tried to make a simple JDBC connection, and it worked out ok.
I am using the following connection string:
String connectionProperties = "jdbc:mondrian:JdbcDrivers=nl.cwi.monetdb.jdbc.MonetDriver;" + "Jdbc=jdbc:monetdb://localhost/foodmart;" + "JdbcUser=monetdb;" + "JdbcPassword=monetdb;" + "Catalog=FoodMart.xml;";
Does anyone knows if I am doing anything wrong?
Has anyone managed to make a working connection between Mondrian and Monet? If so, did you have to make something special?
It would be great to have a working connection between Mondrian and MonetDB, since its much faster than MySQL or LucidDB, which I have already tried.
Best regards, Pedro