[Mondrian] NamedExpressions Class Cast Exceptions

Will Gorman wgorman at pentaho.com
Fri Jan 22 16:35:22 EST 2010


Hi Tom,

Could you post the stack trace and an example mondrian schema that
demonstrates the problem in JIRA?

Thanks!

Will

On Fri, 2010-01-22 at 21:20 +0000, tom at wamonline.org.uk wrote:
> Alright geeks,
> 
> A cube I've been using with BI Server 3.5.0 seems to magically have
> stopped working with BI Server 3.5.2, 
> 
> i've not used namedexpressions before its a cube I inherited:
> 
>   <Dimension type="StandardDimension" name="Purchase Type">
>     <Hierarchy hasAll="true" allMemberName="All Purchase Types">
>       <Table name="F_CONTENT_PURCHASES">
>       </Table>
>       <Level name="Type" column="PURCHASE_PAYMENT_TYPE" type="String"
> uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
>         <NameExpression>
>           <SQL dialect="mysql">
>             <![CDATA[(case PURCHASE_PAYMENT_TYPE  WHEN 0 THEN "Free"
> WHEN 1 THEN "Paid" ELSE "Unknown" END)]]>
>           </SQL>
>         </NameExpression>
>       </Level>
>     </Hierarchy>
>   </Dimension>
> 
> 
> Basically that fails on 3.5.2, but works fine on 3.5.0
> 
> Mondrian throws cast class exceptions, same on PRD 3.6 CI Build.
> 
> Any pointers?
> 
> Cheers
> 
> Tom 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian





More information about the Mondrian mailing list