<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">OK - I'm back to a more logical broken status. <div><br></div><div>I got the latest Saiku plugin snapshot (Oct 31). It recognizes type="TimeDimension" as I think it should be. (Some other issues still, but making progress.)</div><div><br></div><div>However, the Query definition is failing. I have the following inside the PhysicalSchema:</div><div><br></div><div><div> <Query alias="query_customer_geography" keyColumn="CustomerKey"></div><div> <ExpressionList></div><div> <SQL dialect="generic"><![CDATA[</div><div>select c.CustomerKey, g.CountryRegionCode, g.StateProvinceName, g.City from dim_customer as c inner join dim_geography as g on c.GeographyKey = g.GeographyKey;</div><div> ]]></SQL></div><div> </ExpressionList></div><div> </Query></div></div><div><br></div><div>But when the schema loads, I get the following exception message:</div><div><br></div><div><div>Caused by: org.eigenbase.xom.XOMException: In Schema: In PhysicalSchema: In Query: Expecting at least 1 <mondrian.olap.MondrianDef$SQL> but found 0</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.olap.MondrianDef$Schema.<init>(MondrianDef.java:258)</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:231)</div></div><div><br></div><div>I have verified that the query is correct, but this looks more like a validation problem. Leaving out the ExpressionList causes a different error saying it's an invalid Query. However, ExpressionList isn't in the MondrianSchema.xml in the latest pull from the Luganitas branch, so perhaps something is missing? FoodMart.mondrian.xml doesn't use the Query either, so I'm not seeing any examples.</div><div><br></div><div>Based on email from Julian I believe this is the correct format. I've tried all kinds of combinations (even adding a second SQL to see if it was some index error.) Ideas are greatly welcome.</div><div><br></div><div>Thanks,</div><div><br></div><div>Bill.</div><div><br></div><div><div><div><div>On Oct 31, 2012, at 1:07 PM, Paul Stoellberger <<a href="mailto:p.stoellberger@gmail.com">p.stoellberger@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div bgcolor="#FFFFFF"><div>So it is, or is not using the latest version? maven can be a bit weird when pulling snapshot builds. I'll have a look at that</div><div><br></div><div>-Paul<br><br><br><div><br></div></div><div><br>Am 31.10.2012 um 20:59 schrieb Julian Hyde <<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</a>>:<br><br></div><div></div><blockquote type="cite"><meta http-equiv="Content-Type" content="text/html charset=windows-1252"><div><div>On Oct 31, 2012, at 11:59 AM, William Back <<a href="mailto:wback@pentaho.com">wback@pentaho.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><meta http-equiv="Content-Type" content="text/html charset=windows-1252"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I got Saiku to accept the schema, but had to use type='TIME' (all caps). I'm not getting data now, but will verify that it's not something else in my schema. </div></blockquote><div><br></div><div>Yes, I recently changed it to upper-case, to match the values of olap4j's Dimension.Type enum. (Things are changing fast... sorry you got burned.)<div><br></div><div><a href="http://www.olap4j.org/api/org/olap4j/metadata/Dimension.Type.html">http://www.olap4j.org/api/org/olap4j/metadata/Dimension.Type.html</a></div><div><br></div><div>If the schema loads, everything should be OK. Your missing data is probably due to something else.</div><div><br></div><div>Julian</div></div></div></blockquote><blockquote type="cite"><span>_______________________________________________</span><br><span>Mondrian mailing list</span><br><span><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a></span><br><span><a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a></span><br></blockquote></div>_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>http://lists.pentaho.org/mailman/listinfo/mondrian<br></blockquote></div><br></div></div></body></html>