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

[Luc Boudreau]

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> 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/
> Get started evaluating Pentaho Business Analytics pentaho.com/get-started/
>
>
>
>
>
> _______________________________________________
> Mondrian mailing list
> 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/c75bf866/attachment.html