I'm trying to install 3.8 Community Edition (we currently use 3.5), and am having problems with mondrian failing when I use any calculated measures. Here is the definition of the calculated measure that is failing (and by failing I mean that trying to even open a new analysis view for the cube in question bombs):


<CalculatedMember name="GrossMarginPrc" formatString="0.00%" formula="iif(TotalCost &#60;&#62; 0, (SalesPriceTC-TotalCost)/SalesPriceTC, Null)" dimension="Measures" visible="true">
</CalculatedMember>


Here are the definitions of the included members:

<Measure name="TotalCost" column="total_line_cost" datatype="Numeric" formatString="$#,##0.00" aggregator="sum" visible="true">
</Measure>

<Measure name="SalesPriceTC" column="merch_amt_collected_tc" datatype="Numeric" formatString="$#,##0.00" aggregator="sum" visible="true">
</Measure>


Here is the error reported in pentaho.log:

mondrian.olap.MondrianException: Mondrian Error:MDX object '[TotalCost]' not found in cube 'SalesAnalysis_temp'


These definitions all work perfectly in the 3.5 installation.

I'd appreciate it if anyone could find any error that jumps out.

Thanks, --sw