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

[Julian Hyde]

On Oct 31, 2012, at 2:17 PM, William Back <wback at pentaho.com> wrote:

> I have the following inside the PhysicalSchema:
> 
>     <Query alias="query_customer_geography" keyColumn="CustomerKey">
>       <ExpressionList>
>         <SQL dialect="generic"><![CDATA[
> 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>
>       </ExpressionList>
>     </Query>
> 
> But when the schema loads, I get the following exception message:
> 
> Caused by: org.eigenbase.xom.XOMException: In Schema: In PhysicalSchema: In Query: Expecting at least 1 <mondrian.olap.MondrianDef$SQL> but found 0
> 	at mondrian.olap.MondrianDef$Schema.<init>(MondrianDef.java:258)
> 	at mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:231)

Try changing ExpressionList to ExpressionView.

Julian