<HTML>
Alright geeks,<br>
<br>
A cube I've been using with BI Server 3.5.0 seems to magically have stopped working with BI Server 3.5.2, <br>
<br>
i've not used namedexpressions before its a cube I inherited:<br>
<br>
<Dimension type="StandardDimension" name="Purchase Type"><br>
<Hierarchy hasAll="true" allMemberName="All Purchase Types"><br>
<Table name="F_CONTENT_PURCHASES"><br>
</Table><br>
<Level name="Type" column="PURCHASE_PAYMENT_TYPE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"><br>
<NameExpression><br>
<SQL dialect="mysql"><br>
<![CDATA[(case PURCHASE_PAYMENT_TYPE WHEN 0 THEN "Free" WHEN 1 THEN "Paid" ELSE "Unknown" END)]]><br>
</SQL><br>
</NameExpression><br>
</Level><br>
</Hierarchy><br>
</Dimension><br>
<br>
<br>
Basically that fails on 3.5.2, but works fine on 3.5.0<br>
<br>
Mondrian throws cast class exceptions, same on PRD 3.6 CI Build.<br>
<br>
Any pointers?<br>
<br>
Cheers<br>
<br>
Tom<br>
<BR></HTML>