Made some more advances. I found out that if I use a column of type INTEGER, the query works and gives the right results. On the other hand, if I use a column of type DECIMAL(10,4), the result is 0(zero)... Any ideas of what might be the problem? On 03/29/2012 02:14 PM, Pedro Salgueiro wrote:
I have already debugged Mondrian to see all the SQL queries generated by Mondrian. I tried them all in MonetDB and they all worked ok.
Here is a dump of the debug: http://pastebin.com/TnTfzmdM
The in the end of the debug is not the problem, since the same error also appears when using MySql instead of MonetDB.
If there is really the need to change something in Mondrian, wouldn’t that cause other errors?
I will look into the test suit of Mondrian.
Pedro
On 03/29/2012 01:01 PM, Stefan de Konink wrote:
On Thu, 29 Mar 2012, Pedro Salgueiro wrote:
Has anyone managed to make a working connection between Mondrian and Monet? If so, did you have to make something special? Years ago I have done some tests using Mondrian, but it did require some changes to allow the Mondrian queries to work such as row id functionality. If you debug the JDBC/ODBC connection, you might get the query that is actually executed.
I would suggest to run the test suite of Mondrian.
Stefan
------------------------------------------------------------------------------
This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users