<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body 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><br><div>Bill.</div><div><br><div><div>On Oct 31, 2012, at 11:32 AM, Luc Boudreau <<a href="mailto:lucboudreau@gmail.com">lucboudreau@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">About the dimension type. This part of the 4.X docs should help you. It looks like `Time`is the correct type name.<br><br><a href="http://mondrian.pentaho.com/documentation/xml_schema.php#Dimension">http://mondrian.pentaho.com/documentation/xml_schema.php#Dimension</a><br>
<br>Luc<br><br><br><div class="gmail_quote">On Wed, Oct 31, 2012 at 1:53 PM, William Back <span dir="ltr"><<a href="mailto:wback@pentaho.com" target="_blank">wback@pentaho.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">All,<br><br>I've been attempting to get the recent version of Saiku running with an even more recent version of Mondrian 4 and am experiencing problems. <br><br>Using the plug-in without changes causes problems because I am trying to use the new Query in the PhysicalSchema, i.e.<br>
<br> <Query alias="dim_customer_geography" keyColumn="CustomerKey"><br> <ExpressionView><br> <SQL><br>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;<br>
</SQL><br> </ExpressionView><br> </Query><br><br>The version of Mondrian didn't recognize it. So, I pulled a more recent version of Mondrian 4 that should support this. I had to move both the mondrian 4 jar and the xmlaserver jar to get it to not crash on class not found exceptions. But now I get the following:<br>
<br>Caused by: org.eigenbase.xom.XOMException: In Schema: In Dimension: Value 'TimeDimension' of attribute 'type' has illegal value 'TimeDimension'. Legal values: {ACCOUNTS, BILL_OF_MATERIALS, CHANNEL, CURRENCY, CUSTOMERS, GEOGRAPHY, MEASURE, ORGANIZATION, OTHER, PRODUCTS, PROMOTION, QUANTITATIVE, RATES, SCENARIO, TIME, UNKNOWN, UTILITY}<br>
<br>This time dimension was working quite recently with no problems. <br><br> <Dimension name="Date" table="dim_date" key="DateKey" type="TimeDimension"><br> <Attributes><br>
<Attribute name="DateKey" keyColumn="DateKey"/><br> <Attribute name="Year" keyColumn="CalendarYear" levelType="TimeYears"/><br>…<br> </Dimension><br>
<br>Two things;<br>1- Can we get an update to the saiku plugin that uses the latest version of Mondrian 4<br>2 - Any ideas on the time dimension error. That's a very bizarre error message, imo. I've checked the schema and it looks legit.<br>
<br>Finally, are there extra steps to update the plug-in other than dropping in the latest mondrian 4 build into the /lib folder? I'd like to be able to do the updates myself if possible.<br><br>Thanks,<br><br><div>
<div style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-wrap:break-word;word-spacing:0px">
Bill<br><br>--<br><br>Bill Back<br> <br>Pentaho | Powerful Analytics Made Easy <br>Visit the Resource Center for events, news and more <a href="http://pentaho.com/resources/" target="_blank">pentaho.com/resources/</a><br>
Get started evaluating Pentaho Business Analytics <a href="http://pentaho.com/get-started/" target="_blank">pentaho.com/get-started/</a> <br><br><br></div>
</div>
<br></div><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>
_______________________________________________<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>