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

William Back wback at pentaho.com
Wed Oct 31 14:59:55 EDT 2012


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.

Bill.

On Oct 31, 2012, at 11:32 AM, Luc Boudreau <lucboudreau at gmail.com<mailto:lucboudreau at gmail.com>> wrote:

About the dimension type. This part of the 4.X docs should help you. It looks like `Time`is the correct type name.

http://mondrian.pentaho.com/documentation/xml_schema.php#Dimension

Luc


On Wed, Oct 31, 2012 at 1:53 PM, William Back <wback at pentaho.com<mailto:wback at pentaho.com>> wrote:
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/>




_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian


_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

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


More information about the Mondrian mailing list