[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