[Mondrian] Problems with Mondrian 4 and Saiku Plug-in

William Back wback at pentaho.com
Wed Oct 31 13:53:08 EDT 2012


All,

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.

Using the plug-in without changes causes problems because I am trying to use the new Query in the PhysicalSchema, i.e.

   <Query alias="dim_customer_geography" keyColumn="CustomerKey">
     <ExpressionView>
       <SQL>
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;
       </SQL>
     </ExpressionView>
   </Query>

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:

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}

This time dimension was working quite recently with no problems.

 <Dimension name="Date" table="dim_date" key="DateKey" type="TimeDimension">
   <Attributes>
     <Attribute name="DateKey" keyColumn="DateKey"/>
     <Attribute name="Year" keyColumn="CalendarYear" levelType="TimeYears"/>
…
 </Dimension>

Two things;
1- Can we get an update to the saiku plugin that uses the latest version of Mondrian 4
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.

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.

Thanks,

Bill

--

Bill Back

Pentaho | Powerful Analytics Made Easy
Visit the Resource Center for events, news and more pentaho.com/resources/<http://pentaho.com/resources/>
Get started evaluating Pentaho Business Analytics pentaho.com/get-started/<http://pentaho.com/get-started/>



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20121031/69da7b27/attachment.html 


More information about the Mondrian mailing list