It could be that MonetDB returns a type for the cell columns that Mondrian doesn't expect or wrongfully maps to a different datatype. By setting it manually, you are forcing Mondrian to use a specific datatype and thus bypass the problem. <br>
<br>We don't have a dialect specific to MonetDB. We might have to create one, but data types are not handled by the dialects.<br><br>Can you tell us which is the column type returned by the JDBC metadata for these columns? (should be an integer)<br>
<br>Luc<br><br><br><div class="gmail_quote">On Thu, Oct 25, 2012 at 3:19 PM, Brandon Jackson <span dir="ltr"><<a href="mailto:usbrandon@gmail.com" target="_blank">usbrandon@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I was able to load MonetDB with foodmart using the foodmart loader. I noticed that when the tables were created some of the columns had the NUMERIC data type. Everything loaded correctly. Any SQL queries that I issued doing SUM etc through Squirrel and the relevant JDBC driver worked fine.<br>
<br>Mondrian 3.X included with Suite 4.5 issues proper SQL against MonetDB, but the measure results come back as 0 in every query I tried.<br><br>When I changed the data types to DOUBLE or FLOAT, Mondrian's queries finally show correct results.<br>
<br>Where should I look to understand where this problem is entering the picture?<br>I don't know why SquirrelSQL receives and shows a table of correct results, while Mondrian does not. So far, by process of elimination:<br>
<br>Not at fault:<br>JDBC Driver (because SquirrelSQL uses it and gets correct results)<br>MonetDB (because direct queries work)<br><br>At fault:<br>Mondrian somewhere...<br><br>---<br>Is this a sound way to look at the problem?<br>
Would running the test suite against MonetDB give sufficient information to fix this problem?<br>Is a database dialect what prevents these kinds of issues?<br><br>If I can receive a little guidance where to check and what needs to be done, maybe I can even trace into this issue.<br>
<br>Thanks,<br><br>Brandon<br><br>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br>